Pre-Summer Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70track

Free Microsoft DP-900 Practice Exam with Questions & Answers | Set: 2

Questions 11

To complete the sentence, select the appropriate option in the answer area.

DP-900 Question 11

Options:
Microsoft DP-900 Premium Access
Questions 12

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

DP-900 Question 12

Options:
Questions 13

A data engineer is responsible for which task?

Options:
A.

Design and build analytical models.

B.

Design and implement data stores for analytical workloads.

C.

Explore data to identify trends.

D.

Implement policies, tools. and processes for backup and recovery plans.

Questions 14

To complete the sentence, select the appropriate option in the answer area.

DP-900 Question 14

Options:
Questions 15

Match the Azure Cosmos DB APIs to the appropriate data structures.

To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

DP-900 Question 15

Options:
Questions 16

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. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

DP-900 Question 16

Options:
Questions 17

What are two characteristics of real-time data processing? Each correct answer present a complete solution.

NOTE: Each correct selection is worth one point.

Options:
A.

Data is processed as it is created.

B.

Low latency is expected

C.

High latency acceptable

D.

Data is processed periodically

Questions 18

Which language is used to define queries in Azure Synapse Data Explorer?

Options:
A.

Bash

B.

PowerShell

C.

KQL

D.

SQL

Questions 19

Select the answer that correctly completes the sentence.

DP-900 Question 19

Options:
Questions 20

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

DP-900 Question 20

Options: