Free Microsoft DP-900 Exam Actual Questions

The questions for DP-900 were last updated On Dec 19, 2024

Question No. 1

Which language is used to define queries in Azure Synapse Data Explorer?

Show Answer Hide Answer
Correct Answer: C

Question No. 2

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

Show Answer Hide Answer
Correct Answer: B

Question No. 3

You have data saved in the following format.

Which format was used?

Show Answer Hide Answer
Correct Answer: A

Question No. 4

Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.

Which type of data store should you use?

Show Answer Hide Answer
Correct Answer: B

Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.

A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB's Gremlin API supports the property graph model.


https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases

Question No. 5

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

Show Answer Hide Answer
Correct Answer: A