159k views
3 votes
_____________ is a cloud-based EDW that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data.

A. HDInsight
B. CosmosDB
C. SQL Data Warehouse

1 Answer

3 votes

Final answer:

SQL Data Warehouse is a cloud-based Enterprise Data Warehouse utilizing MPP to efficiently execute complex queries on massive datasets, offering high-performance analytics on relational data.

Step-by-step explanation:

C. SQL Data Warehouse is a cloud-based EDW (Enterprise Data Warehouse) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. Unlike HDInsight, which is a cloud-based service for processing big data in the Hadoop framework, or CosmosDB, which is a globally distributed, multi-model database for managing data at large scale, SQL Data Warehouse is specifically designed for high-performance analytics on large volumes of relational data. This makes it a suitable choice for businesses and organizations that require rapid analysis of large datasets with the complexities of relational data modeling.