Free Microsoft DP-900 Exam Questions

Become Microsoft Certified with updated DP-900 exam questions and correct answers

Page: 1 / 62

Total 309 Questions | Updated On: Feb 21, 2026

Add To Cart

Question 1

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

Of which type of solution is this is an example?

A : extract transform, and load (ETL)

B : a data warehouse

C : online analytical processing (OLAP)

D : online transaction processing (OLTP)

Answer: D

Question 2

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

A : report and dashboard creation

B : report sharing and distribution

C : data modeling

D : data acquisition and preparation

Answer: A,D

Question 3

Your company is designing a database that will contain session data for a website. The data will include

notifications, personalization attributes, and products that are added to a shopping cart.

Which type of data store will provide the lowest latency to retrieve the data?

A : key/value

B : graph

C : columnar

D : document

Answer: C

Question 4

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

A : native support for cross-database queries and transactions

B : built-in high availability

C : system-Initiated automatic backups

D : support for encryption at rest

Answer: A

Question 5

What is required to provision Azure Data Lake Storage in an Azure Storage account?

A : Versioning must be enabled.

B : Hierarchical namespace must be enabled

C : Hierarchical namespace must be disabled

D : Versioning must be disabled

Answer: B

Page: 1 / 62

Total 309 Questions | Updated On: Feb 21, 2026

Add To Cart