DP-900 pt 2

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

a

b

c

relationships between employees

images files

key/value pairs

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

a

b

Azure Storage Account

file share

container

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

Pipeline

Dateset

Linked service

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

data warehouse

the CRM system

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