CTP CTP Data Management & Analytics 2 — Questions and Answers
Question 1: Which data quality dimension refers to the degree to which data correctly represents the real-world construct it models?
- Accuracy (Correct answer)
- Completeness
- Timeliness
- Consistency
Correct answer: Accuracy
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?
- The speed at which data is generated and processed (Correct answer)
- The variety of data formats available
- The total volume of data stored
- The veracity of data sources
Correct 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.
Question 3: What is the purpose of a data catalog in an enterprise data management strategy?
- To provide a centralized inventory of data assets with metadata and lineage (Correct answer)
- To store raw backup copies of all production databases
- To restrict access to sensitive data through encryption only
- To automatically generate reports from raw data sources
Correct 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.
Question 4: Which SQL window function calculates a running total across ordered rows within a partition?
- SUM() OVER (PARTITION BY ... ORDER BY ...) (Correct answer)
- GROUP BY with SUM aggregate
- UNION ALL across multiple queries
- CROSS JOIN with a summary table
Correct 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.
Question 5: What is data lineage, and why is it important for a CTP professional?
- Tracking the origin, movement, and transformation of data to ensure traceability (Correct answer)
- Encrypting data at rest to comply with regulations
- Archiving old datasets to cold storage systems
- Indexing all columns for faster query performance
Correct 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.
Question 6: A CTP professional needs to implement a data partitioning strategy for a large table. What is the primary benefit of range partitioning by date?
- Queries filtered by date range scan only relevant partitions, improving performance (Correct answer)
- It encrypts data chronologically for better security
- It automatically archives data older than one year
- It reduces the number of indexes required on the table
Correct 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.
CTP CTP Data Management & Analytics 2
Which data quality dimension refers to the degree to which data correctly represents the real-world construct it models?