DP-203
Data Engineering on Microsoft Azure
EXAM READINESS GUIDE
Q&S
©2024/2025
,1. What Azure service would you use for large-scale,
parallel data processing that requires low-latency data
access?
a) Azure SQL Database
b) Azure Table Storage
c) Azure Blob Storage
d) Azure Data Lake Storage
Answer: d) Azure Data Lake Storage
2. In the context of Azure Cosmos DB, what does the term
"multi-model database" refer to?
a) A database that supports multiple programming models
b) A database that supports multiple consistency models
c) A database that supports multiple data models
d) A database that supports multiple deployment models
Answer: c) A database that supports multiple data
models
3. Which Azure service is a fully managed, scalable, and
secure data warehouse that leverages Massively Parallel
Processing (MPP) to quickly run complex queries over
petabytes of data?
a) Azure SQL Database
b) Azure Synapse Analytics
c) Azure Cosmos DB
d) Azure HDInsight
Answer: b) Azure Synapse Analytics
4. When designing a solution for streaming data in Azure,
which service provides real-time analytics and complex
©2024/2025
, event-processing capabilities?
a) Azure Event Hubs
b) Azure Stream Analytics
c) Azure Data Factory
d) Azure Machine Learning
Answer: b) Azure Stream Analytics
5. In Azure Data Factory, what is the purpose of a pipeline?
a) To manage virtual networks
b) To automate data movement and transformation
c) To provide a data storage solution
d) To monitor service health
Answer: b) To automate data movement and
transformation
6. Which of the following is a benefit of using Azure Blob
Storage for data storage?
a) Support for relational data structures
b) High availability and disaster recovery
c) Automatic data archiving
d) Built-in machine learning capabilities
Answer: b) High availability and disaster recovery
7. What type of storage should be used when you need to
store NoSQL data with schema-less design in Azure?
a) Azure SQL Database
b) Azure Blob Storage
c) Azure Table Storage
d) Azure Queue Storage
Answer: c) Azure Table Storage
8. Which Azure service is best suited for batch processing
of data at regular intervals?
©2024/2025
Data Engineering on Microsoft Azure
EXAM READINESS GUIDE
Q&S
©2024/2025
,1. What Azure service would you use for large-scale,
parallel data processing that requires low-latency data
access?
a) Azure SQL Database
b) Azure Table Storage
c) Azure Blob Storage
d) Azure Data Lake Storage
Answer: d) Azure Data Lake Storage
2. In the context of Azure Cosmos DB, what does the term
"multi-model database" refer to?
a) A database that supports multiple programming models
b) A database that supports multiple consistency models
c) A database that supports multiple data models
d) A database that supports multiple deployment models
Answer: c) A database that supports multiple data
models
3. Which Azure service is a fully managed, scalable, and
secure data warehouse that leverages Massively Parallel
Processing (MPP) to quickly run complex queries over
petabytes of data?
a) Azure SQL Database
b) Azure Synapse Analytics
c) Azure Cosmos DB
d) Azure HDInsight
Answer: b) Azure Synapse Analytics
4. When designing a solution for streaming data in Azure,
which service provides real-time analytics and complex
©2024/2025
, event-processing capabilities?
a) Azure Event Hubs
b) Azure Stream Analytics
c) Azure Data Factory
d) Azure Machine Learning
Answer: b) Azure Stream Analytics
5. In Azure Data Factory, what is the purpose of a pipeline?
a) To manage virtual networks
b) To automate data movement and transformation
c) To provide a data storage solution
d) To monitor service health
Answer: b) To automate data movement and
transformation
6. Which of the following is a benefit of using Azure Blob
Storage for data storage?
a) Support for relational data structures
b) High availability and disaster recovery
c) Automatic data archiving
d) Built-in machine learning capabilities
Answer: b) High availability and disaster recovery
7. What type of storage should be used when you need to
store NoSQL data with schema-less design in Azure?
a) Azure SQL Database
b) Azure Blob Storage
c) Azure Table Storage
d) Azure Queue Storage
Answer: c) Azure Table Storage
8. Which Azure service is best suited for batch processing
of data at regular intervals?
©2024/2025
