- Published 1/22/2018
- 1st Edition
About the Book
Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-765 Provisioning SQL Databases certification exam, the second of two exams required for MCSA: SQL 2016 Database Administration certification.
Exam Ref 70-765 Provisioning SQL Databases offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with SQL database administration. Coverage includes:
· Implementing SQL in Azure: deploying a Microsoft Azure SQL database, planning for SQL Server installation, and deploying SQL Server instances
· Managing databases and instances: configuring secure access to Microsoft Azure SQL Databases, configuring SQL Server performance settings, and managing SQL Server instances
· Deploying and migrating applications: deploying applications to Microsoft Azure SQL Database or SQL Server on Azure Virtual Machines, migrating on-premises SQL Server databases to an Azure Virtual Machine, and migrating client applications
Microsoft Exam Ref publications stand apart from third-party study guides because they:
· Provide guidance from Microsoft, the creator of Microsoft certification exams
· Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
· Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter
Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions
· Explore big picture thinking around the planning and design aspects of the IT pro's job role
For more information on Exam 70-765 and the MCSA: SQL Server 2016 Database Administration certification, visit microsoft.com/learning.
About the Practice Test
This Microsoft Official Practice Test is powered by MeasureUp.
This practice test contains 151 questions and robust explanations.
The 70-765 exam is intended for architects and developers who have a working knowledge of cloud service models and service model architectures, data storage options, and data synchronization techniques. Candidates should also have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources. Candidates should be able to implement SQL in Azure, manage databases and instances, and deploy and migrate applications.
Certification: This exam counts as credit toward the following certifications: MCSA
This test contains 151 questions and covers the following objectives:
• Implement SQL in Azure - 47
•Manage Databases and Instances - 51
• Deploy and Migrate Applications - 53
Why Choose the Microsoft Official Practice Test powered by MeasureUp?
Their quality content and innovative technology have earned the prestigious credential of Microsoft Certified Practice Test Provider.
•Online performance-based simulations give hands on work environment experience
•Questions are similar to exam questions so you test your knowledge of exam objectives
•Detailed explanations for both correct and distractor answers reinforce the material
•Study Mode covers all objectives ensuring topics are covered
•Certification Mode (timed) prepares students for exam taking conditions
•Instant, drill-down score reports tell you exactly the areas to focus on.
How to obtain the Practice Test
The Official Microsoft Practice Test offered with this book is fulfilled by MeasureUp.com. With your order, you will receive a product key on your Account Page. Registering the product key at MeasureUp.com will give you access to a downloadable practice test which does not expire as well as 30-day access to the online version.
Before accessing your practice test, you will be required to create an account at MeasureUp.com if you don’t already have one.
The downloadable practice test is licensed by MeasureUp for a single user and can be downloaded on up to three different devices. Downloading practice tests to virtual machines is prohibited.
Table of Contents
Introduction
Chapter 1 Implement SQL in Azure
Skill 1:1: Deploy a Microsoft Azure SQL Database
Skill 1:2: Plan for SQL Server installation
Skill 1:3: Deploy SQL Server instances
Skill 1:4: Deploy SQL Server databases to Azure virtual machines
Chapter 2 Manage databases and instances
Skill 2.1: Configure secure access to Microsoft Azure SQL databases
Skill 2.2: Configure SQL Server performance settings
Skill 2.3: Manage SQL Server instances
Chapter 3 Manage Storage
Skill 3.1: Manage SQL Storage
Skill 3.2: Perform database maintenance