Data Warehousing and Business Intelligence MCQs

Profiling reveals what source data actually contains rather than what documentation claims.
Its findings shape mappings, cleansing rules, and feasibility decisions.

Maintainable ETL requires clear technical and operational documentation.
It enables others to diagnose failures and safely modify the process.

SSRS is designed for parameterized, printable, and scheduled reporting.
It complements interactive dashboards with structured report delivery.

Balances can be summed across accounts but usually not across time snapshots.
They require a specific time rule such as ending balance or average balance.

Prescriptive analytics recommends actions based on objectives, constraints, and predictions.
It goes beyond estimating what may happen by suggesting what should be done.

A balanced scorecard avoids evaluating strategy through one measure alone.
It combines complementary perspectives to reflect broader organizational performance.

Operational systems often serve many simultaneous customers and employees.
Concurrency controls must preserve correctness without unacceptable delay.

A conceptual model communicates major business entities and scope.
It avoids implementation detail and supports shared understanding with stakeholders.

Workload knowledge guides partitioning, indexing, aggregation, and capacity choices.
A design optimized for one pattern may perform poorly for another.

SQL Server Agent executes scheduled jobs, alerts, and workflows.
Warehouse teams use it to automate loads, backups, and maintenance tasks.

Percentages and ratios must usually be recalculated from their components.
Summing row-level percentages produces a misleading result.

Self-service BI gives users accessible tools and governed data models.
It reduces routine reporting dependence while still requiring controls and standards.