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…

For an Azure SQL Database configured to function as a data warehouse, increasing the Database Throughput Units (DTUs) scales up the underlying compute, memory, and I/O resources. This enhancement accelerates query processing and report generation, reducing peak hour latency.

Adding storage primarily increases data capacity and does not directly enhance the computational power or I/O throughput required to speed up report generation.

Data Warehouse Units (DWUs) are the scaling metric for Azure Synapse Analytics SQL pools, a separate service, and are not applicable for scaling an Azure SQL Database instance based on DTUs.