Home » Microsoft » 70-473 v.2 » Which data platform should you recommend?
You plan to deploy a data platform solution for 4 TB of data. The solution will be used to generate analytic reports during business 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. Microsoft Azure SQL Data Warehouse
B. Microsoft Azure Cosmos DB
C. Microsoft Azure SQL Database
D. Microsoft Azure Data Lake
Correct Answer: A
Explanation/Reference:
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-performance analytics.
References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is