Business Intelligence MCQs (Set-1)

Difficulty: Easy & Basic

Which outcome makes business intelligence useful?

A More spreadsheets without context
B Larger datasets by themselves
C Unreviewed reports for everyone
D Better decisions from trusted data

What type of analytics summarizes past results?

A Diagnostic analytics
B Prescriptive analytics
C Predictive analytics
D Descriptive analytics

Where are integrated historical records often analyzed?

A Web page cache
B Payroll register
C Point-of-sale terminal
D Data warehouse

What does ETL do before analysis?

A Extract, transform, load
B Enter, total, list
C Encrypt, transfer, lock
D Evaluate, test, launch

Which table describes customers, dates, and products?

A Dimension table
B Transaction table
C Log table
D Queue table

Where are measurable business events stored in a star schema?

A Lookup screen
B Fact table
C Access log
D Style table

What shape links facts to descriptive dimensions?

A Network diagram
B Flat text file
C Star schema
D Flowchart

Which display gives a manager key metrics at a glance?

A Source transaction
B Data dictionary
C Dashboard
D ETL log

When leaders need several pages of detailed filters, what is useful?

A Source system form
B Analytical report
C Static invoice
D Single KPI card

Which measure tracks progress toward a business target?

A Storage allocation rule
B Key performance indicator
C Primary database key
D Extract job duration

How does drill-down change a chart view?

A Moves from summary to detail
B Removes dimension context
C Deletes historical values
D Changes a source system

What does a data filter restrict?

A Source-system uptime
B Model refresh schedule
C Included records
D Data ownership

What does a line chart show clearly?

A Trends over time
B One item’s category label
C Supplier contract clauses
D Data ownership roles

Which chart compares values across categories?

A Timeline
B Scatterplot
C Map legend
D Bar chart

What does metadata describe?

A Printed report color
B User password history
C Data meaning and structure
D Only server location

What does data lineage reveal?

A User training status
B Only final totals
C Dashboard color settings
D Origin and transformations

Why build a subject-focused data mart?

A Replace every source system
B Avoid defining measures
C Simplify access to one area
D Remove data ownership

What should a trusted KPI have?

A No target or review
B Consistent definition and owner
C Untracked source values
D Several competing formulas

Which system records daily sales transactions?

A Executive dashboard
B Operational system
C Data visualization layer
D Data dictionary

What does refresh bring into a model?

A Extra user roles
B Updated source data
C New chart colors
D Revised report titles

Why validate data completeness?

A Change report layout
B Hide refresh failures
C Increase visual clutter
D Find missing records

How does self-service BI help analysts?

A Explore approved data directly
B Replace business definitions
C Change every source schema
D Bypass all data controls

What does a scorecard track?

A Goals and performance measures
B Only database storage
C Source-system passwords
D ETL server locations

What does a report slicer control?

A Source password rotation
B Historical retention policy
C Filtered data view
D Data warehouse schema

Which chart best displays a monthly sales trend?

A Line chart
B Pie chart
C Organization chart
D Single value card