Category Archive:

70-357 Developing Mobile Apps

Published: July 22, 2016
Languages: English, Spanish, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Portuguese (Brazil), Russian
Audiences: Developers
Technology: Visual Studio Community
Credit toward certification: MCP, MCSA

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.

Develop a XAML page layout for an adaptive UI (10–15%)
Construct a page layout
Configure a RelativePanel layout; select the appropriate XAML layout panel based on the UI requirement; configure a grid with appropriate column and row properties; configure alignment, margins, and padding
Implement responsive and adaptive UI behaviors
Differentiate between responsive and adaptive UI behaviors, create responsive and adaptive UIs by using VisualStateManager and AdaptiveTriggers, implement settings syntax for element properties and attached properties
Create and use custom controls within an adaptive UI
Evaluate when to create a custom control; create a custom control; implement styles, themes, and resource dictionaries; apply styles to custom controls by using Generic.xaml
Optimize a page layout
Reduce complexity for performance gains, reduce unnecessary nesting

Implement page navigation and lifecycle events (10–15%)
Choose the appropriate navigation structure for an app
Evaluate when to implement the Hub, Master/Details, Tabs and Pivot, and Nav Pane navigation patterns; evaluate when to implement a custom navigation pattern
Implement Nav Pane navigation
Load page content by using Frame.Navigate, implement page navigation by using the Nav Pane pattern; implement a SplitView control for use as a navigation pane; support accessibility requirements within navigation by implementing key based navigation, UI automation, and narrator; handle Back button behavior for different Windows 10 device families
Manage app activation
Launch an app, activate an app on Startup, implement activation from a deep link, implement activation based on Search integration, implement activation from a secondary tile
Manage app suspension and resuming
Prepare an app for suspension, resume from suspension or termination, extend execution and monitor suspension errors

Implement data access and data binding (20–25%)
Access data by using Entity Framework (EF)
Access data by using EFCore with SQLite, implement a local SQLite database
Implement the {Binding} extension
Implement the {x:Bind} extension
Implement MVVM classes and class interactions
Implement event binding by applying command patterns, implement a Dispatcher to update the UI thread with async return data
Implement app-to-app communications
Integrate a Share contract to share content with another app, integrate drag-and-drop, launch an app for results, implement app extensions, implement App Services
Implement REST Web Services
Implement JSON and data serialization, access cloud data and Web APIs by using HttpClient
Implement file system access
Manage storage by using StorageFile, StorageFolder, and StorageItem; access a file location by using FilePickers; implement data roaming and roaming folders

Implement feature detection for adaptive coding (10–15%)
Implement API detection within adaptive code
Implement Type detection within adaptive code
Implement supported capabilities
Implement support for a microphone, implement support for a webcam, implement support for location, implement support for enterprise authentication

Manage user input and custom user interactions (10–15%)
Implement command bars, flyouts, and dialogs
Implement command bars and AppBarButton buttons, implement context menus and menu flyouts, implement content dialogs, display a tooltip by using ToolTipService, display a pop-up menu, implement control over app settings
Implement support for traditional and touch input devices
Support touch input, support mouse input, support keyboard and virtual keyboard input
Implement speech and voice commands
Support speech synthesis, support speech recognition, support Cortana integration, support Personal Assistant Launch capability, support voice commands
Implement alternative forms of input
Implement inking, implement camera input, implement location services and GPS input

Manage authentication and identity management (10–15%)
Implement authentication using Web Authentication Broker
Implement web service authentication, implement OAuth, implement Azure Active Directory authentication
Manage credentials securely with Credential Locker
Implement two-factor authentication
Implement two-factor authentication using Microsoft Passport, implement two-factor authentication using Windows Hello

Implement notifications, background tasks, and reusable components (15–20%)
Create and consume class libraries and Windows Runtime components
Develop Windows Runtime components, develop class libraries, integrate class libraries and Windows Runtime components
Implement tile and toast notifications
Implement adaptive and interactive toast notifications, implement local tile notifications
Create and register a background task
Create a background task project and reference the background task within a project, implement background task event triggers and conditions
Implement and manage a background task
Monitor background task progress and completion, manage task lifecycle, share data and events between an app and its background tasks, call a background task directly
Create and consume a Universal Windows Platform (UWP) app service
Specify the AppService extension, implement app service as a background task, deploy the app service provider, call app services


QUESTION 1 – (Topic 1)
You need to configure the app to meet the load time requirements.
What should you do?

A. Set the value of the CacheSize to 0.
B. Set the value of the CacheMode property to BitmapCache.
C. Set the value of the NavigationCacheMode property to Enabled.
D. Set the value of the NavigationCacheMode property to Disabled.

Answer: C

Explanation:
Scenario: You must optimize the app using the following guidelines:
? You must minimize the time it takes to display content when an item on the timeline is selected.
? The app must respect memory and resource constraints for all devices.
You use the NavigationCacheMode property to specify whether a new instance of the page is created for each visit to the page or if a previously constructed instance of the page that has been saved in the cache is used for each visit.
The default value for the NavigationCacheMode property is Disabled. Set the
NavigationCacheMode property to Enabled or Required when a new instance of the page is not essential for each visit. By using a cached instance of the page, you can improve the performance of your application and reduce the load on your server.


