DP-300 sample questions with answers
The other 86 questions are in the practice tool, with answers revealed as you go.
Start 20 questionsPlan and implement data platform resources
- A multi-tenant analytics vendor keeps one database per client. Usage across clients is sporadic and peaks land at unrelated hours. The vendor wants to keep strict data separation and control spend. Which approach fits best?
- A healthcare company stores full and differential .bak files from its SQL Server estate in a blob container. It wants to restore those backup files into a managed platform with the fewest format changes. Which target supports this?
- Before moving a heavily loaded SQL Server to Azure, a consultant wants the Azure SQL migration tooling to gather live workload counters and suggest which Azure SQL service tier and compute size would fit. Which feature provides this?
Implement a secure environment
- A regulated customer requires that all connections to its Azure SQL logical server use at least TLS 1.2, and that older protocol versions be rejected. Which server setting should the administrator configure?
- An application connects to a single Azure SQL database to read and write customer orders. The security team wants least privilege. Which two actions meet this requirement?
Monitor, configure and optimize database resources
- After a statistics update, a critical reporting query suddenly runs ten times slower. Query Store shows that the query switched to a new plan with much higher duration. The DBA needs to restore the earlier performance immediately while investigating the root cause. What should the DBA do?
- A SaaS company wants Azure to recommend and create missing indexes automatically on its production database, but it does not want the platform to remove any existing index without review. Which automatic tuning configuration meets this requirement?
- A DBA reviews a clustered index that is 45 percent fragmented, with many partially filled pages after heavy updates. The database is in production and the index must remain available during maintenance. What is the most appropriate action?
- During a bulk-load job, log_write_percent stays near 100 percent for long periods while CPU stays around 30 percent. The loader commits each row individually. The team wants the load to finish faster without changing the data. Which change is most effective?
- Query Store is enabled on an Azure SQL database, but a costly ad hoc query that runs only a few times a day never appears in its history. The DBA wants that query captured without changing the application. What should the DBA change?
Configure and manage automation of tasks
Plan and configure a high availability and disaster recovery environment
- A retailer's Business Critical database must remain available if an entire Azure region fails. Which TWO actions provide cross-region recovery capability? (Choose two.)
- A bank's transactional database uses active geo-replication to a secondary in another region. During a regional failure, the team performs a forced failover and notices that a few recent commits are missing from the new primary. Auditors ask why this happened and how the bank can reduce the risk in future. Which statement is the most accurate explanation?
- A compliance team requires monthly backups kept for seven years and a yearly backup kept for ten years. Which Azure SQL feature should the DBA configure?