D427 ITEC 2117 Data Management Applications
Final Assessment Review (Qns & Ans)
2025
Multiple Choice Questions
Which AWS service is primarily used for storing and retrieving
structured data?
A) Amazon S3
B) Amazon RDS
C) Amazon DynamoDB
D) AWS Lambda ANS: B) Amazon RDS Rationale: Amazon
RDS is designed to manage structured data in relational database
systems.
©2025
,What is the purpose of AWS Glue?
A) Data storage
B) Data backup
C) Data cataloging and ETL
D) Real-time data processing ANS: C) Data cataloging and ETL
Rationale: AWS Glue provides capabilities for data cataloging
and ETL (Extract, Transform, Load) processes.
Which of the following AWS services can be used for serverless
data processing?
A) Amazon EC2
B) AWS Lambda
C) Amazon Redshift
D) Amazon S3 ANS: B) AWS Lambda Rationale: AWS Lambda
allows code to run in response to events without managing
servers.
In which AWS storage solution is data stored in a flat,
hierarchical structure?
A) Amazon RDS
B) Amazon S3
©2025
,C) Amazon EFS
D) Amazon Glacier ANS: B) Amazon S3 Rationale: Amazon S3
organizes data in a flat, hierarchical structure with buckets and
objects.
Which AWS service provides a managed NoSQL database?
A) Amazon Aurora
B) Amazon Redshift
C) Amazon DynamoDB
D) Amazon DocumentDB ANS: C) Amazon DynamoDB
Rationale: DynamoDB is a fully managed NoSQL database
service that supports key-value and document data structures.
Fill-in-the-Blank Questions
In AWS, __________ is a fully managed data warehousing
service that enables analytics on large datasets.
ANS: Amazon Redshift
Rationale: Amazon Redshift is specifically designed for analyzing
large datasets efficiently.
The __________ service allows you to execute SQL queries
directly on data stored in S3 without the need for data loading.
ANS: Amazon Athena
©2025
, Rationale: Amazon Athena is an interactive query service that
makes it easy to analyze data in S3 using standard SQL.
AWS __________ is a service that automatically scales a
database server based on the demand for the application.
ANS: Aurora Serverless
Rationale: Aurora Serverless can automatically adjust capacity
based on application needs.
AWS __________ is a fully managed graph database service.
ANS: Amazon Neptune
Rationale: Amazon Neptune is designed to handle graph data
models and supports both property graph and RDF graph models.
Amazon __________ enables users to create and manage data
lakes on AWS.
ANS: AWS Lake Formation
Rationale: AWS Lake Formation simplifies the process of setting
up data lakes, helping with data ingestion and access control.
True/False Questions
True or False: Amazon S3 can only store unstructured data.
©2025
Final Assessment Review (Qns & Ans)
2025
Multiple Choice Questions
Which AWS service is primarily used for storing and retrieving
structured data?
A) Amazon S3
B) Amazon RDS
C) Amazon DynamoDB
D) AWS Lambda ANS: B) Amazon RDS Rationale: Amazon
RDS is designed to manage structured data in relational database
systems.
©2025
,What is the purpose of AWS Glue?
A) Data storage
B) Data backup
C) Data cataloging and ETL
D) Real-time data processing ANS: C) Data cataloging and ETL
Rationale: AWS Glue provides capabilities for data cataloging
and ETL (Extract, Transform, Load) processes.
Which of the following AWS services can be used for serverless
data processing?
A) Amazon EC2
B) AWS Lambda
C) Amazon Redshift
D) Amazon S3 ANS: B) AWS Lambda Rationale: AWS Lambda
allows code to run in response to events without managing
servers.
In which AWS storage solution is data stored in a flat,
hierarchical structure?
A) Amazon RDS
B) Amazon S3
©2025
,C) Amazon EFS
D) Amazon Glacier ANS: B) Amazon S3 Rationale: Amazon S3
organizes data in a flat, hierarchical structure with buckets and
objects.
Which AWS service provides a managed NoSQL database?
A) Amazon Aurora
B) Amazon Redshift
C) Amazon DynamoDB
D) Amazon DocumentDB ANS: C) Amazon DynamoDB
Rationale: DynamoDB is a fully managed NoSQL database
service that supports key-value and document data structures.
Fill-in-the-Blank Questions
In AWS, __________ is a fully managed data warehousing
service that enables analytics on large datasets.
ANS: Amazon Redshift
Rationale: Amazon Redshift is specifically designed for analyzing
large datasets efficiently.
The __________ service allows you to execute SQL queries
directly on data stored in S3 without the need for data loading.
ANS: Amazon Athena
©2025
, Rationale: Amazon Athena is an interactive query service that
makes it easy to analyze data in S3 using standard SQL.
AWS __________ is a service that automatically scales a
database server based on the demand for the application.
ANS: Aurora Serverless
Rationale: Aurora Serverless can automatically adjust capacity
based on application needs.
AWS __________ is a fully managed graph database service.
ANS: Amazon Neptune
Rationale: Amazon Neptune is designed to handle graph data
models and supports both property graph and RDF graph models.
Amazon __________ enables users to create and manage data
lakes on AWS.
ANS: AWS Lake Formation
Rationale: AWS Lake Formation simplifies the process of setting
up data lakes, helping with data ingestion and access control.
True/False Questions
True or False: Amazon S3 can only store unstructured data.
©2025
