Business Intelligence MCQs (Set-4)

Difficulty: Hard

Given two dashboard averages with different group sizes, how should their overall mean be calculated?

A Use the larger mean
B Weight by group size
C Choose the newest mean
D Average the two means equally

Why must a fact table have a declared grain?

A Reports need matching colors
B Measures use consistent events
C Refreshes need no filters
D Dimensions require equal row counts

What can a many-to-many bridge table help represent?

A Associations between multiple entities
B Refresh timing by date
C A dashboard’s color palette
D A single numeric measure

How does Type 2 slowly changing dimension preserve history?

A Insert a new versioned row
B Move data to staging only
C Delete related facts
D Overwrite the old attribute

Why recompute a ratio after aggregating its groups?

A Filters cannot change ratios
B Combined totals may differ
C Ratios are always additive
D Averages equal totals

What should a BI security test verify for each role?

A All users see every table
B Only permitted rows are visible
C Refresh logs contain no dates
D Dimensions have equal sizes

When a late-arriving fact lacks its dimension record, what helps preserve reporting?

A Change its measure to zero
B Rename the source table
C Delete the transaction
D Use a temporary unknown key

What does schema drift mean in an ETL pipeline?

A A KPI exceeds its target
B A dimension is sorted alphabetically
C Source structure changes unexpectedly
D A report page is hidden

How should an incremental pipeline avoid duplicated loads after retries?

A Make writes idempotent
B Disable source validation
C Append every batch blindly
D Delete all history first

Why can a full reload cause risk for large historical models?

A It reduces table count
B Adds processing time and resources
C It removes all source errors
D It guarantees fresher data immediately

What does a KPI denominator definition control?

A Dimension row order
B Dashboard color selection
C Data source ownership
D Meaning of the reported rate

How can sampling bias affect an executive dashboard?

A Improve every forecast automatically
B Guarantee accurate causation
C Underrepresent important populations
D Remove all outliers

Why can dual-axis charts mislead viewers?

A Scales can exaggerate visual relationships
B They remove data lineage
C They guarantee equal units
D They prevent time filtering

What should a data validation rule test before loading facts?

A Dashboard subscription status
B User profile image
C Required keys and measure ranges
D Chart font size

Why can changing a slicer alter a KPI’s denominator?

A The dimension table vanishes
B The source system reboots
C The report title is updated
D Filters change included rows

What does a late-arriving dimension record require?

A Ignore the business key
B Rebuild all dashboards manually
C Delete the event permanently
D Update the unknown member relationship

Which design choice improves consistent metric reuse?

A Store definitions in email
B Centralize measures in semantic model
C Copy formulas into every report
D Use unlabeled spreadsheet columns

How can time-zone mismatches distort daily reporting?

A Measures become non-additive automatically
B Dimensions lose their keys
C Events fall into different dates
D Refreshes stop all visual filters

Why should dashboards avoid excessive visuals?

A Too much information weakens focus
B One page per KPI
C Filters become mathematically incorrect
D More charts guarantee better decisions

What should lineage record across data preparation?

A Only final chart colors
B Report page order
C Source, transformations, and destination
D User login frequency

When import mode is used, where is model data analyzed?

A Inside each report image
B Only in the source application
C In the imported semantic model
D In a dashboard tile file

What is a key DirectQuery tradeoff?

A Source queries; performance may vary
B Fixed answers without refresh
C Automatic historical archiving
D No need for data relationships

Why monitor refresh failures as a governance issue?

A They improve source quality automatically
B They change chart types
C They create new dimensions
D Users may trust stale measures

Which governance control clarifies who owns a shared metric?

A Unlabeled chart legend
B Hidden source query
C Random refresh time
D Named business owner

What makes a KPI comparison fair across departments?

A Consistent scope and calculation rules
B Equal staff headcount
C Identical source applications
D Same chart color