Exam 312-49v10 topic 1 question 734 discussion

Actual exam question from ECCouncil's 312-49v10

Question #: 734
Topic #: 1

After an unexpected shutdown of a company's database server, the IT forensics team is tasked with collecting data from the Database Plan Cache to investigate potential issues. What query should they use to retrieve the SQL text of all cached entries and acquire additional aggregate performance statistics?

A. Use: select * from sys.dm_exec_cached_plans cross apply sys.dm_exec_plan_attributes(plan_handle) followed by: select * from sys.dm_exec_query_stats
B. Use: select * from sys.dm_exec_cached_plans cross apply sys.dm_exec_sql_text(plan_handle) followed by: select * from sys.dm_exec_plan_attributes(plan_handle)
C. Use: select * from sys.dm_exec_sql_text(plan_handle) cross apply sys.dm_exec_cached_plans followed by: select * from sys.dm_exec_query_stats
D. Use: select * from sys.dm_exec_cached_plans cross apply sys.dm_exec_sql_text(plan_handle) followed by: select * from sys.dm_exec_query_stats

Show Suggested Answer

Suggested Answer: D 🗳️

by Elb at May 28, 2024, 10:59 p.m.

Comments

Submit Cancel

aqeel1506

11 months, 2 weeks ago

Retrieving SQL Text of Cached Entries: The sys.dm_exec_cached_plans view returns information about the cached query plans. The sys.dm_exec_sql_text(plan_handle) function returns the text of the SQL batch that is identified by the specified plan handle. Using a CROSS APPLY allows the combination of each plan handle from sys.dm_exec_cached_plans with the corresponding SQL text from sys.dm_exec_sql_text(plan_handle). Acquiring Aggregate Performance Statistics: The sys.dm_exec_query_stats view provides aggregate performance statistics for cached query plans. This includes data such as execution count, total elapsed time, and total logical reads. By using the specified queries in option D, the IT forensics team can gather comprehensive information about the SQL text of cached entries and also obtain performance statistics for further analysis.

upvoted 1 times

...

Elb

1 year, 1 month ago

Selected Answer: D

Issue the syntax select * from sys.dm_exec_cached_plans cross apply sys.dm_exec_sql_text (plan_handle) to retrieve the SQL text of all cached entries The plan_handle argument retrieves the compiled query plans from the SQLCP or the OBJCP cache stores. Issue the syntax select * from sys.dm_exec_query_stat s to view the aggregate performance statistics for the cached query plans. It displays only one row per query statement.

upvoted 1 times

...