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

You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. You discover that the root cause is a query against a frequently updated table that has a clustered index. The query returns four columns: three columns in itsWHERE clause contained in a non-clustered index and one additional column. 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. — đáp án hiện tại
4. D. Add an INCLUDE clause to the index.
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 PROFILE ON statement before you run the query. K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query. L. Include a SET TRANSACTIONISOLATION LEVEL REPEATABLE READ statement before you run the query. M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query. N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.