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
Answer: D. Better decisions from trusted data. BI turns data into information that supports informed decisions.
What type of analytics summarizes past results?
A Diagnostic analytics
B Prescriptive analytics
C Predictive analytics
D Descriptive analytics
Answer: D. Descriptive analytics. Descriptive analytics explains what happened using historical data.
Where are integrated historical records often analyzed?
A Web page cache
B Payroll register
C Point-of-sale terminal
D Data warehouse
Answer: D. Data warehouse. A data warehouse integrates and stores data for analysis and reporting.
What does ETL do before analysis?
A Extract, transform, load
B Enter, total, list
C Encrypt, transfer, lock
D Evaluate, test, launch
Answer: A. Extract, transform, load. ETL extracts source data, transforms it, and loads it into a target.
Which table describes customers, dates, and products?
A Dimension table
B Transaction table
C Log table
D Queue table
Answer: A. Dimension table. Dimension tables provide descriptive context for analysis.
Where are measurable business events stored in a star schema?
A Lookup screen
B Fact table
C Access log
D Style table
Answer: B. Fact table. Fact tables record measurable events and keys linking dimensions.
What shape links facts to descriptive dimensions?
A Network diagram
B Flat text file
C Star schema
D Flowchart
Answer: C. Star schema. A star schema places a fact table among related dimension tables.
Which display gives a manager key metrics at a glance?
A Source transaction
B Data dictionary
C Dashboard
D ETL log
Answer: C. Dashboard. Dashboards present important measures in a compact monitoring view.
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
Answer: B. Analytical report. Reports support detailed analysis across pages, visuals, and filters.
Which measure tracks progress toward a business target?
A Storage allocation rule
B Key performance indicator
C Primary database key
D Extract job duration
Answer: B. Key performance indicator. A KPI measures progress toward a defined objective or performance target.
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
Answer: A. Moves from summary to detail. Drill-down lets users move from aggregate results into more detailed levels.
What does a data filter restrict?
A Source-system uptime
B Model refresh schedule
C Included records
D Data ownership
Answer: C. Included records. Filters limit which records contribute to a view or result.
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
Answer: A. Trends over time. Line charts make changes across ordered time periods easy to see.
Which chart compares values across categories?
A Timeline
B Scatterplot
C Map legend
D Bar chart
Answer: D. Bar chart. Bar charts compare numeric values among categories.
What does metadata describe?
A Printed report color
B User password history
C Data meaning and structure
D Only server location
Answer: C. Data meaning and structure. Metadata provides information about data such as meaning, format, and origin.
What does data lineage reveal?
A User training status
B Only final totals
C Dashboard color settings
D Origin and transformations
Answer: D. Origin and transformations. Lineage documents data sources and changes through the pipeline.
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
Answer: C. Simplify access to one area. A data mart organizes analysis around a department or subject area.
What should a trusted KPI have?
A No target or review
B Consistent definition and owner
C Untracked source values
D Several competing formulas
Answer: B. Consistent definition and owner. Clear definitions and ownership help users interpret and maintain KPIs.
Which system records daily sales transactions?
A Executive dashboard
B Operational system
C Data visualization layer
D Data dictionary
Answer: B. Operational system. Operational systems capture current business transactions.
What does refresh bring into a model?
A Extra user roles
B Updated source data
C New chart colors
D Revised report titles
Answer: B. Updated source data. A refresh loads or synchronizes changed source data into an analytical model.
Why validate data completeness?
A Change report layout
B Hide refresh failures
C Increase visual clutter
D Find missing records
Answer: D. Find missing records. Completeness checks identify missing required records or fields.
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
Answer: A. Explore approved data directly. Self-service BI enables users to analyze governed data with less central report-building effort.
What does a scorecard track?
A Goals and performance measures
B Only database storage
C Source-system passwords
D ETL server locations
Answer: A. Goals and performance measures. Scorecards compare performance against strategic objectives or targets.
What does a report slicer control?
A Source password rotation
B Historical retention policy
C Filtered data view
D Data warehouse schema
Answer: C. Filtered data view. A slicer is a visual control that filters report data.
Which chart best displays a monthly sales trend?
A Line chart
B Pie chart
C Organization chart
D Single value card
Answer: A. Line chart. A line chart is suited to showing a measure changing over time.