IT – D427 ITEC 2117
Data Management Applications
4.0 Credits
Objective Assessment Review (Qns &
Ans)
2025
©2025
, Question 1:
A multinational organization is looking to integrate data from disparate
sources—structured and unstructured—into a unified repository for
advanced analytics. Which data management solution best supports this
integration?
- A. Data Warehouse
- B. Data Lake
- C. Relational Database Management System
- D. Spreadsheet-based system
Correct ANS: B. Data Lake
Rationale:
A data lake is designed to store massive volumes of raw data in its native
format, including structured, semi-structured, and unstructured data.
This flexibility makes it ideal for organizations needing to integrate
diverse data sources for advanced analytics.
---
Question 2:
Which process in an ETL (Extract, Transform, Load) pipeline is primarily
responsible for converting raw data into a cleaned and standardized
format for business intelligence?
- A. Data Extraction
- B. Data Transformation
- C. Data Cleansing
- D. Data Loading
Correct ANS: B. Data Transformation
Rationale:
Data transformation is the step where raw data is cleaned, standardized,
and converted into formats suitable for analysis before being loaded into
the target system, ensuring consistency and reliability for downstream
applications.
©2025
, ---
Question 3:
In a scenario where an organization must ensure high data quality and
mitigate duplicate records in its customer database, which practice is
essential?
- A. Data Warehousing
- B. Master Data Management (MDM)
- C. Data Mining
- D. Business Intelligence Reporting
Correct ANS: B. Master Data Management (MDM)
Rationale:
Master Data Management focuses on creating a single, authoritative
source for key business data. It involves processes to clean, merge, and
deduplicate data across the organization, which is crucial for ensuring
high data quality.
---
Question 4:
A company is implementing a governance framework to ensure data
security, regulatory compliance, and proper data stewardship throughout
the organization. Which key component is most crucial for enforcement?
- A. Data Quality Dashboards
- B. Data Catalog
- C. Data Governance Council
- D. Enterprise Resource Planning (ERP)
Correct ANS: C. Data Governance Council
Rationale:
A Data Governance Council is responsible for establishing policies, roles,
and processes for managing data. It ensures that data governance
strategies are enforced and align with business goals and regulatory
©2025
Data Management Applications
4.0 Credits
Objective Assessment Review (Qns &
Ans)
2025
©2025
, Question 1:
A multinational organization is looking to integrate data from disparate
sources—structured and unstructured—into a unified repository for
advanced analytics. Which data management solution best supports this
integration?
- A. Data Warehouse
- B. Data Lake
- C. Relational Database Management System
- D. Spreadsheet-based system
Correct ANS: B. Data Lake
Rationale:
A data lake is designed to store massive volumes of raw data in its native
format, including structured, semi-structured, and unstructured data.
This flexibility makes it ideal for organizations needing to integrate
diverse data sources for advanced analytics.
---
Question 2:
Which process in an ETL (Extract, Transform, Load) pipeline is primarily
responsible for converting raw data into a cleaned and standardized
format for business intelligence?
- A. Data Extraction
- B. Data Transformation
- C. Data Cleansing
- D. Data Loading
Correct ANS: B. Data Transformation
Rationale:
Data transformation is the step where raw data is cleaned, standardized,
and converted into formats suitable for analysis before being loaded into
the target system, ensuring consistency and reliability for downstream
applications.
©2025
, ---
Question 3:
In a scenario where an organization must ensure high data quality and
mitigate duplicate records in its customer database, which practice is
essential?
- A. Data Warehousing
- B. Master Data Management (MDM)
- C. Data Mining
- D. Business Intelligence Reporting
Correct ANS: B. Master Data Management (MDM)
Rationale:
Master Data Management focuses on creating a single, authoritative
source for key business data. It involves processes to clean, merge, and
deduplicate data across the organization, which is crucial for ensuring
high data quality.
---
Question 4:
A company is implementing a governance framework to ensure data
security, regulatory compliance, and proper data stewardship throughout
the organization. Which key component is most crucial for enforcement?
- A. Data Quality Dashboards
- B. Data Catalog
- C. Data Governance Council
- D. Enterprise Resource Planning (ERP)
Correct ANS: C. Data Governance Council
Rationale:
A Data Governance Council is responsible for establishing policies, roles,
and processes for managing data. It ensures that data governance
strategies are enforced and align with business goals and regulatory
©2025