QUESTION 2 – (Topic 1)
Note: This question is part of a series of questions that present the same scenario. Each
question in the series contains n unique solution. Determine whether the solution meets the stated goals.
You need to implement the appropriate XAML layout (or the Timeline app.
Solution: You create an instance of a RelativePanel class.
Does this meet the goal?

A. Yes
B. No

Answer: A

Explanation: RelativePanel lets you layout UI elements by specifying where they go in relation to other elements and in relation to the panel. By default, an element is positioned in the upper left corner of the panel.


QUESTION 3 – (Topic 1)
You need to design the navigation tor the timeline.
What navigation should you use?

A. hierarchy
B. peer
C. hub
D. master/details

Answer: A

Explanation:
From scenario:
Here we can use a hierarchy with each parent node having only one single child node.
Hierarchical structures are good for organizing complex content that spans lots of pages or when pages should be viewed in a particular order. The downside is that hierarchical pages introduce some navigation overhead: the deeper the structure, the more clicks it takes for users to get from page to page.
We recommend a hiearchical structure when:
You expect the user to traverse the pages in a specific order. Arrange the hierarchy to
enforce that order.
There is a clear parent-child relationship between one of the pages and the other pages in the group.
There are more than 7 pages in the group.
When there are more than 7 pages in the group, it might be difficult for users to understand how the pages are unique or to understand their current location within the group. If you don’t think that’s an issue for your app, go ahead and make the pages peers

 

Click here to view complete Q&A of 70-357 exam
Certkingdom Review
, Certkingdom PDF Torrents

MCTS Training, MCITP Trainnig

Best Microsoft 70-357 Certification, Microsoft 70-357 Training at certkingdom.com


Continue Reading

Exam 70-735 OEM Manufacturing and Deployment for Windows 10

Published: June 19, 2017
Languages: English
Audiences: IT Professionals
Technology: Windows 10
Credit toward certification: MCP

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.

Prepare the Imaging Environment (20-25%)
Install deployment tools and scripts
Prepare the Windows Assessment and Deployment Kit (Windows ADK), prepare the required tools from the Windows ADK installation
Add customizations to the image
Use tools to design an answer file that will add branding to the device, add OEM information such as support URL or phone support number, provide the default product key for OEM Activation implementation, set the default user languages, add the custom logo and wallpaper
Create a Windows Preinstallation Environment (Windows PE)
Use the Windows ADK scripts to create the Windows PE source files, add optional packages, add default languages, add custom scripts, create a bootable USB or ISO file of the Windows PE, add device drivers

Service the Offline Image (40-45%)
Add drivers to the image
Choose the recommended installation paths for adding drivers, add INF-based drivers offline, add INF-based drivers from a folder path using deployment tools
Add language packs to the image
Distinguish the difference between a language pack and a language interface pack; determine when to use Feature on Demand language packs, how to apply the ordering of Feature on Demand language packs when adding new languages to the image, and which language packs should be applied to the Recovery image; set the default time zone in the image; set the default input and system locales in the image
Add update packages to the image
Choose which updates to apply, select which updates to apply to Windows image and Recovery image
Service in-box applications
Reapply in-box applications, select the appropriate dependency packages for each application bundle, troubleshoot installation failures, pin apps to Start layout and taskbar
Optimize the image
Mark updates in a Recovery image as permanent, export a Recovery image, set scratch space size, check the overall size of a Recovery image for partition layout schemes
Deploy the image
Select the disk partition layout, run DISM to apply the image, set up the recovery environment, boot into Audit mode for online servicing

Service the Online Image (35-40%)
Preinstall Office 2016
Prepare office files for preinstallation, create configuration files, add multiple languages, set up the first user experience
Create restore packages
Use ScanState to create restore packages of installed desktop applications, registry settings, and application settings
Prepare the recovery environment
Create extensibility scripts, create configuration files, create migration files, copy backup files to the recovery folder for Push Button Reset
Reseal the image
Use Sysprep to reseal the image to OOBE, boot to Windows PE for final capture, optimize the image for disk footprint, mark update packages as permanent, optimize the image for deployment, use deployment tools to capture the final image for mass deployment
Deploy and validate the image
Test the final image deployment, verify that settings are correct, the image passes system validation tests, and Push Button Reset restores the image to its correct state

QUESTION 1
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are building a new image of Windows 10 that contains a push-button reset solution.
You need to test whether push-button reset works as expected.
Solution: From Windows 10. you press and hold the SHIFT key, and then you restart the computer. After the computer restarts, you click Troubleshoot, and then you click Reset this PC.
Does this meet the goal?

A. Yes
B. No

Answer: B


QUESTION 2
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question Is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a computer named Computer1 that runs Windows 10. Computer1 has the Windows Assessment and Deployment Kit (Windows ADK) installed.
You are building a new image of Windows 10.
You copy the installation media for Windows 10 to Computer1.
You need to add drivers to the Windows 10 image.

A. Mount the Install.wim file.
B. Mount the Boot.wim file.
C. Modify the Winpeshl.ini file.
D. Create an answer file.
E. Modify the Windows.ini file.
F. Create a provisioning package.
G. Load a catalog file (.clg).
H. Create a cabinet file (.cab).

Answer: B


QUESTION 3
This question requires that you evaluate the underlined text to determine if it is correct.
To provide the default product key for OEM activation, you create an answer file by using Windows System Image Manager (Windows SIM), and you add the Microsoft-Windows-Shell-Setup component and the ProductKey component to the generalize pass.
Review the underlined text. It it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

A. No change is needed
B. auditSystem pass
C. specialize pass
D. windowsPE pass

Answer: C


QUESTION 4
You deploy an image of Windows 10.
From audit mode, you install several applications for a customer, and then you run sysprep.exe /oobe /quit.
You need to identify whether any errors occurred when you ran sysprep.exe.
Which folder contains the log files?

A. %WINDIR%\Logs
B. %WlNDIR%\System32\LogFiles
C. %WINDIR%\Panther\
D. %WINDIR%\System32\Sysprep\Panther

Answer: D

 

Click here to view complete Q&A of 70-735 exam
Certkingdom Review
, Certkingdom PDF

MCTS Training, MCITP Trainnig

Best Microsoft MCP 70-735 Certification, Microsoft 70-735 Training at certkingdom.com


Continue Reading

Exam 70-694 Virtualizing Enterprise Desktops and Apps

Published: January 8, 2015
Languages: English
Audiences: IT professionals
Technology: Windows 8.1, Windows Server 2012 R2, Microsoft Intune
Credit toward certification: MCP

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.

Plan app virtualization (27%)
Design an app distribution strategy
Design considerations, including impact on clients, offline access, deployment infrastructure, and remote locations; plan for updates to apps
Plan and implement app compatibility
Configure and implement Microsoft Assessment and Planning (MAP) Toolkit; planning considerations, including Remote Desktop Services (RDS), Virtual Desktop Infrastructure (VDI), client Hyper-V, and Application Compatibility Toolkit (ACT); plan for application version co-existence
Update apps in desktop images
Configure online servicing, apply patches offline, configure offline virtual machine (VM) servicing, update Microsoft Deployment Toolkit (MDT) task sequences

Implement app virtualization (25%)
Configure App-V
Configure a new application, configure a Connection Group, configure App-V reporting on the client, create a report for App-V
Deploy App-V clients
Install and test the App-V client; configure the App-V client; configure the App-V client, by using Group Policy
Configure apps sequencing
Install the App-V Sequencer, deploy sequenced apps, update sequenced apps, publish Office 2013 and Sequencing Add-On for Word 2013, deploy connected apps

Plan and implement virtual desktops (21%)
Plan for pooled and personal desktops
Planning considerations, including shared storage, network, Storage Spaces, and scale-out file servers; plan capacity
Implement virtual desktop collections
Configure collections type, VM creation, and user assignments; configure client settings; configure Active Directory permissions
Plan and implement Remote Desktop Services (RDS)
Install and configure Remote Desktop Session Host, install and configure the Remote Desktop Web Access (RD Web Access) role, configure the Remote Desktop Connection Broker (RD Connection Broker) for the Remote Desktop Session Host, perform capacity analysis
Create and configure remote applications
Prepare Remote Desktop Session Hosts for application installation; configure RemoteApp properties; create a RemoteApp distribution file (MSI or RDP); sign packages with certificates; implement application version co-existence, by using RD Web Access; configure file extension associations
Deploy and manage remote applications
Configure RemoteApp and Desktop Connections settings, configure GPOs for signed packages, configure RemoteApp for Hyper-V, export and import RemoteApp configurations, deploy a RemoteApp distribution file (MSI or RDP)

Plan and implement business continuity for virtualized apps (27%)
Plan and implement a resilient Remote Desktop infrastructure
Design highly available RD Web Access, RD Connection Broker, and Remote Desktop Gateway; perform backup and recovery of the Remote Desktop Licensing server; configure VM or dedicated farm redirection
Plan and implement business continuity for virtual desktops
Design and implement Hyper-V Replica with Hyper-V Replica Broker, design and implement business continuity for personal and shared desktop collections
Plan and implement a resilient virtual app delivery infrastructure
Plan and implement highly available App-V data store and management server; implement pre-populated/shared cache App-V functionality for the VDI environment; implement highly available content share; implement a branch office strategy, using App-V; manage VM backups


QUESTION 1
You need to meet the application requirements for Server1 and Server2.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

A. Create a selection profile.
B. Create a deployment database.
C. Create a linked deployment share.
D. Modify the deployment share properties.
E. Create a new image group.

Correct  Click here to view the answers

Explanation
Explanation/Reference:


QUESTION 2
Which software should you install on Server2 to support the planned changes?

A. SQL Server 2012 Express
B. WDS
C. Windows Assessment and Deployment Kit (Windows ADK)
D. Microsoft .NET Framework 3.5

Correct  Click here to view the answers

Explanation/Reference:


QUESTION 3
You need to meet the application requirements for the client computers of the managers.
What should you do?

A. Create a customization file named Custom.msp. Copy Custom.msp to \\Server4 \Software\Updates. Run \\Server4\Software\Setup.exe without specifying any parameters.
B. Create a customization file named Custom.xml. Copy Custom.xml to \\Server4 \Software\Proplus.ww. Run \\Server4\Software\Setup.exe without specifying any parameters.
C. Create a customization file named Custom.xml. Copy Custom.xml to \\Server4 \Software\Updates. Run \\Server4\Software\Setup.exe without specifying any parameters.
D. Create a customization file named Answer.xml. Copy Answer.xml to the managers’ computers. Run \\Server4\Software\Setup.exe and specify the /admin parameter.

Correct  Click here to view the answers

Explanation/Reference:

Click here to view complete Q&A of 70-694 exam
Certkingdom Review
, Certkingdom PDF 70-694

MCTS Training, MCITP Trainnig

Best Microsoft Office Specialist 70-694 Certification, Microsoft 70-694 Training at certkingdom.com


Continue Reading

Exam 70-696 Administering System Center Configuration Manager and Intune

Published: January 23, 2015
Languages: English, Spanish, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Portuguese (Brazil)
Audiences: IT professionals
Technology: Windows 8.1, Windows Server 2012 R2, Microsoft Intune
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 2016, this exam was updated to reflect Windows 10 scenarios, requirements, and any related service pack updates. To learn more about these changes and how they affect the skills measured, please download and review the Exam 70-696 change document.

Deploy and manage virtual applications (10–15%)
Prepare virtual applications
Sequence applications, install and configure the sequencer environment, prepare applications for deployment in different environments, configure virtual application interaction and sharing
Manage application virtualization environments
Configure App-V, manage application cache, configure System Tray/SFTTray.exe switches, configure application extensions with virtualized applications, configure application settings using group policies
Deploy and manage RemoteApp
Configure RemoteApp and Desktop Connections settings, configure Group Policy Objects (GPOs) for signed packages, subscribe to the RemoteApp and Desktop Connections feeds, support iOS and Android, configure Remote Desktop web access for RemoteApp distribution, configure and deploy Azure RemoteApp

Deploy and manage desktop and mobile applications (15–20%)
Plan an application distribution strategy
Considerations, including impact on clients due to offline access, deployment infrastructure, and remote locations; choose the appropriate application distribution method; plan to distribute applications to mobile devices, including Windows Phone, iOS, and Android, by using Microsoft Intune; plan to distribute applications to devices including Windows Store Apps
Deploy applications using Microsoft System Center Configuration Manager
Choose and configure deployment types, configure user device affinity, configure requirements, manage the software library and application catalog
Deploy applications using Microsoft Intune
Choose between automatic and manual deployment, configure application deployment policies, add software packages, configure the company portal
Plan for application upgrades
Considerations, including application version co-existence, compatibility issues, and migrating application settings and configurations; re-sequence/redeploy applications
Monitor applications
Monitor offline application usage; monitor real-time sessions; monitor application licensing usage; configure Asset Intelligence in Configuration Manager; monitor applications, using Software Center
Manage content distribution
Manage distribution points, distribution point groups, and Content Library; monitor log files

Plan and implement software updates (15–20%)
Plan and deploy third-party updates
Plan for third-party support, integrate System Center Updates Publisher with Configuration Manager
Deploy software updates by using Configuration Manager and Windows Server Update Services (WSUS)
Configure software update point synchronization to Windows Update, use reports and In Console Monitoring to identify required updates, create update groups, create and monitor deployments, analyze log files, configure Automatic Deployment Rules (ADR), provide secondary access to Windows Update, configure GPO settings
Servicing Windows using Microsoft Intune and the Windows as a Service Model
Use reports and In Console Monitoring to identify required updates, approve or decline updates, configure automatic approval settings, configure deadlines for update installations, deploy Microsoft and non-Microsoft updates, plan for a service branch

Manage compliance and Endpoint Protection settings (15–20%)
Build a Configuration Item (CI)
Create a CI, import a CI, set CI versioning, remediate rules
Create and monitor a baseline
Deploy a baseline, import a configuration pack, build a custom baseline
Configure Endpoint Protection
Create and manage the Endpoint Protection policy; configure definitions within the client policy; export policies; choose which template to use; select exclusions; configure Endpoint Protection, using Microsoft Intune; use In Console Monitoring to monitor client compliance

Manage Configuration Manager clients (15–20%)
Deploy and manage the client agent
Identify deployment methods, manage client agent settings
Manage collections
Plan the collection structure; define rules for collections; customize collection-specific settings, including maintenance windows and power management
Configure and monitor client status
Configure client status settings, use In Console Monitoring to determine client health, configure alert thresholds, configure client health auto-remediation

Manage inventory using Configuration Manager (10–15%)
Manage hardware and software inventory
Extend hardware inventory WMI classes, export and import WMI class settings, configure standardized vendor names, analyze the identified inventory and generate reports
Manage software metering
Create software metering rules, enable or disable auto-generated rules, report software metering results
Create reports
Clone and modify reports, create custom reports, import and export reports, manage asset intelligence, install the asset intelligence sync point, enable the WMI classes, modify categories and labels, analyze reports

Provision and manage mobile devices (10–15%)
Integrate Configuration Manager with the Exchange ActiveSync Connector
Configure and apply ActiveSync policies, view inventory on mobile devices, configure connection to an on-premises or Hosted Exchange server environment, monitor the Exchange connector log file
Manage devices with Microsoft Intune
Provision user accounts, enroll devices, integrate Microsoft Intune with Configuration Manager, view and manage all managed devices, configure the Microsoft Intune subscriptions, configure the Microsoft Intune connector site system role, manage profiles and conditional access by using Microsoft Intune
Manage connection profiles, by using Configuration Manager
Configure Remote Desktop profiles, certificate profiles, email profiles, and Wi-Fi profiles
 


Question 1
You need to recommend a deployment solution for App6.
What is the best recommendation? More than one answer choice may achieve the goal.
Select the BEST answer.

B. a local installation
C. a RemoteApp program
D. a Microsoft Application Virtualization (App-V) package

Answer: D


Question 2
You need to resolve the Windows update issue.
What should you do?

A. Modify the Group Policy objects (GPOs) in Active Directory.
B. Synchronize software updates from Configuration Manager.
C. Create an automatic deployment rule.
D. Add distribution points to each branch office.

Answer: D
 


Question 3
You need to ensure that the personal devices that run Windows 8.1 meet the corporate
security policy requirements.
What should you do first?

A. Create a federated trust with Windows Azure Active Directory.
B. Create a federated identity relationship with the Microsoft Federation Gateway.
C. Enroll the device in Windows Intune.
D. Join the devices to the domain by using an offline domain join.

Answer: C
 


Question 4
You need to make App4 available to all of the users.
What should you do?

A. Package App4 as an MSI package and upload the installer to Windows Intune.
B. Sequence App4 and use streaming delivery.
C. Deploy App4 as a Configuration Manager package.
D. Deploy App4 to a Remote Desktop Session Host (RD Session Host) server.

Answer: D

Click here to view complete Q&A of 70-696 exam
Certkingdom Review
, Certkingdom PDF 70-696

MCTS Training, MCITP Trainnig

Best Microsoft Office Specialist 70-696 Certification, Microsoft 70-696 Training at certkingdom.com


Continue Reading

Exam MB2-709 Microsoft Dynamics Marketing

Exam MB2-709 Microsoft Dynamics Marketing

Published: July 9, 2015
Languages: English
Audiences: Information workers
Technology: Microsoft Dynamics Marketing
Credit toward certification: MCP

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.

Apply integrated marketing management (IMM) solution concepts (10-15%)
Describe marketing organizations and their solution requirements
Identify typical marketing organization types and roles, define their functional needs, define specific marketing scenarios
Identify the characteristics of an IMM solution
Define IMM disciplines; identify functional product modules, define a solution implementation scope
Explain integration options
Characterize a customer relationship management (CRM) integration scenario, explain external Power BI reporting options, outline social engagement integration options

Set up and configure the application (10-15%)
Provision the software
Provision a mobile device management (MDM) system via Office 365, explain the Office 365 user setup process, describe the license assignment process
Explain the user interface and administrative settings
Indicate key navigation functionality, set up dashboard widgets; demonstrate user interface customization options; configure user alerts options; describe key administrative system settings; enter support tickets, and work with support for resolution
Define users, contacts, and organizations
Set up different types of companies; introduce business hierarchies; create contact records; create templates for programs, campaigns, jobs, approvals, and estimates; explain the users and contacts relationship; define user and role privileges; use custom contact fields

Create, track, and measure multichannel marketing communication (10-15%)
Prepare system for multichannel marketing activities
Explain different email marketing plug-ins; review functional options of the Subscription Center; evaluate available email editor options; compare available email designations and rules; demonstrate file management for email marketing; describe events, landing pages, A/B testings, and webinars
Compose and send email marketing messages
Determine functional options of the drag-and-drop email editor, identify available personalization and dynamic content options, expand on legal requirements for marketing email communication, characterize email performance reporting options, create queries; understand marketing lists
Create and post social media messages
Set up social media outlets; create and dispatch social media messages, create and integrate landing pages into email messages; create email templates; gather leads and connections with CRM

Generate and manage marketing leads (10-15%)
Capture and nurture marketing leads
Explore alternative lead creation methods and sources; describe available lead creation rules and strategies, differentiate between leads and lead interactions, apply manual and automated lead scoring, outline landing page design and operation options
Convert marketing leads and close opportunities
Identify key stages of the lead lifecycle, explain the Sales Ready stage and its relevance for an integrated MDM/CRM scenario, assign leads automatically based on defined criteria
Apply lead-based segmentation
Characterize different segmentation options; explain list and query setup, maintenance, and synchronization options with CRM

Automate marketing campaigns (10-15%)
Plan automated marketing campaigns
Name and explain different campaign action and response types, compare different types of email campaigns, explore functional options available to pre-test certain campaign contents
Compose and activate the campaign workflow
Describe best practice examples for setting up automated campaign workflows, validate and activate automated campaigns
Maintain and report on automated campaigns
Demonstrate campaign performance and results tracking options, display sales collaboration features in an integrated MDM/CRM scenario, devise best-practices for mid-flight campaign alterations

Measure marketing performance and results (10-15%)
Use built-in performance reporting
Demonstrate benefits and limitations of built-in reports; explore report security options; compare built-in reports with ad-hoc list view reports; create standard Power BI dashboard widgets; repurpose OOB fields; add new fields for reporting needs
Leverage external reporting
Leverage Power BI functionality to build external custom reports, explain the role and function of the OData interface, demonstrate how Microsoft Social Engagement reports can be embedded

Manage marketing projects (10-15%)
Work with jobs, tasks, and requests
Compare typical job workflow scenarios, explain the job teams and job tasks functionality, build a job request connected to a job template
Manage digital assets and approval workflows
Name supported file types, point out available online markup functionality, compare different approval methods and user roles, manage file versioning and purge of deleted files, assist in naming conventions for files and a file library folder structure
Plan and organize events
Describe event registration and attendance management, define event venues and facilities, set up and manage event sessions, create approval templates

Manage marketing finance (5-10%)
Manage marketing budgets
Set up a chart of accounts, manage and maintain marketing budgets, configure budget security, differentiate between a workbook and a worksheet
Track expenses and other costs
Explore how to track marketing expenses and direct cost of labor; track time slips; report on planned versus actual project costs; create purchase orders, invoices, expenses, and estimates
Plan and buy media
Introduce media vendors and outlets, build a media plan and create media orders, report based on media usage and channel performance, compose a rate card

Integrate Microsoft Dynamics Marketing with CRM (10-15%)
Explain the business case scenario
Describe the solution’s underlying philosophy; determine limiting factors and exception criteria; assist the marketing and sales team to define which fields will be integrated; define business rules for leads, opportunities, and new campaigns
Describe technical requirements
Name the supported MDM and CRM versions and deployment options, identify the required technical steps to complete the integration, describe the MDM configuration steps for the MDM-CRM Connector

Click here to view complete Q&A of MB2-709 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft MCP MB2-709 Certification, Microsoft MB2-709 Training at certkingdom.com


Continue Reading

Exam 70-713 Software Asset Management (SAM) – Core

Published: April 11, 2017
Languages: English, Spanish, Chinese (Simplified), French, German, Italian, Japanese, Portuguese (Brazil), Russian
Audiences: IT Professionals
Technology: Microsoft SAM Optimization Model, ISO/IEC 19770-1 standards, IAITAM best practices, ITIL SAM-related standards
Credit toward certification: MCP

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.

Assess SAM Programs by using the SAM Optimization Model (SOM) (15-20%)
Define the scope of a SAM program assessment
Identify infrastructure groups and locations, identify estimated quantity of hardware and on-premises and cloud software assets, identify functional descriptions for each group and key points of contact
Assess SAM processes, policies, resources, and tools throughout an organization
Assess infrastructure groups for the existence of documented SAM procedures, roles, and responsibilities
Assign maturity levels
Assign maturity levels according to the 10 components of SOM, Assign one of four maturity levels to each component
Perform a gap analysis between maturity levels
Perform a gap analysis between the current maturity level and the desired maturity level, review assigned maturity levels

Manage Software Licenses (15-20%)
Collect and manage complete hardware and on-premises and cloud software inventories
Review an organization’s hardware and on-premises and cloud software inventory collection processes and data to ensure completeness
Validate inventory accuracy
Normalize on-premises and cloud software inventories, reconcile on-premises and cloud software inventories against other data sources, verify the accuracy of specified license metrics such as user counts based on HR employee records
Collect, validate, and manage license entitlement records
Gather, store, normalize, and validate license entitlement records and term documents, provide reports as needed
Perform a periodic reconciliation of on-premises and cloud software inventories, license entitlements and optimization opportunities
Reconcile on-premises and cloud software inventory data against on-premises and cloud software license entitlements data, determine and report license compliance status

Coordinate Data Collection Technologies (15-20%)
Manage data collection and ensure completeness
Identify machine type, agent installation requirements, collection schedules, and discrepancies between inventories, define data schemas, identify data storage locations, normalize collected data
Coordinate data collection between operations groups
Facilitate data transfer and synchronization between various IT groups; validate data between various IT groups; ensure that overall SAM processes are being followed; collect data for security, virtualization, and third-party resources including Linux
Manage data interfaces between disparate data sources
Identify the process of matching common fields, cross-referencing, and consolidation and integration of data from multiple sources
Manage reporting
Gather requirements for general user and executive reports, generate and maintain periodic reports, maintain the infrastructure necessary for ad hoc reporting requests, generate reports for software publishers

Design and Manage a SAM Program (25-30%)
Secure executive sponsorship and ongoing cadence
Identify stakeholders, create proposal materials, obtain explicit executive authorization for software asset infrastructure, policies, and overall corporate governance, establish a regular engagement with the senior management team
Secure funding
Estimate operational costs in both consulting hours and employee time, create a project plan and budget, obtain funding from each infrastructure group for each task associated with managing a SAM program
Design a SAM program
Identify resources and objectives for a SAM program, align resources with customer requirements and schedules, coordinate acquisition strategies, coordinate optimization methods that include Software as a Service (SaaS), Platform as a Service (PaaS), and application virtualization, ensure strong security and compliance requirements
Implement a SAM program
Create a SAM stakeholder group to oversee the project, assess and benchmark the current state of SAM according to industry standards such as ISO/IEC 19770-1 and IAITAM, implement technologies to support asset discovery, enhance purchasing processes to include storage and retrieval of license entitlement information, perform initial license and cloud services reconciliation, create policies, processes, and procedures to support SAM efforts, secure support from all associated departments, educate employees
Maintain a SAM program
Monitor adherence to the policies, processes, and procedures of an organization’s SAM life cycle, standardize SAM processes across all domains and organizational units, perform periodic license and cloud services reconciliation, provide ongoing SAM awareness training
Create and manage a SAM program improvement plan
Incorporate SAM analytical data into strategic IT and business unit planning, create detailed metrics and reports to measure SAM adoption, implementation, and maturity, report Return of Investment (ROI), cost avoidance, and end-user satisfaction to all stakeholders, evangelize SAM maturity benefits

Manage the Software Asset Life Cycle (15-20%)

Manage the acquisition process
Identify and manage approved and unapproved purchasing processes, identify suppliers, manage software approval and receiving processes, manage license updates, optimization, and subscriptions, ensure proper consumption of online services
Manage the deployment process and consumption
Validate the availability of on-premises and cloud software licenses, select the correct media, specify the software identification characteristics, track deployment and consumption of on-premises cloud software
Optimize assets
Manage on-premises and cloud software and hardware centralization throughout the software asset life cycle according to ISO/IEC 19770-1 and IAITAM, generate awareness of available agreement benefits
Manage the retirement process
Identify hardware for retirement, retire software, harvest software licenses, ensure decommissioning or destruction of storage media, stop subscriptions and downloads, preserve compliance, perform notifications, retain documentation

QUESTION 1
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question In the series. Each question is Independent of the other questions In this series. Information and details provided In a question apply only to that question.
You represent a SAM partner.
A client must consolidate then IT departments into a single business unit. The client was previously assessed in the Microsoft SAM Optimization Model (SOM) key competencies and assigned a SAM maturity level.
You need to ensure that unused Microsoft Office 365 licenses arc reclaimed.
What should you do?

A. Purchase software from approved vendors.
B. Publish software deployment reports to stakeholder.
C. Use information provided by a software publisher.
D. Use software metadata generated by the client.
E. Deploy only approved software.
F. Formulate a retirement process.
G. Create an inventory of deployed assets.
H. Maintain updated records of deployed assets.

Answer: C


QUESTION 2
This question requires that you evaluate the underlined text to determine if it is correct.
An organization that achieves the Dynamic Microsoft SAM Optimization Model (SOM) level has SAM data available but typically does not use it for decision marking.
Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

A. No change is needed.
B. Basic
C. Standardized
D. Rationalized

Answer: A


QUESTION 3
An organization is implementing a SAM program. The organization is focused on achieving Tier 1 of the ISO 19770-1 specification.
You need to verity that contracts are reported on and inventoried.
What should you include in the report?

A. the last reported hardware inventory date
B. any approved exceptions to the contracts
C. contracts that do not match billing statements
D. the last reported software inventory date

Answer: D


QUESTION 4
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question In the series. Each question is independent of the other questions In this series. Information and details provided In a question apply only to that question.
You represent a SAM partner.
A client must consolidate their II departments into a single business unit. The client was previously assessed in the Microsoft SAM Optimization Model (SOM) key competencies and assigned a SAM maturity level.
The client reclaims unused software licenses from all departments.
You need to ensure that the client progresses to the next SOM level in the Retirement
Process key competency.
What should you do?

A. Purchase software only from approved vendors.
B. Publish software deployment reports to stakeholders.
C. Use information provided by a software publisher.
D. Use software metadata generated by the client.
E. Deploy only approved software.
F. Formulate a retirement process.
G. Create an inventory of deployed assets.
H. Maintain updated records of deployed assets.

Answer: A

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

MCTS Training, MCITP Trainnig

Best Microsoft MCP 70-713 Certification, Microsoft 70-713 Training at certkingdom.com


Continue Reading

Exam MB6-705 Microsoft Dynamics AX 2012 R3 CU8 Installation and Configuration

Published: January 22, 2015
Languages: English, Chinese (Simplified), Japanese
Audiences: IT professionals
Technology: Microsoft Dynamics AX
Credit toward certification: MCP

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.

Plan a Microsoft Dynamics AX 2012 installation (15–20%)
Manage organizational hierarchies
Identify legal entities, operating units, and organizational hierarchies; define hierarchy purposes; create organizations and hierarchies; add organizations to a hierarchy
Plan a deployment
Identify Microsoft Dynamics AX 2012 R3 CU8 architectural components, compare minimum versus complete server setup, identify other servers in the environment, identify necessary service accounts for Microsoft Dynamics AX 2012 R3 CU8, identify necessary service accounts for SQL Server services
Manage pre-installation tasks
Pre-installation checklists, plan system topology, identify current hardware and software

Install, configure, and update Microsoft Dynamics AX 2012 R3 CU8 (15–20%)
Install and configure Microsoft Dynamics AX 2012 R3 CU8
Use the Setup Wizard and automatic update installer, validate that prerequisite software is installed, install an environment, troubleshoot installation issues, identify considerations for cloud-hosted environments, configure the Application Object Server (AOS), use the Server Configuration Utility, perform post-installation configuration steps
Configure and initialize the Microsoft Dynamics AX 2012 R3 CU8 environment
Configure clusters, load balancing, and batch servers; specify help system parameters; identify and configure client performance options; specify system service accounts; view and configure licenses; configure system parameters; prepare initialization; synchronize the database; initialize the system
Deploy Microsoft Dynamics AX 2012 R3 CU8 clients
Install a client, create a Group Policy logon script, deploy multiple clients, create a shared configuration file, create a batch file to install clients, understand considerations for installing multiple instances on one computer, identify and describe Microsoft Office add-ins, configure Office add-ins, import data from Microsoft Excel, edit data in Excel, use Office templates and documents
Update Microsoft Dynamics AX 2012 R3 CU8
Describe Lifecycle Services, identify tools for updating the environment, understand and implement slipstream installations

Manage users and security (15–20%)
Understand security concepts and components
Understand the pluggable authentication architecture; identify features that support compliance, auditing, and reporting; implement custom authentication; integrate security with the organizational model; determine proper placement of system components to secure the environment
Manage authentication, users, and Active Directory user groups
Create Active Directory users and groups; describe claims-based authentication; import users from Active Directory; identify role-based security features including process cycles, duties, privileges and permissions; align application security with business needs; assign roles to users roles, duties, and process cycles; add a role; modify a role; override permissions for a role; add duties to a role; remove duties from a role; edit a duty
Manage the extensible data security framework
Control access to past, present, and future records; develop data security policies; identify data security filters; implement record-level security
Secure OLAP data and reports
Identify default Analysis Services roles, assign users to database roles, specify user access to cubes, restrict access to specific members of a dimension, identify report security considerations, control access to data and assemblies, implement role-based security to reports and resources, mitigate injection attacks

Implement services and manage workflows (10–15%)
Describe workflow architecture
Identify workflow types, identify workflow features, identify uses and limitations of workflow types
Implement support for workflows
Specify the workflow execution account; run the Workflow infrastructure configuration wizard; create email notification templates; specify workflow templates; set up work item queue groups, queues, and queue assignments
Create, configure, and monitor workflows
Create a workflow with the graphical workflow editor, configure workflow approval elements, configure workflow decisions, create performance analysis reports, view workflow history

Manage reporting and analytics (10–15%)
Understand reporting components
Identify the reporting architecture, identify services that are used in reporting, identify SQL Server Reporting Services features, describe .rdl files, understand report generation from end-user requests through report rendering
Understand analytics components
Differentiate between online analytical processing (OLAP) and online transaction processing (OLTP) databases; describe cubes; define facts, dimensions, and measures; identify types of cubes; identify default cubes; work with date dimensions; configure the Gregorian calendar
Deploy and configure cubes
Deploy default cubes, connect SQL Server Analysis Server to the Application Object Server (AOS), automate cube processing, configure access to cubes, configure default cubes and analysis servers
Install and configure report servers
Identify reporting components, install prerequisite software, configure report servers, validate settings, set up reports as batches, use Windows PowerShell to deploy reports

Manage the Enterprise Portal (10–15%)
Describe Enterprise Portals
Identify Enterprise Portal components and features including Role Centers, sites, and pages; describe enterprise search architecture; describe the Enterprise Portal security process flow; describe perimeter networks
Install and deploy Enterprise Portals
Identify installation tasks, understand search components, describe relationships between search components, install Enterprise Portal and Role Centers, deploy objects from the Application Object Tree (AOT), deploy changes to the Enterprise Portal, use the AdUpdatePortal utility, manage remote Enterprise Portal deployments
Configure and administer Enterprise Portals
Identify and configure Enterprise Portal parameters, publish images, manage Enterprise Portal websites, configure collaboration workspace settings, configure search, update the search crawler role

Manage Microsoft Dynamics AX 2012 R3 CU8 installations (15–20%)
Manage models
Identify model store components; understand model store uses; identify files related to the model store including .aod, .axmodel, and .xpo files; understand the difference between the current model store architecture and earlier versions of the model store
Manage batch processes
Understand task processing order, create a batch group, create batch jobs, add tasks to a batch job, run batch tasks, view batch job history
Set up and manage email messages and alerts
Integrate Microsoft Dynamics AX with Microsoft Outlook, identify forms that support sending email messages, send email messages to distribution groups, define alert parameters, create alert rules and alerts, use rule templates, process alerts, connect templates with alerts
Monitor Microsoft Dynamics AX 2012 R3 CU8
Describe system monitoring tools including Management Pack, Microsoft Baseline Configuration Analyzer, and Performance Monitor; identify Microsoft Dynamics AX 2012 R3 CU8-specific Performance Monitor counters
Manage infrastructure and deployment components
Install and configure web services on Internet Information Services (IIS), create service groups, configure integration ports and adapters, migrate configuration settings between environments, describe and configure inbound and outbound ports, understand the differences between basic and enhanced ports
Troubleshoot and manage services
Start and stop batch services, debug services, understand Queue Manager message status values, view and manage queued messages, view information about Application Integration Framework (AIF) exceptions

QUESTION 1
You need to create a new service group in Microsoft Dynamics AX 2012 R3. What should you do?

A. Publish all services in the service group to multiple web services description language (WSDL) files.
B. Configure the service group by the using Microsoft Dynamics AX 2012 Server Configuration utility.
C. Associate the service group with an enhanced integration port.
D. Use the Application Object Tree (AOT) to create the service group.

Answer: D


QUESTION 2
Which statement about Microsoft Dynamics AX 2012 security authentication is true?

A. Microsoft Dynamics AX 2012 can use authentication providers other than Active Directory.
B. You can configure Microsoft Dynamics AX 2012 to apply data security before authenticating users.
C. Microsoft Dynamics AX 2012 can only use Active Directory authentication
D. You can configure Microsoft Dynamics AX 2012 to apply security role authorization before authenticating users

Answer: A


QUESTION 3
A batch job is not processing and remains in the waiting status. You need to identify why the batch job is not processing What is the cause?

A. The batch job does not have a batch group assigned.
B. The user that created the batch job does not have permissions to the Batch processing form
C. The batch tasks do not have a batch group assigned.
D. The Application Object Server (AOS) assigned to the batch group is not enabled as a batch server.

Answer: A


QUESTION 4
You need to configure the data sources for Microsoft Office add ins.
What should you do?

A. Specify the data source module and type in the Microsoft Dynamics AX 2012 client.
B. Specify the data source connection string and type in the Microsoft Dynamics AX 2012 client.
C. Specify the data source connection string and type in the Microsoft Dynamics AX 2012 Configuration utility.
D. Specify the data source module and type in the Microsoft Dynamics AX 2012 Configuration utility.

Answer: D

 

Click here to view complete Q&A of MB6-705 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft Microsoft Certified Specialist MB6-705 Certification, Microsoft MB6-705 Training at certkingdom.com


Continue Reading

Exam 70-348 Managing Projects and Portfolios with Microsoft PPM

Published: July 28, 2016
Languages: English
Audiences: IT professionals
Technology: Office 365 Project Portfolio Management
Credit toward certification: MCP

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.

Create projects and programs
Define strategy
Define business drivers, create multiple driver prioritizations, analyze consistency ratio
Optimize portfolios
Capture project requests and ideas, rate projects against business drivers, determine primary cost constraints, determine resource constraints, set project dependencies, create a portfolio analysis, review and modify prioritizations in an analysis, force projects in and out of analysis, determine hired resources, compare and run simulations for project portfolio selection, add additional constraints
Create a new enterprise project
Create a project and manage workflow, use workflow approvals, import projects through Project Professional, create and manage project schedules using Project Web App, save and check in projects, import projects from Excel
Create programs
Insert sub-projects, create cross-project task dependencies, calculate sub-project summary fields, associate programs to portfolios, associate projects to programs

Plan projects and programs
Define deliverables
Add deliverables, set dependencies on deliverables, synchronize deliverables with project, link related items
Create tasks and a Work Breakdown Structure (WBS)
Create and modify summary tasks and subtasks, rearrange tasks, create milestones, create manually scheduled tasks, set tasks as active or inactive
Schedule the project
Set date constraints, deadlines, dependencies, links, duration equations, effort-driven tasks, and formulas; choose task types; enter duration; set or change the task mode (manual or auto); display warnings and suggestions; use estimated durations and user-controlled summary tasks
Manage resources and teams
Edit resources with Project Web App, edit resources with Project Pro for Office 365, create team resources, create team assignments, add a team task to a task page or timesheet, map resource roles (Portfolio analysis)
Perform resource engagement
Submit, accept, modify, and reject a resource engagement request; build a team for a resource plan; build a resource plan for a project; set resource utilization; use committed versus proposed assignments
Build a project team
Build a Project Team through Project Pro for Office 365 or Project Web App, build a Project Team through Project Web App, replace generic resources, work with proposed assignments
Resolve resource over allocations across projects
Level resources using leveling methods; plan resource allocations using Team Planner, Task usage, Resource Requests page, and Resource Utilization
Build a financial plan
Plan program financial requirements using the resource rate table, cost per use, cost resources

Track projects and programs
Baseline enterprise projects
Set a protected baseline, set a baseline from Project Web App and Project Pro for Office 365, clear and copy a baseline
Select tracking method
Use percent complete, hours per period, actual work remaining, freeform, done, and not done fields
Manage task assignments
Publish assignments, select a status manager, select an assignment owner, set the published values for individual tasks
Update tasks and timesheets
Submit and recall timesheets, insert and remove tasks, reassign tasks, submit updates from My Tasks, submit updates from a mobile app
Approve tasks and timesheets
Accept task updates from tasks or timesheets, view impact of updates on a project, reject updates, approve and reject timesheets, manage delegations
Update the project plan
Reschedule uncompleted work, update cost resources, publish schedule changes, utilize task update history, update schedules with protected user updates, close tasks for updates
Collaborate and communicate projects and programs
Create a project site; add Document Library; add Lists, Calendar, and Folders; modify site layout; create program (master-sub) structure using subsites; add risks and issues

Control, report, manage, and extend the PPM solution

Customize Project Web App views and reports
Create a portfolio report using Excel; create dashboards; copy and edit views; set default views; rename field names; group, filter, and sort views
Advanced Reporting
Load the content pack with Power BI, create reports and dashboards, ask natural language questions, leverage filters, pin results to the dashboard, create views with tiles from multiple datasets and reports, create reports using the out-of-the-box reporting capability
Manage configurable enterprise objects
Create and manage enterprise project templates, define enterprise custom fields, define Project workflows, define enterprise global objects, extend with Office Store apps, add social elements
Implement a security model
Change between SharePoint Security mode and Project Security mode, create users, create and modify security groups and categories, set up Project Site permissions

QUESTION 1
Your company has had several large projects fail due to cost overruns and the lack of available resources. These projects use an enterprise project type named Large IT Project and use a workflow to govern the approval of the projects. The workflow consists of four phases; Initiate, Plan, Execute, and Close.
You need to use Microsoft PPM to compare the value that a new project provides with the cost of implementing the project.
Which three configuration changes should you make? Each correct answer presents part of the solution.

A. Navigate to PWA Settings Edit the Large IT Project project type, and in the Available Project Detail Page section, add the Strategic Impact form.
B. Create a project-level custom field that will be used to enter the total cost of a project
C. Define your company’s strategic drivers, and enter them into the Strategic Impact form.
D. Create a project-level custom field that will be used to enter the value statements of why this project should be undertaken.
E. Define your company’s strategic drivers and enter them into the driver library.
F. In PWA Settings, edit and then save the stage information. In the Available Project Detail Page section, add the Strategic Impact.

Answer: B,C,E


QUESTION 2
You are using Microsoft PPM to manage an e-commerce portal development program. The program is separated into individual projects that represent each area of development.
You have the following requirements:
• All work and progress on individual projects must be reflected in the e-commerce portal development program.
• Each group must be able to manage their own tasks.
You need to set up the e-commerce portal development program and its associated projects in Microsoft PPM.
Where should you add resources?

A. in the e-commerce portal development program project site
B. in the individual project schedules
C. in Build Team, in the e-commerce portal development program schedule
D. in the individual project sites

Answer: C

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

MCTS Training, MCITP Trainnig

Best Microsoft Microsoft Certified Specialist 70-348 Certification, Microsoft 70-348 Training at certkingdom.com


Continue Reading

Developing SQL Databases (beta) Exam 70-762

Published: August 26, 2016
Languages: English
Audiences: Developers
Technology: SQL Server
Credit toward certification: MCP, MCSA

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 and implement database objects (25–30%)
Design and implement a relational database schema
Design tables and schemas based on business requirements, improve the design of tables by using normalization, write table create statements, determine the most efficient data types to use
Design and implement indexes
Design new indexes based on provided tables, queries, or plans; distinguish between indexed columns and included columns; implement clustered index columns by using best practices; recommend new indexes based on query plans
Design and implement views
Design a view structure to select data based on user or business requirements, identify the steps necessary to design an updateable view, implement partitioned views, implement indexed views
Implement columnstore indexes
Determine use cases that support the use of columnstore indexes, identify proper usage of clustered and non-clustered columnstore indexes, design standard non-clustered indexes in conjunction with clustered columnstore indexes, implement columnstore index maintenance

Implement programmability objects (20–25%)
Ensure data integrity with constraints
Define table and foreign key constraints to enforce business rules, write Transact-SQL statements to add constraints to tables, identify results of Data Manipulation Language (DML) statements given existing tables and constraints, identify proper usage of PRIMARY KEY constraints
Create stored procedures
Design stored procedure components and structure based on business requirements, implement input and output parameters, implement table-valued parameters, implement return codes, streamline existing stored procedure logic, implement error handling and transaction control logic within stored procedures
Create triggers and user-defined functions
Design trigger logic based on business requirements; determine when to use Data Manipulation Language (DML) triggers, Data Definition Language (DDL) triggers, or logon triggers; recognize results based on execution of AFTER or INSTEAD OF triggers; design scalar-valued and table-valued user-defined functions based on business requirements; identify differences between deterministic and non-deterministic functions

Manage database concurrency (25–30%)
Implement transactions
Identify DML statement results based on transaction behavior, recognize differences between and identify usage of explicit and implicit transactions, implement savepoints within transactions, determine the role of transactions in high-concurrency databases
Manage isolation levels
Identify differences between Read Uncommitted, Read Committed, Repeatable Read, Serializable, and Snapshot isolation levels; define results of concurrent queries based on isolation level; identify the resource and performance impact of given isolation levels
Optimize concurrency and locking behavior
Troubleshoot locking issues, identify lock escalation behaviors, capture and analyze deadlock graphs, identify ways to remediate deadlocks
Implement memory-optimized tables and native stored procedures
Define use cases for memory-optimized tables versus traditional disk-based tables, optimize performance of in-memory tables by changing durability settings, determine best case usage scenarios for natively compiled stored procedures, enable collection of execution statistics for natively compiled stored procedures

Optimize database objects and SQL infrastructure (20–25%)
Optimize statistics and indexes
Determine the accuracy of statistics and the associated impact to query plans and performance, design statistics maintenance tasks, use dynamic management objects to review current index usage and identify missing indexes, consolidate overlapping indexes
Analyze and troubleshoot query plans
Capture query plans using extended events and traces, identify poorly performing query plan operators, create efficient query plans using Query Store, compare estimated and actual query plans and related metadata, configure Azure SQL Database Performance Insight
Manage performance for database instances
Manage database workload in SQL Server; design and implement Elastic Scale for Azure SQL Database; select an appropriate service tier or edition; optimize database file and tempdb configuration; optimize memory configuration; monitor and diagnose scheduling and wait statistics using dynamic management objects; troubleshoot and analyze storage, IO, and cache issues; monitor Azure SQL Database query plans
Monitor and trace SQL Server baseline performance metrics
Monitor operating system and SQL Server performance metrics; compare baseline metrics to observed metrics while troubleshooting performance issues; identify differences between performance monitoring and logging tools, such as perfmon and dynamic management objects; monitor Azure SQL Database performance; determine best practice use cases for extended events; distinguish between Extended Events targets; compare the impact of Extended Events and SQL Trace; define differences between Extended Events Packages, Targets, Actions, and Sessions

QUESTION: No: 01
You are experiencing performance issues with the database server.
You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O
problems.
What should you create?

A. a System IV|onitor report
B. a sys.dm_exec_query_stats dynamic management view query
C. a sys.dm_exec_session_wait_stats dynamic management view query
D. an ActMty Monitor session in Microsoft SQL Management Studio.

Answer:


QUESTION: No: 02
You are developing an application to track customer sales.
You need to create a database object that meets the following requirements:
-Return a value of 0 if data inserted successfully into the Customers table.
-Return a value of 1 if data is not inserted successfully into the Customers table.
-Support logic that is written by using managed code.
What should you create’?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. DDL trigger
F. scalar-valued function
G. table-valued function

Answer:


QUESTION: No: 03
You are developing an application to track customer sales.
You need to create a database object that meets the following requirements:
-Return a value of 0 if data inserted successfully into the Customers table.
-Return a value of 1 if data is not inserted successfully into the Customers table.
-Support TRY CATCH error handling
– Be written by using Transact-SOL statements.
What should you create?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. scalar-valued function
F. table-valued function

Answer:


QUESTION: No: 04
You are developing an application to track customer sales.
You need to create a database object that meets the following requirements:
– Launch when table data is modified.
– Evaluate the state a table before and after a data modification and take action based on the difference.
– Prevent malicious or incorrect table data operations.
– Prevent changes that violate referential integrity by cancelling the attempted data modification.
-Run managed code packaged in an assembly that is created in the Microsoft.NET Framework and
located into Microsoft SQL Server.
What should you create?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. scalar-valued function
F. table-valued function

Answer:


QUESTION: No: 05
You are developing and application to track customer sales.
You need to return the sum of orders that have been finalized, given a specified order identifier. This
value will be used in other Transact-SOL statements.
You need to create a database object.
What should you create?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. scalar-valued function
F. table-valued function

Answer:
 

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

MCTS Training, MCITP Trainnig

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


Continue Reading

Exam 70-734 OEM Preinstallation for Windows 10

Published: June 16, 2016
Languages: English, Japanese
Audiences: IT professionals
Technology: Windows 10, Microsoft Assessment and Deployment Kit (ADK)
Credit toward certification: MCP

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.

Prepare deployments
Prepare the environment
Prepare Assessment and Deployment Kit (ADK), prepare USB, design an answer file, create a default user profile, preserve preinstalled OEM drivers
Identify a business strategy for deploying operating system images
Identify a build-to-order or build-to-plan approach, select a deployment method, implement end-user upgrade paths
Determine hardware configurations
Determine Unified Extensible Firmware Interface (UEFI) requirements, configure network and storage drivers, configure a boot device
Build a Windows Preinstallation Environment (Windows PE or WinPE)
Troubleshoot a problematic installation in WinPE, customize a WinPE installation, create a 32-bit or 64-bit WinPE environment, manage Windows PE packages

Create, capture, and deploy images
Create a reference installation
Set up and capture a reference PC, preinstall Microsoft and third-party desktop applications, set up a Push-Button Restore, evaluate deployment logs, prepare and test Out-of-Box Experience (OOBE)
Determine redistribution licensing requirements
Determine redistribution rights and technical requirements, select licensed recovery types, determine OEM preinstallation requirements

Manage deployments
Manage images
Upgrade a Windows edition, perform online or offline servicing, activate a grace period timer, manage nested images within Windows Imaging File Format (WIMS), add and remove packages, add and remove drivers, set the multilingual deployment of an operating system, manage application updates
Apply a reference installation
Perform drive partitioning, deploy reference and recovery images, set up Push-Button Recovery with REAgentC and BCD commands
Validate an image
Validate an image in audit mode, validate Push-Button Reset, sysprep images to OOBE, identify causes of driver failure, finalize installation, validate licensing requirements and components

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

MCTS Training, MCITP Trainnig

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


Continue Reading

Exam 70-761 Querying Data with Transact-SQL (beta)

Published: October 18, 2016
Languages: English
Audiences: IT professionals
Technology: SQL Server
Credit toward certification: MCP, MCSA

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 data with Transact-SQL (40–45%)
Create Transact-SQL SELECT queries
Identify proper SELECT query structure, write specific queries to satisfy business requirements, construct results from multiple queries using set operators, distinguish between UNION and UNION ALL behaviour, identify the query that would return expected results based on provided table structure and/or data
Query multiple tables by using joins
Write queries with join statements based on provided tables, data, and requirements; determine proper usage of INNER JOIN, LEFT/RIGHT/FULL OUTER JOIN, and CROSS JOIN; construct multiple JOIN operators using AND and OR; determine the correct results when presented with multi-table SELECT statements and source data; write queries with NULLs on joins
Implement functions and aggregate data
Construct queries using scalar-valued and table-valued functions; identify the impact of function usage to query performance and WHERE clause sargability; identify the differences between deterministic and non-deterministic functions; use built-in aggregate functions; use arithmetic functions, date-related functions, and system functions
Modify data
Write INSERT, UPDATE, and DELETE statements; determine which statements can be used to load data to a table based on its structure and constraints; construct Data Manipulation Language (DML) statements using the OUTPUT statement; determine the results of Data Definition Language (DDL) statements on supplied tables and data

Query data with advanced Transact-SQL components (30–35%)
Query data by using subqueries and APPLY
Determine the results of queries using subqueries and table joins, evaluate performance differences between table joins and correlated subqueries based on provided data and query plans, distinguish between the use of CROSS APPLY and OUTER APPLY, write APPLY statements that return a given data set based on supplied data
Query data by using table expressions
Identify basic components of table expressions, define usage differences between table expressions and temporary tables, construct recursive table expressions to meet business requirements
Group and pivot data by using queries
Use windowing functions to group and rank the results of a query; distinguish between using windowing functions and GROUP BY; construct complex GROUP BY clauses using GROUPING SETS, and CUBE; construct PIVOT and UNPIVOT statements to return desired results based on supplied data; determine the impact of NULL values in PIVOT and UNPIVOT queries
Query temporal data and non-relational data
Query historic data by using temporal tables, query and output JSON data, query and output XML data

Program databases by using Transact-SQL (25–30%)
Create database programmability objects by using Transact-SQL
Create stored procedures, table-valued and scalar-valued user-defined functions, and views; implement input and output parameters in stored procedures; identify whether to use scalar-valued or table-valued functions; distinguish between deterministic and non-deterministic functions; create indexed views
Implement error handling and transactions
Determine results of Data Definition Language (DDL) statements based on transaction control statements, implement TRY…CATCH error handling with Transact-SQL, generate error messages with THROW and RAISERROR, implement transaction control in conjunction with error handling in stored procedures
Implement data types and NULLs
Evaluate results of data type conversions, determine proper data types for given data elements or table columns, identify locations of implicit data type conversions in queries, determine the correct results of joins and functions in the presence of NULL values, identify proper usage of ISNULL and COALESCE functions

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

MCTS Training, MCITP Trainnig

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


Continue Reading

Exam 70-762 Developing SQL Databases (beta)

Published: August 26, 2016
Languages: English
Audiences: Developers
Technology: SQL Server
Credit toward certification: MCP, MCSA

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 and implement database objects (25–30%)
Design and implement a relational database schema
Design tables and schemas based on business requirements, improve the design of tables by using normalization, write table create statements, determine the most efficient data types to use
Design and implement indexes
Design new indexes based on provided tables, queries, or plans; distinguish between indexed columns and included columns; implement clustered index columns by using best practices; recommend new indexes based on query plans
Design and implement views
Design a view structure to select data based on user or business requirements, identify the steps necessary to design an updateable view, implement partitioned views, implement indexed views
Implement columnstore indexes
Determine use cases that support the use of columnstore indexes, identify proper usage of clustered and non-clustered columnstore indexes, design standard non-clustered indexes in conjunction with clustered columnstore indexes, implement columnstore index maintenance

Implement programmability objects (20–25%)
Ensure data integrity with constraints
Define table and foreign key constraints to enforce business rules, write Transact-SQL statements to add constraints to tables, identify results of Data Manipulation Language (DML) statements given existing tables and constraints, identify proper usage of PRIMARY KEY constraints
Create stored procedures
Design stored procedure components and structure based on business requirements, implement input and output parameters, implement table-valued parameters, implement return codes, streamline existing stored procedure logic, implement error handling and transaction control logic within stored procedures
Create triggers and user-defined functions
Design trigger logic based on business requirements; determine when to use Data Manipulation Language (DML) triggers, Data Definition Language (DDL) triggers, or logon triggers; recognize results based on execution of AFTER or INSTEAD OF triggers; design scalar-valued and table-valued user-defined functions based on business requirements; identify differences between deterministic and non-deterministic functions

Manage database concurrency (25–30%)
Implement transactions
Identify DML statement results based on transaction behavior, recognize differences between and identify usage of explicit and implicit transactions, implement savepoints within transactions, determine the role of transactions in high-concurrency databases
Manage isolation levels
Identify differences between Read Uncommitted, Read Committed, Repeatable Read, Serializable, and Snapshot isolation levels; define results of concurrent queries based on isolation level; identify the resource and performance impact of given isolation levels
Optimize concurrency and locking behavior
Troubleshoot locking issues, identify lock escalation behaviors, capture and analyze deadlock graphs, identify ways to remediate deadlocks
Implement memory-optimized tables and native stored procedures
Define use cases for memory-optimized tables versus traditional disk-based tables, optimize performance of in-memory tables by changing durability settings, determine best case usage scenarios for natively compiled stored procedures, enable collection of execution statistics for natively compiled stored procedures

Optimize database objects and SQL infrastructure (20–25%)
Optimize statistics and indexes
Determine the accuracy of statistics and the associated impact to query plans and performance, design statistics maintenance tasks, use dynamic management objects to review current index usage and identify missing indexes, consolidate overlapping indexes
Analyze and troubleshoot query plans
Capture query plans using extended events and traces, identify poorly performing query plan operators, create efficient query plans using Query Store, compare estimated and actual query plans and related metadata, configure Azure SQL Database Performance Insight
Manage performance for database instances
Manage database workload in SQL Server; design and implement Elastic Scale for Azure SQL Database; select an appropriate service tier or edition; optimize database file and tempdb configuration; optimize memory configuration; monitor and diagnose scheduling and wait statistics using dynamic management objects; troubleshoot and analyze storage, IO, and cache issues; monitor Azure SQL Database query plans
Monitor and trace SQL Server baseline performance metrics
Monitor operating system and SQL Server performance metrics; compare baseline metrics to observed metrics while troubleshooting performance issues; identify differences between performance monitoring and logging tools, such as perfmon and dynamic management objects; monitor Azure SQL Database performance; determine best practice use cases for extended events; distinguish between Extended Events targets; compare the impact of Extended Events and SQL Trace; define differences between Extended Events Packages, Targets, Actions, and Sessions

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

MCTS Training, MCITP Trainnig

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


Continue Reading

Exam 70-764 Administering a SQL Database Infrastructure (beta)

Published: October 18, 2016
Languages: English
Audiences: IT professionals
Technology: SQL Server
Credit toward certification: MCP, MCSA

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.

Configure data access and auditing (20–25%)
Configure encryption
Implement cell-level encryption, implement Always Encrypted, implement backup encryption, configure transparent data encryption, configure encryption for connections, troubleshoot encryption errors
Configure data access and permissions
Manage database object permissions, create and maintain users, create and maintain custom roles, configure user options for Azure SQL Database, configure row-level security, configure dynamic data masking
Configure auditing
Configure an audit on SQL Server, query the SQL Server audit log, manage a SQL Server audit, configure an Azure SQL Database audit, analyze audit logs and reports from Azure SQL Database

Manage backup and restore of databases (20–25%)
Develop a backup strategy
Back up very large databases, configure alerting for failed backups, back up databases to Azure, manage transaction log backups, configure database recovery models, configure backup automation
Restore databases
Perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restores
Manage database integrity
Implement database consistency checks, identify database corruption, recover from database corruption

Manage and monitor SQL Server instances (35–40%)
Monitor database activity
Monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collector, create a utility control point (UCP)
Monitor queries
Manage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using Extended Events
Manage indexes
Identify and repair index fragmentation, identify and create missing indexes, identify and drop underutilized indexes, manage existing columnstore indexes
Manage statistics
Identify and correct outdated statistics, implement Auto Update Statistics, implement statistics for large tables
Monitor SQL Server instances
Create and manage operators, create and manage SQL Agent alerts, define custom alert actions, define failure actions, configure database mail, configure Policy-Based Management, identify available space on data volumes, identify performance degradation

Manage high availability and disaster recovery (20–25%)
Implement log shipping
Configure log shipping, monitor log shipping
Implement AlwaysOn Availability Groups
Configure Windows clustering, create an availability group, configure read-only routing, manage failover, create distributed availability groups
Implement failover cluster instances
Manage shared disks, configure cluster shared volumes

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

MCTS Training, MCITP Trainnig

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


Continue Reading

Exam 70-765 Provisioning SQL Databases (beta)

Published: August 26, 2016
Languages: English
Audiences: IT professionals
Technology: SQL Server
Credit toward certification: MCP, MCSA

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 SQL in Azure (30–35%)
Deploy a Microsoft Azure SQL Database
Choose a service tier, create servers and databases, create a sysadmin account, configure elastic pools
Plan for SQL Server installation
Plan for an IaaS or on-premises deployment, select the appropriate size for a virtual machine, plan storage pools based on performance requirements, evaluate best practices for installation, design a storage layout for a SQL Server virtual machine
Deploy SQL Server instances
Deploy a SQL Server instance in IaaS and on-premises, manually install SQL Server on an Azure Virtual Machine, provision an Azure Virtual Machine to host a SQL Server instance, automate the deployment of SQL Server databases, deploy SQL Server by using templates

Manage databases and instances (35–40%)
Configure secure access to Microsoft Azure SQL Databases
Configure firewall rules, configure Always Encrypted for Azure SQL Database, configure cell-level encryption, configure dynamic data masking, configure transparent data encryption (TDE)
Configure SQL Server performance settings
Configure database performance settings, configure max server memory, configure the database scope, configure operators and alerts
Manage SQL Server instances
Create databases, manage files and file groups, manage system database files, configure tempdb

Deploy and migrate applications (30–35%)
Deploy applications to Microsoft Azure SQL Database
Manage deployments that support multiple tenants, migrate on-premises SQL Server to Azure SQL Database, migrate data to Azure SQL Database
Deploy applications to SQL Server on Azure Virtual Machines
Migrate an on-premises SQL Server database to an Azure Virtual Machine, generate benchmark data for performance needs, perform performance tuning on Azure IaaS, support availability sets in Azure
Migrate client applications
Configure application connection strings, manage traffic between on-premises applications and Azure services, develop application retry connection logic, identify application patterns that must be migrated with SQL Server data, evaluate network performance between applications and databases

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

MCTS Training, MCITP Trainnig

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


Continue Reading

Exam 70-767 Implementing a SQL Data Warehouse (in development)

Published: October 18, 2016
Languages: English
Audiences: IT professionals
Technology: SQL Server
Credit toward certification: MCP, MCSA

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 and implement a data warehouse (30–35%)
Design and implement dimension tables
Design shared and conformed dimensions, determine support requirements for slowly changing dimensions, determine attributes, design hierarchies, determine star or snowflake schema requirements, determine the granularity of relationship by using fact tables, determine auditing or lineage requirements, determine keys and key relationships for a data warehouse, implement dimensions, implement data lineage of a dimension table
Design and implement fact tables
Identify measures, identify dimension table relationships, create composite keys, design a data warehouse that supports many-to-many relationships, implement semi-additive measures, implement non-additive measures
Design and implement indexes for a data warehouse workload
Design an indexing solution; select appropriate indexes; implement clustered, non-clustered, filtered, and columnstore indexes
Design storage for a data warehouse
Design an appropriate storage solution, including hardware, disk, and file layout
Design and implement partitioned tables and views
Design a partition structure to support a data warehouse, implement sliding windows, implement partition elimination, design a partition structure that supports the quick loading and scale-out of data

Extract, transform, and load data (35–40%)
Design and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package
Design and implement ETL control flow elements, including containers, tasks, and precedence constraints; create variables and parameters; create checkpoints, sequence and loop containers, and variables in SSIS; implement data profiling, parallelism, transactions, logging, and security
Design and implement an ETL data flow by using an SSIS package
Implement slowly changing dimension, fuzzy grouping, fuzzy lookup, audit, blocking, non-blocking, and term lookup transformations; map columns; determine the appropriate transform object for a given task; determine appropriate scenarios for Transact-SQL joins versus SSIS lookup; design table loading by using bulk loading or standard loading; remove extra rows or bad rows by using deduplication
Implement an ETL solution that supports incremental data extraction
Design fact table patterns, enable Change Data Capture, create a SQL MERGE statement
Implement an ETL solution that supports incremental data loading
Design a control flow to load change data, load data by using Transact-SQL Change Data Capture functions, load data by using Change Data Capture in SSIS
Debug SSIS packages
Fix performance, connectivity, execution, and failed logic issues by using the debugger; enable logging for package execution; implement error handling for data types; implement breakpoints; add data viewers; profile data with different tools; perform batch clean-up
Deploy and configure SSIS packages and projects
Create an SSIS catalog; deploy packages by using the deployment utility, SQL Server, and file systems; run and customize packages by using DTUTIL

Integrate solutions with cloud data and big data (15–20%)
Integrate external data sources with SQL Server by using Polybase
Integrate with Hadoop, integrate with text files stored in the Azure Blob service, manage external tables, access data in Hadoop databases with Transact-SQL, access data in the Azure Blob service by using Transact-SQL, import data from Hadoop or blobs as regular SQL Server tables, export data to Hadoop or the Azure Blob service
Extract, transform, and load data from SQL Data Warehouse by using Polybase
Integrate Azure SQL Data Warehouse with on-premises data warehouses, implement bi-directional data synchronization between Azure and on-premises systems, load data into SQL Data Warehouse from Polybase, design an incremental load strategy by using Polybase and the Azure Blob service
Design and implement an Azure SQL Data Warehouse
Create a new Azure SQL Data Warehouse database by using the Azure portal, create an Azure SQL Data Warehouse database by using Transact-SQL, select the appropriate method to load data into Azure SQL Data Warehouse
Manage and maintain a SQL Data Warehouse
Manage queries by using labels; manage statistics; manage partition distribution; scale out the data warehouse; grow, shrink, and pause the data warehouse

Build data quality solutions (15–20%)
Create a knowledge base
Create a Data Quality Services (DQS) knowledge base, determine appropriate use cases for a DQS knowledge base, perform knowledge discovery, perform domain management
Maintain data quality by using DQS
Add matching knowledge to a knowledge base, prepare a DQS for data deduplication, create a matching policy, clean data by using DQS knowledge clean data by using the SSIS DQS task, install DQS
Implement a Master Data Services (MDS) model
Install MDS; implement MDS; create models, entities, hierarchies, collections, and attributes; define security roles; import and export data; create and edit a subscription; implement entities, attributes, hierarchies, and business rules
Manage data by using MDS
Use MDS tools, use the Master Data Services Configuration Manager, create a Master Data Manager database and web application, deploy a sample model using MDSModelDeploy.exe, use the Master Data Services web application, use the Master Data Services Add-in for Excel, create a Master Data Management hub, stage and load data, create subscription views

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

MCTS Training, MCITP Trainnig

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


Continue Reading

Follow Us

Bookmark and Share


Popular Posts