Exam Ref DP-300: Administering Microsoft Azure SQL Solutions

Title Page....2

Copyright Page....3

Contents at a glance....6

Contents....7

About the author....14

Introduction....15

Organization of this book....15

Preparing for the exam....16

Microsoft certifications....16

Access the Exam Updates chapter and online references....17

Errata, updates, & book support....17

Stay in touch....18

Chapter 1. Plan and implement data platform resources....19

Skill 1.1: Plan and deploy Azure SQL solutions....19

Skill 1.2: Configure resources for scale and performance....64

Skill 1.3: Plan and implement a migration strategy....81

Chapter summary....114

Thought experiment....116

Thought experiment answers....117

Chapter 2. Implement a secure environment....118

Skill 2.1: Configure database authentication and authorization....118

Skill 2.2: Implement security for data at rest and data in transit....144

Skill 2.3: Implement compliance controls for sensitive data....161

Chapter summary....187

Thought experiment....188

Thought experiment answers....188

Chapter 3. Monitor, configure, and optimize database resources....190

Skill 3.1: Monitor resource activity and performance....190

Skill 3.2: Monitor and optimize query performance....211

Skill 3.3: Configure database solutions for optimal performance....238

Chapter summary....257

Thought experiment....258

Thought experiment answers....259

Chapter 4. Configure and manage automation of tasks....261

Skill 4.1: Create and manage SQL Server Agent jobs....261

Skill 4.2: Automate deployment of database resources....279

Skill 4.3: Create and manage database tasks in Azure....290

Chapter summary....306

Thought experiment....307

Thought experiment answers....307

Chapter 5. Plan and configure a high availability and disaster recovery (HA/DR) environment....309

Skill 5.1: Recommend an HA/DR strategy for database solutions....309

Skill 5.2: Plan and perform backup and restore of a database....316

Skill 5.3: Configure HA/DR for database solutions....332

Chapter summary....350

Thought experiment....352

Thought experiment answers....353

Chapter 6. DP-300 Administering Microsoft Azure SQL Solutions exam updates....354

The purpose of this chapter....354

Exam objective updates....356

Updated technical content....356

Objective mapping....356

Index....364

Code Snippets....398

Prepare for Microsoft Exam DP-300 and demonstrate your real-world foundational knowledge of Azure database administration using a variety of methods and tools to perform and automate day-to-day operations, including use of Transact-SQL (T-SQL) and other tools for administrative management purposes. Designed for database administrators, solution architects, data scientists, and other data professionals, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the Microsoft Certified: Azure Database Administrator Associate level. Focus on the expertise measured by these objectives:

• Plan and implement data platform resources
• Implement a secure environment
• Monitor, configure, and optimize database resources
• Configure and manage automation of tasks
• Plan and configure a high availability and disaster recovery (HA/DR) environment

This Microsoft Exam Ref:

• Organizes its coverage by the Skills Measured list published for the exam
• Features strategic, what-if scenarios to challenge you
• Assumes you have subject matter expertise in building database solutions that are designed to support multiple workloads built with SQL Server on-premises and Azure SQL

About the Exam

Exam PD-300 focuses on core knowledge for implementing and managing the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services, using a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes. About Microsoft Certification

Passing this exam fulfills your requirements for the Microsoft Certified: Azure Database Administrator Associate certification, demonstrating your ability to administer a SQL Server database infrastructure for cloud, on-premises, and hybrid relational databases using the Microsoft PaaS relational database offerings.