Microsoft Azure Data Fundamentals
(DP-900) Exam Questions And Correct
Answers (Verified Answers) Plus
Rationales 2026 Q&A | Instant
Download Pdf
Question 1
Which type of data is best represented in tables with rows and columns?
A. Semi-structured data
B. Unstructured data
C. Structured data
D. Binary data
Answer: C. Structured data
Structured data is organized into a predefined schema using rows and columns,
typically stored in relational databases. This format allows efficient querying
using SQL and is ideal for transactional systems and reporting.
Question 2
Which Azure service is a fully managed relational database?
A. Azure Blob Storage
B. Azure SQL Database
C. Azure Data Lake Storage
D. Azure Cosmos DB
Answer: B. Azure SQL Database
Azure SQL Database is a fully managed Platform-as-a-Service (PaaS) relational
,database that handles patching, backups, and scaling, making it ideal for OLTP
applications.
Question 3
What type of data store is Azure Cosmos DB primarily considered?
A. Relational database
B. Object storage
C. NoSQL database
D. Data warehouse
Answer: C. NoSQL database
Azure Cosmos DB is a globally distributed NoSQL database supporting multiple
models such as document, key-value, graph, and column-family data.
Question 4
Which language is commonly used to query relational databases?
A. Python
B. HTML
C. SQL
D. JSON
Answer: C. SQL
SQL (Structured Query Language) is the standard language used to query, insert,
update, and delete data in relational database systems.
Question 5
Which Azure service is best suited for big data analytics and data lake storage?
A. Azure Data Lake Storage Gen2
B. Azure SQL Managed Instance
,C. Azure Table Storage
D. Azure App Service
Answer: A. Azure Data Lake Storage Gen2
Azure Data Lake Storage Gen2 is optimized for large-scale analytics workloads
and supports hierarchical namespace for big data processing.
Question 6
What is a key characteristic of unstructured data?
A. It has a fixed schema
B. It is stored in tables
C. It has no predefined format
D. It is always numeric
Answer: C. It has no predefined format
Unstructured data includes formats such as videos, images, and text files that do
not conform to a structured schema.
Question 7
Which workload is best suited for transactional processing?
A. OLAP
B. OLTP
C. Data mining
D. Machine learning
Answer: B. OLTP
Online Transaction Processing (OLTP) systems handle real-time transactional
workloads such as banking and order processing.
Question 8
, Which Azure service is used for real-time analytics on streaming data?
A. Azure Stream Analytics
B. Azure Data Factory
C. Azure SQL Database
D. Azure DevTest Labs
Answer: A. Azure Stream Analytics
Azure Stream Analytics processes real-time data streams from sources like IoT
devices and event hubs.
Question 9
What is a data warehouse primarily used for?
A. Real-time transaction processing
B. Storing raw files
C. Analytical reporting and BI
D. Hosting web applications
Answer: C. Analytical reporting and BI
Data warehouses are optimized for querying and analyzing large historical
datasets for business intelligence.
Question 10
Which Azure service is a NoSQL key-value store?
A. Azure SQL Database
B. Azure Table Storage
C. Azure Synapse Analytics
D. Azure Database for PostgreSQL
Answer: B. Azure Table Storage
Azure Table Storage is a NoSQL key-value store designed for fast and scalable
access to structured NoSQL data.
(DP-900) Exam Questions And Correct
Answers (Verified Answers) Plus
Rationales 2026 Q&A | Instant
Download Pdf
Question 1
Which type of data is best represented in tables with rows and columns?
A. Semi-structured data
B. Unstructured data
C. Structured data
D. Binary data
Answer: C. Structured data
Structured data is organized into a predefined schema using rows and columns,
typically stored in relational databases. This format allows efficient querying
using SQL and is ideal for transactional systems and reporting.
Question 2
Which Azure service is a fully managed relational database?
A. Azure Blob Storage
B. Azure SQL Database
C. Azure Data Lake Storage
D. Azure Cosmos DB
Answer: B. Azure SQL Database
Azure SQL Database is a fully managed Platform-as-a-Service (PaaS) relational
,database that handles patching, backups, and scaling, making it ideal for OLTP
applications.
Question 3
What type of data store is Azure Cosmos DB primarily considered?
A. Relational database
B. Object storage
C. NoSQL database
D. Data warehouse
Answer: C. NoSQL database
Azure Cosmos DB is a globally distributed NoSQL database supporting multiple
models such as document, key-value, graph, and column-family data.
Question 4
Which language is commonly used to query relational databases?
A. Python
B. HTML
C. SQL
D. JSON
Answer: C. SQL
SQL (Structured Query Language) is the standard language used to query, insert,
update, and delete data in relational database systems.
Question 5
Which Azure service is best suited for big data analytics and data lake storage?
A. Azure Data Lake Storage Gen2
B. Azure SQL Managed Instance
,C. Azure Table Storage
D. Azure App Service
Answer: A. Azure Data Lake Storage Gen2
Azure Data Lake Storage Gen2 is optimized for large-scale analytics workloads
and supports hierarchical namespace for big data processing.
Question 6
What is a key characteristic of unstructured data?
A. It has a fixed schema
B. It is stored in tables
C. It has no predefined format
D. It is always numeric
Answer: C. It has no predefined format
Unstructured data includes formats such as videos, images, and text files that do
not conform to a structured schema.
Question 7
Which workload is best suited for transactional processing?
A. OLAP
B. OLTP
C. Data mining
D. Machine learning
Answer: B. OLTP
Online Transaction Processing (OLTP) systems handle real-time transactional
workloads such as banking and order processing.
Question 8
, Which Azure service is used for real-time analytics on streaming data?
A. Azure Stream Analytics
B. Azure Data Factory
C. Azure SQL Database
D. Azure DevTest Labs
Answer: A. Azure Stream Analytics
Azure Stream Analytics processes real-time data streams from sources like IoT
devices and event hubs.
Question 9
What is a data warehouse primarily used for?
A. Real-time transaction processing
B. Storing raw files
C. Analytical reporting and BI
D. Hosting web applications
Answer: C. Analytical reporting and BI
Data warehouses are optimized for querying and analyzing large historical
datasets for business intelligence.
Question 10
Which Azure service is a NoSQL key-value store?
A. Azure SQL Database
B. Azure Table Storage
C. Azure Synapse Analytics
D. Azure Database for PostgreSQL
Answer: B. Azure Table Storage
Azure Table Storage is a NoSQL key-value store designed for fast and scalable
access to structured NoSQL data.
