ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam
Go to Exam

Exam DP-200 topic 17 question 1 discussion

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

What should you include in the Data Factory pipeline for Race Central?

  • A. a copy activity that uses a stored procedure as a source
  • B. a copy activity that contains schema mappings
  • C. a delete activity that has logging enabled
  • D. a filter activity that has a condition
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Scenario:
An Azure Data Factory pipeline must be used to move data from Cosmos DB to SQL Database for Race Central. If the data load takes longer than 20 minutes, configuration changes must be made to Data Factory.
The telemetry data is sent to a MongoDB database. A custom application then moves the data to databases in SQL Server 2017. The telemetry data in MongoDB has more than 500 attributes. The application changes the attribute names when the data is moved to SQL Server 2017.
You can copy data to or from Azure Cosmos DB (SQL API) by using Azure Data Factory pipeline.
Column mapping applies when copying data from source to sink. By default, copy activity map source data to sink by column names. You can specify explicit mapping to customize the column mapping based on your need. More specifically, copy activity:
Read the data from source and determine the source schema
1. Use default column mapping to map columns by name, or apply explicit column mapping if specified.
2. Write the data to sink
3. Write the data to sink
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-schema-and-type-mapping
by syu31svc at Nov. 27, 2020, 2:53 p.m.

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
Submit Cancel
syu31svc
Highly Voted 4 years, 6 months ago
There is no copy activity that uses a stored procedure delete and filter don't make sense Answer is B
upvoted 10 times
maciejt
4 years ago
Copy activity can use query as a source, you can query a function, which can be understood as a procedure
upvoted 1 times
...
...
JGECM
Most Recent 4 years, 5 months ago
Yes, answer is B
upvoted 2 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