Home » Microsoft » DP-201 v.2 » 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
Correct Answer: D
Explanation/Reference:
Explanation:
Azure Synapse Analytics is a cloud-based enterprise data warehouse that leverages massively parallel processing (MPP) to quickly run complex queries across petabytes of data. Use Synapse Analytics as a key component of a big data solution.
You can access Azure Synapse Analytics (SQL DW) from Databricks using the Synapse Analytics 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
Reference:
https://docs.databricks.com/data/data-sources/azure/sql-data-warehouse.html