CTP CTP Data Management & Analytics 2

Question 1

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

Accepted Answer

Accuracy

Answer

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

Question 2

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

Accepted Answer

The speed at which data is generated and processed

Answer

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

Question 3

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

Accepted Answer

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

Answer

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

Question 4

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

Accepted Answer

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

Answer

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

Question 5

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

Accepted Answer

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

Answer

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

CTP - Certified Technical Professional Practice Test

CTP - Certified Technical Professional Practice Test

CTP CTP Data Management & Analytics 2