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: Nov 11, 2025

Add To Cart

Question 1

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

Question 2

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 3

Which command-line tool can you use to query Azure SQL databases?

A : sqlcmd

B : bcp

C : azdata

D : Azure CLI

Answer: A

Question 4

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 5

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

Page: 1 / 62

Total 309 Questions | Updated On: Nov 11, 2025

Add To Cart