Câu 4: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

You have a database application that uses Microsoft SQL Server 2012. You have a query named Query1 that returns four columns from a frequently updated table that has a clustered index. Three of the columns are referenced in the WHERE clause of the query. The three columns are part of a non-clustered index. The fourth column is not referenced in the WHERE clause. Users report that the application begins to run slowly. You determine that the root cause for the performance issue is Query1. You need to optimize the statement. What should you do?

1. A. Add a HASH hint to the query.
2. B. Add a LOOP hint to the query.
3. C. Add a FORCESEEK hint to the query.
4. D. Add an INCLUDE clause to the index. — đáp án hiện tại
5. E. Add a FORCESCAN hint to the Attach query.
6. F. Add a columnstore index to cover the query.
7. G. Enable the optimize for ad hoc workloads option.
8. H. Cover the unique clustered index with a columnstore index.
9. I. Include a SET FORCEPLAN ON statement before you run the query.
10. J. Include a SET STATISTICS PROFILEON statement before you run the query.
11. K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
12. L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
13. M. Include a SET TRANSACTION ISOLATIONLEVEL SNAPSHOT statement before you run the query.
14. N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.