Exam DP-201 topic 21 question 3 discussion

Actual exam question from Microsoft's DP-201

Question #: 3
Topic #: 21

You need to design the solution for the government planning department.
Which services should you include in the design?

A. Azure Synapse Analytics and Elastic Queries
B. Azure SQL Database and Polybase
C. Azure Synapse Analytics and Polybase
D. Azure SQL Database and Elastic Queries

Show Suggested Answer

Suggested Answer: C 🗳️
PolyBase is a new feature in SQL Server 2016. It is used to query relational and non-relational databases (NoSQL) such as CSV files.
Scenario: Traffic data must be made available to the Government Planning Department for the purpose of modeling changes to the highway system. The traffic data will be used in conjunction with other data such as information about events such as sporting events, weather conditions, and population statistics. External data used during the modeling is stored in on-premises SQL Server 2016 databases and CSV files stored in an Azure Data Lake Storage Gen2 storage account.
Reference:
https://www.sqlshack.com/sql-server-2016-polybase-tutorial/
Design Azure data storage solutions

by DirectX at May 5, 2021, 4:08 p.m.

Comments

Submit Cancel

hoangton

3 years, 11 months ago

Answer is C

upvoted 2 times

...

Wendy_DK

4 years ago

External data used during the modeling is stored in on-premises SQL Server 2016 databases and CSV files stored in an Azure Data Lake Storage Gen2 storage account. Answer is B

upvoted 3 times

ZodiaC

3 years, 11 months ago

Correct DYMIZE is right. SO ITS C 10000%

upvoted 2 times

...

Dymize

4 years ago

Keep in mind that this data will be modeled and served, that leans towards Synapse Analytics and Polybase since there are external sources

upvoted 6 times

...

[Removed]

3 years, 11 months ago

Data Lake is not supported with neither Azure SQL Database or onpremise SQL Server.

upvoted 2 times

...