DP-300 Certification Practice Question #147

Question

You have an Azure SQL database named DB1 in the General Purpose service tier.

The performance metrics for DB1 are shown in the following exhibit.

You need to reduce the Log IO percentage. The solution must minimize costs.

What should you do?

Accepted Answer

Azure SQL Database does not support the Simple recovery model (eliminates D). The question requires minimizing costs, which eliminates upgrading to Business Critical (A) or adding vCores (B). A CHECKPOINT operation flushes dirty pages and marks the transaction log as reusable, reducing Log IO pressure by allowing previously logged transactions to be cleared. While there's debate about its effectiveness, it is the only cost-free option in the list. Despite testdumps2017's concern, C is the Suggested Answer with the most votes and kev22 (👍 5) provides the definitive elimination of D.

More DP-300 practice questions