Microsoft
70-451 · Question #138
70-451 Question #138: Real Exam Question with Answer & Explanation
The correct answer is D. Create a partitioning strategy.. See the full explanation below for the reasoning.
Question
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?
Options
- AImplement query hints.
- BCreate a filegroup strategy.
- CImplement an index strategy.
- DCreate a partitioning strategy.
Community Discussion
No community discussion yet for this question.