RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
SQL Monitoring
«Prev
Next»
Configuration Monitoring
Importing/Exporting Data
Insert Data Load Statement
Select into Statement
Bulk Insert Statement
SQL Bulk Copy Program
SSIS
SQL Server Data Tools
SQL Server Agent
Azure Data Factory
SQL Data Integration
Load Export Conclusion
Intro Monitoring SSMS
SQL Server Connections
Monitoring SQL Connections
Monitor Locked Resources
SQL EM Monitor Locks
Overall System Performance
Database Consistency Checker
Monitor Data Cache
Monitor Performance Using DBCC
Trace Flags
Built In Functions
SQL EM Conclusion
Monitoring Databases
Monitor Database Size
Use SSMS monitor DB Size
Monitor Databases using DBCC
Monitor Consistency Individual Tables
Miscellaneous DB Monitoring via Dbcc
Monitor Transaction Log
Maintaining Database Statistics
View Statistical Information
Run sqlmaint.exe
Database Maintenance Plan wizard
SSMS Conclusion
Intro Extended Events
Extended Events Tools Ssms
Extended Events Sessions
Extended Events Actions
Extended Events Payload Fields
Run Extended Events Sessions
Query Store Regression Analysis
Query Store Top Tuning
Configure Query Store
Extended Events Conclusion
Each question is worth one point. Select the best answer (or answers) for each question.
Query Store - Quiz
Query Store configuration and performance troubleshooting
1.
Which Query Store options can you configure using
ALTER DATABASE ... SET QUERY_STORE
?
Please select all the correct answers.
A.
OPERATION_MODE (READ_WRITE / READ_ONLY)
B.
QUERY_CAPTURE_MODE (AUTO / ALL / NONE / CUSTOM)
C.
MAX_STORAGE_SIZE_MB (Query Store storage limit)
D.
AUTO_CREATE_STATISTICS (database option unrelated to Query Store)
2.
In SSMS, which Query Store features help an administrator perform regression analysis?
Please select all the correct answers.
A.
Regressed Queries report (compare performance across time windows)
B.
Force Plan / Unforce Plan (stabilize a regressed query)
C.
Top Resource Consuming Queries report (identify heavy CPU/IO/duration)
D.
Login auditing report (security feature, not Query Store)
3.
Which Query Store catalog view contains the SQL text for captured queries?
Select the best answer.
A.
sys.query_store_query_text
B.
sys.query_store_plan
C.
sys.query_store_runtime_stats
D.
sys.dm_exec_query_stats