CTP Data Management & Analytics Flashcards

Which data quality dimension refers to the degree to which data correctly represents the real-world construct it models?

Answer: Accuracy

Accuracy measures how well data values correctly reflect the actual real-world entities or events they are meant to represent.

In big data analytics, what does the 'V' for Velocity in the 5 Vs of big data refer to?

Answer: The speed at which data is generated and processed

Velocity refers to the rate at which new data is generated and the speed at which it must be processed to extract timely insights.

What is the purpose of a data catalog in an enterprise data management strategy?

Answer: To provide a centralized inventory of data assets with metadata and lineage

A data catalog centralizes metadata, ownership, lineage, and descriptions of data assets, enabling discovery and governance across the organization.

Which SQL window function calculates a running total across ordered rows within a partition?

Answer: SUM() OVER (PARTITION BY ... ORDER BY ...)

The SUM() window function with OVER, PARTITION BY, and ORDER BY computes a cumulative running total within defined partitions.

What is data lineage, and why is it important for a CTP professional?

Answer: Tracking the origin, movement, and transformation of data to ensure traceability

Data lineage documents where data comes from, how it has been transformed, and where it goes, which is critical for auditing, debugging, and compliance.

A CTP professional needs to implement a data partitioning strategy for a large table. What is the primary benefit of range partitioning by date?

Answer: Queries filtered by date range scan only relevant partitions, improving performance

Range partitioning by date enables partition pruning, so queries with date filters only access the relevant partition rather than the entire table.