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 17, 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

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 3

What should you use to build a Microsoft Power BI paginated report?

A : Power BI report Builder

B : Power BI Desktop

C : Charticulator

D : the Power BI service

Answer: A

Question 4

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

A : sqlcmd

B : bcp

C : azdata

D : Azure CLI

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 17, 2025

Add To Cart