An Azure SQL Database in the Business Critical tier is experiencing high CPU usage during peak hours. Query Store shows that a specific query has a high duration and high CPU time. The query is part of a legacy application that cannot be modified. You need to improve performance with minimal administrative effort. What should you do first?

Apply a plan guide to force a better execution plan for the query.

Use the Query Performance Insight to identify the query and then scale up the database to a higher service objective.

Use the Automatic Tuning feature to apply a plan correction recommendation for the query.

Create a covering index on the tables used by the query.

An Azure SQL Database in the Standard tier is experiencing high DTU consumption. The database is used by a reporting application that runs heavy queries during the day. You need to improve performance without changing the application. What should you do?

Create an in-memory OLTP table for the reporting data.

Enable read-only replicas and redirect reporting queries to them.

Use the Automatic Tuning feature to force a plan for the heavy queries.

Scale up the database to a higher DTU tier.

A SQL Server on Azure VM experiences high latency for write-heavy transactions. The VM uses a single premium SSD for both data and log files. You need to improve write performance with minimal cost. What should you do?

Enable read-only routing on the availability group.

Convert the disk to an ultra disk to get lower latency.

Move the transaction log files to a separate premium SSD disk.

Enable compression on the database to reduce I/O.

A large table in an Azure SQL Database is partitioned by month. The table has a clustered index on the partitioning key. Queries that filter on the partitioning column are fast, but queries that filter on another column are slow. You need to improve performance for those queries without affecting the partitioning strategy. What should you do?

Change the partitioning key to the other column.

Create a nonclustered index on the other column.

Enable page compression on the table.

Create a columnstore index on the table.

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 2

Configure Resources for Scale and Performance DP-300 Practice Questions (Page 2)

Part of the Plan and implement data platform resources domain, which accounts for 15–20% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 2–4 from this objective — we provide 34 practice questions to prepare you well beyond it. (estimate)

34questions here

7free pages

8concepts

15–20%of the exam

Questions 6–10

6application · medium
An Azure SQL Database in the Business Critical tier is experiencing high CPU usage during peak hours. Query Store shows that a specific query has a high duration and high CPU time. The query is part of a legacy application that cannot be modified. You need to improve performance with minimal administrative effort. What should you do first?
Select an answer first
7application · medium
An Azure SQL Database in the Standard tier is experiencing high DTU consumption. The database is used by a reporting application that runs heavy queries during the day. You need to improve performance without changing the application. What should you do?
Select an answer first
8application · medium
A SQL Server on Azure VM experiences high latency for write-heavy transactions. The VM uses a single premium SSD for both data and log files. You need to improve write performance with minimal cost. What should you do?
Select an answer first
9foundation · easy
You need to configure an Azure SQL Database so that it can automatically adjust its allocated resources based on workload demand without manual intervention. Which Azure SQL Database feature should you use?
Select an answer first
10expert · hard
A large table in an Azure SQL Database is partitioned by month. The table has a clustered index on the partitioning key. Queries that filter on the partitioning column are fast, but queries that filter on another column are slow. You need to improve performance for those queries without affecting the partitioning strategy. What should you do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Configure Resources for Scale and Performance DP-300 Practice Questions (Page 2)

Questions 6–10

An Azure SQL Database in the Standard tier is experiencing high DTU consumption. The database is used by a reporting application that runs heavy queries during the day. You need to improve performance without changing the application. What should you do?

A SQL Server on Azure VM experiences high latency for write-heavy transactions. The VM uses a single premium SSD for both data and log files. You need to improve write performance with minimal cost. What should you do?

You need to configure an Azure SQL Database so that it can automatically adjust its allocated resources based on workload demand without manual intervention. Which Azure SQL Database feature should you use?

Keep studying — Plan and implement data platform resources