You have an Azure SQL Database in the Standard service tier. You need to increase its allocated storage capacity without changing its compute size. Which action should you take?

Change the service tier to Premium

Enable auto-scaling on the database

Add a secondary replica to the database

Increase the max data size setting in the database's service tier configuration

A large table in an Azure SQL Database is partitioned by year. The table has a clustered columnstore index. You need to archive data from the oldest partition to a staging table and then drop the partition. What should you do?

Delete the rows from the partition and then rebuild the index.

Use the ALTER TABLE ... SWITCH PARTITION statement to move the partition to the staging table.

Truncate the partition and then merge the partition boundary.

Create a new table and use INSERT INTO ... SELECT to copy the data.

A company runs an Azure SQL Database in the Business Critical tier (8 vCores). The database has a heavy OLTP workload with high CPU usage. The team wants to reduce cost while maintaining performance. They are considering scaling down to the General Purpose tier. What should you do?

Use a read replica in the General Purpose tier and redirect read-only queries.

Keep the Business Critical tier but reduce the number of vCores to 4.

Scale down to General Purpose and enable data compression to reduce I/O.

Evaluate the workload's latency and I/O requirements before changing the service tier.

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 2

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

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 16–20

16foundation · easy
You need to improve the manageability of a large table by dividing it into smaller, more manageable segments based on a date column. Which feature should you implement?
Select an answer first
17foundation · easy
You need to improve the performance of a large table in an Azure SQL Managed Instance by reducing the amount of I/O required for queries. Which feature should you implement?
Select an answer first
18foundation · easy
You have an Azure SQL Database in the Standard service tier. You need to increase its allocated storage capacity without changing its compute size. Which action should you take?
Select an answer first
19application · medium
A large table in an Azure SQL Database is partitioned by year. The table has a clustered columnstore index. You need to archive data from the oldest partition to a staging table and then drop the partition. What should you do?
Select an answer first
20expert · hard
A company runs an Azure SQL Database in the Business Critical tier (8 vCores). The database has a heavy OLTP workload with high CPU usage. The team wants to reduce cost while maintaining performance. They are considering scaling down to the General Purpose tier. 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 4)

Questions 16–20

You need to improve the manageability of a large table by dividing it into smaller, more manageable segments based on a date column. Which feature should you implement?

You need to improve the performance of a large table in an Azure SQL Managed Instance by reducing the amount of I/O required for queries. Which feature should you implement?

You have an Azure SQL Database in the Standard service tier. You need to increase its allocated storage capacity without changing its compute size. Which action should you take?

A large table in an Azure SQL Database is partitioned by year. The table has a clustered columnstore index. You need to archive data from the oldest partition to a staging table and then drop the partition. What should you do?

A company runs an Azure SQL Database in the Business Critical tier (8 vCores). The database has a heavy OLTP workload with high CPU usage. The team wants to reduce cost while maintaining performance. They are considering scaling down to the General Purpose tier. What should you do?

Keep studying — Plan and implement data platform resources