Monitor, configure, and optimize database resources Questions
Practice questions for Monitor, configure, and optimize database resources topic in Microsoft Certified: Azure Database Administrator Associate. 44 questions covering this domain.
Which monitoring technology is the lightweight replacement for SQL Trace and SQL Server Profiler?
A DBA wants to integrate Intelligent Insights with centralized monitoring. Which destinations are supported for streaming the SQLInsights log?
Which automatic tuning option is supported on Azure SQL Managed Instance?
Which statement about Extended Events support is correct?
What are the Azure default automatic tuning settings that new logical servers inherit?
Intelligent Insights flags an excessive wait time issue. Which telemetry source is explicitly used for that analysis?
An administrator lets Azure SQL Database apply an automatic tuning recommendation. What protection does the platform provide after applying it?
How does Intelligent Insights establish a performance baseline for an Azure SQL database?
A team wants to use Database Engine Tuning Advisor against Azure SQL Database. What is the correct guidance?
What permission is generally required to query database-scoped dynamic management views for troubleshooting?
Why might Azure SQL Database automatic tuning not recommend a CREATE INDEX action for a very large table even if queries are slow?
An Azure SQL Database administrator wants to maintain index health. What is the documented expectation?
Which statement is correct regarding parameter sensitive plan optimization (PSP optimization) introduced in newer SQL versions?
A DBA wants to limit CPU consumption of an analytics workload on a SQL Server on Azure VM so it doesn't starve OLTP queries. Which feature should they...
Which DMV provides recent CPU, IO, and memory usage samples for Azure SQL Database at frequent intervals?
A DBA wants to manually force a known-good plan for a query showing plan regression. Which Query Store stored procedure forces a specific plan?
An application connects to an Azure SQL Database Business Critical with ApplicationIntent=ReadOnly. What does the platform do?
An Azure SQL Managed Instance shows high LCK_M_X waits and locking on an OLTP table. The team is comfortable with optimistic concurrency. Which databa...
A DBA observes high PAGELATCH waits on tempdb GAM/SGAM/PFS pages on a SQL Server on Azure VM. Which mitigation does Microsoft recommend?
What is the default state of Query Store on a new Azure SQL Database?
Sign in to see all 44 questions
Create a free account to browse all questions — completely free during our launch phase.