Category Archives: Microsoft MCP

MCTS, Microsoft MCP

Exam 70-696 Administering System Center Configuration Manager and Intune

Leave a comment

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

Microsoft, Microsoft MCP

Exam MB2-709 Microsoft Dynamics Marketing

Leave a comment

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

Microsoft Certified Professional, Microsoft MCP

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

Leave a comment

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

Microsoft MCP

Exam 70-346 Managing Office 365 Identities and Requirements

Leave a comment

Published: February 17, 2014
Languages: English, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Portuguese (Brazil), Spanish
Audiences: IT professionals
Technology: Microsoft Office 365
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.

As of June 30, 2016, this exam includes content covering the latest updates and features of Office 365. To learn more about these changes and how they affect the skills measured, please download and review the exam 70-346 change document.

Provision Office 365 (15–20%)
Provision tenants
Configure the tenant name, tenant region, initial global administrator; manage tenant subscriptions; manage the licensing model; configure tenant for new features and updates
Add and configure custom domains
Specify domain name, confirm ownership, specify domain purpose, set default domain, and move ownership of DNS to Office 365
Plan a pilot
Designate pilot users; identify workloads that don’t require migration; run the Office 365 Health, Readiness, and Connectivity Checks; run IdFix; create a test plan or use case, and connect existing email accounts for pilot users; understand service descriptions and planning to onboard users to Office 365; configure connected accounts

Plan and implement networking and security in Office 365 (15–20%)
Configure DNS records for services
Create DNS records for Exchange Online, Skype for Business Online, and SharePoint Online
Enable client connectivity to Office 365
Configure proxy to allow client access to Office 365 URLs, configure firewalls for outbound port access to Office 365, recommend bandwidth, configure Internet connectivity for clients, deploy desktop setup for previous versions of Office clients
Administer Microsoft Azure Rights Management (RM)
Activate rights management, configure Office integration with rights management, assign roles for rights management, enable recovery of protected documents
Manage administrator roles in Office 365
Implement a permission model; create or revoke assignment of administrative roles or the administrative model; determine and assign global administrator, billing administrator, user administrator, and delegated administrator; control password resets

Preparation resources
Create DNS records for Office 365 when you manage your DNS records
Assigning admin roles in Office 365

Manage cloud identities (15–20%)
Configure password management
Set expiration policy, password complexity, password resets in Administration Center
Manage user and security groups
Import users using bulk import (CSV), soft delete, Administration Center, and multi-factor authentication
Manage cloud identities with Windows PowerShell
Configure passwords to never expire, bulk update of user properties, bulk user creation, Azure Active Directory cmdlets, bulk user license management, hard delete users

Preparation resources
Password policy for Office 365
User account management
Manage Azure AD using Windows PowerShell

Implement and manage identities by using Azure AD Connect (15–20%)
Prepare on-premises Active Directory for Azure AD Connect
Plan for non-routable domain names, clean up existing objects, plan for filtering Active Directory, implement support for multiple forests
Set up Azure AD Connect tool
Implement soft match filtering and identify synchronized attributes, password sync, and installation requirements
Manage Active Directory users and groups with Azure AD Connect in place
Delete (soft delete), create, modify users and groups with Azure AD Connect in place, schedule and force synchronization

Preparation resources
Prepare for directory synchronization
Synchronize your directories

Implement and manage federated identities for single sign-on (SSO) (15–20%)
Plan requirements for Active Directory Federation Services (AD FS)
Plan namespaces and certificates, plan AD FS internal topologies and dependencies, plan WAP/AD FS proxy topologies, network requirements, multi-factor authentication, and access filtering using claims rules
Install and manage AD FS servers
Create AD FS service account, configure farm or stand-alone settings, add additional servers, convert from standard to federated domain, manage certificate lifecycle
Install and manage WAP/AD FS proxy servers
Set up perimeter network name resolution, install required Windows roles and features, set up certificates, configure WAP/AD FS proxy settings, set custom proxy forms login page, switch between federated authentication and password sync

