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 monitoring user queries to a Microsoft Azure SQL data warehouse that has six compute nodes.
You discover that compute node utilization is uneven. The rows_processed column from sys.dm_pdw_workers
shows a significant variation in the number of rows being moved among the distributions for the same table for
the same query.
You need to ensure that the load is distributed evenly across the compute nodes.
Solution: You add a nonclustered columnstore index.
Does this meet the goal?
A.
Yes
B.
No