54-Second Sprint 01 — Mixed 10
Time limit: 9:00
Questions: 10
Mode: mixed, closed answer key
Target: preserve reasoning while averaging ~54 seconds.
Record for each: answer, confidence 1–5, whether you would look up, and time if over 75 seconds.
1
Two business units disagree on the official definition of “Active Customer.” The integration platform can implement either definition. What should happen first?
A. Let the integration developer choose the definition that requires fewer mappings.
B. Let the Data Quality Analyst choose the definition with fewer current defects.
C. Use Data Governance decision rights to resolve/approve the business definition, then implement it.
D. Build both definitions into the warehouse and let users choose.
2
A team needs a technology-independent representation of Customer, Account and Product entities, their attributes and relationships, with more detail than a conceptual subject-area view but without DBMS-specific storage design. What is the closest model?
A. Logical Data Model
B. Physical Data Model
C. Metamodel
D. Data Catalog
3
An auditor asks, “Which source field produced this dashboard measure, what transformations occurred, and where else is the field used downstream?” What Metadata capability is most directly needed?
A. Business Glossary
B. Data Dictionary
C. Data Catalog search only
D. Data Lineage
4
A customer email value satisfies the approved syntax and domain rules but actually belongs to a different person. Which Data Quality dimension is most directly violated?
A. Validity
B. Accuracy
C. Completeness
D. Timeliness
5
Three systems use different local IDs for records that may represent the same legal customer. The enterprise must determine whether they are one entity and preserve source-to-enterprise identity mappings. Which capability leads?
A. Master Data Management
B. Reference Data Management
C. Data Catalog Management
D. Data Warehousing
6
Sales and Inventory marts must analyze their separate facts using the same governed Product definitions and attributes. What dimensional concept best supports this?
A. Degenerate fact
B. Staging table
C. Conformed Dimension
D. Operational Data Store
7
A migration design must describe how the legacy warehouse and new cloud platform will coexist, synchronize and be retired in waves before the final target is reached. Which architecture view is most directly required?
A. Current-state Architecture only
B. Transition-state Architecture
C. Physical Data Model
D. Business Glossary
8
A user successfully proves identity at login but can see salary fields that are unnecessary for the user’s job. What control area is primarily failing?
A. Authentication
B. Encryption
C. Availability
D. Authorization / entitlement design
9
After the initial load, an integration process must identify and transmit only rows that changed since the prior cycle. Which pattern is the closest match?
A. Replication as the management objective
B. Data Virtualization
C. Change Data Capture (CDC)
D. Complex Event Processing
10
A distributed system experiences a network partition and the design decision centers on the trade-off between consistency and availability while partition tolerance is required. Which concept is being invoked?
A. CAP
B. ACID
C. BASE
D. RACI
Stop at 9:00. Record any unanswered item before opening the key.