Difficulty: Easy & Basic
How does OLAP support business analysis?
A Schedule employee shifts
B Compare data across dimensions
C Store source passwords
D Approve purchase orders
Answer: B. Compare data across dimensions. OLAP supports multidimensional analysis of measures across dimensions.
Which fact-table grain records each individual sale line?
A One row per year
B One row per product
C One row per sale line
D One row per dashboard
Answer: C. One row per sale line. Fact-table grain states exactly what one row represents.
Why define fact-table grain before choosing measures?
A Remove dimension keys
B Avoid collecting transaction dates
C Make every table identical
D Keep one consistent detail level
Answer: D. Keep one consistent detail level. A declared grain prevents mixing events recorded at different levels.
Which attributes usually belong in a product dimension?
A Sales amount and quantity
B Category, brand, and color
C Invoice total and tax
D Refresh duration and status
Answer: B. Category, brand, and color. Dimensions hold descriptive attributes used to group or filter facts.
What does a conformed dimension enable?
A Consistent analysis across subject areas
B Unrelated date formats
C Separate labels for each report
D Different customer identities
Answer: A. Consistent analysis across subject areas. A conformed dimension uses shared definitions across multiple data marts or facts.
Which design keeps prior customer attributes for historical reporting?
A Unlinked fact table
B Type 2 slowly changing dimension
C Single current-value overwrite
D Temporary staging table
Answer: B. Type 2 slowly changing dimension. Type 2 SCD preserves history by adding a new dimension version.
What does a periodic snapshot fact record?
A State at regular intervals
B Rejected source rows
C Every transaction as it occurs
D Only dimension descriptions
Answer: A. State at regular intervals. Periodic snapshots capture measures at recurring points such as each day or month.
Which fact type captures each business event?
A Transaction fact table
B Date dimension
C Metadata catalog
D Dashboard tile
Answer: A. Transaction fact table. Transaction fact tables store individual events at a declared grain.
Where are raw or transformed records temporarily held before loading?
A Semantic model measure
B Report bookmark
C Staging area
D Scorecard panel
Answer: C. Staging area. Staging areas hold data during extraction and transformation workflows.
What does change data capture identify?
A Rows changed in a source
B Dashboard users online
C Missing chart labels
D Unviewed report pages
Answer: A. Rows changed in a source. CDC tracks inserts, updates, or deletes made in source data.
How does incremental refresh reduce work?
A Deletes old dimension keys
B Refreshes selected data ranges
C Rebuilds every report visual
D Changes every source record
Answer: B. Refreshes selected data ranges. Incremental refresh processes selected periods or partitions rather than all history.
Which report feature sends scheduled results to users?
A Drill-through
B Fact grain
C Subscription
D Dimension relationship
Answer: C. Subscription. Subscriptions deliver report content on a schedule or when configured conditions are met.
What is a threshold alert designed to flag?
A New dimension attributes
B Every data refresh
C Measure crossing a defined limit
D A report page opening
Answer: C. Measure crossing a defined limit. Alerts notify users when a monitored value reaches a configured condition.
How does a dashboard differ from a report in Power BI?
A Always supports more pages
B Uses no semantic model
C Cannot combine visuals
D One page of highlights
Answer: D. One page of highlights. Power BI dashboards are single-page canvases; reports can have multiple pages and deeper filtering.
What does a data cube organize for analysis?
A Reports across servers
B Measures across dimensions
C Sources across contracts
D Users across passwords
Answer: B. Measures across dimensions. A cube concept arranges measures for analysis by multiple dimensions.
What does pivoting let an analyst do?
A Change source ownership
B Archive a data mart
C Replace all measures
D Reorient rows and columns
Answer: D. Reorient rows and columns. Pivoting changes how dimensions appear across rows and columns.
Where does drill-through take a report user?
A A detail page for selection
B An ETL staging folder
C A database backup
D A user permission screen
Answer: A. A detail page for selection. Drill-through passes a selected context to a detailed report page.
What is data latency in a BI report?
A Delay between event and availability
B Time spent on a chart
C Difference between two measures
D Table row count
Answer: A. Delay between event and availability. Latency is the elapsed delay before data becomes available for analysis.
How does batch processing update a model?
A Without reading source data
B After every individual event
C At scheduled intervals
D Only when a user exports
Answer: C. At scheduled intervals. Batch processing collects or processes data in groups at intervals.
What does an operational data store commonly support?
A Long-term archival only
B Visual design governance
C Predictive model training only
D Integrated current operational reporting
Answer: D. Integrated current operational reporting. An ODS typically integrates current or near-current operational data.
Why retain historical snapshots in a warehouse?
A Avoid defining dimensions
B Reduce business context
C Compare performance across periods
D Replace transaction identifiers
Answer: C. Compare performance across periods. Historical snapshots enable time-based comparisons and trend analysis.
Which field commonly links a fact to a date dimension?
A Chart title
B Source password
C Refresh label
D Date key
Answer: D. Date key. A fact stores a key that relates the event to a date dimension row.
What does a data dictionary explain?
A Only server addresses
B Field names and meanings
C Chart colors and positions
D Report subscription fees
Answer: B. Field names and meanings. A data dictionary documents elements, definitions, formats, and usage.
Which dimension supports filtering sales by region?
A ETL job history
B Refresh log
C Sales amount fact
D Geography dimension
Answer: D. Geography dimension. A geography dimension provides attributes such as region and country.
When should a dashboard alert be configured?
A When an action threshold matters
B When a chart looks colorful
C For every available measure
D Only after a data export
Answer: A. When an action threshold matters. Alerts are useful when reaching a threshold should prompt a response.