admin

admin

Hi I educated in the U.K. with working experienced for 18 years in multinational companies, As an IT Manager and IT Instructor, I am attached with certkingdom.com here they provide IT exams study material, the study materials included exams Q&A with Explanation, Study Guides, Training Labs, Exams Simulations, Training Videos, etc. for certification like MCSE 2003 Training, MCITP Training, http://www.certkingdom.com, CCNA exams preparation, CompTIA A+ Training, and more Certkingdom.com provide you the best training 100% guarantee. “Best Material Great Results”

Home page: http://www.certkingdom.com

Posts by admin

Exam 70-484 Essentials of Developing Windows Store Apps Using C#

Published: October 23, 2012
Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
Audiences: Partners, developers Technology Visual Studio 2012
Credit toward certification: MCP, MCSD

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Design Windows Store apps (20-25%)
Design the UI layout and structure
Evaluate the conceptual design and decide how the UI will be composed; design for the inheritance and re-use of visual elements (e.g., styles, resources); design for accessibility; decide when custom controls are needed; use the Hub App template
Design for separation of concerns (SOC)
Plan the logical layers of your solution to meet app requirements; design loosely coupled layers; incorporate WinMD components
Apply the MVVM pattern to your app design
Design and implement the appropriate data model to support business entities; design your viewmodel to support your view based on your model; develop a view to meet data-binding requirements; create view models using INotifyPropertyChanged, ObservableCollection, and CollectionViewSource
Design and implement Process Lifetime Management (PLM)
Choose a state management strategy; handle the suspend event; prepare for app termination; handle the Resume event; handle the OnActivated event; check the ActivationKind and previous state
Plan for an app deployment
Plan a deployment based on Windows Store app certification requirements; prepare an app manifest (capabilities and declarations); sign an app; plan the requirements for an enterprise deployment

Develop Windows Store apps (15-20%)
Access and display contacts
Call the ContactsPicker class; filter which contacts to display; display a set number of contacts; create and modify contact information; select specific contact data
Design for charms and contracts
Choose the appropriate charm based on app requirements; design your app in a charm- and contract-aware manner; configure app manifest for correct permissions
Implement search
Provide search suggestions using the SearchPane class and SearchBox control; search for and launch other apps; provide and constrain search within an app, including inside and outside of Search charm; provide search result previews; implement activation from within search; configure search contracts
Implement Share in an app
Use the DataTransferManager class to share data with other apps; accept sharing requests by implementing activation from within Share; limit the scope of sharing using the DataPackage object; implement in-app Share outside of Share charm; use web links and application links
Manage app settings and preferences
Choose which app features are accessed in AppSettings; add entry points for AppSettings in the Settings window; create settings flyouts; store and retrieve settings from the roaming app data store
Integrate media features
Support DDS images; implement video playback; implement XVP and DXVA; implement Text to Speech (TTS)

Create the user interface (20-25%)
Create layout aware apps to handle windowing modes
Respond to changes in orientation; adapt to new windowing modes by using the ViewManagement namespace; manage settings for an apps view
Implement layout controls
Implement the Grid control to structure your layout; set the number of rows/columns and size; enable zoom and scroll capabilities in layout controls; manage text flow and presentation
Design and implement the app/nav bar
Determine what to put on the app/nav bar based on app requirements; style and position app/nav bar items; design the placement of controls on the app/nav bar; handle app/nav bar events; design the placement of controls on the app/nav bar
Design and implement data presentation
Choose and implement data controls and properties to meet app requirements (e.g., ListView, GridView, FlipView, DatePicker, TimePicker, Hyperlink, PlaceholderText, menu flyouts, and CommandBar); create data templates to meet app requirements
Create and manage XAML styles and templates
Implement and extend styles and templates; implement gradients; modify styles based on event and property triggers; create shared resources and themes

Preparation resources
XAML AppBar control sample

Program the user interaction (20-25%)
Create and manage tiles
Create and update tiles and tile contents; create and update badges (TileUpdateManager class); respond to notification requests; choose an appropriate tile update schedule based on app requirements
Notify users by using toast
Enable an app for toast notifications; populate toast notifications with images and text using the ToastUpdateManager class; play sounds with toast notifications; respond to toast events; control toast duration; configure and use Azure Mobile Services for push notifications
Manage input devices
Capture Gesture library events; create custom gesture recognizers; listen to mouse events or touch gestures; manage Stylus input and inking
Design and implement navigation in an app
Handle navigation events, check navigation properties, and call navigation functions by using the Navigation framework; design navigation to meet app requirements; Semantic Zoom

