CS – D326 DTMG 3179
Advanced Data Management
LATEST OBJECTIVE
ASSESSMENT REVIEW
Q&S
©2024/2025
,1. Multiple Choice: Which of the following is a key feature of a
NoSQL database?
a) Fixed schema
b) SQL compatibility
c) Scalability
d) Single data model
ANS: c) Scalability
Rationale: NoSQL databases are designed to provide high
scalability across many servers and flexibility in handling
different types of data models.
2. Fill-in-the-Blank: __________ is the process of ensuring that
data remains consistent and accurate across all nodes in a
distributed system.
ANS: Data replication
Rationale: Data replication is crucial in distributed systems to
ensure that all nodes have the same data, which is essential for
consistency and reliability.
3. True/False: In a relational database, data redundancy is
completely eliminated.
ANS: False
©2024/2025
, Rationale: While relational databases aim to minimize
redundancy through normalization, it's not always possible to
eliminate it completely without impacting performance.
4. Multiple Response: Select all that apply. Which of the
following are benefits of data warehousing?
a) Data consolidation from multiple sources
b) Real-time data analysis
c) Historical data analysis
d) Increased data input/output speed
ANSs: a) Data consolidation from multiple sources, c)
Historical data analysis
Rationale: Data warehousing allows for the consolidation of
data from various sources and enables historical data analysis.
Real-time analysis and increased I/O speed are not primary
functions of a data warehouse.
5. Multiple Choice: What is the primary purpose of using an ETL
tool in data management?
a) Data entry
b) Data transformation
c) Data visualization
d) Data archiving
©2024/2025
, ANS: b) Data transformation
Rationale: ETL (Extract, Transform, Load) tools are used to
extract data from various sources, transform it into a suitable
format, and load it into a destination database for analysis.
6. Fill-in-the-Blank: The __________ model is a database model
that is designed to handle large sets of structured, semi-structured,
and unstructured data.
ANS: Big Data
Rationale: The Big Data model accommodates a wide variety of
data types and is geared towards handling vast volumes of data.
7. True/False: Data mining is exclusively concerned with the
extraction of quantitative information.
ANS: False
Rationale: Data mining involves discovering patterns and
knowledge from large amounts of data, which can be both
quantitative and qualitative.
8. Multiple Response: Which of the following are types of
database normalization? Select all that apply.
a) First Normal Form (1NF)
b) Second Normal Form (2NF)
c) Third Normal Form (3NF)
©2024/2025
Advanced Data Management
LATEST OBJECTIVE
ASSESSMENT REVIEW
Q&S
©2024/2025
,1. Multiple Choice: Which of the following is a key feature of a
NoSQL database?
a) Fixed schema
b) SQL compatibility
c) Scalability
d) Single data model
ANS: c) Scalability
Rationale: NoSQL databases are designed to provide high
scalability across many servers and flexibility in handling
different types of data models.
2. Fill-in-the-Blank: __________ is the process of ensuring that
data remains consistent and accurate across all nodes in a
distributed system.
ANS: Data replication
Rationale: Data replication is crucial in distributed systems to
ensure that all nodes have the same data, which is essential for
consistency and reliability.
3. True/False: In a relational database, data redundancy is
completely eliminated.
ANS: False
©2024/2025
, Rationale: While relational databases aim to minimize
redundancy through normalization, it's not always possible to
eliminate it completely without impacting performance.
4. Multiple Response: Select all that apply. Which of the
following are benefits of data warehousing?
a) Data consolidation from multiple sources
b) Real-time data analysis
c) Historical data analysis
d) Increased data input/output speed
ANSs: a) Data consolidation from multiple sources, c)
Historical data analysis
Rationale: Data warehousing allows for the consolidation of
data from various sources and enables historical data analysis.
Real-time analysis and increased I/O speed are not primary
functions of a data warehouse.
5. Multiple Choice: What is the primary purpose of using an ETL
tool in data management?
a) Data entry
b) Data transformation
c) Data visualization
d) Data archiving
©2024/2025
, ANS: b) Data transformation
Rationale: ETL (Extract, Transform, Load) tools are used to
extract data from various sources, transform it into a suitable
format, and load it into a destination database for analysis.
6. Fill-in-the-Blank: The __________ model is a database model
that is designed to handle large sets of structured, semi-structured,
and unstructured data.
ANS: Big Data
Rationale: The Big Data model accommodates a wide variety of
data types and is geared towards handling vast volumes of data.
7. True/False: Data mining is exclusively concerned with the
extraction of quantitative information.
ANS: False
Rationale: Data mining involves discovering patterns and
knowledge from large amounts of data, which can be both
quantitative and qualitative.
8. Multiple Response: Which of the following are types of
database normalization? Select all that apply.
a) First Normal Form (1NF)
b) Second Normal Form (2NF)
c) Third Normal Form (3NF)
©2024/2025
