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.
LAG
B.
SUM
C.
GROUPING
D.
LEAD
Show Answer
Correct Answer: D. LEAD
Explanation:
LEAD accesses a later row within the ordered partition.
Choose an option to check your answer.
A.
Stacked area chart
B.
Gauge
C.
Text table with one total
D.
Scatter plot
Show Answer
Correct Answer: D. Scatter plot
Explanation:
A scatter plot shows paired numeric values and possible association patterns.
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.
Store raw source files without definitions
B.
Replace ETL with manual spreadsheets
C.
Allow every report to implement different KPI logic
D.
Expose reusable business terms, relationships, calculations, and security over technical data
Show Answer
Correct Answer: D. Expose reusable business terms, relationships, calculations, and security over technical data
Explanation:
A semantic layer makes data understandable and consistent for consumers.
Choose an option to check your answer.
A.
SUM(Amount) OVER (ORDER BY Date ROWS UNBOUNDED PRECEDING)
B.
SUM(Amount) without an OVER clause
C.
COUNT(*) GROUP BY Date only
D.
MAX(Amount) OVER ()
Show Answer
Correct Answer: A. SUM(Amount) OVER (ORDER BY Date ROWS UNBOUNDED PRECEDING)
Explanation:
A cumulative frame from the first row through the current row produces a running total.
Choose an option to check your answer.
A.
When location itself is essential to the analytical question
B.
Whenever a table contains any text column
C.
When exact values must be compared across many close categories
D.
When data has no geographic component
Show Answer
Correct Answer: A. When location itself is essential to the analytical question
Explanation:
Maps are useful for spatial patterns such as regional coverage or distribution.
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.
Discover datasets, definitions, owners, quality information, and usage guidance
B.
Update operational transactions directly
C.
Rebuild SQL Server indexes
D.
Generate random dashboard samples
Show Answer
Correct Answer: A. Discover datasets, definitions, owners, quality information, and usage guidance
Explanation:
A catalog makes analytical assets searchable and understandable.
Choose an option to check your answer.
A.
A grand total over the entire table
B.
A frame containing the current row and two preceding monthly rows
C.
A unique clustered index on month name
D.
A GROUP BY with no date column
Show Answer
Correct Answer: B. A frame containing the current row and two preceding monthly rows
Explanation:
A bounded window frame computes the average over a sliding set of periods.
Choose an option to check your answer.
A.
They cannot display any numeric values
B.
Perspective can distort apparent values and make comparison harder
C.
They always use more database storage
D.
They prevent report refresh
Show Answer
Correct Answer: B. Perspective can distort apparent values and make comparison harder
Explanation:
3D perspective changes visible lengths, angles, and areas.
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.
Choose an option to check your answer.
A.
To determine the column’s preferred chart color
B.
To identify ETL jobs, models, reports, and users that depend on it
C.
To increase the fact-table grain
D.
To create unrelated data marts
Show Answer
Correct Answer: B. To identify ETL jobs, models, reports, and users that depend on it
Explanation:
Lineage reveals downstream dependencies that a schema change could break.
