CET Data Management and Analytics

Question 1

What is the primary purpose of a data warehouse in an enterprise environment?

Accepted Answer

To consolidate historical data from multiple sources for analytical reporting

Answer

To store real-time transactional data for operational systems

Answer

To replace relational databases with unstructured storage

Answer

To provide temporary cache storage for web applications

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?

Accepted Answer

ETL (Extract, Transform, Load)

Answer

ERP (Enterprise Resource Planning)

Answer

API (Application Programming Interface)

Answer

OLAP (Online Analytical Processing)

Question 3

What is data normalization in the context of relational database design?

Accepted Answer

Organizing data to reduce redundancy and improve data integrity

Answer

Scaling all numeric values to a range between 0 and 1

Answer

Converting unstructured data into structured formats

Answer

Encrypting sensitive data fields before storage

Question 4

Which type of database is best suited for storing and querying large volumes of unstructured or semi-structured data at scale?

Accepted Answer

NoSQL database

Answer

Relational (SQL) database

Answer

Flat-file database

Answer

Hierarchical database

Question 5

What is a data lake, and how does it differ from a data warehouse?

Accepted Answer

A data lake stores raw data in native format at scale; a data warehouse stores processed, structured data optimized for queries

Answer

A data lake stores only structured data, whereas a data warehouse stores all data types

Answer

A data lake is a temporary storage solution; a data warehouse provides permanent archiving

Answer

A data lake is used exclusively for streaming data; a data warehouse handles only batch data

Question 6

Which concept refers to the accuracy, completeness, consistency, and reliability of data throughout its lifecycle?

Accepted Answer

Data quality

Answer

Data sovereignty

Answer

Data velocity

Answer

Data provenance

Question 7

In the context of the data management lifecycle, what does 'data archiving' primarily accomplish?

Accepted Answer

Moving infrequently accessed data to lower-cost storage while retaining it for compliance or future reference

Answer

Permanently deleting data that is no longer actively used

Answer

Compressing data in active production systems to improve query performance

Answer

Replicating data across multiple geographic regions for high availability