CET Data Management and Analytics 3

Question 1

What is data governance, and what is its primary objective in an organization?

Accepted Answer

A framework of policies, roles, and processes that ensure data is accurate, available, and used appropriately

Answer

A set of IT security protocols designed to prevent unauthorized database access

Answer

A software architecture pattern for routing data between microservices

Answer

A compliance audit checklist required for financial institutions under SOX

Question 2

What is Master Data Management (MDM) designed to solve?

Accepted Answer

Creating and maintaining a single authoritative source of key business entities like customers, products, and locations

Answer

Backing up transactional databases to prevent data loss during system failures

Answer

Managing access privileges for database administrators across the enterprise

Answer

Automating the generation of compliance reports for regulatory submissions

Question 3

What does data lineage track within a data management framework?

Accepted Answer

The history of data's origin, movement, transformations, and usage over time

Answer

The geographic locations where data is physically stored

Answer

The access frequency of data assets by individual users

Answer

The version history of database schema changes

Question 4

Under the General Data Protection Regulation (GDPR), what right allows EU citizens to request that their personal data be permanently deleted?

Accepted Answer

Right to erasure (Right to be forgotten)

Answer

Right to data portability

Answer

Right to rectification

Answer

Right to restriction of processing

Question 5

What is a data catalog, and how does it support data management?

Accepted Answer

An inventory of data assets with metadata that helps users discover, understand, and trust available data

Answer

A physical server that stores compressed backups of production databases

Answer

A tool for visually designing entity-relationship diagrams for relational databases

Answer

A log of all database queries executed across the enterprise for performance auditing

Question 6

Which data management principle states that data should be collected and stored only to the extent necessary for its specified purpose?

Accepted Answer

Data minimization

Answer

Data redundancy

Answer

Data replication

Answer

Data standardization

Question 7

In big data architecture, what does the 'velocity' dimension of the three Vs refer to?

Accepted Answer

The speed at which new data is generated and must be processed

Answer

The total size or volume of data stored in the system

Answer

The variety of structured, semi-structured, and unstructured data formats

Answer

The accuracy and trustworthiness of data across its lifecycle