Microsoft Certification Azure Data Fundamentals (DP-900)

Question 1

What type of data workload processes data in real-time as it continuously arrives?

Accepted Answer

Stream processing

Answer

Stream processing handles data in real-time as it arrives, unlike batch processing which accumulates data and processes it in groups.

Question 2

Which of the following is the best example of structured data?

Accepted Answer

Rows in a relational database table

Answer

Structured data is organized in a defined format with rows and columns, as found in relational database tables.

Question 3

What does ACID stand for in the context of database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID stands for Atomicity, Consistency, Isolation, and Durability — four properties that guarantee reliable processing of database transactions.

Question 4

Which Azure service provides a fully managed relational database based on the SQL Server engine?

Accepted Answer

Azure SQL Database

Answer

Azure SQL Database is a fully managed, Platform-as-a-Service relational database built on the SQL Server engine.

Question 5

What is the primary purpose of a data warehouse?

Accepted Answer

To store and analyze large volumes of historical data for reporting

Answer

A data warehouse is optimized for storing and analyzing large amounts of historical data to support business intelligence, analytics, and reporting.

Microsoft Certification Practice Test