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.
Decorate reports regardless of analytical meaning
B.
Replace all data validation
C.
Make patterns, comparisons, trends, and exceptions easier to understand
D.
Hide uncertainty from decision-makers
Show Answer
Correct Answer: C. Make patterns, comparisons, trends, and exceptions easier to understand
Explanation:
Effective visuals reduce the effort required to interpret complex data.
Choose an option to check your answer.
A.
To change the source system’s transaction records
B.
To define a SQL Server filegroup
C.
To create a reusable value derived from existing fields in the analysis
D.
To schedule operating-system backups
Show Answer
Correct Answer: C. To create a reusable value derived from existing fields in the analysis
Explanation:
Calculated fields express analytical logic such as ratios, categories, or date calculations.
Choose an option to check your answer.
A.
Replace all axis labels permanently
B.
Bypass row-level security
C.
Provide additional context on demand without overcrowding the main visual
D.
Modify warehouse fact rows
Show Answer
Correct Answer: C. Provide additional context on demand without overcrowding the main visual
Explanation:
Tooltips reveal supporting values or explanations when users point to a mark.
Choose an option to check your answer.
A.
They eliminate all security responsibilities
B.
They guarantee zero data-transfer cost
C.
Elastic resources and managed services can accelerate scaling and deployment
D.
They make data modeling unnecessary
Show Answer
Correct Answer: C. Elastic resources and managed services can accelerate scaling and deployment
Explanation:
Cloud platforms can provision capacity quickly and offer managed integration and analytics.
Choose an option to check your answer.
A.
RANK
B.
DENSE_RANK
C.
COUNT DISTINCT
D.
ROW_NUMBER
Show Answer
Correct Answer: D. ROW_NUMBER
Explanation:
ROW_NUMBER gives every row a different sequence value according to the specified order.
Choose an option to check your answer.
A.
Pie chart
B.
Single KPI card
C.
Treemap without time order
D.
Line chart
Show Answer
Correct Answer: D. Line chart
Explanation:
A line chart preserves chronological order and makes trends visible.
Choose an option to check your answer.
A.
A dimension that automatically contains every database row
B.
A fixed report image
C.
A source-system foreign key
D.
A user-controlled single value that can influence calculations, filters, or reference lines
Show Answer
Correct Answer: D. A user-controlled single value that can influence calculations, filters, or reference lines
Explanation:
Parameters let users supply a value independent of a specific field selection.
Choose an option to check your answer.
A.
Mobile devices cannot display measures
B.
A mobile layout increases warehouse granularity
C.
It removes the need for report security
D.
Small screens require prioritized visuals, readable sizing, and touch-friendly navigation
Show Answer
Correct Answer: D. Small screens require prioritized visuals, readable sizing, and touch-friendly navigation
Explanation:
A desktop canvas does not automatically translate well to a narrow screen.
Choose an option to check your answer.
A.
List every possible visualization without priorities
B.
Commit to one large release with no feedback
C.
Focus only on purchasing licenses
D.
Sequence capabilities and projects according to business value, dependencies, governance, and resources
Show Answer
Correct Answer: D. Sequence capabilities and projects according to business value, dependencies, governance, and resources
Explanation:
A roadmap connects BI investments to strategic outcomes and practical delivery constraints.
Choose an option to check your answer.
A.
Tied rows receive the same rank and subsequent rank numbers contain gaps
B.
Every row receives a unique consecutive rank
C.
Tied rows are removed
D.
All following ranks become NULL
Show Answer
Correct Answer: A. Tied rows receive the same rank and subsequent rank numbers contain gaps
Explanation:
RANK assigns equal positions to ties.
Choose an option to check your answer.
A.
Sorted bar chart
B.
Gauge for each transaction
C.
Map without geographic meaning
D.
Area chart with overlapping categories
Show Answer
Correct Answer: A. Sorted bar chart
Explanation:
Bars provide a common baseline for accurate categorical comparison.
Choose an option to check your answer.
A.
User interaction in one view to filter, highlight, or navigate another view
B.
Permanent deletion of source records
C.
Automatic creation of all indexes
D.
Conversion of a star schema into OLTP
Show Answer
Correct Answer: A. User interaction in one view to filter, highlight, or navigate another view
Explanation:
Actions coordinate views and make dashboards interactive.
