MS Azure D330 DBMG 3380 Data Systems
Administration
Objective Assessment Review (Qns & Ans)
2025
Multiple Choice Questions
Which Azure service is best suited for real-time analytics on
streaming data?
A) Azure Cosmos DB
B) Azure Data Lake Storage
C) Azure Stream Analytics
D) Azure SQL Database
Correct ANS: C) Azure Stream Analytics
©2025
,Rationale: Azure Stream Analytics is designed specifically for
processing and analyzing real-time data streams.
What is the primary purpose of Azure SQL Database's Geo-
Replication?
A) Backup of data
B) Load balancing
C) Disaster recovery and high availability
D) Data transformation
Correct ANS: C) Disaster recovery and high availability
Rationale: Geo-Replication enables databases to be replicated to
different regions, thus ensuring data availability during outages.
Which Azure service provides the ability to manage and monitor
SQL Server databases both on-premises and in the cloud?
A) Azure Database Migration Service
B) Azure Monitor
C) Azure SQL Database Managed Instance
D) Azure Data Factory
Correct ANS: C) Azure SQL Database Managed Instance
Rationale: Managed Instance offers a fully managed SQL Server
environment that integrates seamlessly with Azure services.
©2025
,Which of the following Azure services is best for storing large
amounts of unstructured data?
A) Azure Blob Storage
B) Azure SQL Database
C) Azure Table Storage
D) Azure Queues
Correct ANS: A) Azure Blob Storage
Rationale: Blob Storage is optimized for large, unstructured data,
making it an ideal choice for such requirements.
In Azure Data Factory, what does a pipeline represent?
A) A data integration model
B) A collection of activities
C) A data storage solution
D) A monitoring tool
Correct ANS: B) A collection of activities
Rationale: A pipeline in Azure Data Factory is a logical grouping
of activities that together perform a task.
Fill-in-the-Blank Questions
Azure HDInsight is primarily used for processing __________ big
data frameworks.
©2025
, Correct ANS: Apache
Rationale: HDInsight supports various Apache projects for big
data processing, including Hadoop and Spark.
The __________ service in Azure allows for the creation of
relational databases with built-in intelligence.
Correct ANS: Azure SQL Database
Rationale: Azure SQL Database is a fully managed relational
database that includes features like machine learning for
performance optimization.
To improve security, Azure provides a feature known as
__________, allowing you to restrict access to your resources.
Correct ANS: Role-Based Access Control (RBAC)
Rationale: RBAC enables precise control over user permissions,
enhancing security for Azure resources.
The Azure service __________ enables seamless integration
between different Azure services and on-premises applications.
Correct ANS: Azure Logic Apps
Rationale: Logic Apps provide enterprise integration capabilities
that automate workflows between various services.
©2025
Administration
Objective Assessment Review (Qns & Ans)
2025
Multiple Choice Questions
Which Azure service is best suited for real-time analytics on
streaming data?
A) Azure Cosmos DB
B) Azure Data Lake Storage
C) Azure Stream Analytics
D) Azure SQL Database
Correct ANS: C) Azure Stream Analytics
©2025
,Rationale: Azure Stream Analytics is designed specifically for
processing and analyzing real-time data streams.
What is the primary purpose of Azure SQL Database's Geo-
Replication?
A) Backup of data
B) Load balancing
C) Disaster recovery and high availability
D) Data transformation
Correct ANS: C) Disaster recovery and high availability
Rationale: Geo-Replication enables databases to be replicated to
different regions, thus ensuring data availability during outages.
Which Azure service provides the ability to manage and monitor
SQL Server databases both on-premises and in the cloud?
A) Azure Database Migration Service
B) Azure Monitor
C) Azure SQL Database Managed Instance
D) Azure Data Factory
Correct ANS: C) Azure SQL Database Managed Instance
Rationale: Managed Instance offers a fully managed SQL Server
environment that integrates seamlessly with Azure services.
©2025
,Which of the following Azure services is best for storing large
amounts of unstructured data?
A) Azure Blob Storage
B) Azure SQL Database
C) Azure Table Storage
D) Azure Queues
Correct ANS: A) Azure Blob Storage
Rationale: Blob Storage is optimized for large, unstructured data,
making it an ideal choice for such requirements.
In Azure Data Factory, what does a pipeline represent?
A) A data integration model
B) A collection of activities
C) A data storage solution
D) A monitoring tool
Correct ANS: B) A collection of activities
Rationale: A pipeline in Azure Data Factory is a logical grouping
of activities that together perform a task.
Fill-in-the-Blank Questions
Azure HDInsight is primarily used for processing __________ big
data frameworks.
©2025
, Correct ANS: Apache
Rationale: HDInsight supports various Apache projects for big
data processing, including Hadoop and Spark.
The __________ service in Azure allows for the creation of
relational databases with built-in intelligence.
Correct ANS: Azure SQL Database
Rationale: Azure SQL Database is a fully managed relational
database that includes features like machine learning for
performance optimization.
To improve security, Azure provides a feature known as
__________, allowing you to restrict access to your resources.
Correct ANS: Role-Based Access Control (RBAC)
Rationale: RBAC enables precise control over user permissions,
enhancing security for Azure resources.
The Azure service __________ enables seamless integration
between different Azure services and on-premises applications.
Correct ANS: Azure Logic Apps
Rationale: Logic Apps provide enterprise integration capabilities
that automate workflows between various services.
©2025
