What should you include in the recommendation?

You need to design a solution that meets the business requirements of Health Insights.

What should you include in the recommendation?
A . Azure Cosmos DB that uses the Gremlin
B . Azure Data Factory
C . Azure Cosmos DB that uses the SQL API
D . Azure Databricks

View Answer

Answer: D

Explanation:

Azure SQL Data Warehouse is a cloud-based enterprise data warehouse 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.

You can access Azure SQL Data Warehouse (SQL DW) from Databricks using the SQL Data Warehouse connector (referred to as the SQL DW connector), a data source implementation for Apache Spark that uses Azure Blob Storage, and PolyBase in SQL DW to transfer large volumes of data efficiently between a Databricks cluster and a SQL DW instance.

Scenario: ADatum identifies the following requirements for the Health Insights application:

✑ The new Health Insights application must be built on a massively parallel processing (MPP) architecture that will support the high performance of joins on large fact tables

References: https://docs.databricks.com/data/data-sources/azure/sql-data-warehouse.html