Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with 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.
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.
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.
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.
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.
It converts every report into a cube
B.
It replaces database authentication
C.
It stores all source data permanently in the gateway
D.
It securely connects the cloud service to approved on-premises data sources
Show Answer
Correct Answer: D. It securely connects the cloud service to approved on-premises data sources
Explanation:
The gateway brokers refresh or live queries without exposing sources directly to the internet.
Choose an option to check your answer.
A.
Refreshes only the browser page layout
B.
Changes DAX formulas automatically
C.
Reloads data from configured sources at planned times
D.
Creates a new report for every user
Show Answer
Correct Answer: C. Reloads data from configured sources at planned times
Explanation:
Imported models contain a snapshot that becomes stale as sources change.
Choose an option to check your answer.
A.
Prevent users from changing chart sizes
B.
Restrict model rows visible to each user or role
C.
Encrypt every dashboard image
D.
Control SQL Server index fragmentation
Show Answer
Correct Answer: B. Restrict model rows visible to each user or role
Explanation:
RLS applies role filters so different users see permitted subsets of the same model.
Choose an option to check your answer.
A.
A saved report state including filters, visibility, and navigation context
B.
A permanent copy of every source transaction
C.
A database backup chain
D.
An SSIS package configuration only
Show Answer
Correct Answer: A. A saved report state including filters, visibility, and navigation context
Explanation:
Bookmarks preserve a designed view of the report.
Choose an option to check your answer.
A.
A method for rebuilding indexes
B.
A new source-system transaction screen
C.
A replacement for all report tooltips
D.
A detail page filtered to the context selected in another visual
Show Answer
Correct Answer: D. A detail page filtered to the context selected in another visual
Explanation:
Drill-through passes selected category context to a dedicated detail page.
Choose an option to check your answer.
A.
A process that physically divides database files
B.
A DAX function that deletes rows
C.
An on-canvas control that lets users filter report visuals interactively
D.
A tool for creating surrogate keys
Show Answer
Correct Answer: C. An on-canvas control that lets users filter report visuals interactively
Explanation:
Slicers expose filter choices directly on a report page.
Choose an option to check your answer.
A.
A measure can contain only text
B.
A measure is evaluated at query time in filter context, while a calculated column is stored per row after refresh
C.
A calculated column cannot reference other columns
D.
A measure is always visible in the source database
Show Answer
Correct Answer: B. A measure is evaluated at query time in filter context, while a calculated column is stored per row after refresh
Explanation:
Measures respond dynamically to report filters and aggregate over model data.