Preparation resources
Plan your AD FS deployment
Checklist: Use AD FS to implement and manage single sign-on
Administering Office 365 Jump Start (03): DirSync, SSO, and AD FS

Monitor and troubleshoot Office 365 availability and usage (15–20%)
Analyze reports
Analyze service reports, mail protection reports, analyze Office 365 audit log reports, analyze portal email hygiene reports
Monitor service health
Monitor health using RSS feed, use service health dashboard (including awareness of planned maintenance, service updates, and historical data), Office 365 Management Pack for System Center Operations Manager, and Windows PowerShell cmdlets
Isolate service interruption
Create a service request; determine connection issues using the Microsoft Remote Connectivity Analyzer (RCA), Microsoft Lync Connectivity Analyzer tool, and Microsoft Connectivity Analyzer tool; determine availability issues using the hybrid free/busy troubleshooter; determine client configuration issues using Office 365 Client Performance Analyzer and Microsoft Support and Recovery Assistant for Office 365

Preparation resources
Reporting features and troubleshooting tools
Service health

QUESTION 1
An organization plans to migrate to Office 365.
You need to estimate the post-migration network traffic.
Which tool should you use?

A. Lync 2013 Bandwidth Calculator
B. Process Monitor
C. Microsoft Network Monitor
D. Microsoft OnRamp Readiness tool

Answer: A

Explanation:
Office 365 includes Lync 2013.
With this latest version of the Microsoft Lync Server 2010 and 2013 Bandwidth Calculator, you can enter information about your users and the Lync Server features that you want to deploy, and the Bandwidth Calculator will determine bandwidth requirements for the WAN that connects sites in your deployment. The accompanying Bandwidth Calculator User Guide describes the recommended process for estimating your WAN bandwidth needs for Lync client real-time traffic.
Reference: Lync Server 2010 and 2013 Bandwidth Calculator Version 2.0
http://blogs.technet.com/b/nexthop/archive/2013/06/07/lync-server-2010-and-2013-
bandwidth-calculator-version-2-0.aspx

QUESTION 2
A company has an Office 365 tenant that has an Enterprise E1 subscription. The company has offices in several different countries.
You need to restrict Office 365 services for existing users by location.
Which Windows PowerShell cmdlet should you run?

A. Set-MsolUser
B. Redo-MsolProvisionUser
C. Set-MsolUserLicense
D. Set-MsolUserPrincipalName
E. Convert-MsolFederatedUser
F. Set-MailUser
G. Set-LinkedUser
H. New-MsolUser

Answer: A

Explanation:
The Set-MsolUser cmdlet is used to update a user object.
Example: The following command sets the location (country) of this user. The country must be a two-letter ISO code. This can be set for synced users as well as managed users. Set-MsolUser -UserPrincipalName user@contoso.com -UsageLocation “CA”
Note:
Some organizations may want to create policies that limit access to Microsoft Office 365 services, depending on where the client resides.
Active Directory Federation Services (AD FS) 2.0 provides a way for organizations to configure these types of policies. Office 365 customers using Single Sign-On (SSO) who require these policies can now use client access policy rules to restrict access based on the location of the computer or device that is making the request. Customers using Microsoft Online Services cloud User IDs cannot implement these restrictions at this time.
Reference: Limiting Access to Office 365 Services Based on the Location of the Client https://technet.microsoft.com/en-us/library/hh526961(v=ws.10).aspx
Reference: Set-MsolUser https://msdn.microsoft.com/en-us/library/azure/dn194136.aspx

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

MCTS Training, MCITP Trainnig

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

Microsoft MCP

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

Leave a comment

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

Microsoft Certified Professional, Microsoft MCP

Exam 70-734 OEM Preinstallation for Windows 10

Leave a comment

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

Microsoft MCP, Microsoft MCSA

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

Leave a comment

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

Microsoft MCP, Microsoft MCSA

Exam 70-762 Developing SQL Databases (beta)

Leave a comment

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

Microsoft MCP, Microsoft MCSA

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

Leave a comment

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

Microsoft MCP, Microsoft MCSA

Exam 70-765 Provisioning SQL Databases (beta)

Leave a comment

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