FirstTry
DP-300Microsoft Azure Database Administrator Associate

Practice Exam 1

5 of this form’s 40 questions, drawn from across its domains, free. The explanation on every one of them is free too, at every tier, and always will be.

  1. Question 1 of 5

    choosing-an-azure-sql-deployment-optionPlan and implement data platform resources

    A migration team must keep CLR assemblies working in a managed service with no operating system to patch. Which Azure SQL offering fits?

  2. Question 2 of 5

    transparent-data-encryptionImplement a secure environment

    A team runs a Transact-SQL statement to switch the TDE protector to a key vault key and it fails. Why?

  3. Question 3 of 5

    Automatic tuning options and defaultsMonitor, configure, and optimize database resources

    A database on Azure SQL Managed Instance needs automatic tuning. Which options does the instance support?

  4. Question 4 of 5

    Agent alerts and performance conditionsConfigure and manage automation of tasks

    An administrator is naming a new SQL Server Agent alert. What do the naming rules require?

  5. Question 5 of 5

    Failover groups policy and endpointsPlan and configure a high availability and disaster recovery environment

    An engineer asks what the failover groups feature is actually built on top of. What is the answer?

0 of 40 completed

0%

The other 35 questions are the rest of this form: same 100 minute clock, same 700 cut score, and the same explanation on every question, which is never behind the wall. Practice Exam 1 of 2 on Azure Database Administrator.

What this exam covers

  • Plan and implement data platform resources7 questions / 17% of the exam
  • Implement a secure environment9 questions / 22% of the exam
  • Monitor, configure, and optimize database resources9 questions / 22% of the exam
  • Configure and manage automation of tasks7 questions / 17% of the exam
  • Plan and configure a high availability and disaster recovery environment8 questions / 22% of the exam

Checking what you already have access to.

Every question is original, written from the published objectives. We never reproduce, paraphrase, or imitate real exam content, and neither should anything else you study from.