CDC vs CDC Framework — Learn free

Self-check

Questions 1–10 of 10

1. What does the abbreviation CDC stand for in data processing?
Question 1A. Central Data CatalogueB. Change Data CaptureC. Continuous Data CopyD. Controlled Data ConsumptionE. Common Data Contract
2. What are the three steps of a CDC framework?
Question 2A. CDC Extraction, CDC Processing/Consumption and CDC ServingB. CDC Design, CDC Build and CDC TestC. CDC Backup, CDC Restore and CDC ArchiveD. CDC Landing, CDC Staging and CDC ReportingE. CDC Encryption, CDC Masking and CDC Sharing
3. Which three kinds of change does Change Data Capture pick up?
Question 3A. Schema changes, index changes and permission changesB. Backups, restores and migrationsC. A new row added, an existing row updated, and a previously added row deletedD. Queries, reports and dashboardsE. Compression, encryption and archiving
4. During CDC Extraction, what does the tag D on a row instruct the ETL process to do?
Question 4A. Load a brand-new row into the data modelB. Duplicate the row into an archive tableC. Update the row's enter_date onlyD. Close the row previously entered in the data modelE. Skip the row entirely
5. Why is a CDC process mostly not run in real time?
Question 5A. Because databases cannot detect changes quickly enoughB. Because regulators forbid real-time data movementC. Because dashboards only refresh once a dayD. Because BI teams prefer stale dataE. Because real-time CDC needs a lot of memory processing, which comes with a heavy TCO, so it depends on ROI
6. In a CDC framework, which mechanism is used during CDC Processing to load changed data into a Bill Inmon or Ralph Kimball model?
Question 6A. One of the three Slowly Changing Dimension types, SCD1, SCD2 or SCD3B. A full truncate and reload of every tableC. A NoSQL document storeD. A spreadsheet macroE. Manual data entry by the BI team
7. Which additional columns typically accompany SCD-enabled tables in a CDC framework?
Question 7A. user_name, password and emailB. enter_date, update_date and end_date, and sometimes a status column with Active or InactiveC. latitude, longitude and altitudeD. currency, exchange_rate and taxE. file_name, file_size and checksum
8. In CDC Serving without a status column, how does a BI team identify new records?
Question 8A. Pull rows with all three date columns filledB. Pull rows with an empty enter_dateC. Pull rows with a filled enter_date and empty update_date and end_date columnsD. Pull rows with a filled end_date onlyE. Pull every row regardless of dates
9. Which of the following is NOT true of Change Data Capture as described?
Question 9A. Only the changed data is picked up and pushed to the next layerB. Each extracted row carries an I, U or D tagC. Many tools can extract CDC data from a databaseD. Extracting changed data alone is enough to present data on dashboardsE. CDC Extraction is the first step of the CDC framework
10. What does the tag I signal in CDC Extraction?
Question 10A. That the row is invalid and should be rejectedB. That the row should be indexed for faster searchC. That the row is isolated from other transactionsD. That the row is an intermediate resultE. That a new row has arrived and the ETL should load a new row in the data model