Azure Data Fundamentals (DP-900) Microsoft Exam Info and Free Practice Test

Azure Data Fundamentals (DP-900)

1 / 19

Which type of database is ideal for managing hierarchical relationships?

Relational database

Graph database

Key-value database

NoSQL database

2 / 19

What is the purpose of a partition key in a NoSQL database?

To encrypt data

To distribute data across partitions

To ensure schema compliance

To provide high consistency

3 / 19

Which database system uses tables, rows, and columns?

Relational database

NoSQL database

Key-value store

Graph database

4 / 19

What is a key characteristic of structured data?

Fixed schema

No predefined schema

Highly variable formats

Limited query capabilities

5 / 19

Which Azure service is best suited for integrating data from multiple sources?

Azure Data Factory

Azure Blob Storage

Azure Kubernetes Service

Azure Functions

6 / 19

What is the purpose of Azure Event Hubs?

Stream real-time data

Host relational databases

Create workflows

Secure application access

7 / 19

Which Azure service is used to implement data pipelines?

Azure Synapse Analytics

Azure Data Factory

Azure Cosmos DB

Azure Monitor

8 / 19

What is a benefit of using a NoSQL database?

High data consistency

Flexible schema support

Limited scalability

Complex query optimization

9 / 19

Which component is central to the Extract, Transform, Load (ETL) process?

Azure Logic Apps

Data integration tools

Virtual machines

Azure Key Vault

10 / 19

Which component is central to the Extract, Transform, Load (ETL) process?

Azure Logic Apps

Data integration tools

Virtual machines

Azure Key Vault

11 / 19

What is the role of Azure Data Lake Storage?

Hosting relational databases

Storing large-scale unstructured data

Monitoring application performance

Managing containerized apps

12 / 19

Which Azure service enables the movement and transformation of data?

Azure Data Factory

Azure SQL Database

Azure Event Hubs

Azure DevOps

13 / 19

What type of data is typically stored in a data lake?

Structured only

Unstructured, semi-structured, and structured

Unstructured only

Metadata only

14 / 19

Which Azure service is designed for real-time analytics on fast-moving data?

Azure Data Factory

Azure Stream Analytics

Azure SQL Database

Azure Logic Apps

15 / 19

What is the main use case for Azure Synapse Analytics?

Web application hosting

Big data analytics

Real-time monitoring

Secure file storage

16 / 19

Which Azure service provides a globally distributed NoSQL database?

Azure SQL Database

Azure Cosmos DB

Azure Synapse Analytics

Azure Data Lake

17 / 19

What is the primary feature of a NoSQL database?

Support for fixed schemas

Support for flexible schemas

Limited data scalability

Strict data consistency

18 / 19

Which Azure service is a relational database offering?

Azure Blob Storage

Azure SQL Database

Azure Data Factory

Azure Cosmos DB

19 / 19

What is the primary purpose of a relational database?

Storing structured data

Storing unstructured data

Processing real-time streams

Managing virtual machines

Your score is

The average score is 0%