PrepAway - Latest Free Exam Questions & Answers

What should you recommend?

You have a database that has 20 large tables. All the tables have qualified indexes. As the
tables grow, you discover that queries that contain JOIN statements execute more slowly.
You need to recommend a solution to decrease the query response time and the I/O. The
solution must minimize hardware costs. What should you recommend?

PrepAway - Latest Free Exam Questions & Answers

A.
Create a partitioning strategy.

B.
Implement an index strategy.

C.
Implement query hints.

D.
Create a filegroup strategy.


Leave a Reply