MCQ Collection
Data Warehousing and Business Intelligence MCQs
Practice Data Warehousing and Business Intelligence questions with answers and explanations.
Choose an option to check your answer.
A.
Unrecorded manual changes to production tables
B.
Shared accounts with unknown users
C.
Removing timestamps from warehouse rows
D.
Logged data loads, model changes, access events, and report publications
Show Answer
Correct Answer: D. Logged data loads, model changes, access events, and report publications
Explanation:
Audit trails show who changed or accessed what and when.
Choose an option to check your answer.
A.
Hierarchical subtotals following the order of grouping columns plus a grand total
B.
Every possible combination of grouping columns
C.
Only detail rows with no totals
D.
A ranking column for each row
Show Answer
Correct Answer: A. Hierarchical subtotals following the order of grouping columns plus a grand total
Explanation:
ROLLUP follows a hierarchy from detailed groups toward higher-level totals.
Choose an option to check your answer.
A.
It can reduce the cost of locating and matching rows between tables
B.
It changes nonadditive measures into additive measures
C.
It removes the need for join conditions
D.
It guarantees a nested-loops join is always best
Show Answer
Correct Answer: A. It can reduce the cost of locating and matching rows between tables
Explanation:
Indexes can support efficient probes, ordering, or reduced scans on join columns.
Choose an option to check your answer.
A.
Dimensions categorize data, while measures are values commonly aggregated
B.
Dimensions are always numeric and measures are always text
C.
Measures cannot be placed on a visual
D.
Dimensions exist only in databases, not Tableau
Show Answer
Correct Answer: A. Dimensions categorize data, while measures are values commonly aggregated
Explanation:
Dimensions define categories, headers, and levels of detail.
Choose an option to check your answer.
A.
A dashboard is a single service canvas of tiles, while a report can contain multiple interactive pages
B.
A dashboard can be created only in Desktop and reports only in SQL Server
C.
Reports cannot contain filters
D.
Dashboards always store source transactions
Show Answer
Correct Answer: A. A dashboard is a single service canvas of tiles, while a report can contain multiple interactive pages
Explanation:
Power BI dashboards provide at-a-glance monitoring in the service.
Choose an option to check your answer.
A.
Load duration, query latency, resource use, failures, and growth trends
B.
Only the number of dashboard colors
C.
Only employee login names
D.
Only the size of one dimension table
Show Answer
Correct Answer: A. Load duration, query latency, resource use, failures, and growth trends
Explanation:
Operational metrics reveal bottlenecks and emerging capacity risks.
Choose an option to check your answer.
A.
Only one grand total
B.
Aggregations for all combinations of the specified grouping columns
C.
Only the most detailed group
D.
A multidimensional SSAS database file
Show Answer
Correct Answer: B. Aggregations for all combinations of the specified grouping columns
Explanation:
CUBE returns every subtotal combination across the listed dimensions.
Choose an option to check your answer.
A.
They automatically summarize every measure
B.
They improve security and may allow execution plan reuse
C.
They remove the need for user permissions
D.
They guarantee identical performance for every parameter value
Show Answer
Correct Answer: B. They improve security and may allow execution plan reuse
Explanation:
Parameters separate values from SQL syntax and reduce injection risk.
Choose an option to check your answer.
A.
Create a new physical database table
B.
Restrict the data included in a view based on selected conditions
C.
Generate surrogate keys
D.
Rebuild cube aggregations
Show Answer
Correct Answer: B. Restrict the data included in a view based on selected conditions
Explanation:
Filters focus a visualization on relevant members, ranges, or conditions.
Choose an option to check your answer.
A.
To show the distribution of thousands of observations
B.
To emphasize one important current value, often with a target or comparison
C.
To compare twenty categories precisely
D.
To display a network graph
Show Answer
Correct Answer: B. To emphasize one important current value, often with a target or comparison
Explanation:
Cards make a small number of headline metrics immediately visible.
Choose an option to check your answer.
A.
The color standard for executive charts
B.
Measurable expectations such as availability, refresh completion, and response time
C.
The natural key of every dimension
D.
The formula for each source-system transaction
Show Answer
Correct Answer: B. Measurable expectations such as availability, refresh completion, and response time
Explanation:
An SLA converts service expectations into measurable commitments.
Choose an option to check your answer.
A.
Collapses each group into one result row
B.
Physically partitions the database table
C.
Divides rows into independent groups while retaining individual rows
D.
Filters out rows before the query runs
Show Answer
Correct Answer: C. Divides rows into independent groups while retaining individual rows
Explanation:
Window partitions define the peer group over which a calculation operates.
