D426 ITEC 2116
Data Management Foundations
3.0 Credits
Objective Assessment Review (Qns &
Ans)
2025
©2025
, Multiple Choice Questions
Question 1:
A company is modernizing its data management strategy. It needs to process high-
volume, diverse data types (structured, semi-structured) in real time while
maintaining strong consistency for mission-critical operations. Which technology
best addresses these requirements?
A. Traditional Relational Database Management Systems (RDBMS)
B. NoSQL databases with eventual consistency
C. NewSQL databases
D. Distributed file systems
Correct ANS: C. NewSQL databases
Rationale:
NewSQL databases combine the ACID guarantees of traditional RDBMS with the
scalability and distributed processing capabilities often associated with NoSQL
solutions. This makes them ideal for environments requiring real-time processing
with strong consistency across distributed systems.
---
Question 2:
What is the primary objective of database normalization in relational database
design?
A. To minimize data redundancy and preserve data integrity
B. To enhance report generation speed by duplicating data
C. To improve storage efficiency through data compression
D. To partition data across multiple servers for performance
Correct ANS: A. To minimize data redundancy and preserve data integrity
Rationale:
Normalization is a process that organizes data into related tables to reduce
duplication and ensure that updates, insertions, and deletions do not cause
inconsistencies. This streamlines maintenance and promotes data integrity.
©2025
, ---
Question 3:
In the context of data management, metadata is best described as:
A. The raw, unprocessed data collected from various sources
B. Data about data that details its source, structure, and context
C. The aggregated results obtained after data analysis
D. A backup copy of the primary database stored offsite
Correct ANS: B. Data about data that details its source, structure, and context
Rationale:
Metadata provides essential information about other data, such as its format,
origin, relationships, and usage guidelines. This facilitates data discovery, quality
assessment, and integration across systems.
---
Question 4:
Which SQL clause is primarily used to eliminate duplicate rows in query results?
A. WHERE
B. GROUP BY
C. DISTINCT
D. HAVING
Correct ANS: C. DISTINCT
Rationale:
The DISTINCT clause in SQL is used to ensure that the output of a query includes
only unique records. It effectively removes duplicate rows from the result set,
which is crucial when the underlying data source may contain repetitive entries.
---
Question 5:
A data management team faces data quality issues due to inconsistent entry rules
across various sources. What is the most effective strategy to address this problem?
©2025
Data Management Foundations
3.0 Credits
Objective Assessment Review (Qns &
Ans)
2025
©2025
, Multiple Choice Questions
Question 1:
A company is modernizing its data management strategy. It needs to process high-
volume, diverse data types (structured, semi-structured) in real time while
maintaining strong consistency for mission-critical operations. Which technology
best addresses these requirements?
A. Traditional Relational Database Management Systems (RDBMS)
B. NoSQL databases with eventual consistency
C. NewSQL databases
D. Distributed file systems
Correct ANS: C. NewSQL databases
Rationale:
NewSQL databases combine the ACID guarantees of traditional RDBMS with the
scalability and distributed processing capabilities often associated with NoSQL
solutions. This makes them ideal for environments requiring real-time processing
with strong consistency across distributed systems.
---
Question 2:
What is the primary objective of database normalization in relational database
design?
A. To minimize data redundancy and preserve data integrity
B. To enhance report generation speed by duplicating data
C. To improve storage efficiency through data compression
D. To partition data across multiple servers for performance
Correct ANS: A. To minimize data redundancy and preserve data integrity
Rationale:
Normalization is a process that organizes data into related tables to reduce
duplication and ensure that updates, insertions, and deletions do not cause
inconsistencies. This streamlines maintenance and promotes data integrity.
©2025
, ---
Question 3:
In the context of data management, metadata is best described as:
A. The raw, unprocessed data collected from various sources
B. Data about data that details its source, structure, and context
C. The aggregated results obtained after data analysis
D. A backup copy of the primary database stored offsite
Correct ANS: B. Data about data that details its source, structure, and context
Rationale:
Metadata provides essential information about other data, such as its format,
origin, relationships, and usage guidelines. This facilitates data discovery, quality
assessment, and integration across systems.
---
Question 4:
Which SQL clause is primarily used to eliminate duplicate rows in query results?
A. WHERE
B. GROUP BY
C. DISTINCT
D. HAVING
Correct ANS: C. DISTINCT
Rationale:
The DISTINCT clause in SQL is used to ensure that the output of a query includes
only unique records. It effectively removes duplicate rows from the result set,
which is crucial when the underlying data source may contain repetitive entries.
---
Question 5:
A data management team faces data quality issues due to inconsistent entry rules
across various sources. What is the most effective strategy to address this problem?
©2025
