FirstTry
DP-300Microsoft Azure Database Administrator Associate

Practice Exam 2

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 SaaS team hosts hundreds of small customer databases whose busy hours rarely overlap. Which Azure SQL Database option holds total cost down?

  2. Question 2 of 5

    transparent-data-encryptionImplement a secure environment

    A team exports a TDE-protected database to a BACPAC file for a partner. Is the exported content encrypted?

  3. Question 3 of 5

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

    Automatic DROP INDEX is enabled on a Business Critical database. Which indexes does it actually drop?

  4. Question 4 of 5

    Agent alerts and performance conditionsConfigure and manage automation of tasks

    A database administrator defines an alert with severity level 15 and names one database. When does SQL Server Agent fire it?

  5. Question 5 of 5

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

    An administrator sets a failover group to the customer managed policy through the Azure CLI. Which value is passed?

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 2 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.