Dëse Browser gëtt net méi ënnerstëtzt.
Upgrat op Microsoft Edge fir vun de Virdeeler vun leschten Eegeschaften, Sécherheetsupdaten, an techneschem Support ze profitéieren.
Choose the best response for each of the questions below.
Which type of execution plan is stored in the plan cache?
Estimated execution plan
Actual execution plan
Live Query Stats
Which DMV should you use to find index utilization?
sys.dm_db_index_usage_stats
sys.dm_db_missing_index_details
sys.dm_exec_query_plan_stats
Which of the following wait types would indicate excessive CPU consumption?
SOS_SCHEDULER_YIELD
RESOURCE_SEMAPHORE
PAGEIOLATCH_SH
Which isolation level should you choose if you want to prevent users reading data from blocking users writing data?
Serializable
Read Committed Snapshot Isolation
Repeatable Read
You must answer all questions before checking your work.
War dës Säit hëllefräich?
Braucht Dir Hëllef mat dësem Theema?
Wëllt Dir probéieren, Ask Learn ze benotzen, fir Iech duerch dëst Theema ze leeden oder et méi kloer ze maachen?