Câu 46: 70-765: Provisioning SQL Databases

You have a database named DB1 that contains a table named Table1. Table1 has 1 billion rows. You import 10 million rows of data into Table1. After the import, users report that queries take longer than usual to execute. You need to identify whether an out-of-date execution plan is causing the performance issue. Which dynamic management view should you use?

1. A. sys.dm_xtp_transaction_stats
2. B. sys.dm_exec_input_buffer
3. C. sys.dm_db_index_operational_stats — đáp án hiện tại
4. D. sys.dm_db_stats_properties