Microsoft DP-900 Exam Practice Test Instant Access

Question 1

What can you use to create data ingestion pipelines?

AAzure HDInsight

BAzure SQL Database

CAzure Data Factory

DAzure Cosmos DB

Answer : C

Question 2

Question: 298

You have data in a tabular format as shown in the following table.

Of which type of data is this an example?

Aunstructured data

Bsemi-structured data

Cdocument

Dstructured data

Answer : D

Question 3

Which three services support Apache Spark? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

AAzure Data Explorer

BAzure Synapse Analytics

CAzure Databricks

DAzure Stream Analytics

EAzure HDInsight

Answer : A, B, C

Question 4

What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?

Aa few milliseconds

Ba few seconds

Ca few minutes

Da few hours

Answer : A

Question 5

How is raw data stored in a data lakehoose?

Aas tables

Bas queues

Cas files

Das disks

Answer : B

Question 6

What is the primary purpose of a data warehouse?

Ato provide answers to complex queries that rely on data from multiple sources

Bto provide transformation services between source and target data stores

Cto provide read-only storage of relational and non-relational historical data

Dto provide storage for transactional line-of-business (LOB) applications

Answer : C

Consider using a data warehouse when you need to keep historical data separate from the source transaction systems for performance reasons. Data warehouses make it easy to access historical data from multiple locations, by providing a centralized location using common formats, keys, and data models.

Query both relational and nonrelational data.

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing

Question 7

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.

Which type of data store should you use?

Agraph

Bkey/value

Cdocument

Dcolumnar

Answer : A

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

Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test