You recently implemented a Microsoft Azure SQL data warehouse.
You discover that during peak hours, the data warehouse takes longer than expected to generate reports.
You need to reduce the amount of time it takes to generate the reports.
What should you do from the Azure portal?
A. Increase the number of Database Throughput Units (DTUs).
B. Move the data warehouse to a different resource group.
C. Add storage to the data warehouse.
D. Increase the number of Data Warehouse Units (DWUs).
Correct Answer: D
Explanation/Reference:
With SQL Data Warehouse CPU, memory, and IO are bundled into units of compute scale called Data Warehouse Units (DWUs). A DWU represents an abstract, normalized measure of compute resources and performance. By changing your service level you alter the number of DWUs that are allocated to the system, which in turn adjusts the performance, and the cost, of your system.
Incorrect Answers:
A: Database Throughput Unit (DTU): DTUs provide a way to describe the relative capacity of a performance level of Basic, Standard, and Premium databases. DTUs are based on a blended measure of CPU, memory, reads, and writes. As DTUs increase, the power offered by the performance level increases.
Reference: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/what-is-a-data-warehouse-unit-dwu-cdwu
