Correct Answer: C. Daily sales totals must reconcile to approved source controls within the stated tolerance
Explanation:
Good acceptance criteria are measurable, testable, and tied to business requirements.
A defined reconciliation tolerance provides an objective release decision.
Correct Answer: D. A clear understanding of decisions, pain points, measures, and information needs
Explanation:
Interviews uncover how people make decisions and where current information fails.
These insights convert business needs into useful analytical requirements.
Correct Answer: B. Monitor loads and queries while adapting to source and business changes
Explanation:
Warehouses require continuous monitoring, tuning, data-quality management, and enhancement.
They must evolve as sources, volumes, and analytical needs change.
Correct Answer: A. Move tested components into production with schedules, security, and support procedures
Explanation:
Deployment makes the solution operational in a controlled production environment.
Scheduling, permissions, monitoring, training, and rollback planning are essential.
Correct Answer: C. Processes that extract, cleanse, transform, and load warehouse data
Explanation:
ETL implements the movement and transformation of data from sources to targets.
It operationalizes mappings and data quality rules defined during design.
Correct Answer: B. Selecting indexes, partitions, compression, and storage placement
Explanation:
Physical design maps the logical model to database structures and hardware resources.
Its goal is efficient storage, loading, querying, and maintenance.