Implementation & Configuration Flashcards
7 cards from real CDO practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Implementation & Configuration flashcards as text
A company is implementing a modern data stack with ELT. Where are transformations primarily executed in ELT compared with traditional ETL?
Answer: Inside the target cloud data warehouse after raw data is loaded
ELT loads raw data first and then uses the warehouse's own compute to transform it.
Which practice best ensures data pipeline configuration changes are controlled and reproducible?
Answer: Managing pipeline code and infrastructure as code in version control with CI/CD and peer review
Version control, infrastructure as code, and CI/CD give traceable, reviewed, and repeatable deployments (the core of DataOps).
When configuring a data contract between a producer team and consumer teams, which element is essential?
Answer: Agreed schema, semantics, quality SLAs, and change/versioning rules
Data contracts formalize schema, meaning, quality expectations, and how changes are versioned and communicated.
A CDO wants to measure adoption of the newly implemented data catalog. Which KPI is most meaningful?
Answer: Active monthly users and percentage of critical assets with certified descriptions and owners
Active usage and the share of critical assets that are documented and certified show real adoption and value.
In implementing reference data management, which configuration prevents inconsistent country codes across applications?
Answer: Publishing a centrally governed reference code set (e.g., ISO 3166) distributed to all consuming systems
A single governed reference set based on standards like ISO 3166, shared to every system, keeps codes consistent.
Which control best detects unauthorized access to sensitive data after access policies are configured?
Answer: Centralized audit logging with automated monitoring and alerting on anomalous access
Audit logs with automated anomaly alerts provide the detective control that complements preventive access policies.
During a cloud data platform migration, what is the best way to validate that data was moved correctly?
Answer: Reconcile row counts, checksums, and key business totals between source and target
Reconciling counts, checksums, and business totals gives objective proof that the data arrived complete and accurate.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy