You need to increase the I/O performance of SQL Server on an Azure Virtual Machine without changing the VM size. Which action should you take?

Change the VM's operating system

A company runs an Azure SQL Managed Instance (MI) in the General Purpose tier with 8 vCores. The MI hosts a database used by a mission-critical application. The application experiences periodic CPU spikes that cause latency. The team has a limited budget and cannot change the application code. They need to reduce latency during spikes. What should you do?

Move the database to Azure SQL Database and use the Hyperscale tier.

Implement a job that scales the MI up before expected peak times and down after.

Scale up the MI to 16 vCores to provide more CPU headroom.

Use Query Store to identify the queries causing the spikes and create missing indexes.

You need to scale the compute resources of an Azure SQL Managed Instance to meet increased performance demands. Which action should you take?

Increase the storage size of the managed instance

Add a read replica to the managed instance

Change the vCore count in the managed instance's pricing tier

Enable auto-scaling on the managed instance

An Azure SQL Database in the Business Critical tier is experiencing high latency during peak hours. Query Store shows that a specific query frequently waits on PAGEIOLATCH_SH. The database has a high number of logical reads. You need to improve performance without changing the application code. What should you do first?

Increase the database's max degree of parallelism (MAXDOP) to 8.

Switch the database to the Hyperscale tier to get faster local SSD storage.

Enable row-level security to reduce the data returned by the query.

Scale up to a higher service objective within the Business Critical tier to get more I/O capacity.

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 2

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

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 21–25

21foundation · easy
You need to increase the I/O performance of SQL Server on an Azure Virtual Machine without changing the VM size. Which action should you take?
Select an answer first
22expert · hard
A company runs an Azure SQL Managed Instance (MI) in the General Purpose tier with 8 vCores. The MI hosts a database used by a mission-critical application. The application experiences periodic CPU spikes that cause latency. The team has a limited budget and cannot change the application code. They need to reduce latency during spikes. What should you do?
Select an answer first
23foundation · easy
You need to scale the compute resources of an Azure SQL Managed Instance to meet increased performance demands. Which action should you take?
Select an answer first
24application · medium
An Azure SQL Database in the Business Critical tier is experiencing high latency during peak hours. Query Store shows that a specific query frequently waits on PAGEIOLATCH_SH. The database has a high number of logical reads. You need to improve performance without changing the application code. What should you do first?
Select an answer first
25foundation · easy
You need to reduce the storage footprint of a table that contains many repeated values in a column. Which data compression technique is most appropriate?
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 5)

Questions 21–25

You need to increase the I/O performance of SQL Server on an Azure Virtual Machine without changing the VM size. Which action should you take?

You need to scale the compute resources of an Azure SQL Managed Instance to meet increased performance demands. Which action should you take?

You need to reduce the storage footprint of a table that contains many repeated values in a column. Which data compression technique is most appropriate?

Keep studying — Plan and implement data platform resources