PrepAway - Latest Free Exam Questions & Answers

You plan to deploy a data platform solution for 4 TB of data. The solution will be used to generate analytic r

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


Leave a Reply