Preparation resources
Tile and tile notification overview (Windows Store apps)
Toast notification overview (Windows Store apps)
Navigation model (using C#/VB/C++ and XAML)

Manage security and data (20-25%)
Choose an appropriate data access strategy
Choose the appropriate data access strategy (file based, web service, remote storage, including Microsoft Azure storage and Azure Mobile Services) based on requirements
Retrieve data remotely
Use HttpClient to retrieve web services; set the appropriate HTTP verb for REST; consume SOAP/WCF services; use WebSockets for bi-directional communication; handle the progress of data requests
Implement data binding
Choose and implement data-bound controls; bind collections to items controls; implement the IValueConverter interface; create and set dependency properties; validate user input; enable filtering, grouping, and sorting data in the user interface
Manage Windows Authentication and Authorization
Retrieve a user’s roles or claims; store and retrieve credentials by using the PasswordVault class; implement the CredentialPicker class; verify credential existence by using credential locker; store account credentials in app settings
Manage Web Authentication
Use the Windows.Security.Authentication.Web namespace; set up oAuth2 for authentication; implement the CredentialPicker class; set up single sign-on (SSO); implement credential roaming; implement the WebAuthenticationBroker class; support proxy authentication for enterprises

Preparation resources
Connecting to web services (Windows Store apps using C#/VB/C++ and XAML)
Data binding overview (Windows Store apps using C#/VB/C++ and XAML)
Managing user info (Windows Store apps using C#/VB/C++ and XAML)

 

QUESTION 1
You need to ensure that launching the app displays the required information.
From which ApplicationExecutionState enumeration should you configure the user interface state?

A. ClosedByUser
B. Suspended
C. NotRunning
D. Running
E. Terminated

Answer: E

Explanation: The user closes the app through the close gesture or Alt+F4 and takes longer than 10 seconds to activate the app again.
*From scenario: The app must meet the following technical requirements: Retain state for each user and each device.
Restore previously saved state each time the app is launched.
Your app can use activation to restore previously saved data in the event that the operating system terminates your app, and subsequently the user re-launches it. The OS may terminate your app after it has been suspended for a number of reasons. The user may manually close your app, or sign out, or the system may be running low on resources.
Ref: http://msdn.microsoft.com/en-us/library/windows/apps/hh464925.aspx


QUESTION 2
You need to choose the appropriate data binding strategy for the image list box.
Which method should you use?

A. System.Drawing.ImageConverter.ConvertToString()
B. IValueConverter.ConvertBack()
C. IValueConverter.Convert()
D. System.Drawing. ImageConverter-ConvertFromStrin()

Answer: C

Explanation: IValueConverter.Convert
The data binding engine calls this method when it propagates a value from the binding source to the binding target.


QUESTION 3
You need to ensure that only the correct information is preserved when the user switches to another app.
Which actions should you perform? (Each correct answer presents part of the solution. Choose all that apply.)

A. Save application state by calling the SaveDataToRoamingStorage() method,
B. Save photographs by calling the SaveDataToLocalStorage() method.
C. Save photographs by calling the SaveDataToWebService() method.
D. save application state by calling the SaveDataToLocalStorage() method.

Answer: A,B

Explanation: A: From scenario: The app must meet the following technical requirements: Retain state for each user and each device.
B: From scenario: The app must store cached images on the device only


QUESTION 4
You need to ensure that the app resumes according to the requirements.
Which actions should you perform? (Each correct answer presents part of the solution. Choose all that apply.)

A. Retrieve new user content by using the Window.Current.Dispatcher.ProcessEvents()
method in the App_Resuming event handler.
B. update the user interface by using the Window.Current.Dispatcher.Invoke() method in the App_Resuming event handler.
C. Override the OnLaunched event handler.
D. Retrieve new user content by using the Window.Current.Dispatcher.ProcessEvents() method in the OnLaunched event handler when the ActivationKind is Launch.
E. Update the user interface by using the Window.Current.Dispatcher.Invoke() method in the OnLaunched event handler when the ActivationKind is Launch.
F. Register the App_Resuming event handler for the Resuming event.

Answer: A,B

Explanation:
From scenario:
The app must meet the following technical requirements:
/ When the app resumes after a period of suspension, refresh the user interface, tile images, and data with current information from the web service.


QUESTION 5
You need to choose the appropriate data binding strategy for the image list box.
Which method should you use?

A. System.Drawing.ImageConverter.ConvertTo(value, typeof(Image))
B. IValueConverter.Convert()
C. System.Drawing.ImageConverter.ConvertFrom(value, typeof(Image), CultureInfo.CurrentUICulture)
D. IValueConverter.ConvertBack ()

Answer: B

Explanation: IValueConverter.Convert
The data binding engine calls this method when it propagates a value from the binding source to the binding target.

 

Click here to view complete Q&A of 70-484 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-484 Training at certkingdom.com

 

Exam 70-483 Programming in C#

Published: October 12, 2012
Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
Audiences: Developers
Technology: Visual Studio 2012
Credit toward certification: MCP, MCSD

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Manage program flow (25–30%)
Implement multithreading and asynchronous processing
Use the Task Parallel library (ParallelFor, Plinq, Tasks); create continuation tasks; spawn threads by using ThreadPool; unblock the UI; use async and await keywords; manage data by using concurrent collections
Manage multithreading
Synchronize resources; implement locking; cancel a long-running task; implement thread-safe methods to handle race conditions
Implement program flow
Iterate across collection and array items; program decisions by using switch statements, if/then, and operators; evaluate expressions
Create and implement events and callbacks
Create event handlers; subscribe to and unsubscribe from events; use built-in delegate types to create events; create delegates; lambda expressions; anonymous methods
Implement exception handling
Handle exception types (SQL exceptions, network exceptions, communication exceptions, network timeout exceptions); catch typed vs. base exceptions; implement try-catch-finally blocks; throw exceptions; determine when to rethrow vs. throw; create custom exceptions

Preparation resources
Asynchronous programming with Async and Await (C# and Visual Basic)
Threading (C# and Visual Basic)
Selection statements (C# reference)

Create and use types (25–30%)
Create types
Create value types (structs, enum), reference types, generic types, constructors, static variables, methods, classes, extension methods, optional and named parameters, and indexed properties; create overloaded and overriden methods
Consume types
Box or unbox to convert between value types; cast types; convert types; handle dynamic types; ensure interoperability with unmanaged code, for example, dynamic keyword
Enforce encapsulation
Enforce encapsulation by using properties, by using accessors (public, private, protected), and by using explicit interface implementation
Create and implement a class hierarchy
Design and implement an interface; inherit from a base class; create and implement classes based on the IComparable, IEnumerable, IDisposable, and IUnknown interfaces
Find, execute, and create types at runtime by using reflection
Create and apply attributes; read attributes; generate code at runtime by using CodeDom and lambda expressions; use types from the System.Reflection namespace (Assembly, PropertyInfo, MethodInfo, Type)
Manage the object life cycle
Manage unmanaged resources; implement IDisposable, including interaction with finalization; manage IDisposable by using the Using statement; manage finalization and garbage collection
Manipulate strings
Manipulate strings by using the StringBuilder, StringWriter, and StringReader classes; search strings; enumerate string methods; format strings

Preparation resources
Types (C# programming guide)
Classes and structs (C# programming guide)
Object-oriented programming (C# and Visual Basic)

Debug applications and implement security (25–30%)
Validate application input
Validate JSON data; data collection types; manage data integrity; evaluate a regular expression to validate the input format; use built-in functions to validate data type and content out of scope: writing regular expressions
Perform symmetric and asymmetric encryption
Choose an appropriate encryption algorithm; manage and create certificates; implement key management; implement the System.Security namespace; hashing data; encrypt streams
Manage assemblies
Version assemblies; sign assemblies using strong names; implement side-by-side hosting; put an assembly in the global assembly cache; create a WinMD assembly
Debug an application
Create and manage compiler directives; choose an appropriate build type; manage programming database files and symbols
Implement diagnostics in an application
Implement logging and tracing; profiling applications; create and monitor performance counters; write to the event log

Preparation resources
Validating data
.NET Framework regular expressions

Implement data access (25–30%)
Perform I/O operations
Read and write files and streams; read and write from the network by using classes in the System.Net namespace; implement asynchronous I/O operations
Consume data
Retrieve data from a database; update data in a database; consume JSON and XML data; retrieve data by using web services
Query and manipulate data and objects by using LINQ
Query data by using operators (projection, join, group, take, skip, aggregate); create method-based LINQ queries; query data by using query comprehension syntax; select data by using anonymous types; force execution of a query; read, filter, create, and modify data structures by using LINQ to XML
Serialize and deserialize data
Serialize and deserialize data by using binary serialization, custom serialization, XML Serializer, JSON Serializer, and Data Contract Serializer
Store data in and retrieve data from collections
Store and retrieve data by using dictionaries, arrays, lists, sets, and queues; choose a collection type; initialize a collection; add and remove items from a collection; use typed vs. non-typed collections; implement custom collections; implement collection interfaces

Preparation resources
File system and the registry (C# programming guide)
Connecting to data in Visual Studio
Editing data in your application


QUESTION 1
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the use of
the Queue <T> collection type.
Which of the following is TRUE with regards to the Queue <T>collection type?

A. It represents a first in, first out (FIFO) collection of objects.
B. It represents a last in, first out (LIFO) collection of objects.
C. It represents a collection of key/value pairs that are sorted by key based on the associated
IComparer<T> implementation.
D. It represents a list of objects that can be accessed by index.

Answer: A

Explanation:


QUESTION 2
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
You have written the following code segment:
int[] filteredEmployeeIds = employeeIds.Distinct().Where(value => value !=
employeeIdToRemove).OrderByDescending(x => x).ToArray();
Which of the following describes reasons for writing this code? (Choose two.)

A. To sort the array in order from the highest value to the lowest value.
B. To sort the array in order from the lowest value to the highest value.
C. To remove duplicate integers from the employeeIds array.
D. To remove all integers from the employeeIds array.

Answer: A,C

Explanation:


QUESTION 3
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the use of a
method that moves the SqlDataReader on to the subsequent record.
Which of the following is the SqlDataReader method that allows for this?

A. The Read method.
B. The Next method.
C. The Result method.
D. The NextResult method.

Answer: A

Explanation:


QUESTION 4
You work as a developer at ABC.com. The ABC.com network consists of a single domain named ABC.com.
You have received instructions to create a custom collection for ABC.com. Objects in the
collection must be processed via a foreach loop.
Which of the following is TRUE with regards to the required code?

A. The code should implement the ICollection interface.
B. The code should implement the IComparer interface.
C. The code should implement the IEnumerable interface.
D. The code should implement the IEnumerator interface.

Answer: C

Explanation:


QUESTION 5
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the use of LINQ queries.
Which of the following is NOT considered a distinct action of a LINQ query?

A. Creating the query.
B. Obtaining the data source.
C. Creating the data source.
D. Executing the query.

Answer: C

Explanation:

Click here to view complete Q&A of 70-483 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-483 Training at certkingdom.com

Exam 70-482 Advanced Windows Store App Development Using HTML5 and JavaScript

Published: October 4, 2012
Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
Audiences: Developers
Technology: Visual Studio 2012
Credit toward certification: MCP, MCSD

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

As of November 18, 2013, this exam includes content covering Windows 8.1 and Visual Studio 2013.

Develop Windows Store apps (15-20%)
Create background tasks
Implement the Windows.applicationmodel.background classes; implement WebUIBackgroundTaskInstance; create a background task to manage and preserve resources; create a background task to get notifications for an app; register the background task by using the BackgroundTaskBuilder class; prioritize tasks by using the Scheduler namespace
Consume background tasks
Use timing triggers and system triggers; keep communication channels open; request lock screen access; use the backgroundtransfer class to finish downloads
Integrate WinMD components into a solution
Consume a WinMD component in JavaScript; handle WinMD reference types; reference a WinMD component

Preparation resources
Background task sample
Windows Runtime Components in a .NET World

Discover and interact with devices (15-20%)
Capture media with the camera and microphone
Use CameraCaptureUI to take pictures or video, and configure camera settings; use MediaCapture to capture pictures, video, and audio; configure camera settings; set media formats; handle media capture events; implement advanced photo capabilities, such as sequence mode, thumbnails, and focus mode
Get data from sensors
Determine the availability of a sensor (Windows.devices.sensors); add sensor requests to the app manifest; handle sensor events; get sensor properties; determine location via GPS; enable geofencing
Enumerate and discover device capabilities
Discover the capabilities and properties of available devices, for example, GPS, removable storage, accelerometer, and near field communication
Implement device access
USB; Bluetooth; Human Interface Device (HID); 3D printer support; Point of Service (PoS) devices

Preparation resources
CameraCaptureUI Sample
Bluetooth device support
USB device support

Program user interaction (15-20%)
Implement printing by using contracts and charms
Implement the print contract; create a custom print template; construct a print preview; handle print pagination; implement in-app printing; expose printer settings within an app
Implement Play To by using contracts and charms
Register an app for Play To; use PlayToManager stream media assets; register an app as a PlayToReceiver; programmatically implement PlayTo functionality
Notify users by using Windows Push Notification Service (WNS)
Authenticate with WNS; request, create, and save a notification channel; call and poll the WNS; configure and implement push notifications by using Azure Mobile Services

Preparation resources
Azure Mobile Services for Windows Store app and Android app developers

Enhance the user interface (15-20%)
Design for and implement UI responsiveness
Choose an asynchronous strategy between web workers and promises; implement web workers; nest and chain promises; make custom functions promise-aware; improve interface performance by using the Scheduler namespace
Implement animations and transitions
Apply animations from the animation library (WinJS.UI.animation); create and customize animations and transitions by using CSS; apply transformations; create animations by using keypoints; apply timing functions; animate with the HTML5 <canvas> element
Create custom controls
Create custom controls using WinJS.Namespace, WinJS.Class.define, and HTML; bind to custom controls with data-win-bind; inherit from and extend an existing WinJS control
Design apps for globalization and localization
Implement .resjson files to translate text; implement collation and grouping to support different reading directions; implement culture-specific formatting for dates and times; bind JSON properties to resources by using the data-win-res property

Preparation resources
Globalizing your app (Windows Store apps using JavaScript and HTML)

Manage data and security (15-20%)
Design and implement data caching
Choose which types of items (user data, settings, application data) in your app should be persisted to the cache based on requirements; choose when items are cached; choose where items are cached (Microsoft Azure, Azure Mobile Services, remote storage); select a caching mechanism; store data by using indexDB, LocalStorage, and SessionStorage
Save and retrieve files
Handle file streams; save and retrieve files by using the StorageFile and StorageFolder classes; set file extensions and associations; save and retrieve files by using file pickers and the folder picker; compress files to save space; access libraries and KnownFolders, for example, pictures, documents, and videos; manage appearance of the file picker; improve searchability by using Windows Index; integrate OneDrive with apps; compare files; manage libraries
Secure application data
Encrypt data by using the Windows.Security.Cryptography namespace; enroll and request certificates; encrypt data by using certificates; revoke file permissions

Prepare for a solution deployment (15-20%)
Design and implement monetization features in an app
Set up a timed trial; set up a feature-based trial; implement in-app purchases; transition an app from trial to full
Design for error handling
Design the app so that errors and exceptions never reach the user; handle device capability errors; handle promises errors
Design and implement a test strategy
Design a functional test plan; implement a coded UI test; design a reliability test plan, including performance testing, stress testing, scalability testing, and duration testing; simulate in-app purchases
Design a diagnostics and monitoring strategy
Design profiling, tracing, performance counters, audit trails (events and information), and usage reporting; decide where to log events (local vs. centralized reporting)
Evaluate and configure for Windows Store deployment
Configure app options to submit to the Windows Store, such as age restrictions, privacy statement, permissions, images, and contact information; create application files, resource files, and application bundles; verify application readiness by using the Windows Application Certification Kit (WACK)

Preparation resources
Testing Windows Store apps
Debugging and testing


QUESTION 1
You need to complete the code to start the background task.
Which code segment should you insert at line BG07?

A. Windows.ApplicationModel.Background.SystemTriggerType.connectedStateChange, true
B. Windows.ApplicationModel.Background.SystemTriggerType.networkStateChange, false
C. Windows.ApplicationModel.Background.SystemTriggerType.sessionConnected, true
D. Windows.ApplicationModel.Background.SystemTriggerType.internetAvailable, false

Answer: D


QUESTION 2
You need to identify the required camera specifications.
Which code segment should you insert at line VD06?

A. var maxZoom = videoDev.zoom.capabilities.max;
B. var cameraType = videoDev.extendedZoomProperties(“cameraType”);
C. var cameraZoom = videoDev.zoom;
D. var minZoom = mediaCaptureSettings.min.millimeters;

Answer: A


QUESTION 3
You need to attach the background task.
Which code segment should you insert at line BG09?

A. var task = builder.register( );
B. var task = Windows. ApplicationModel.Background.BackgroundTaskBuilder.insert (builder);
C. var task: = Windows.ApplicationModel.Background.BackgroundTaskBuilder.insert (builder, this);
D. var task = builder.setTrigger ( );

Answer: A


QUESTION 4
You need to set the default storage location for the client profiles.
Which code segment should you insert at line CD04?

A. fop.defaultFolder = Windows.Storage.Pickers.PickerLocationId.documentsLibrary;
B. fop.defaultFolder = environment.getFolderPath (environment.specialFolder.applicationData);
C. fop.suggestedStartLocation = “%AppData%”;
D. fop.suggestedStartLocation = Windows.Storage.Pickers.PickerLocationId.documentsLibrary;

Answer: A


QUESTION 5
You need to prevent the exception that is being thrown by the findCamera( ) method.
What should you do?

A. Check the devices collection for multiple devices.
B. Place a try block immediately after line VD12 and a catch block immediately before line VD17. In the catch
block, display the message property of the exception object to the user.
C. In line VD10, set the cameraID variable to null.
D. Check the devices collection for null before setting the cameraID variable.

Answer: D

Click here to view complete Q&A of 70-482 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-482 Training at certkingdom.com

Exam 70-481 Essentials of Developing Windows Store Apps Using HTML5 and JavaScript

Published: October 11, 2012
Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
Audiences: Developers
Technology: Visual Studio 2012
Credit toward certification: MCP, MCSD

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Design Windows Store apps (20-25%)
Design the UI layout and structure
Evaluate the conceptual design; decide how the UI will be composed; design for the inheritance and re-use of visual elements (e.g., styles, resources); design for accessibility; decide when custom controls are needed; use the Hub App template
Design for separation of concerns
Plan the logical layers of your solution to meet application requirements; design loosely coupled layers; incorporate WinMD components
Design and implement Process Lifetime Management (PLM)
Choose a state management strategy; handle the suspend event (oncheckpoint); prepare for app termination; handle the onactivated event; check the ActivationKind and previous state
Plan for an application deployment
Plan a deployment based on Windows 8 Application certification requirements; prepare an app manifest (capabilities and declarations); sign an app; plan the requirements for an enterprise deployment

Develop Windows Store apps (15-20%)
Access and display contacts
Call the ContactsPicker (windows.applicationmodel.contacts) class; filter which contacts to display; display a set number of contacts; create and modify contact information; select specific contact data
Design for charms and contracts
Choose the appropriate charms based on app requirements; design an application to be charm- and contract-aware; configure the application manifest for correct permissions
Implement search
Provide search suggestions using the SearchPane and SearchBox control class; search and launch other apps; provide and constrain search within an app, including inside and outside of search charm; provide search result previews; implement activation from within search; configure search contracts
Implement Share in an app
Use the DataTransferManager class to share data with other apps; accept sharing requests by implementing activation from within Share; limit the scope of sharing using the DataPackage object; implement in-app Share outside of Share charm; use web links and application links
Manage application settings and preferences
Choose which application features are accessed in AppSettings; add entry points for AppSettings in the Settings window; create settings flyouts using the SettingsFlyout control; add settings options to SettingsFlyout; store and retrieve settings from the roaming app data store
Integrate media features
Support DDS images; implement video playback; implement XVP and DXVA; implement TTS; implement audio and video playback using HTML5 DRM

Create the user interface (20-25%)
Implement WinJS controls
Flipview; flyout; grid layout; list layout; menu object; WebView; item container; repeater
Implement HTML layout controls
Implement layout controls to structure your layout; implement templates and bindings; support scrolling and zooming with CSS3; manage text flow and presentation, including overflow
Create layout-aware apps to handle windowing modes
Use CSS3 media queries to adapt to different devices; respond to changes in orientation; adapt to new windowing modes by using the ViewManagement namespace; manage setting for an apps view
Design and implement the app bar
Determine what to put on the app bar based on app requirements; style and position app bar items; design the placement of controls on the app bar; handle AppBar events
Apply CSS styling
Implement gradients, grid layouts, zooming, scroll snapping, and media queries

Preparation resources
XAML AppBar control sample

Program user interaction (20-25%)
Manage input devices
Capture gesture library events; create custom gesture recognizers; listen to mouse events or touch gestures; manage Stylus input and inking; handle drag and drop events
Design and implement navigation in an app
Handle navigation events, check navigation properties, and call navigation functions by using the WinJS.Navigation namespace; design navigation to meet app requirements; Semantic Zoom; load HTML fragments
Create and manage tiles
Create and update tiles and tile contents; create and update badges (the TileUpdateManager class); respond to notification requests; choose an appropriate tile update schedule based on app requirements
Notify users by using toast
Enable an app for toast notifications; populate toast notifications with images and text by using the ToastUpdateManager; play sounds with toast notifications; respond to toast events; control toast duration; configure and use Azure Mobile Services for push notifications

Preparation resources
Supporting navigation (Windows Store apps using JavaScript and HTML)
Tile and tile notification overview (Windows Store Apps)
Toast notification overview (Windows Store Apps)

Manage security and data (20-25%)
Choose a data access strategy
Choose the appropriate data access strategy (file based; web service; remote storage, including Microsoft Azure storage and Azure Mobile Services) based on requirements
Retrieve data remotely
Use XHR or HttpClient to retrieve web services; set appropriate HTTP verb for REST; handle progress of data requests; consume SOAP/WCF services; use WebSockets for bidirectional communication
Implement data binding
Choose and implement data-bound controls, including WinJS.UI.ListView, to meet requirements; bind data to item templates such as WinJS.Binding.Template; bind data to controls by using data-win-control and data-win-bind; configure an iterator with data-win-options; enable filtering, sorting, and grouping data in the user interface
Manage Windows Authentication and Authorization
Retrieve a user’s roles or claims; store and retrieve credentials by using the PasswordVault class; implement the CredentialPicker class; verify credential existence by using credential locker; store account credentials in app settings
Manage Web Authentication
Use the Windows.Security.Authentication.Web namespace; set up OAuth2 for authentication; CredentialPicker; set up single sign-on (SSO); implement credential roaming; implement the WebAuthenticationBroker class; support proxy authentication for enterprises

Preparation resources
Connecting to web services (Windows Store apps using JavaScript and HTML)
Data binding (Windows Store apps using JavaScript and HTML)
Managing user info (JavaScript)
QUESTION 1
You are preparing to write code that configures a CredentialPicker object. The code should allow
for platinum members to save their user credentials according to business authentication
prerequisites.
Which of the following is the property that should be included in your code?

A. The PreviousCredential property.
B. The AuthenticationProtocol property.
C. The CredentialSaveOption property.
D. The TargetName property.

Answer: C

Explanation:

QUESTION 2
You are preparing to write code that enforces the technical search capabilities requirements.
Which of the following is a method that should be included in your code?

A. The appendSearchSeparator method.
B. The appendResultSuggestion method.
C. The appendQuerySuggestions(suggestions) method.
D. The appendQuerySuggestion(text) method.

Answer: C

Explanation:

QUESTION 3
You have been instructed to make sure that customers and visitors are shown in keeping with the
prerequisites. You are preparing to write the necessary code.
Which of the following should be included in your code?

A. The CommitButtonText property of the ContactPicker class.
B. The SelectionMode property of the ContactPicker class.
C. The Email property of the ContactPicker class.
D. The DesiredFields property of the ContactPicker class.

Answer: D

Explanation:

QUESTION 4
You are preparing to write code to deal with adding and saving annotations according to the
technical product news updates prerequisites.
Which of the following should be included in the code?

A. You should consider making use of the onbeforenavigate navigation member.
B. You should consider making use of the onnavigated navigation member.
C. You should consider making use of the canGoForward navigation member.
D. You should consider making use of the canGoBack navigation member.

Answer: A

Explanation:

QUESTION 5
You are preparing to write code to satisfy the navigation business requirements.
Which of the following is the function that should be included in your code?

A. The navigate function.
B. The forward function.
C. The back function.
D. The addEventListener function.

Answer: A

Click here to view complete Q&A of 70-481 exam
Certkingdom Review

Best Microsoft MCTS Certification, Microsoft 70-481 Training at certkingdom.com

Exam 70-480 Programming in HTML5 with JavaScript and CSS3

Published: August 20, 2012
Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
Audiences: Developers
Technology: Microsoft Visual Studio 2012
Credit toward certification: MCP, MCSD

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft
Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Implement and manipulate document structures and objects (24%)
Create the document structure
Structure the UI by using semantic markup, including for search engines and screen readers (Section, Article, Nav, Header, Footer, and Aside); create a layout container in HTML
Write code that interacts with UI controls
Programmatically add and modify HTML elements; implement media controls; implement HTML5 canvas and SVG graphics
Apply styling to HTML elements programmatically
Change the location of an element; apply a transform; show and hide elements
Implement HTML5 APIs
Implement storage APIs, AppCache API, and Geolocation API
Establish the scope of objects and variables
Define the lifetime of variables; keep objects out of the global namespace; use the “this” keyword to reference an object that fired an event; scope variables locally and globally
Create and implement objects and methods
Implement native objects; create custom objects and custom properties for native objects using prototypes and functions; inherit from an object; implement native methods and create custom methods

Preparation resources
The developer’s guide to HTML5 canvas
How to zoom and pan with SVG

Implement program flow (25%)
Implement program flow
Iterate across collections and array items; manage program decisions by using switch statements, if/then, and operators; evaluate expressions
Raise and handle an event
Handle common events exposed by DOM (OnBlur, OnFocus, OnClick); declare and handle bubbled events; handle an event by using an anonymous function
Implement exception handling
Set and respond to error codes; throw an exception; request for null checks; implement try-catch-finally blocks
Implement a callback
Receive messages from the HTML5 WebSocket API; use jQuery to make an AJAX call; wire up an event; implement a callback by using anonymous functions; handle the “this” pointer
Create a web worker process
Start and stop a web worker; pass data to a web worker; configure timeouts and intervals on the web worker; register an event listener for the web worker; limitations of a web worker

Preparation resources
Controlling program flow (JavaScript)
Coding basic apps
try…catch…finally statement (JavaScript)

Access and secure data (26%)
Validate user input by using HTML5 elements
Choose the appropriate controls based on requirements; implement HTML input types and content attributes (for example, required) to collect user input
Validate user input by using JavaScript
Evaluate a regular expression to validate the input format; validate that you are getting the right kind of data type by using built-in functions; prevent code injection
Consume data
Consume JSON and XML data; retrieve data by using web services; load data or get data from other sources by using XMLHTTPRequest
Serialize, deserialize, and transmit data
Binary data; text data (JSON, XML); implement the jQuery serialize method; Form.Submit; parse data; send data by using XMLHTTPRequest; sanitize input by using URI/form encoding

Preparation resources
pattern attribute | pattern property
Sandbox
XMLHttpRequest object

Use CSS3 in applications (25%)
Style HTML text properties
Apply styles to text appearance (color, bold, italics); apply styles to text font (WOFF and @font-face, size); apply styles to text alignment, spacing, and indentation; apply styles to text hyphenation; apply styles for a text drop shadow
Style HTML box properties
Apply styles to alter appearance attributes (size, border and rounding border corners, outline, padding, margin); apply styles to alter graphic effects (transparency, opacity, background image, gradients, shadow, clipping); apply styles to establish and change an element’s position (static, relative, absolute, fixed)
Create a flexible content layout
Implement a layout using a flexible box model; implement a layout using multi-column; implement a layout using position floating and exclusions; implement a layout using grid alignment; implement a layout using regions, grouping, and nesting
Create an animated and adaptive UI
Animate objects by applying CSS transitions; apply 3-D and 2-D transformations; adjust UI based on media queries (device adaptations for output formats, displays, and representations); hide or disable controls
Find elements by using CSS selectors and jQuery
Choose the correct selector to reference an element; define element, style, and attribute selectors; find elements by using pseudo-elements and pseudo-classes (for example, :before, :first-line, :first-letter, :target, :lang, :checked, :first-child)
Structure a CSS file by using CSS selectors
Reference elements correctly; implement inheritance; override inheritance by using !important; style an element based on pseudo-elements and pseudo-classes (for example, :before, :first-line, :first-letter, :target, :lang, :checked, :first-child)


QUESTION 1
You are developing a web page that will be divided into three vertical sections. The main content of the site will be placed in the center section. The two outer sections will contain advertisements.
You have the following requirements:
? The main content section must be set to two times the width of the advertising sections.
? The layout must be specified by using the CSS3 flexible box model.
You need to ensure that the visual layout of the page meets the requirements.
Which CSS3 property should you use?

A. box-orient
B. box-flex-group
C. box-flex
D. box-direction

Answer: C
Reference:
http://www.html5rocks.com/en/tutorials/flexbox/quick/


QUESTION 2
You are developing a web application that consumes services from a third-party application. A web worker processes the third-party application requests in the background. A page in the application instantiates the web worker process.
You need to establish two-way communications between the web worker process and the page.
Which two actions will achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A. From the web worker, use the onconnect event handler of the main page to capture events.
B. From the main page, use the onmessage event handler of the web worker to capture events.
C. From the web worker, use the onmessage event handler of the main page to capture events.
D. From the main page, use the onconnect event handler of the web worker to capture events.

Answer: B,C
Reference:
http://www.w3schools.com/html/html5_serversentevents.asp
http://www.html5rocks.com/en/tutorials/workers/basics/


QUESTION 3
You are developing a customer web form that includes the following HTML.
<input id = “txtValue” />
A customer must enter a value in the text box prior to submitting the form.
You need to add validation to the text box control.
Which HTML should you use?

A. <input id=”txtValue” type=”text” required=”required”/>
B. <input id=”txtValue” type=”text” pattern=”[A-Za-z]{3}” />
C. <input id=”txtValue” type=”required” />
D. <input id=”txtValue” type=”required” autocomplete=”on” />

Answer: A
Reference:
http://www.w3schools.com/html5/att_input_required.asp


QUESTION 4
You are creating a class named Consultant that must inherit from the Employee class. The Consultant class must modify the inherited PayEmployee method. The Employee class is defined as follows.
function Employee() {}
Employee.prototype.PayEmployee = function ( ){
alertt’Hi there!’);
}
Future instances of Consultant must be created with the overridden method.
You need to write the code to implement the Consultant class.
Which code segments should you use? (Each correct answer presents part of the solution. Choose two.)

A. Consultant.PayEmployee = function ()
{
alert(‘Pay Consulant’);
}
B. Consultant.prototype.PayEmployee = function ()
{
alert(‘Pay Consultant’);
}
C. function Consultant () {
Employee.call(this);
}
Consultant.prototype = new Employee(); Consultant.prototype.constructor = Consultant; D. function Consultant() {
Employee.call(this); } Consultant.prototype.constructor = Consultant.create;

Answer: B,C


QUESTION 5
You are developing an HTML5 web application and are styling text.
You need to use the text-transform CSS property.
Which values are valid for the text-transform property?

A. hidden
B. blink
C. capitalize
D. line-through

Answer: C
Reference:
http://www.w3schools.com/cssref/pr_text_text-transform.asp
none,capitalize,uppercase,lowercase and inherit Example
Transform text in different elements: h1 {text-transform:uppercase;}
h2 {text-transform:capitalize;} p {text-transform:lowercase;}


Click here to view complete Q&A of 70-480 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-480 Training at certkingdom.com

Exam 70-475 Designing and Implementing Big Data Analytics Solutions

Published: October 27, 2015
Languages: English
Audiences: IT Professionals
Technology: Microsoft Azure
Credit toward certification: Specialist

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Design big data batch processing and interactive solutions (20-25%)
Ingest data for batch and interactive processing, design and provision compute clusters, design for data security, design for batch processing, design interactive queries for big data

Design big data real-time processing solutions (25-30%)
Ingest data for real-time processing, design and provision compute resources, design for lambda architecture, design for real-time processing

Design machine-learning solutions (25-30%)
Create and manage experiments, determine when to pre-process or train inside Machine Learning Studio, select input/output types, apply custom processing steps with R and Python, publish web services

Operationalize end-to-end cloud analytics solutions (25-30%)
Create a data factory, orchestrate data processing activities in a data-driven workflow, monitor and manage the data factory, move, transform, and analyze data

Click here to view complete Q&A of 70-475 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-475 Training at certkingdom.com

 

Exam 70-473 Designing and Implementing Cloud Data Platform Solutions

Published: October 27, 2015
Languages: English
Audiences: IT Professionals
Technology: Microsoft Azure
Credit toward certification: Specialist

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Design and implement database solutions for Microsoft SQL Server and SQL Database (20–25%)
Design a hybrid SQL Server solution
Design Geo/DR topology, design a data storage architecture, design a security architecture, design a data load strategy
Implement SQL Server on Azure Virtual Machines (VMs)
Provision SQL Server in an Azure VM, configure firewall rules, configure and optimize storage, migrate an on-premises database to Microsoft Azure, configure and optimize VM sizes by workload
Design a SQL Database solution
Design a solution architecture, design Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier
Implement SQL Database
Provision SQL Database, configure firewall rules, configure active geo-replication, migrate an on-premises database to SQL Database, configure for scale and performance
Design and implement data warehousing on Azure
Design a data warehousing solution on Azure, design a data load strategy and topology, configure SQL Data Warehouse, migrate an on-premises database to SQL Data Warehouse

Manage database management systems (DBMS) security (25–30%)
Design and implement SQL Server Database security
Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure transparent database encryption
Implement Azure SQL Database security
Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure row-level security; configure data encryption; configure data masking; configure Always Encrypted

Design for high availability, disaster recovery, and scalability (25–30%)
Design and implement high availability solutions
Design a high availability solution topology, implement high availability solutions between on-premises and Azure, design cloud-based backup solutions, implement backup and recovery strategies
Design and implement scalable solutions
Design a scale-out solution, implement multi-master scenarios with database replication, implement elastic scale for SQL Database
Design and implement SQL Database data recovery
Design a backup solution for SQL Database, implement self-service restore, copy and export databases

Monitor and manage database implementations on Azure (25–30%)
Monitor and troubleshoot SQL Server VMs on Azure
Monitor database and instance activity, monitor using dynamic management views (DMVs) and dynamic management functions (DMFs), monitor performance and scalability
Monitor and troubleshoot SQL Database
Monitor and troubleshoot SQL Database, monitor database activity, monitor using DMVs and DMFs, monitor performance and scalability
Automate and manage database implementations on Azure
Manage SQL Server in Azure VMs with PowerShell, manage Azure SQL Database with PowerShell, configure Automation and Runbooks

Click here to view complete Q&A of 70-473 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-473 Training at certkingdom.com

 

Exam 70-470 Recertification for MCSE: Business Intelligence

Published: August 10, 2014
Languages: English, Japanese
Audiences: IT professionals
Technology: Microsoft SQL Server 2014
Credit toward certification: MCP, MCSE

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Build an analysis services multidimensional database
Implement a cube
Use SQL Server Data Tools – Business Intelligence (SSDT-BI) to build the cube; use SSDT-BI to do non-additive or semi-additive measures in a cube, define measures, specify perspectives, define translations, define dimension usage, define cube-specific dimension properties, define measure groups, implement reference dimensions, implement many-to-many relationships, implement fact relationships, implement role-playing relationships, create and manage linked measure groups and linked dimensions, create actions
Implement custom logic in a data model
Define key performance indicators (KPIs); define calculated members; create relative measures (growth, YoY, same period last year), percentage of total using MDX; named sets; add Time Intelligence; implement ranking and percentile; define MDX script to import partial PowerPivot model
Select an appropriate model for data analysis
Select Tabular versus Multidimensional based on scalability needs, traditional hierarchical, data volume; select appropriate organizational BI, such as corporate BI or PowerBI, and team and personal BI needs and data status

Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database
Process data models
Define processing of tables or partitions for tabular and multidimensional models; define processing of databases, cubes, and dimensions for multidimensional models; select full processing versus incremental processing; define remote processing; define lazy aggregations; automate with Analysis Management Objects (AMO) or XML for Analysis (XMLA); process and manage partitions by using PowerShell
Install and maintain an SSAS instance
Install SSAS; install development tools; identify development and production installation considerations; upgrade SSAS instance; define data file and program file location; plan for Administrator accounts; define server and database level security; support scale-out read-only; update SSAS (service packs); install and maintain each instance type of Analysis Services, including PowerPivot; restore and import PowerPivot; back up and restore by using PowerShell

Build a tabular data model
Implement a tabular data model
Define tables, import data, define calculated columns, define relationships, define hierarchies and perspectives, manage visibility of columns and tables, embed links, optimize BISM for Power View, mark a date table, sort a column by another column
Implement data access for a tabular data model
Manage partitions, processing, select xVelocity versus DirectQuery for data access

Build a report with SQL Server Reporting Services (SSRS)
Design a report
Select report components (crosstab report, Tablix, design chart, data visualization components), design report templates (Report Definition Language), identify the data source and parameters; design a grouping structure; drill-down reports, drill-through reports; determine if any expressions are required to display data that is not coming directly from the data source
Manage a report environment
Manage subscriptions and subscription settings; define data-driven subscriptions; manage data sources; integrate SharePoint Server; define email delivery settings; manage the number of snapshots; manage schedules, running jobs, and report server logs; manage report server databases; manage the encryption keys; set up the execution log reporting; review the reports; configure site-level settings; design report lifecycle; automate management of reporting services; create a report organization structure; install and configure reporting services; deploy custom assemblies
Configure report data sources and datasets
Select appropriate query types (stored procedure versus table versus text only); configure parameterized connection strings (dynamic connection strings); define filter location (dataset versus query); configure data source options, for example, extract and connect to multiple data sources; shared and embedded data sources and datasets; use custom expressions in data sources; connect to Microsoft Azure SQL database; connect to Microsoft Azure Marketplace; implement DAX and MDX queries to retrieve appropriate data sets; work with non-relational data sources, such as XML or SharePoint lists; connect to HDInsight Server

Plan business intelligence (BI) infrastructure
Plan for performance
Optimize batch procedures: extract, transform, load (ETL) in SQL Server Integration Services (SSIS)/SQL and processing phase in Analysis Services; configure Proactive Caching within SQL Server Analysis Services (SSAS) for different scenarios; understand performance consequences of named queries in a data source view; analyze and optimize performance, including Multidimensional Expression (MDX) and Data Analysis Expression (DAX) queries; understand the difference between partitioning for load performance versus query performance in SSAS; appropriately index a fact table; optimize Analysis Services cubes in SQL Server Data Tools; create aggregations

Design BI infrastructure
Design a high availability and disaster recovery strategy
Design a recovery strategy, back up and restore SSAS databases, back up and restore SSRS databases, move and restore the SSIS Catalog, design an AlwaysON solution

Design a reporting solution
Design a Reporting Services dataset
Design appropriate data query parameters, create appropriate SQL queries, create appropriate DAX queries for an application, manage data rights and security, extract data from analysis services by using MDX queries, balance query-based processing versus filter-based processing, manage data sets through the use of stored procedures
Manage Excel Services/reporting for SharePoint
Configure data refresh schedules for PowerPivot published to SharePoint, publish BI info to SharePoint, use SharePoint to accomplish BI administrative tasks, install and configure Power View, publish PowerPivot and Power View to SharePoint
Design BI reporting solution architecture
Linked drill-down reports, drill-through reports, and sub reports; design report migration strategies; access report services API; design code-behind strategies; identify when to use Reporting Services (RS), Report Builder (RB), or Power View; design and implement context transfer when interlinking all types of reports (RS, RB, Power View, Excel); implement BI tools for reporting in SharePoint (Excel Services versus PowerView versus Reporting Services); select a subscription strategy; enable Data Alerts; design map visualization

Design BI data models
Design the data warehouse
Design a data model that is optimized for reporting; design and build a cube on top; design enterprise data warehouse (EDW) and OLAP cubes; choose between natural keys and surrogate keys when designing the data warehouse; use SQL Server to design, implement, and maintain a data warehouse, including partitioning, slowly changing dimensions (SCD), change data capture (CDC), Index Views, and column store indexes; identify design best practices; implement a many-to-many relationship in an OLAP cube; design a data mart/warehouse in reverse from an Analysis Services cube; implement incremental data load; choose between performing aggregation operations in the SSIS pipeline or the relational engine
Design cube architecture
Partition cubes and build aggregation strategies for the separate partitions; design a data model; choose the proper partitioning strategy for the data warehouse and cube; design the data file layout; identify the aggregation method for a measure in a MOLAP cube; performance tune a MOLAP cube using aggregations; design a data source view; design for cube drill-through and write back actions; choose the correct grain of data to store in a measure group; design analysis services processing by using indexes, indexed views, and order by statements

Design an ETL solution
Design SSIS package execution
Use the new project deployment model; pass values at execution time; share parameters between packages; plan for incremental loads versus full loads; optimize execution by using Balanced Data Distributor (BDD); choose optimal processing strategy (including Script transform, flat file incremental loads, and Derived Column transform)
Plan to deploy SSIS solutions
Deploy the package to another server with different security requirements, secure integration services packages that are deployed at the file system, demonstrate awareness of SSIS packages/projects and how they interact with environments (including recoverability), decide between performing aggregation operations in the SSIS pipeline or the relational engine, plan to automate SSIS deployment, plan the administration of the SSIS Catalog database

QUESTION 1
You need to identify the reports that produce the errors that Marc is receiving.
What should you do?

A. Write a query by using the Subscriptions table in the report server database.
B. Use the Windows Event Viewer to search the Application log for errors.
C. Write a query by using the ExecutionLog3 view in the report server database.
D. Search the ReportServerService_<timestamp>.log file for errors.

Answer: C


QUESTION 2
You need to deploy the StandardReports project.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

A. Deploy the project from SQL Server Data Tools (SSDT).
B. Use the Analysis Services Deployment utility to create an XMLA deployment script.
C. Use the Analysis Services Deployment wizard to create an MDX deployment script.
D. Use the Analysis Services Deployment wizard to create an XMLA deployment script.

Answer: A,D

Explanation: There are several methods you can use to deploy a tabular model project. Most of the deployment methods that can be used for other Analysis Services projects, such as multidimensional, can also be used to deploy tabular model projects.
A: Deploy command in SQL Server Data Tools
The Deploy command provides a simple and intuitive method to deploy a tabular model project from the SQL Server Data Tools authoring environment.
Caution:
This method should not be used to deploy to production servers. Using this method can overwrite certain properties in an existing model.
D: The Analysis Services Deployment Wizard uses the XML output files generated from a Microsoft SQL Server Analysis Services project as input files. These input files are easily modifiable to customize the deployment of an Analysis Services project. The generated deployment script can then either be immediately run or saved for later deployment.
Incorrect:
not B: The Microsoft.AnalysisServices.Deployment utility lets you start the Microsoft SQL Server Analysis Services deployment engine from the command prompt. As input file, the utility uses the XML output files generated by building an Analysis Services project in SQL Server Data Tools (SSDT).


QUESTION 3
You need create the data source view for the StandardReports project.
What should you do?

A. Generate a relational schema from the dimensions and cubes by using the Schema Generation wizard.
B. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.
C. Execute the Import from Table wizard and then use the Data Source View wizard.
D. Create a new data source view and then use the Import from Table wizard.

Answer: B


QUESTION 4
You need to ascertain why Marc did not receive his reports.
What should you do?

A. Search the ReportServerService_<timestamp>.log file for errors.
B. Search the registry for errors.
C. Use the Windows Event Viewer to search the Application log for errors.
D. Use SQL Server Management Studio to search the SQL Server logs for errors.

Answer: B


QUESTION 5
You need to create a measure for DOD sales.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A. Specify a date table by using a Mark as Date table.
B. Use the Data Analysis Expressions (DAX) PARALLELPERIOD() function.
C. Use the Business Intelligence Wizard to define time intelligence.
D. Use the Multidimensional Expressions (MDX) LAG() function.

Answer: A,C

Explanation: * From scenario:
A measure must be created to calculate day-over-day (DOD) sales by region based on order date.
A: Specify Mark as Date Table for use with Time Intelligence (SSAS Tabular)
In order to use time intelligence functions in DAX formulas, you must specify a date table and a unique identifier (datetime) column of the Date data type. Once a column in the date table is specified as a unique identifier, you can create relationships between columns in the date table and any fact tables.
C: The time intelligence enhancement is a cube enhancement that adds time calculations (or time views) to a selected hierarchy. This enhancement supports the following categories of calculations:
Period to date.
Period over period growth. Moving averages.
Parallel period comparisons.

Click here to view complete Q&A of 70-470 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-470 Training at certkingdom.com

7 reasons to gamify your cybersecurity strategy

Gamification relies on the competitive nature of people to help harden the company’s security.

Game on
Data breaches continue to grow in number, size, severity and cost. With the increase in new security holes, vulnerabilities and attack vectors that need to be fixed, many businesses are turning to gamification to help employees adhere to cybersecurity best practices.

Gamification is the process of engaging people and changing behavior using game mechanics in a non-game context. Essentially, it’s taking what’s fun about games and applying it to situations that maybe aren’t so fun.

By using gamification, organizations are finding new ways to educate employees on the importance of cybersecurity, through gaming elements like one-on-one competitions, rewards programs and more. Mark Stevens, senior vice president of Global Services at Digital Guardian, provided seven reasons to use gamification to address data security.

Reward good cybersecurity behavior
Reward employees when they abide by the rules, which will encourage continued good behavior. With gamification for instance, users could receive printable badges upon sending their first, 10th and 100th email without triggering a policy – leading to continued positive behavior.

Incentivize continued good behavior
Once an employee has an impressive digital badge collection, incentivize them to continue the good behavior, such as with e-store gift cards or company perks. On the contrary, if an employee continues to exhibit poor behavior in gamification, it may raise a red flag within the organization or warrant a need for further cybersecurity training.

Encourage an open data protection dialogue
Through gamification, an organization can establish a new data protection language, which encourages open dialogue among employees when discussing how to properly handle sensitive data. Instead of the topic being boring or rogue, workers are encouraged to talk about their achievements, challenges or lessons learned through the gaming system.

Address the lack of awareness
The most effective cybersecurity training is one that occurs on a regular basis throughout the year. However, a majority of businesses often don’t adhere to this training cycle, due to lack of time and resources. Gamification allows employees to acknowledge the lack of awareness and individual employee accountability sensitive data protection/hygiene, and ultimately change long-term behavior.

Increase employee engagement
Staff should be encouraged to print and display their badges in their workspaces and engage managers to recognize the good behavior by publishing a monthly leaderboard. Through leaderboard competitions and badge collections, end users are instantly engaged in the game – or training – at hand. This increases internal communication and creates new relationships, improving employee engagement across the board.

Find cybersecurity talent
Not enough people are entering the cybersecurity workforce, and most firms are faced with vacancies. Organizations like UK-based Cyber Security Challenge have been trying to tackle the talent gap by hosting yearly competitions where players face simulated threat situations they must prevent using their cyber skills. Winners are then offered lucrative job opportunities at large tech firms and government agencies who sponsor the challenge.

Audit to measure effectiveness
Of course, gamification is only effective if employees apply their lessons learned to real-world scenarios. For this reason, it’s critical that businesses measure the effectiveness of gamification at reducing real data risk. Conduct regular audits and cybersecurity assessments within the organization, to determine which employees would still pose as a risk outside of the gaming environment.

Click here to view complete Q&A of 70-414 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-414 Training at certkingdom.com

Exam 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server

Published: June 11, 2012
Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
Audiences: IT professionals
Technology: Microsoft SQL Server
Credit toward certification: MCP, MCSE

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

As of February 18, 2016, this exam includes content covering both SQL Server 2012 and 2014. Please note that this exam does not include questions on features or capabilities that are present only in the SQL Server 2012 product. For more information, please download and review this document.

Plan business intelligence (BI) infrastructure (15–20%)
Plan for performance
Optimize batch procedures: extract, transform, load (ETL) in SQL Server Integration Services (SSIS)/SQL and processing phase in Analysis Services; configure Proactive Caching within SQL Server Analysis Services (SSAS) for different scenarios; understand performance consequences of named queries in a data source view; analyze and optimize performance, including Multidimensional Expression (MDX) and Data Analysis Expression (DAX) queries; understand the difference between partitioning for load performance versus query performance in SSAS; appropriately index a fact table; optimize Analysis Services cubes in SQL Server Data Tools; create aggregations
Plan for scalability
Change binding options for partitions; choose the appropriate Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP), and Hybrid OLAP (HOLAP) storage modes
Plan and manage upgrades
Plan change management for a BI solution
Maintain server health
Design an automation strategy

Preparation resources
Create and manage a local partition
Partition storage modes and processing
Designing Aggregations (Analysis Services – Multidimensional)

Design BI infrastructure (15–20%)
Design a security strategy
Configure security and impersonation between SQL Server service, analysis services, and front end; implement Dynamic Dimension Security within a cube; configure security for an extranet environment; configure Kerberos security; design authentication mechanisms; design security tests; build secure solutions end to end; design roles for calculated measures; understand the tradeoffs between regular SSAS security and dynamic security
Design a SQL partitioning strategy
Choose the proper partitioning strategy for the data warehouse and cube, implement a parallel load to fact tables by using partition switching, use data compression
Design a high availability and disaster recovery strategy
Design a recovery strategy, back up and restore SSAS databases, back up and restore SSRS databases, move and restore the SSIS Catalog, design an AlwaysON solution
Design a logging and auditing strategy
Design a new SSIS logging infrastructure (for example, information available through the catalog views), validate data is balancing and reconciling correctly

Preparation resources
Granting cube access
Connection string properties
Partitioned tables and indexes

Design a reporting solution (20–25%)
Design a Reporting Services dataset
Design appropriate data query parameters, create appropriate SQL queries, create appropriate DAX queries for an application, manage data rights and security, extract data from analysis services by using MDX queries, balance query-based processing versus filter-based processing, manage data sets through the use of stored procedures
Manage Excel Services/reporting for SharePoint
Configure data refresh schedules for PowerPivot published to SharePoint, publish BI info to SharePoint, use SharePoint to accomplish BI administrative tasks, install and configure Power View, publish PowerPivot and Power View to SharePoint
Design a data acquisition strategy
Identify the data sources that need to be used to pull in the data, determine the changes (incremental data) in the data source (time window), identify the relationship and dependencies between the data sources, determine who can access which data, determine what data can be retained for how long (regulatory compliance, data archiving, aging), design a data movement strategy, profile source data
Plan and manage reporting services configuration
Choose the appropriate reporting services requirements (including native mode and SharePoint mode)
Design BI reporting solution architecture
Linked drill-down reports, drill-through reports, and sub reports; design report migration strategies; access report services API; design code-behind strategies; identify when to use Reporting Services (RS), Report Builder (RB), or Power View; design and implement context transfer when interlinking all types of reports (RS, RB, Power View, Excel); implement BI tools for reporting in SharePoint (Excel Services versus PowerView versus Reporting Services); select a subscription strategy; enable Data Alerts; design map visualization

Preparation resources
Configure Windows Authentication on the Report Server
Different ways to update data in PowerPivot
Add dataset filters, data region filters, and group filters (Report Builder and SSRS)

Design BI data models (30–35%)

Design the data warehouse
Design a data model that is optimized for reporting; design and build a cube on top; design enterprise data warehouse (EDW) and OLAP cubes; choose between natural keys and surrogate keys when designing the data warehouse; use SQL Server to design, implement, and maintain a data warehouse, including partitioning, slowly changing dimensions (SCD), change data capture (CDC), Index Views, and column store indexes; identify design best practices; implement a many-to-many relationship in an OLAP cube; design a data mart/warehouse in reverse from an Analysis Services cube; implement incremental data load; choose between performing aggregation operations in the SSIS pipeline or the relational engine
Design a schema
Multidimensional modeling starting from a star or snowflake schema, design relational modeling for a Data Mart
Design cube architecture
Partition cubes and build aggregation strategies for the separate partitions; design a data model; choose the proper partitioning strategy for the data warehouse and cube; design the data file layout; identify the aggregation method for a measure in a MOLAP cube; performance tune a MOLAP cube using aggregations; design a data source view; design for cube drill-through and write back actions; choose the correct grain of data to store in a measure group; design analysis services processing by using indexes, indexed views, and order by statements
Design fact tables
Design a data warehouse that supports many to many dimensions with factless fact tables
Design BI semantic models
Plan for a multidimensional cube; support a many-to-many relationship between tables; choose between multidimensional and tabular, depending on the type of data and workload
Design and create MDX calculations
Design MDX queries, identify the structures of MDX and the common functions (tuples, sets, TopCount, SCOPE, VisualTotals, and more), create calculated members in an MDX statement, identify which MDX statement would return the required result, implement a custom MDX or logical solution for a pre-prepared case task

Preparation resources
Defining a many-to-many relationship
Define Relationship dialog box (Analysis Services – multidimensional data)
Set aggregation options (Usage-Based Optimization Wizard)

Design an ETL solution (10–15%)
Design SSIS package execution
Use the new project deployment model; pass values at execution time; share parameters between packages; plan for incremental loads versus full loads; optimize execution by using Balanced Data Distributor (BDD); choose optimal processing strategy (including Script transform, flat file incremental loads, and Derived Column transform)
Plan to deploy SSIS solutions
Deploy the package to another server with different security requirements, secure integration services packages that are deployed at the file system, demonstrate awareness of SSIS packages/projects and how they interact with environments (including recoverability), decide between performing aggregation operations in the SSIS pipeline or the relational engine, plan to automate SSIS deployment, plan the administration of the SSIS Catalog database
Design package configurations for SSIS packages
Avoid repeating configuration information entered in SSIS packages, and use configuration files

Preparation resources
Data profiling task
Create package configurations
Deployment of projects and packages

QUESTION 1
You need to create the Sales Reporting shared SSRS data source.
Which SSRS data connection type should you use?

A. OData
B. Microsoft SQL Server
C. ODBC
D. OLE DB

Answer: B


QUESTION 2
You need to grant appropriate permissions to the SSISOwners SQL Server login.
What should you do?

A. Map the login to the SSISDB database. Assign the user to the ssis_admin role.
B. Map the login to the msdb database. Assign the user to the db_owner role.
C. Map the login to the msdb database. Assign the user to the db_ssisadmin role.
D. Map the login to the SSISDB database. Assign the user to the db_ssisadmin role.
E. Map the login to the SSISDB database. Assign the user to the db_owner role.
F. Map the login to the msdb database. Assign the user to the ssis_admin role.

Answer: D


QUESTION 3
You need to configure data refresh for the Manufacturing Performance PowerPivot workbook.
What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)

A. Configure the PowerPivot Data Refresh Timer Job to run every 60 minutes.
B. Restore the PowerPivot workbook to an SSAS instance in tabular mode.
C. Script a process command and configure a SQL Server Agent job to execute the command every 60 minutes.
D. Restore the PowerPivot workbook to an SSAS instance in PowerPivot for SharePoint mode.

Answer: A


QUESTION 4
You need to configure package execution logging to meet the requirements.
What should you do?

A. Configure logging in each ETL package to log the OnError, OnInformation, and Diagnostic events.
B. Set the SSIS catalog’s Server-wide Default Logging Level property to Performance.
C. Set the SSIS catalog’s Server-wide Default Logging Level property to Basic.
D. Set the SSIS catalog’s Server-wide Default Logging Level property to Verbose.
E. Configure logging in each ETL package to log the OnError, OnPreExecute, and OnPostExecute events.

Answer: B

Click here to view complete Q&A of 70-467 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-467 Training at certkingdom.com

admin's RSS Feed
Go to Top