File Name: RE4q3yZ
File Size: 169.19 KB
File Type: Application/pdf
Last Modified: 7 months
Last checked: 3 days ago!
This Document Has Been Certified by a Professional
We recommend downloading this file onto your computer
Exam DP-300: Administering Microsoft Azure SQL Solutions Study Guide Exam DP-300: Administering Microsoft Azure SQL SolutionsQuick navigationPurpose of this documentCertification Certification journey Certification renewalAbout the exam Passing score What to expect on the examPrepare to take the exam Request accommodations Take practice tests Objective domain: skills the exam measuresSkills measured Functional groupsCorresponding learning paths and modulesAdditional study resources 1 Exam DP-300: Administering Microsoft Azure SQL SolutionsPurpose of this documentThis study guide should help you understand what to expect on Exam DP-300: Administering MicrosoftAzure SQL Solutions, and includes a summary of the topics the exam might cover and links to additionalresources. The information and materials in this document should help you focus your studies as youprepare for the exam
CertificationCertification journeyFor an overview of attaining Microsoft Certification, including prerequisites (if any) and additionalresources, explore The journey to Microsoft Certified: Azure Database Administrator Associate
Certification renewalOnce you earn your certification, don’t let it expire. When you have an active certification that’s expiringwithin six months, you should renew it—at no cost—by passing a renewal assessment on MicrosoftLearn. Remember to renew your certification annually, if you want to retain it
To identify which certifications are available for you to renew, visit your Certifications in your MicrosoftLearn profile: • Ensure your certification profile is connected to your Microsoft Learn profile
• Expect an email that directs you to the applicable assessment that you must pass on Microsoft Learn. You’ll receive this email as soon as you have a certification that you’re eligible to renew
• When you pass an online assessment, your certification will extend by one year from the current expiration date
• To help prepare for the assessment, explore the collection of free modules on the certification renewal page
About the examExam DP-300: Administering Microsoft Azure SQL Solutions is required to earn the Azure DatabaseAdministrator Associate certification
As a candidate for this exam, you should have knowledge of and experience with Azure SQL Edge,Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines(Windows and Linux). You should also have subject matter expertise in building database solutions thatare designed to support multiple workloads built with Azure SQL database services
Passing scoreA passing score is 700. Learn more about exam scoring and score reports
2 Exam DP-300: Administering Microsoft Azure SQL SolutionsWhat to expect on the examAre you new to Microsoft certification exams? You can explore the exam environment by visiting ourexam sandbox. We created the sandbox so you have an opportunity to experience an exam before youtake it. In the sandbox, you can interact with different question types, such as build list, case studies, andothers that you might encounter in the user interface when you take an exam. Additionally, it includesthe introductory screens, instructions, and help topics related to the different types of questions thatyour exam might include. It also includes the non-disclosure agreement that you must accept beforeyou can launch the exam
Prepare to take the examThere are several points to consider, or pursue, as you prepare for an exam. The following sectionsdetail those points
Request accommodationsWe’re committed to ensuring all learners are set up for success. If you use assistive devices, requireextra time, or need modification to any part of the exam experience, you can request anaccommodation. We encourage you to learn more about available accommodations and how to obtainthem by visiting this page
Take practice testsTaking a practice test is a great way to know whether you’re ready to take the exam or if you need tostudy a bit more. Subject-matter experts write the Microsoft Official Practice Tests, which are designedto assess all exam objectives. Take the DP-300: Administering Microsoft Azure SQL Solutions MicrosoftOfficial Practice Test
Objective domain: skills the exam measuresThe English language version of this exam was updated on August 4, 2022
Some exams are localized into other languages, and those are updated approximately eight weeks afterthe English version is updated. Other available languages are listed in the Schedule Exam section of theExam Details webpage. If the exam isn’t available in your preferred language, you can request anadditional 30 minutes to complete the exam
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam
3 Exam DP-300: Administering Microsoft Azure SQL Solutions Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used
Skills measured • 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%)Functional groupsPlan and implement data platform resources (20—25%)Plan and deploy Azure SQL Database solutions • Deploy database offerings on selected platforms • Understand automated deployment • Apply patches and updates for hybrid and infrastructure as a service (IaaS) deployment • Deploy hybrid SQL Server database solutions • Recommend an appropriate database offering based on specific requirements • Evaluate the security aspects of the possible database offering • Recommend a table partitioning solution • Recommend a database sharding solutionConfigure resources for scale and performance • Configure Azure SQL Database for scale and performance • Configure Azure SQL Managed Instance for scale and performance • Configure SQL Server on Azure Virtual Machines for scale and performance • Configure table partitioning • Configure data compressionPlan and implement a migration strategy • Evaluate requirements for the migration • Evaluate offline or online migration strategies • Implement an online migration strategy • Implement an offline migration strategy • Perform post migration validations • Troubleshoot a migration 4 Exam DP-300: Administering Microsoft Azure SQL Solutions • Set up SQL Data Sync for Azure • Implement a migration to Azure • Implement a migration between Azure SQL servicesImplement a secure environment (15—20%)Configure database authentication and authorization • Configure Azure Active Directory (Azure AD) authentication and Active Directory authentication • Create users from Azure AD identities • Configure security principals • Configure database and object-level permissions using graphical tools • Apply principle of least privilege for all securables • Troubleshoot authentication and authorization issues • Manage authentication and authorization by using T-SQLImplement security for data at rest and data in transit • Implement transparent data encryption (TDE) • Implement object-level encryption • Configure server- and database-level firewall rules • Implement Always Encrypted • Configure secure access • Configure Transport Layer Security (TLS)Implement compliance controls for sensitive data • Apply a data classification strategy • Configure server and database audits • Implement data change tracking • Implement dynamic data masking • Manage database resources by using Azure Purview • Implement Azure SQL Database ledger • Implement row-level security • Configure Advanced Threat ProtectionMonitor, configure, and optimize database resources (20—25%)Monitor resource activity and performance • Prepare an operational performance baseline • Determine sources for performance metrics • Interpret performance metrics • Configure and monitor activity and performance • Monitor by using SQL Insights 5 Exam DP-300: Administering Microsoft Azure SQL Solutions • Monitor by using Extended EventsMonitor and optimize query performance • Configure Query Store • Monitor by using Query Store • Identify sessions that cause blocking • Identify performance issues using dynamic management views (DMVs) • Identify and implement index changes for queries • Recommend query construct modifications based on resource usage • Assess the use of query hints for query performance • Review execution plansConfigure database solutions for optimal performance • Implement index maintenance tasks • Implement statistics maintenance tasks • Implement database integrity checks • Configure database automatic tuning • Configure server settings for performance • Configure Resource Governor for performance • Implement database-scoped configuration • Configure compute and storage resources for scaling • Configure intelligent query processing (IQP)Configure and manage automation of tasks (15—20%)Create and manage SQL Server Agent jobs • Manage schedules for regular maintenance jobs • Configure job alerts and notifications • Troubleshoot SQL Server Agent jobsAutomate deployment of database resources • Automate deployment by using Azure Resource Manager templates (ARM templates) and Bicep • Automate deployment by using PowerShell • Automate deployment by using Azure CLI • Monitor and troubleshoot deploymentsCreate and manage database tasks in Azure • Create and configure elastic jobs • Create and configure database tasks by using automation • Automate database workflows by using Azure Logic Apps • Configure alerts and notifications on database tasks 6 Exam DP-300: Administering Microsoft Azure SQL Solutions • Troubleshoot automated database tasksPlan and configure a high availability and disaster recovery (HA/DR)environment (20—25%)Recommend an HA/DR strategy for database solutions • Recommend HA/DR strategy based on Recovery Point Objective/Recovery Time Objective (RPO/RTO) requirements • Evaluate HA/DR for hybrid deployments • Evaluate Azure-specific HA/DR solutions • Recommend a testing procedure for an HA/DR solutionPlan and perform backup and restore of a database • Recommend a database backup and restore strategy • Perform a database backup by using database tools • Perform a database restore by using database tools • Perform a database restore to a point in time • Configure long-term backup retention • Backup and restore a database by using T-SQLConfigure HA/DR for database solutions • Configure active geo-replication • Configure an Always On availability group • Configure auto-failover groups • Configure quorum options for a Windows Server Failover Cluster • Configure failover cluster instances on Azure Virtual Machines • Configure log shipping • Monitor an HA/DR solution • Troubleshoot an HA/DR solutionCorresponding learning paths andmodulesThe design of learning paths and modules should teach you how to perform a role and will help youstudy for the applicable exam. However, learning paths aren’t always in the same order as an exam’s“skills measured” list. Therefore, we’ve created a convenient table that links the skills measured tospecific paths and modules
7 Exam DP-300: Administering Microsoft Azure SQL Solutions Exam skills measured Links to learning paths Plan and implement data Introduction to Azure database administration platform resources (20–25%) • Prepare to maintain SQL databases on Azure Plan and implement data platform resources • Deploy IaaS solutions with Azure SQL • Deploy PaaS solutions with Azure SQL • Evaluate strategies for migrating to Azure SQL Implement a secure environment Implement a secure environment for a database service (15–20%) • Configure database authentication and authorization • Protect data in-transit and at rest • Implement compliance controls for sensitive data Monitor, configure, and optimize Monitor and optimize operational resources in Azure SQL database resources (20–25%) • Describe performance monitoring • Configure SQL Server resources for optimal performance • Configure databases for optimal performance Optimize query performance in Azure SQL • Explore query performance optimization • Explore performance-based design • Evaluate performance improvements Configure and manage Automate database tasks for Azure SQL automation of tasks (15–20%) • Automate deployment of database resources • Create and manage SQL Agent jobs • Manage Azure PaaS tasks using automation Plan and configure a High Plan and implement a high availability and disaster recovery Availability and Disaster Recovery solution (HA/DR) environment (20–25%) • Describe high availability and disaster recovery strategies • Explore IaaS and PaaS solutions for high availability and disaster recovery • Back up and restore databasesAdditional study resourcesWe offer several resources to help you prepare for the exam and stay current and engaged with theMicrosoft Azure community. These resources range from formal training to blogs and even interviewswith Microsoft team members
8 Exam DP-300: Administering Microsoft Azure SQL SolutionsStudy resource link Resource descriptionCourse DP-300T00: Administering Take an instructor-led course to gain knowledge and skills toMicrosoft Azure SQL Solutions administer a SQL Server database infrastructure for cloud, on- premises and hybrid relational databases
Azure documentation Stay informed on the latest products, tools, and features, and get information on pricing, partners, support, solutions, and more
Azure Community Support Ask questions, get answers, and connect with Microsoft engineers and Azure community experts
Microsoft Learn Community Blog Get the latest information about certification tests and exam study groups
Data Exposed Data Exposed is a show that is all about data; relational and non-relational, on-premises and in the cloud, big and small
Get the inside scoop and join us as we demonstrate features, discuss the latest news, and share our love for data technology including SQL Server, Azure SQL Database, Cosmos DB, open-source databases, Azure Arc Data Services, Azure Data Factory, Azure Synapse and more! 9
Purpose of this document This study guide should help you understand what to expect on Exam DP-300: Administering Microsoft Azure SQL Solutions, and includes a summary of the topics the exam might cover and links to additional resources. The information and materials in this document should help you focus your studies as you prepare for the exam.
Exam DP-300 Administering Relational Databases on Microsoft Azure 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.
Some certifications have requirements going back to older exams, while others use two or more tests to help someone pass. If you find the DP-300 is over your head, that’s ok. It might make sense to see if a lower level exam will give you some clarity. If offered, read the exam objectives
Looking for DP-300 Dumps? Read This! Using DP-300 exam dumps can get you permanently banned from taking any future Microsoft certificate exam. Read the FAQ page for more information.
The Microsoft DP-300 is developed for Azure database administrator. They are responsible for the maintenance, security, and availability of databases, as well as performance monitoring and optimization of existing relational database systems.