Practice Questions 001–014
DII8-001 · Introduction · Foundational · Recall
Which statement best matches Chapter 8's distinction between Data Integration and Data Interoperability?
A. Integration is movement/consolidation of data; interoperability is the ability of systems to communicate.
B. Integration is only physical copying; interoperability is only API programming.
C. Integration is Data Quality correction; interoperability is Metadata governance.
D. Integration is database backup; interoperability is disaster recovery.
DII8-002 · Introduction · Foundational · Recall
Which activity is explicitly listed as a basic Data Integration and Interoperability use case?
A. Designing employee performance plans.
B. Data migration and conversion.
C. Approving financial statements.
D. Creating legal contracts.
DII8-003 · Introduction · Standard · Understand
Why does Chapter 8 say DII depends heavily on Metadata Management?
A. Metadata replaces the need for transformation rules.
B. Metadata makes all integrations real-time.
C. Metadata tracks data inventory, meaning, transformation rules, operational history and lineage.
D. Metadata eliminates the need for Data Governance.
DII8-004 · Introduction · Standard · Understand
What problem most strongly supports an enterprise approach to DII rather than uncontrolled point-to-point integration?
A. Too few applications exist to justify any interface.
B. All applications already use identical data structures.
C. Every integration must be synchronous.
D. Interface proliferation and support complexity can overwhelm IT resources and cost.
DII8-005 · Introduction · Foundational · Recall
Which is one of Chapter 8's stated DII goals?
A. Make data available from disparate sources in the format and timeframe needed.
B. Require all source systems to be replaced by a single application.
C. Eliminate all physical data stores in favor of virtualization.
D. Make every integration use the same latency pattern.
DII8-006 · Introduction · Foundational · Recall
Which principle best matches Chapter 8's implementation guidance?
A. Design locally first and standardize only after all projects finish.
B. Take an enterprise design perspective but deliver iteratively and incrementally.
C. Keep business experts away from transformation-rule design.
D. Favor maximum tool diversity to increase flexibility.
DII8-007 · Introduction · Standard · Apply
A developer changes a transformation rule that alters the business meaning of a status code without business review. Which Chapter 8 principle is most directly violated?
A. Low latency.
B. Canonical messaging.
C. Business accountability for DII design and transformation rules.
D. Physical staging.
DII8-008 · Introduction · Standard · Understand
Why can enterprise DII help with compliance?
A. It makes legal requirements unnecessary.
B. It guarantees all data is public.
C. It removes the need to document rules.
D. Shared integration systems can reuse compliance logic and simplify verification across flows.
DII8-009 · ETL & Latency · Foundational · Recall
In ETL, what happens during Extract?
A. Required data is selected and acquired from the source.
B. Target data is transformed after it is loaded.
C. Consumers subscribe to a service catalog.
D. A canonical model is governed.
DII8-010 · ETL & Latency · Foundational · Recall
Which is a transformation example named in Chapter 8?
A. Choosing a project sponsor.
B. Semantic conversion of source values to target values.
C. Approving a data sharing agreement.
D. Setting a service-level target.
DII8-011 · ETL & Latency · Standard · Distinguish
When is ELT especially appropriate according to Chapter 8?
A. When the source has no data.
B. When all transformations must be completed before the target is touched.
C. When the target has strong transformation capability and raw data can be loaded first.
D. Only when no staging is allowed.
DII8-012 · ETL & Latency · Standard · Distinguish
What does a source-to-target mapping primarily define?
A. Only the timing of jobs.
B. Only network bandwidth.
C. Only who approves a project.
D. Sources, targets, row-selection/update rules, lookups, calculations and transformation rules.
DII8-013 · ETL & Latency · Foundational · Recall
What is latency in Chapter 8?
A. The time between data generation in the source and availability in the target.
B. The number of interfaces between applications.
C. The number of rules in a canonical model.
D. The cost of an ETL license.
DII8-014 · ETL & Latency · Standard · Apply
A warehouse must process a very large nightly volume and several hours of delay are acceptable. Which approach best fits?
A. Synchronous two-phase commit.
B. Batch integration.
C. CEP.
D. Data virtualization only.