A database in Azure SQL Database has a large table with a clustered columnstore index. The table is updated frequently with small transactions. You notice that the columnstore index has high fragmentation and queries are slow. What should you do to improve performance?

Switch the table to a rowstore with page compression.

Disable the columnstore index and use a heap.

Increase the database's service objective to improve index maintenance.

Rebuild the columnstore index to consolidate segments.

A large fact table in an Azure SQL Database contains over 1 billion rows and is queried frequently by date range. Queries that filter on the date column are slow. You need to improve query performance and also make it easier to manage data by archiving old partitions. What should you do?

Partition the table by the date column and create a clustered index on the partitioning key.

Create a nonclustered index on the date column.

Use columnstore index on the table.

Enable data compression on the table.

A company runs an Azure SQL Database in the serverless tier. The database has a minimum of 1 vCore and a maximum of 4 vCores. During a sudden traffic spike, the database reaches 100% CPU and queries begin to time out. You need to ensure the database can handle the spike without manual intervention. What should you configure?

Change the database to the provisioned tier.

Enable zone redundancy for the database.

Set the auto-pause delay to a longer duration.

Increase the maximum vCores to 8.

An Azure SQL Managed Instance is used for a migration from on-premises SQL Server. The instance is currently at 8 vCores and the workload is expected to grow. You need to plan for scaling while minimizing downtime. What should you do?

Scale up during business hours to avoid maintenance windows.

Create a second managed instance and use failover to switch during scaling.

Scale up to 16 vCores during a maintenance window.

Use Azure SQL Managed Instance auto-scaling to scale up automatically.

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 2

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

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 1–5

1expert · hard
A database in Azure SQL Database has a large table with a clustered columnstore index. The table is updated frequently with small transactions. You notice that the columnstore index has high fragmentation and queries are slow. What should you do to improve performance?
Select an answer first
2foundation · easy
You need to identify which queries in an Azure SQL Managed Instance are consuming the most CPU resources. Which built-in tool should you use?
Select an answer first
3application · medium
A large fact table in an Azure SQL Database contains over 1 billion rows and is queried frequently by date range. Queries that filter on the date column are slow. You need to improve query performance and also make it easier to manage data by archiving old partitions. What should you do?
Select an answer first
4application · medium
A company runs an Azure SQL Database in the serverless tier. The database has a minimum of 1 vCore and a maximum of 4 vCores. During a sudden traffic spike, the database reaches 100% CPU and queries begin to time out. You need to ensure the database can handle the spike without manual intervention. What should you configure?
Select an answer first
5application · medium
An Azure SQL Managed Instance is used for a migration from on-premises SQL Server. The instance is currently at 8 vCores and the workload is expected to grow. You need to plan for scaling while minimizing downtime. 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 1)

Questions 1–5

A database in Azure SQL Database has a large table with a clustered columnstore index. The table is updated frequently with small transactions. You notice that the columnstore index has high fragmentation and queries are slow. What should you do to improve performance?

You need to identify which queries in an Azure SQL Managed Instance are consuming the most CPU resources. Which built-in tool should you use?

A large fact table in an Azure SQL Database contains over 1 billion rows and is queried frequently by date range. Queries that filter on the date column are slow. You need to improve query performance and also make it easier to manage data by archiving old partitions. What should you do?

An Azure SQL Managed Instance is used for a migration from on-premises SQL Server. The instance is currently at 8 vCores and the workload is expected to grow. You need to plan for scaling while minimizing downtime. What should you do?

Keep studying — Plan and implement data platform resources