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: Oct 28, 2025

Add To Cart

Question 1

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 2

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

A : sqlcmd

B : bcp

C : azdata

D : Azure CLI

Answer: A

Question 3

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

A : extract transform, and load (ETL)

B : a data warehouse

C : online analytical processing (OLAP)

D : online transaction processing (OLTP)

Answer: D

Question 5

What can be used with native notebook support to query and visualize data by using a web-based interface?

A : Azure Databricks

B : pgAdmin

C : Microsoft Power Bl

Answer: A

Page: 1 / 62

Total 309 Questions | Updated On: Oct 28, 2025

Add To Cart