Welcome to the third part of our series on DP-900 exam dumps! In the previous posts, we reviewed a wide variety of sample questions and answers and assessed their relevance to the actual exam. If you haven’t checked out those posts yet, please refer to the following links below. Now, as we move into the third series, we’ll continue to explore the available exam dumps and identify key insights and trends that can help you prepare for your upcoming DP-900 certification exam. Let’s dive in!
Question # 21
DRAG DROP
Match the types of data to the appropriate Azure data services. To answer, drag the appropriate data type from the column on the left to its service on the right.
Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

- Image files
- Relationships between employees
- Key/value pairs
Question # 22
DRAG DROP
Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right.
Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

- Azure Storage account
- Container
Box 1: Azure Storage account – Azure file shares are deployed into storage accounts, which are top-level objects that represent a shared pool of storage.
Box 2: Container
Question # 23
What are the two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct match is worth one point.

B – Low latency is expected
D – Data is processed as it is created
Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses.
Question # 24
DRAG DROP
Match the Azure Data Factory components to the appropriate descriptions. To answer, drag the appropriate component from the column on the left to its description on the right.
Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

- Dataset
- Linked service
- Pipeline
Question # 25
DRAG DROP
Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right.
Each workload may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

- Batch
- Streaming
- Batch
Box 1: Batch processing refers to the processing of blocks of data that have already been stored over a period of time.
Box 2: Stream processing is a big data technology that allows us to process data in real-time as they arrive.
Question # 26

B. Relational
Relational databases store structured data in tables. Records in separate tables are related to each other using keys, which are columns storing unique values per table row.
Question # 27
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.

A. Predictive

Question # 28

D. Update
Data Manipulation Language (DML) affects the information stored in the database. Use these statements to insert, update, and change the rows in the database.
BULK INSERT
DELETE
INSERT
SELECT
UPDATE
MERGE
Question # 29
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

Cognitive
This is a recognizing. Closed captions are the text versions of the spoken part of a television, movie, or computer presentation. It’s created for deaf people especially, it’s cognitive because it is doing something on its own.
Question # 30
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

Descriptive
Generally speaking, data analytics comes in four types:
- Descriptive – to answer the question: What’s happening?
- Diagnostic – to answer the question: Why’s happening?
- Predictive – to answer the question: What will happen?
- Prescriptive – to answer the question: What actions should we take?