
A comprehensive study guide that will provide you with great preparation tools.
Students learn to create an Azure virtual machine, enable RDP, and manually install SQL Server with a specific admin user, then connect using SQL Server Management Studio.
Learn to install Azure SQL Database, a cloud native relational service with server and database components, offering region options, and v-core or D2 pricing with endpoints secured by firewall whitelisting.
Evaluate how patching, security features, and licensing shape choosing between SQL server on a vm, sql managed instance, and azure sql database.
Evaluate the scaling requirements for your solution by comparing scaling up and scaling down, read scale-out, and global scale-out in Azure SQL Database.
Learn how to vertically scale a sql server in a vm by resizing the virtual machine, adjust disk space for data and logs, and compare with Azure sql database scaling.
Demonstrates using SQL Data Sync to synchronize data between two databases on the same server, configuring a hub database, bidirectional sync, hub-win conflicts, and automatic updates every minute.
Design an upgrade strategy to move from SQL Server to SQL Server 2019 in Azure using the data migration assistant, with backup to blob storage, log shipping, and bulk copy.
Explore how Azure SQL uses firewall rules and virtual networks to control access, including IP-based firewall entry and service endpoints for private network access.
Candidates for this exam are database administrators and data management specialists that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services.
The content of this exam will be updated on December 2, 2022.
Plan and implement data platform resources (20–25%)
Implement a secure environment (15–20%)
Monitor, configure, and optimize database resources (20–25%)
Configure and manage automation of tasks (15–20%)
Plan and configure a high availability and disaster recovery (HA/DR) environment (20–25%)
The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.
This role is responsible for management, availability, security and performance monitoring and optimization of modern relational database solutions. This role works with the Azure Data Engineer role to manage operational aspects of data platform solutions.
Candidates for this role should understand all concepts covered in Exam DP-900: Microsoft Azure Data Fundamentals.
This exam measures your ability to accomplish the following technical tasks: plan and implement data platform resources; implement a secure environment; monitor and optimize operational resources; optimize query performance; perform automation of tasks; plan and implement a High Availability and Disaster Recovery (HADR) environment; and perform administration by using T-SQL.