Monitor, configure and optimize database resources
Practise only this domain. 18 questions with explanations, 20 at a time.
Start this domainSample questions
- After a statistics update, a critical reporting query suddenly runs ten times slower. Query Store shows that the query switched to a new plan with much higher duration. The DBA needs to restore the earlier performance immediately while investigating the root cause. What should the DBA do?Medium
- A SaaS company wants Azure to recommend and create missing indexes automatically on its production database, but it does not want the platform to remove any existing index without review. Which automatic tuning configuration meets this requirement?Medium
- A DBA reviews a clustered index that is 45 percent fragmented, with many partially filled pages after heavy updates. The database is in production and the index must remain available during maintenance. What is the most appropriate action?Medium
- During a bulk-load job, log_write_percent stays near 100 percent for long periods while CPU stays around 30 percent. The loader commits each row individually. The team wants the load to finish faster without changing the data. Which change is most effective?Hard
- Query Store is enabled on an Azure SQL database, but a costly ad hoc query that runs only a few times a day never appears in its history. The DBA wants that query captured without changing the application. What should the DBA change?Hard