Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
Define measures, calculated columns, and analytical expressions in a model
B.
Create clustered indexes in SQL Server
C.
Extract files from an FTP server
D.
Design Tableau workbook actions
Show Answer
Correct Answer: A. Define measures, calculated columns, and analytical expressions in a model
Explanation:
DAX is a formula language evaluated within row and filter contexts.
Choose an option to check your answer.
A.
Write DAX measures only
B.
Configure row-level security roles only
C.
Design mobile phone hardware
D.
Connect to, clean, reshape, and combine data before modeling
Show Answer
Correct Answer: D. Connect to, clean, reshape, and combine data before modeling
Explanation:
Power Query provides repeatable data preparation through the M language and interface steps.
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.
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.
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.
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.
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.
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.
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.
Communicate status only through red and green
B.
Use very small fonts to fit more charts
C.
Remove keyboard navigation
D.
Combine color with labels or shapes and maintain readable contrast
Show Answer
Correct Answer: D. Combine color with labels or shapes and maintain readable contrast
Explanation:
Users may have color-vision or visual limitations.
Choose an option to check your answer.
A.
Fill every empty area with graphics
B.
Hide labels and scales
C.
Maximize meaningful marks while minimizing unnecessary decoration
D.
Use the largest possible logo
Show Answer
Correct Answer: C. Maximize meaningful marks while minimizing unnecessary decoration
Explanation:
The principle favors visual elements that communicate data or aid interpretation.
Choose an option to check your answer.
A.
It sorts database tables by row count
B.
It directs attention from the most important information to supporting detail
C.
It defines dimension surrogate keys
D.
It determines ETL task order
Show Answer
Correct Answer: B. It directs attention from the most important information to supporting detail
Explanation:
Size, position, contrast, and whitespace signal relative importance.
