You plan to deploy a data platform solution for 4 TB of data. The solution will be used to generate analytic reports during bu
siness hours only. All reports will be generated by using Microsoft Excel.
You need to recommend a data platform for the data. The solution must minimize costs and provide the highest read performance.
Which data platform should you recommend?
A. Micros
oft Azure SQL Data Warehouse
B. Microsoft Azure Cosmos DB
C. Microsoft Azure SQL Database
D. Microsoft Azure Data Lake
Explanation:
SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing
(MPP) to quickly run complex queries across petabytes of data. Use SQL Data Warehouse as a key component of a big data solution. Import big data into SQL Data Warehouse with simple PolyBase T-SQL queries, and then use the power of MPP to run high-performa
nce analytics.
References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is