Business Intelligence MCQs (Set-2)

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

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

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

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

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

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

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

Which fact type captures each business event?

A Transaction fact table
B Date dimension
C Metadata catalog
D Dashboard tile

Where are raw or transformed records temporarily held before loading?

A Semantic model measure
B Report bookmark
C Staging area
D Scorecard panel

What does change data capture identify?

A Rows changed in a source
B Dashboard users online
C Missing chart labels
D Unviewed report pages

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

Which report feature sends scheduled results to users?

A Drill-through
B Fact grain
C Subscription
D Dimension relationship

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

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

What does a data cube organize for analysis?

A Reports across servers
B Measures across dimensions
C Sources across contracts
D Users across passwords

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

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

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

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

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

Why retain historical snapshots in a warehouse?

A Avoid defining dimensions
B Reduce business context
C Compare performance across periods
D Replace transaction identifiers

Which field commonly links a fact to a date dimension?

A Chart title
B Source password
C Refresh label
D Date key

What does a data dictionary explain?

A Only server addresses
B Field names and meanings
C Chart colors and positions
D Report subscription fees

Which dimension supports filtering sales by region?

A ETL job history
B Refresh log
C Sales amount fact
D Geography dimension

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