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 CAP theorem property is sacrificed by Apache Cassandra by default in favor of availability and partition tolerance? → Consistency
2. 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
3. Which financial data standard defines a common language for electronic communication of business and financial data? → XBRL
4. What does ETL stand for in the context of data integration? → Extract, Transform, Load
5. Which regulatory framework requires financial institutions to report derivative positions to a trade repository? → Dodd-Frank Act (CFTC reporting)
6. 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
7. Which file format is optimized for columnar storage and is widely used in big data ecosystems for analytical queries? → Parquet
8. The difference between a collection of data's top and lowest scores. Answer: Range → TRUE
9. 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
10. What is 'data provenance'? → The documented history of data's origin and transformations over its lifecycle
11. 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
12. In portfolio analytics, what does 'alpha' represent? → Excess return of an investment relative to a benchmark index
13. In the context of streaming analytics, what is 'watermarking' used for? → Handling late-arriving data by defining a threshold for event-time delays
14. Which type of data governance maturity model stage describes ad hoc, undocumented data management with no formal policies? → Initial/Reactive
15. Which normal form requires that every non-key attribute be fully dependent on the entire primary key? → Second Normal Form (2NF)
16. In which of the following diagrams is correlation shown? → Corrgram
17. What does 'data lineage' mean in the context of data governance? → Documenting the origin, movement, and transformation of data over time
18. What is a Data Governance Council primarily responsible for? → Overseeing enterprise data governance policies and resolving data conflicts
19. In YARN, what is the role of the ApplicationMaster? → Negotiating resources and tracking task status for a specific application
20. What is the primary role of a message broker in a data integration architecture? → Routing messages between producers and consumers while decoupling them
21. Which data quality dimension refers to data being available when needed for decision-making? → Timeliness
22. Which HDFS configuration parameter controls the minimum percentage of DataNodes that must successfully write a block before the client receives acknowledgment? → dfs.replication.min
23. What does the 'embarrassingly parallel' term mean in the context of big data processing? → Tasks can be divided into independent subtasks with no dependency between them
24. Which data quality practice involves monitoring data quality metrics continuously and alerting stakeholders when thresholds are breached? → Data Quality Monitoring / Alerting
25. A place-valued data visualization graph. → Stem and leaf plot
26. What is 'data standardization' in data quality management? → Converting data to a common format, structure, or value set to ensure consistency
27. Which data modeling technique uses entities, attributes, and relationships to represent business concepts? → Entity-Relationship (ER) Modeling
28. 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
29. What does ACID stand for in the context of database transactions? → Atomicity, Consistency, Isolation, Durability
30. 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