nerdexam
Microsoft

70-776 · Question #32

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…

The correct answer is B. No. See the full explanation below for the reasoning.

Question

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 clustered columnstore index. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(57 responses)
  • A
    26% (15)
  • B
    74% (42)

Community Discussion

No community discussion yet for this question.

Full 70-776 Practice