exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 8 question 1 discussion

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

HOTSPOT -
You need to design the data loading pipeline for Planning Assistance.
What should you recommend? To answer, drag the appropriate technologies to the correct locations. Each technology may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: SqlSink Table -
Sensor data must be stored in a Cosmos DB named treydata in a collection named SensorData

Box 2: Cosmos Bulk Loading -
Use Copy Activity in Azure Data Factory to copy data from and to Azure Cosmos DB (SQL API).
Scenario: Data from the Sensor Data collection will automatically be loaded into the Planning Assistance database once a week by using Azure Data Factory. You must be able to manually trigger the data load process.
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-cosmos-db

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
Luke97
Highly Voted 5 years, 1 month ago
The data pipeline is moving data from Cosmos DB to SQL Database. So, the 1st box should be Cosmos Bulking Loading and 2nd box should be SQLSink Table.
upvoted 77 times
cmihai
4 years, 10 months ago
why Cosmos Bulk Loading when you are reading from Cosmos DB? should be Cosmos Query
upvoted 22 times
...
ZodiaC
3 years, 11 months ago
I AGREE ITS ONCE A WEEK SO BULK LOADING and SQL DATABASE
upvoted 2 times
...
...
silango
Highly Voted 4 years, 12 months ago
ADF uses Cosmos DB as the source. Shouldn't be Cosmos query? Check: https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-cosmos-db#azure-cosmos-db-sql-api-as-source
upvoted 15 times
silango
4 years, 12 months ago
Box1: Cosmos query Box2: SQLSink Table
upvoted 52 times
...
...
davita8
Most Recent 4 years, 1 month ago
Cosmos Query in Box1 and SqlSink Table in Box2
upvoted 3 times
...
felmasri
4 years, 3 months ago
I will go with Bulk Loading because of this it happens once a week: Data from the Sensor Data collection will automatically be loaded into the Planning Assistance database once a week by using Azure Data Factory. You must be able to manually trigger the data load process.
upvoted 3 times
...
Az301301X
4 years, 4 months ago
it is Query for the first one. check this: https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-cosmos-db#azure-cosmos-db-sql-api-as-source
upvoted 2 times
...
ThijsN
4 years, 4 months ago
I can't find the adf "Cosmos Bulk Loading" anywhere. There is a bulk loading option for loading data INTO cosmos but i can't find the otherway anywhere
upvoted 3 times
...
mohowzeh
4 years, 4 months ago
Second box = SQLSink Table First box: since sensor data are coming in pretty much like a stream, a change feed would be a good solution. If Cosmos query is used, how would you deal with the fact that the endpoint of the data moves every few seconds? https://devblogs.microsoft.com/cosmosdb/change-feed-unsung-hero-of-azure-cosmos-db/
upvoted 4 times
...
S3
4 years, 5 months ago
So is it Cosmos Bulk loading or cosmos query?
upvoted 2 times
...
groy
4 years, 8 months ago
Box1: Cosmos query Box2: SQLSink Table
upvoted 7 times
...
avix
4 years, 9 months ago
Why not cosmos change feed for box 1?
upvoted 2 times
User27069
4 years, 7 months ago
Sensor data has a time stamp in it, and as it is only inserts, this time stamp will not change. So I guess you could use it, but a regular query would be enough. So my guess for box 1 is Cosmos query.
upvoted 2 times
...
...
LeonLeon
4 years, 10 months ago
Sensor data from Cosmos DB > ADF is juist a Source or a Sink (table) so the left answer is correct https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview
upvoted 3 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 ...