CS – ITEC 2117 D427 Data Management
Applications
Complete Final Assessment (Qns & Ans)
2025
Question 1 (Multiple Choice)
Case:
A company integrates data from several legacy systems into a
central data warehouse. During the ETL process, raw data from
heterogeneous sources must be transformed into a uniform format
before analytics can be performed.
Question:
Which transformation technique is primarily used to remove
duplicate records and ensure data quality?
A. Data parsing
B. Data deduplication
©2025
,C. Data aggregation
D. Data encryption
Correct ANS: B. Data deduplication
Rationale:
Data deduplication eliminates redundant data and ensures that
only one instance of each unique record is loaded into the data
warehouse. This step is essential for maintaining data integrity
and accuracy across diverse sources.
---
Question 2 (Fill in the Blank)
Case:
A data engineer is designing the transformation stage of an ETL
process. The raw data contains dates in multiple formats from
different systems.
Statement:
Converting multiple date formats into a single canonical format
during ETL is known as ______.
©2025
, Correct ANS: standardization
Rationale:
Standardization transforms data elements into a consistent format.
Converting dates into a unified representation ensures that
subsequent analysis and reporting are accurate and comparable.
---
Question 3 (True/False)
Case:
A global application uses a distributed NoSQL database that
allows different nodes to be temporarily inconsistent but
guarantees convergence over time.
Statement:
In systems that follow eventual consistency, temporary
discrepancies between nodes are acceptable as long as all replicas
eventually reflect the same data.
Correct ANS: True
©2025
, Rationale:
Eventual consistency models permit temporary data
inconsistencies in favor of high availability and partition
tolerance. Over time and in the absence of new updates, all nodes
converge to a consistent state.
---
Question 4 (Multiple Response)
Case:
A startup chooses a NoSQL database for its social media
application to handle large volumes of unstructured data while
maintaining high availability.
Question:
Which of the following advantages are typically associated with
NoSQL databases for big data applications? (Select all that
apply.)
A. Horizontal scalability
B. Flexible schema design
C. Strong, rigid ACID compliance
D. High availability
©2025
Applications
Complete Final Assessment (Qns & Ans)
2025
Question 1 (Multiple Choice)
Case:
A company integrates data from several legacy systems into a
central data warehouse. During the ETL process, raw data from
heterogeneous sources must be transformed into a uniform format
before analytics can be performed.
Question:
Which transformation technique is primarily used to remove
duplicate records and ensure data quality?
A. Data parsing
B. Data deduplication
©2025
,C. Data aggregation
D. Data encryption
Correct ANS: B. Data deduplication
Rationale:
Data deduplication eliminates redundant data and ensures that
only one instance of each unique record is loaded into the data
warehouse. This step is essential for maintaining data integrity
and accuracy across diverse sources.
---
Question 2 (Fill in the Blank)
Case:
A data engineer is designing the transformation stage of an ETL
process. The raw data contains dates in multiple formats from
different systems.
Statement:
Converting multiple date formats into a single canonical format
during ETL is known as ______.
©2025
, Correct ANS: standardization
Rationale:
Standardization transforms data elements into a consistent format.
Converting dates into a unified representation ensures that
subsequent analysis and reporting are accurate and comparable.
---
Question 3 (True/False)
Case:
A global application uses a distributed NoSQL database that
allows different nodes to be temporarily inconsistent but
guarantees convergence over time.
Statement:
In systems that follow eventual consistency, temporary
discrepancies between nodes are acceptable as long as all replicas
eventually reflect the same data.
Correct ANS: True
©2025
, Rationale:
Eventual consistency models permit temporary data
inconsistencies in favor of high availability and partition
tolerance. Over time and in the absence of new updates, all nodes
converge to a consistent state.
---
Question 4 (Multiple Response)
Case:
A startup chooses a NoSQL database for its social media
application to handle large volumes of unstructured data while
maintaining high availability.
Question:
Which of the following advantages are typically associated with
NoSQL databases for big data applications? (Select all that
apply.)
A. Horizontal scalability
B. Flexible schema design
C. Strong, rigid ACID compliance
D. High availability
©2025
