exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 145 discussion

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

DRAG DROP -
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Data movement -

Box 2: Data transformation -
A pipeline could contain a set of activities that ingest and clean log data, and then kick off a mapping data flow to analyze the log data.

Box 3: Control -
Lookup Activity is a control flow activity.
Lookup Activity can be used to read or look up a record/ table name/ value from any external source. This output can further be referenced by succeeding activities.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation-activities

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
Mjwc
Highly Voted 3 years ago
Correct: Movement Transformation Control https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities
upvoted 18 times
...
OrangeSG
Highly Voted 1 year, 10 months ago
Box 1: Movement Data movement activities: Copy Activity in Data Factory copies data from a source data store to a sink data store. Data from any source can be written to any sink. Box 2: Transformation Mapping data flows are visually designed data transformations in Azure Data Factory. Data flows allow data engineers to develop data transformation logic without writing code. The resulting data flows are executed as activities within Azure Data Factory pipelines that use scaled-out Apache Spark clusters. Box 3: Control Lookup Activity is a control flow activity. Lookup Activity can be used to read or look up a record/ table name/ value from any external source. This output can further be referenced by succeeding activities. Reference Pipelines and activities in Azure Data Factory and Azure Synapse Analytics https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities Mapping data flows in Azure Data Factory https://learn.microsoft.com/en-us/azure/data-factory/concepts-data-flow-overview
upvoted 10 times
...
AGTraining
Most Recent 8 months ago
Movement Transformation Control
upvoted 1 times
...
[Removed]
1 year, 10 months ago
For those who are interested, an easy explanation why 'mapping data flows' is 'transformation': "In October 2018 Microsoft launched mapping data flows which allows ADF to also perform code-free transformations such as joining, splitting or aggregating the data. "
upvoted 6 times
...
wellingtonluis
3 years ago
https://docs.microsoft.com/en-us/azure/data-factory/data-flow-transformation-overview
upvoted 2 times
...
wellingtonluis
3 years ago
Lookup also is Transformation. This question require many atention. https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity
upvoted 2 times
kleranti
2 years, 10 months ago
Lookup main category is - Control flow, so ans is correct
upvoted 4 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago