DP-900 pt 2

Match the types of data to the appropriate Azure data services.

a

b

c

images files

relationships between employees

key/value pairs

Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy.

a

b

file share

container

Azure Storage Account

What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• Data is processed periodically

• High latency is acceptable

• Low latency is expected

• Data is processed as it is created

Match the Azure Data Factory components to the appropriate descriptions.

a

b

c

Mapping data flow

Linked service

Pipeline

Dateset

Match the types of workloads to the appropriate scenarios.

a

b

c

BATCH

Streaming

Batch

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location 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.

a

b

c

the data warehouse

the CRM system

data warehouse

Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?

• predictive

• prescriptive

• descriptive

• diagnostic

Which statement is an example of Data Manipulation Language (DML)?

• REVOKE

• DISABLE

• CREATE

• UPDATE

Creating closed caption text for audio files is an example of ​ (a)   analytics

• descriptive
• cognitive
• predictive
• prescriptive

A visualization that illustrates a university's current student enrollment per department is an example of ​ (a)   analytics

• descriptive
• cognitive
• predictive
• prescriptive