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

Batch processing

Answer

Analytical processing

Answer

Transactional processing

Question 2

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

Accepted Answer

Rows in a relational database table

Answer

Social media posts

Answer

Audio recordings

Answer

PDF documents

Question 3

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

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Accuracy, Completeness, Integrity, Dependency

Answer

Atomicity, Correctness, Integration, Distribution

Answer

Availability, Consistency, Isolation, Data

Question 4

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

Accepted Answer

Azure SQL Database

Answer

Azure Cosmos DB

Answer

Azure Blob Storage

Answer

Azure Table Storage

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

To store real-time transactional data

Answer

To cache frequently accessed application data

Answer

To provide document storage for unstructured content

Question 6

Which of the following best describes a NoSQL database?

Accepted Answer

A non-relational database that stores unstructured or semi-structured data flexibly

Answer

A database that uses only structured query language

Answer

A database that enforces strict table schemas with foreign keys

Answer

A database that cannot handle large volumes of data

Question 7

What is a primary key in a relational database?

Accepted Answer

A unique identifier that distinguishes each row in a table

Answer

The first column defined in a table

Answer

The most frequently queried field in a record

Answer

A column that references a row in another table