DB-900 Exam Questions

DP-900 Practice Test 5

DP-900 Practice Test - Skilltestpro

1 / 10

Which Azure service would you use to ingest and analyze real-time data from millions of devices, such as temperature readings from sensors?

2 / 10

What is a "star schema" commonly used for in data warehousing?

3 / 10

Which Azure service is a fully managed, in-memory Apache Spark-based analytics service that focuses on fast data processing, machine learning, and data engineering?

4 / 10

You need to connect Power BI to an on-premises SQL Server database to refresh your reports. Which component is required to enable this secure connection?

5 / 10

What is the purpose of "schema-on-write" in database management?

6 / 10

Which common data workload prioritizes consistent and immediate processing of individual records, often with ACID (Atomicity, Consistency, Isolation, Durability) properties?

7 / 10

A Data Engineer needs to choose a storage solution for raw, unprocessed files in a data lake that supports hierarchical namespaces and fine-grained access control. Which Azure storage service is optimized for this?

8 / 10

Which Azure Cosmos DB feature allows applications to interact with the database using familiar MongoDB, Cassandra, or Gremlin APIs, even though the underlying database is Cosmos DB?

9 / 10

What is the common term for the process of extracting data from various sources, transforming it into a consistent format, and then loading it into a target data store for analysis?

10 / 10

Which Power BI capability allows users to create reports that can be printed or shared as a fixed-layout document, pixel-perfectly formatted?

Your score is

The average score is 67%

0%