exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 20 question 1 discussion

Actual exam question from Microsoft's DP-201
Question #: 1
Topic #: 20
[All DP-201 Questions]

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 API
  • B. Azure Data Factory
  • C. Azure Cosmos DB that uses the SQL API
  • D. Azure Databricks
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
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 SQL Data Warehouse as a key component of a big data solution.
You can access Azure Synapse Analytics (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
Reference:
https://docs.databricks.com/data/data-sources/azure/sql-data-warehouse.html

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
[Removed]
Highly Voted 5 years, 1 month ago
It should be azure data warehouse (or actually synapse analytics now)
upvoted 12 times
vistran
5 years, 1 month ago
True Since that option is not available, next best option would be Azure Databricks which can access Azure Synapse Anlytics through Azure Synapse Connector I guess
upvoted 5 times
...
DaemonMahara
4 years, 6 months ago
I think question is asking for design solution for storing the data .. so Databricks should be fine i guess ...
upvoted 1 times
...
...
SidN
Highly Voted 5 years ago
isn't the answer B - ADF can be used to make data available into SQLDW as per requirement"The data from Health Interface and Health Review must be available in Health Insights within 15 minutes of being committed."
upvoted 10 times
...
ThijsN
Most Recent 4 years, 5 months ago
I pick databricks over ADF because it need to grab both streaming (the interface data) and batch data.
upvoted 5 times
...
XoN
4 years, 5 months ago
I had this question in my exam. I believe Databricks is the best answer.
upvoted 2 times
...
saponazureguy
4 years, 6 months ago
"Minimize the number of services required to perform data processing, development, scheduling, monitoring, and the operationalizing of pipelines" - ADF best fits this requirement so my answer is B
upvoted 1 times
Johnnien
4 years, 6 months ago
Can I use ADF only for solution of both Health Insights and Health Interface?
upvoted 1 times
...
ThijsN
4 years, 5 months ago
databricks fits that description as well.
upvoted 2 times
...
...
syu31svc
4 years, 6 months ago
From https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html: "You can access Azure Synapse from Databricks using the Azure Synapse connector" Databricks it is then
upvoted 2 times
...
M0e
4 years, 8 months ago
Still not convinced why ADF is not the answer instead of ADB? I think both can be used as part of the solution. -- Data is ingested from Health Interface which should support scalable batch processing (ADB) and the data should be transferred to the Insight in 15 minutes intervals (ADF). So either both answers are correct or question is faulty and has been changed by now.
upvoted 2 times
...
Bob123456
4 years, 10 months ago
How about Cosmos with Sql Api option C ??
upvoted 3 times
suhas16c
4 years, 9 months ago
Cosmos DB supports only self joins. But health insight app shold support joins on fact tables. Hence cosmos db is ruled out
upvoted 4 times
...
...
extraego
4 years, 10 months ago
From "The data from Health Interface and Health Review must be available in Health Insights within 15 minutes of being committed." we have two options: Azure Data Factory and Azure Databricks. Then we need to be able to analyze events, so Azure Databricks is the answer.
upvoted 1 times
...
dcpavelescu
4 years, 10 months ago
Answer B? As described by Health Insights Requirements: the solution shall provide a data warehouse and the ingestion into the data warehouse. ADF might be the solution for the ingestion past.
upvoted 1 times
Johnnien
4 years, 6 months ago
I cannot see the requirement of ingestion into the data warehouse.
upvoted 1 times
...
...
where is the option for synapse? the answer should be synapse
upvoted 2 times
...
thukza
5 years ago
massively parallel processing (MPP) architecture -> SQL DW but its not part of the answer options here
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...