Practice Questions 015–028
DII8-015 · ETL & Latency · Standard · Distinguish
What is the main purpose of Change Data Capture?
A. To build an enterprise data model.
B. To create a data sharing agreement.
C. To identify and pass only inserts, updates and deletes/deltas rather than full data sets.
D. To maintain a permanent archive.
DII8-016 · ETL & Latency · Difficult · Distinguish
Which statement correctly distinguishes data-based from log-based CDC?
A. Data-based CDC always uses an ESB; log-based CDC always uses files.
B. Data-based CDC is synchronous; log-based CDC is always batch.
C. Data-based CDC copies entire databases; log-based CDC profiles them.
D. Data-based CDC relies on application/data indicators or change objects, while log-based CDC processes DBMS activity logs.
DII8-017 · ETL & Latency · Standard · Apply
A source application must continue processing even if a downstream consumer is temporarily offline. Which integration behavior best fits?
A. Asynchronous / loosely coupled.
B. Synchronous confirmation before every transaction.
C. Two-phase commit across all consumers.
D. A shared account.
DII8-018 · ETL & Latency · Difficult · Apply
Which trade-off is most characteristic of real-time synchronous integration?
A. It always has higher latency than nightly batch.
B. It keeps coordinated systems synchronized but can block transactions or make critical systems depend on less critical ones.
C. It requires no state or availability planning.
D. It is identical to publish-subscribe.
DII8-019 · Interaction & Architecture · Standard · Understand
Which description best matches streaming/low-latency integration?
A. Monthly snapshots only.
B. Only physical staging on disk.
C. Continuous event data processed with very low response time, often using in-memory/parallel techniques.
D. A legal agreement between partners.
DII8-020 · Interaction & Architecture · Standard · Distinguish
When does replication work most optimally?
A. When every site freely updates the same values independently.
B. When source and target use unrelated structures and semantics.
C. When no copies are maintained.
D. When source and target are exact copies and changes are controlled so synchronization can be maintained.
DII8-021 · Interaction & Architecture · Standard · Apply
What long-term DII risk must be managed for archived data?
A. Archived formats may become unreadable as technology changes.
B. Archived data must always be real-time.
C. Archives must use publish-subscribe.
D. Archiving removes all retention obligations.
DII8-022 · Interaction & Architecture · Standard · Understand
What is the main enterprise benefit of a canonical model?
A. It forces every system to use one database product.
B. It reduces pairwise transformations by giving systems a common exchange format.
C. It eliminates Data Governance.
D. It makes all integrations synchronous.
DII8-023 · Interaction & Architecture · Difficult · Apply
Why does point-to-point integration become risky as system count grows?
A. It prevents any direct data exchange.
B. It cannot carry files.
C. Interface count/support burden and inconsistency can grow rapidly, approaching the square of the number of systems.
D. It always requires a data warehouse.
DII8-024 · Interaction & Architecture · Standard · Apply
A company has six applications sharing the same customer data and wants fewer interfaces and more consistent views. Which model best fits?
A. Independent local extracts from every source.
B. Only synchronous point-to-point calls.
C. Separate one-off message formats for every pair.
D. Hub-and-spoke using a common hub/canonical model.
DII8-025 · Interaction & Architecture · Foundational · Recall
In publish-subscribe, what happens when data is published?
A. Subscribed consumers receive the published data/service output.
B. Every consumer writes directly to the producer's database.
C. The publisher waits for every consumer to finish all downstream processing.
D. The data is automatically archived.
DII8-026 · Interaction & Architecture · Standard · Distinguish
Which design is more loosely coupled?
A. Two systems that must be online together and wait for each other's response.
B. A producer that places a message on a queue and continues without waiting for the consumer.
C. A two-phase commit across two applications.
D. A direct database dependency where one application reads another's tables.
DII8-027 · Interaction & Architecture · Standard · Distinguish
What is orchestration?
A. The physical encryption of messages.
B. The business approval of a sharing agreement.
C. The organization and execution order/dependencies of multiple data-integration processes.
D. The statistical analysis of nulls and patterns.
DII8-028 · Interaction & Architecture · Difficult · Distinguish
Which item is a Chapter 8 process control rather than orchestration itself?
A. Choosing hub-and-spoke.
B. Defining a canonical model.
C. Selecting CDC.
D. Exception logs and job-dependency charts used to prove/monitor correct execution.