Free Microsoft DP-900 Exam Actual Questions

The questions for DP-900 were last updated On May 2, 2024

Question No. 1

In a fully denormalized database, how is data read and written for a single entity?

Show Answer Hide Answer
Correct Answer: B

Question No. 2

You have a SQL query that combines customer data and order dat

a. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

Show Answer Hide Answer
Correct Answer: D

Question No. 3

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

Show Answer Hide Answer
Correct Answer: C

Question No. 4

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Show Answer Hide Answer
Correct Answer: D

Question No. 5

Which Azure Storage service implements the key/value model?

Show Answer Hide Answer
Correct Answer: B