nerdexam
Microsoft

70-475 · Question #19

You need to recommend a platform architecture for a big data solution that meets the following requirements: - Supports batch processing - Provides a holding area for a 3-petabyte (PB) dataset…

The correct answer is A. a Microsoft Azure SQL data warehouse E. Microsoft Azure Table Storage. A: Azure SQL Data Warehouse is a SQL-based, fully-managed, petabyte-scale cloud data warehouse. It's highly elastic, and it enables you to set up in minutes and scale capacity in seconds. Scale compute and storage independently, which allows you to burst compute for complex…

Implement Big Data batch processing solutions

Question

You need to recommend a platform architecture for a big data solution that meets the following requirements: - Supports batch processing - Provides a holding area for a 3-petabyte (PB) dataset - Minimizes the development effort to implement the solution - Provides near real time relational querying across a multi-terabyte (TB) dataset Which two platform architectures should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • Aa Microsoft Azure SQL data warehouse
  • Ba Microsoft Azure HDInsight Hadoop cluster
  • Ca Microsoft SQL Server database
  • Da Microsoft Azure HDInsight Storm cluster
  • EMicrosoft Azure Table Storage

How the community answered

(57 responses)
  • A
    74% (42)
  • B
    4% (2)
  • C
    16% (9)
  • D
    7% (4)

Explanation

A: Azure SQL Data Warehouse is a SQL-based, fully-managed, petabyte-scale cloud data warehouse. It's highly elastic, and it enables you to set up in minutes and scale capacity in seconds. Scale compute and storage independently, which allows you to burst compute for complex analytical workloads, or scale down your warehouse for archival scenarios, and pay based on what you're using instead of being locked into predefined cluster configurations-and get more cost efficiency versus traditional data warehouse solutions. E: Use Azure Table storage to store petabytes of semi-structured data and keep costs down. Unlike many data stores-on-premises or cloud-based-Table storage lets you scale up without having to manually shard your dataset. Perform OData-based queries. https://azure.microsoft.com/en-us/services/sql-data-warehouse/ https://azure.microsoft.com/en-us/services/storage/tables/

Topics

#batch processing#Azure SQL Data Warehouse#Azure Table Storage#platform architecture

Community Discussion

No community discussion yet for this question.

Full 70-475 Practice