Querying Data with Transact-SQL — Question 71

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are creating indexes in a data warehouse.
You have a dimension table named Table1 that has 10,000 rows. The rows are used to generate several reports.
The reports join a column that is the primary key.
The execution plan contains bookmark lookups for Table1.
You discover that the reports run slower than expected.
You need to reduce the amount of time it takes to run the reports.
Solution: You create a clustered index on the primary key column.
Does this meet the goal?

Answer options

Correct answer: A

Explanation

Creating a clustered index on the primary key column optimizes the data retrieval process, helping to reduce the execution time for the reports. This is because a clustered index organizes the data physically on the disk, which can eliminate the need for bookmark lookups. The alternative option, 'No,' is incorrect because it suggests that the solution would not improve performance, which contradicts the benefits of implementing a clustered index.