nerdexam
Microsoft

70-473 · Question #82

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.

The correct answer is D. Microsoft Azure Data Lake. For a 4 TB data platform generating analytical reports during business hours only via Excel, with cost minimization and highest read performance as key requirements, Azure Data Lake Storage is the most suitable recommendation.

Design and implement data storage

Question

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 possible read performance. Which data platform should you recommend?

Options

  • AMicrosoft Azure SQL Data Warehouse
  • BMicrosoft Azure Cosmos DB
  • CMicrosoft Azure SQL Database
  • DMicrosoft Azure Data Lake

How the community answered

(47 responses)
  • A
    30% (14)
  • B
    6% (3)
  • C
    13% (6)
  • D
    51% (24)

Why each option

For a 4 TB data platform generating analytical reports during business hours only via Excel, with cost minimization and highest read performance as key requirements, Azure Data Lake Storage is the most suitable recommendation.

AMicrosoft Azure SQL Data Warehouse

While Azure SQL Data Warehouse (now Azure Synapse Analytics dedicated SQL pool) offers high performance for analytical workloads, its always-on compute costs can be higher than a data lake solution, especially if resources are only needed during business hours.

BMicrosoft Azure Cosmos DB

Azure Cosmos DB is a NoSQL database optimized for high-performance transactional applications and real-time data access, making it less suitable and more expensive for batch analytical reporting requirements.

CMicrosoft Azure SQL Database

Azure SQL Database is a relational database primarily designed for OLTP workloads; while it can store 4 TB, it may not offer the most cost-effective solution or the highest possible read performance for large-scale analytical reporting compared to specialized data warehousing or data lake services.

DMicrosoft Azure Data LakeCorrect

Azure Data Lake Storage Gen2 provides a highly scalable and cost-effective storage solution for 4 TB of data, optimized for big data analytics with high throughput. It minimizes costs by offering tiered storage and allowing compute resources to be provisioned only during business hours when reports are generated, while still providing high read performance for analytical workloads.

Concept tested: Azure data platform selection, cost optimization for analytics

Source: https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction

Topics

#Azure Data Lake#Data warehousing#Cost optimization#Analytic solutions

Community Discussion

No community discussion yet for this question.

Full 70-473 Practice