CET Data Management and Analytics 1 — Questions and Answers
Question 1: What is the primary purpose of a data warehouse in an enterprise environment?
- To store real-time transactional data for operational systems
- To consolidate historical data from multiple sources for analytical reporting (Correct answer)
- To replace relational databases with unstructured storage
- To provide temporary cache storage for web applications
Correct answer: To consolidate historical data from multiple sources for analytical reporting
A data warehouse consolidates historical data from disparate sources into a centralized repository optimized for analytical queries and business intelligence reporting.
Question 2: Which term describes the process of extracting data from source systems, transforming it into a usable format, and loading it into a target system?
- ERP (Enterprise Resource Planning)
- API (Application Programming Interface)
- ETL (Extract, Transform, Load) (Correct answer)
- OLAP (Online Analytical Processing)
Correct answer: ETL (Extract, Transform, Load)
ETL (Extract, Transform, Load) is the standard pipeline process that moves data from source systems, applies business rules and cleaning, then loads it into analytical targets.
Question 3: What is data normalization in the context of relational database design?
- Scaling all numeric values to a range between 0 and 1
- Organizing data to reduce redundancy and improve data integrity (Correct answer)
- Converting unstructured data into structured formats
- Encrypting sensitive data fields before storage
Correct answer: Organizing data to reduce redundancy and improve data integrity
Database normalization organizes tables and relationships to minimize data redundancy and avoid update anomalies, improving overall data integrity.
Question 4: Which type of database is best suited for storing and querying large volumes of unstructured or semi-structured data at scale?
- Relational (SQL) database
- Flat-file database
- NoSQL database (Correct answer)
- Hierarchical database
Correct answer: NoSQL database
NoSQL databases (such as document, key-value, or graph stores) are designed for flexible schemas and horizontal scaling, making them well-suited for unstructured and semi-structured data.
Question 5: What is a data lake, and how does it differ from a data warehouse?
- A data lake stores only structured data, whereas a data warehouse stores all data types
- A data lake stores raw data in native format at scale; a data warehouse stores processed, structured data optimized for queries (Correct answer)
- A data lake is a temporary storage solution; a data warehouse provides permanent archiving
- A data lake is used exclusively for streaming data; a data warehouse handles only batch data
Correct answer: A data lake stores raw data in native format at scale; a data warehouse stores processed, structured data optimized for queries
A data lake stores vast amounts of raw data in its native format until needed, while a data warehouse stores pre-processed, structured data organized for specific analytical use cases.
Question 6: Which concept refers to the accuracy, completeness, consistency, and reliability of data throughout its lifecycle?
- Data sovereignty
- Data velocity
- Data quality (Correct answer)
- Data provenance
Correct answer: Data quality
Data quality encompasses dimensions such as accuracy, completeness, consistency, timeliness, and reliability, ensuring data is fit for its intended purpose.
Question 7: In the context of the data management lifecycle, what does 'data archiving' primarily accomplish?
- Permanently deleting data that is no longer actively used
- Moving infrequently accessed data to lower-cost storage while retaining it for compliance or future reference (Correct answer)
- Compressing data in active production systems to improve query performance
- Replicating data across multiple geographic regions for high availability
Correct answer: Moving infrequently accessed data to lower-cost storage while retaining it for compliance or future reference
Data archiving moves rarely accessed data to cost-effective storage tiers while preserving it for regulatory compliance, auditing, or potential future analytical use.
CET Data Management and Analytics 1
What is the primary purpose of a data warehouse in an enterprise environment?