You have a Microsoft Azure SQL data warehouse to which 1,000 Data Warehouse Units (DWUs) are allocated.You plan to load
Posted: Wed Aug 17, 2022 7:02 am
You have a Microsoft Azure SQL data warehouse to which 1,000 Data Warehouse Units (DWUs) are allocated.You plan to load 10 million rows of data to the data warehouse.You need to load the data in the least amount of time possible. The solution must ensure that queries against the new data execute as quickly as possible.What should you use to optimize the data load?
A. resource classes
B. resource pools
C. MAXDOP
D. Resource Governor
A. resource classes
B. resource pools
C. MAXDOP
D. Resource Governor