Weekend Special Sale 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale75best

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

Questions 11

Select the answer that correctly completes the sentence.

DP-900 Question 11

Options:
Microsoft DP-900 Premium Access
Questions 12

You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?

Options:
A.

Azure Cosmos

B.

Azure Table storage

C.

Azure Files

D.

Azure Blob storage

Questions 13

Match the datastore services to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

DP-900 Question 13

Options:
Questions 14

Select the answer that correctly completes the sentence.

DP-900 Question 14

Options:
Questions 15

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 type 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

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 17

You have an inventory management database that contains the following table.

DP-900 Question 17

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

Options:
A.

INSERT

B.

MERGE

C.

UPDATE

D.

CREATE

Questions 18

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 18

Options:
Questions 19

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

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: