You have a Microsoft Azure SQL data warehouse. During peak usage, you discover that the data warehouse fails to meet performance expectations. You need to provide additional resources to the data ware

The correct answer is D. Increase the number of Data Warehouse Units (DWUs).. https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-manage-compute-

Monitor and manage an Azure data platform solution

Question

You have a Microsoft Azure SQL data warehouse. During peak usage, you discover that the data warehouse fails to meet performance expectations. You need to provide additional resources to the data warehouse. What should you do?

Options

ACreate an additional storage pool.
BCreate an elastic database pool.
CIncrease the number of Database Throughput Units (DTUs).
DIncrease the number of Data Warehouse Units (DWUs).

How the community answered

(41 responses)

A
2% (1)
B
7% (3)
C
2% (1)
D
88% (36)

Explanation

https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-manage-compute-

Topics

#Azure SQL Data Warehouse#Performance tuning#DWUs#Resource scaling

Community Discussion

No community discussion yet for this question.

Full 70-473 Practice