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.
Add targets, trends, annotations, and guided interactions that clarify action
B.
Add decorative animations unrelated to performance
C.
Repeat the same chart several times
D.
Use more colors than categories
Show Answer
Correct Answer: A. Add targets, trends, annotations, and guided interactions that clarify action
Explanation:
Enrichment should improve interpretation, context, or decision support.
Choose an option to check your answer.
A.
It never allows tied ranks
B.
It gives ties the same rank without leaving gaps afterward
C.
It ranks only numeric columns
D.
It collapses all rows into one group
Show Answer
Correct Answer: B. It gives ties the same rank without leaving gaps afterward
Explanation:
DENSE_RANK advances by one distinct ordered value.
Choose an option to check your answer.
A.
A scatter plot
B.
A carefully labeled pie or 100% stacked bar chart
C.
A line chart with unordered categories
D.
A box plot
Show Answer
Correct Answer: B. A carefully labeled pie or 100% stacked bar chart
Explanation:
Part-to-whole visuals show proportional contribution when categories sum to a total.
Choose an option to check your answer.
A.
When every query must reflect source changes instantly
B.
When faster offline analysis and a controlled refresh snapshot are desired
C.
When data must never be copied from the source
D.
When source performance is unlimited and latency must be zero
Show Answer
Correct Answer: B. When faster offline analysis and a controlled refresh snapshot are desired
Explanation:
Extracts store optimized data for responsive analysis and scheduled refresh.
Choose an option to check your answer.
A.
The number of colors in its default theme
B.
Fit with user needs, data sources, governance, skills, scale, and total cost
C.
The popularity of its logo
D.
The largest possible installation file
Show Answer
Correct Answer: B. Fit with user needs, data sources, governance, skills, scale, and total cost
Explanation:
Tool selection should reflect functional, technical, organizational, and economic requirements.
Choose an option to check your answer.
A.
LEAD
B.
NTILE
C.
LAG
D.
CUME_DIST
Show Answer
Correct Answer: C. LAG
Explanation:
LAG accesses an earlier row without a self-join.
Choose an option to check your answer.
A.
KPI card
B.
Network diagram
C.
Histogram
D.
Single pie slice
Show Answer
Correct Answer: C. Histogram
Explanation:
A histogram groups numeric values into intervals and displays their frequencies.
Choose an option to check your answer.
A.
Host enterprise email accounts
B.
Manage SQL Server transaction logs
C.
Connect, transform, model, analyze, and author interactive reports
D.
Create operating-system virtual machines
Show Answer
Correct Answer: C. Connect, transform, model, analyze, and author interactive reports
Explanation:
Power BI Desktop is the main report-authoring and data-modeling application.
Choose an option to check your answer.
A.
Allow unrestricted publication of unverified datasets
B.
Prohibit business users from creating any analysis
C.
Provide certified datasets and clear standards while allowing authorized exploration
D.
Let each team redefine enterprise KPIs independently
Show Answer
Correct Answer: C. Provide certified datasets and clear standards while allowing authorized exploration
Explanation:
Certified models provide trusted foundations without eliminating analytical flexibility.
Choose an option to check your answer.
A.
One row per month for each product
B.
One row updated through the entire order lifecycle
C.
Only dimension version changes
D.
One row for each individual business event at its lowest chosen grain
Show Answer
Correct Answer: D. One row for each individual business event at its lowest chosen grain
Explanation:
Transaction facts store discrete events such as sales lines or payments.
Choose an option to check your answer.
A.
To increase the number of dimension rows for performance
B.
To replace all null descriptive attributes
C.
To store ETL source code
D.
To preserve referential integrity when a source key is missing or unmatched
Show Answer
Correct Answer: D. To preserve referential integrity when a source key is missing or unmatched
Explanation:
Unknown members provide a valid key when business context cannot be resolved.
Choose an option to check your answer.
A.
To define DAX measures
B.
To determine report color themes
C.
To replace all indexes
D.
To support storage management, backup strategies, and partition administration
Show Answer
Correct Answer: D. To support storage management, backup strategies, and partition administration
Explanation:
Filegroups map database objects to sets of physical files.
