QUESTION: 161

Which Azure Data Factory component initiates the execution of a pipeline?

a control flow
a trigger
a parameter
an activity

Answer(s): B

Reference:

https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution

Reveal Solution Next Question

QUESTION: 162

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.

Which type of processing does the reporting solution use?

stream processing
batch processing
Online Analytical Processing (OLAP)
Online Transaction Processing (OLTP)

Answer(s): C

Reference:

https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

Reveal Solution Next Question

DRAG DROP (Drag and Drop is not supported)
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.

See Explanation section for answer.

Answer(s): A

Explanation:

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

Reveal Solution Next Question

QUESTION: 164

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

denormalized data
heavy writes and moderate reads
light writes and heavy reads
schema on write
schema on read
normalized data

Answer(s): B,D,F

Explanation:

B: Transactional data tends to be heavy writes, moderate reads.
D: Typical traits of transactional data include: schema on write, strongly enforced
F: Transactional data tends to be highly normalized.

Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

Reveal Solution Next Question

Free DP-900 Exam Braindumps (page: 41)

QUESTION: 161

Reference:

QUESTION: 162

Reference:

QUESTION: 163

Explanation:

Reference:

QUESTION: 164

Explanation:

Reference: