CDP Cheat Sheet 2026

The 30 highest-yield CDP facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. Which approach is most effective for sustaining long-term data quality improvements? → Embedding data quality rules into data entry and integration processes to prevent defects
2. What does ETL stand for in the context of data integration? → Extract, Transform, Load
3. What is a key advantage of ELT over traditional ETL in a cloud data warehouse environment? → ELT leverages the target system's massively parallel processing power for transformations
4. The difference between a collection of data's top and lowest scores. Answer: Range → TRUE
5. What does 'right to erasure' (also called 'right to be forgotten') under GDPR mean? → Individuals can request that their personal data be deleted under certain conditions
6. What role does metadata play in supporting data integration processes? → It describes the structure, origin, lineage, and transformation history of integrated data
7. What is 'data provenance'? → The documented history of data's origin and transformations over its lifecycle
8. What does 'grain' mean in the context of a data warehouse fact table? → The level of detail that each row in the fact table represents
9. Which type of data governance maturity model stage describes ad hoc, undocumented data management with no formal policies? → Initial/Reactive
10. Which normal form requires that every non-key attribute be fully dependent on the entire primary key? → Second Normal Form (2NF)
11. In which of the following diagrams is correlation shown? → Corrgram
12. What does 'data lineage' mean in the context of data governance? → Documenting the origin, movement, and transformation of data over time
13. What is a Data Governance Council primarily responsible for? → Overseeing enterprise data governance policies and resolving data conflicts
14. What is the primary role of a message broker in a data integration architecture? → Routing messages between producers and consumers while decoupling them
15. Which data quality dimension refers to data being available when needed for decision-making? → Timeliness
16. Which data quality practice involves monitoring data quality metrics continuously and alerting stakeholders when thresholds are breached? → Data Quality Monitoring / Alerting
17. A place-valued data visualization graph. → Stem and leaf plot
18. What is 'data standardization' in data quality management? → Converting data to a common format, structure, or value set to ensure consistency
19. Which data modeling technique uses entities, attributes, and relationships to represent business concepts? → Entity-Relationship (ER) Modeling
20. Which data quality rule type checks that a value in one field is consistent with a related value in another field? → Cross-Field Consistency Rule
21. What does ACID stand for in the context of database transactions? → Atomicity, Consistency, Isolation, Durability
22. What is the key difference between a data policy and a data standard in governance? → Policies state what must be done; standards specify how to do it
23. Using a weighted average in → Forecasting
24. Which of the following best describes a Data Quality dimension? → A measurable characteristic of data such as accuracy, completeness, or timeliness
25. Which architectural pattern separates compute from storage to allow independent scaling in cloud data platforms? → Decoupled Storage-Compute Architecture
26. What is 'principle of least privilege' in database access control? → Granting users only the minimum permissions required to perform their job functions
27. A strategy for earning and spending cash. → Budget
28. A graph that displays data using horizontal or vertical bars. → Bar Graph
29. Which data quality dimension measures whether data values conform to the correct format, type, and range? → Validity
30. Which of the following traits best describes processed data? → None of the mentioned