Business Intelligence

• A. To replace all manual business processes with automation
• B. To transform raw data into meaningful insights that support better business decisions ✓
• C. To design the physical infrastructure of a company's computer network
• D. To manage employee payroll and human resource records

Why: Business Intelligence focuses on collecting, integrating, analyzing, and presenting data so that organizations can make informed, evidence-based decisions. It is not primarily about automation, network design, or HR administration.

• A. A physical building used to store paper business records
• B. A centralized repository that stores integrated historical data from multiple sources for analysis ✓
• C. A temporary storage area used only for real-time transaction processing
• D. A software tool that creates visual dashboards for end users

Why: A data warehouse consolidates data from various operational systems into a single, structured repository optimized for querying and analysis over time. Transactional storage and dashboard tools serve different purposes.

• A. Evaluate, Test, Launch
• B. Extract, Transform, Load ✓
• C. Enter, Track, Log
• D. Export, Transfer, Link

Why: ETL stands for Extract, Transform, Load. It describes the process of pulling data from source systems, cleaning and converting it into a consistent format, and loading it into a data warehouse or analytics environment.

• A. Predictive analysis
• B. Prescriptive analysis
• C. Descriptive analysis ✓
• D. Diagnostic analysis

Why: Descriptive analysis summarizes historical data to show what has occurred, such as monthly sales totals or customer counts. Diagnostic analysis explains why it happened, predictive analysis forecasts what will happen, and prescriptive analysis recommends actions.

• A. A key programming interface used to connect databases
• B. A Key Performance Indicator, a measurable value that shows progress toward a business objective ✓
• C. A knowledge processing index used to rank employee productivity
• D. A kernel-level process that improves database speed

Why: A Key Performance Indicator (KPI) is a quantifiable metric tied to strategic goals, such as customer retention rate or revenue growth. KPIs help organizations track performance and identify areas needing attention.

• A. A transactional system designed to process day-to-day operations
• B. A centralized repository of integrated, historical data optimized for analysis and reporting ✓
• C. A temporary storage area used only during data extraction
• D. A spreadsheet application used by individual employees

Why: A data warehouse consolidates data from multiple sources into a single, integrated, historical store designed for querying and analysis rather than for processing transactions.

• A. Evaluate, Test, Launch
• B. Extract, Transform, Load ✓
• C. Enter, Track, Log
• D. Estimate, Transfer, Lock

Why: ETL stands for Extract, Transform, Load. Data is extracted from source systems, transformed into a consistent format, and loaded into the data warehouse.

• A. Volatile and frequently updated
• B. Subject-oriented and non-volatile ✓
• C. Application-specific and unstructured
• D. Real-time and transaction-level

Why: Inmon defined data warehouses as subject-oriented, integrated, time-variant, and non-volatile. Non-volatile means data is loaded and read, not routinely changed or deleted.

• A. A large enterprise-wide data warehouse covering all departments
• B. A subset of a data warehouse focused on a specific business area or department ✓
• C. An online marketplace for buying and selling datasets
• D. A backup copy of operational databases

Why: A data mart is a smaller, focused subset of a data warehouse serving a particular department or business function, such as sales or finance.

• A. Operational systems such as ERP and CRM applications ✓
• B. Printed reports stored in filing cabinets
• C. Personal notes kept by individual managers
• D. Public social media posts only

Why: Operational systems such as ERP, CRM, and point-of-sale applications capture day-to-day transactions and are the primary sources feeding a data warehouse.

• A. Dimension table
• B. Fact table ✓
• C. Lookup table
• D. Bridge table

Why: A fact table sits at the center of a star schema and stores measurable, numeric data about business events, such as sales amounts or quantities, linked to surrounding dimension tables through foreign keys.

• A. Loading data into the data warehouse
• B. Cleaning and removing duplicate records
• C. Retrieving data from source systems ✓
• D. Creating reports for business users

Why: Extract is the first step of ETL, where data is pulled from one or more source systems such as databases, CSV files, or APIs before any transformation or loading occurs.

• A. Slowly Changing Dimension Type 1
• B. Surrogate key
• C. Degenerate dimension
• D. Slowly Changing Dimension Type 2 ✓

Why: Slowly Changing Dimension Type 2 preserves history by inserting a new record with a new surrogate key whenever a tracked attribute changes, typically with effective date columns to mark validity periods.

• A. They make queries run slower for security reasons
• B. They replace business keys that may change or be reused by source systems ✓
• C. They store the actual transaction amounts
• D. They are required by all SQL databases

Why: Surrogate keys are system-generated integers that remain stable even when source business keys change or get reused, and they allow tracking of historical versions of dimension records.

• A. Extract
• B. Load
• C. Transform ✓
• D. Archive

Why: The Transform step applies cleansing, standardization, business rules, and calculations to the extracted data so that it is consistent and ready for analysis before being loaded into the warehouse.

• A. To predict future outcomes using machine learning models
• B. To summarize historical data and explain what has happened ✓
• C. To recommend specific actions based on optimization algorithms
• D. To automatically generate new business strategies

Why: Descriptive analytics focuses on summarizing and interpreting historical data to show what has happened, distinguishing it from predictive and prescriptive analytics.

• A. Monthly total sales revenue ✓
• B. Probability of customer churn next quarter
• C. Optimal price point for a new product
• D. Recommended inventory level for next year

Why: Monthly total sales revenue is a historical, measurable metric that describes past performance, which is the core focus of descriptive reporting. The other options involve forecasting or prescribing future actions.

• A. Encrypt sensitive data before sharing it
• B. Summarize and cross-tabulate large datasets by grouping and aggregating values ✓
• C. Automatically cleanse duplicate records from a database
• D. Create real-time streaming connections to data sources

Why: Pivot tables let analysts group, aggregate, and cross-tabulate data across dimensions such as region and product, making patterns in descriptive summaries easy to see.

• A. Pie chart
• B. Line chart ✓
• C. Scatter plot
• D. Gauge chart

Why: Line charts are best suited for displaying changes over time, making them ideal for showing trends in time-series data such as monthly revenue.

• A. Standard reports are always real-time while ad hoc reports are not
• B. Standard reports are predefined and recurring, while ad hoc reports are created on demand to answer specific questions ✓
• C. Ad hoc reports can only be created by IT staff
• D. Standard reports contain no numerical data

Why: Standard reports follow a fixed, recurring format set in advance, whereas ad hoc reports are created on demand to address a particular, often one-time, business question.

• A. To store raw transactional data for long-term archiving
• B. To display key metrics and KPIs in a consolidated, at-a-glance view ✓
• C. To write and execute database queries for developers
• D. To automatically send emails to customers

Why: Dashboards consolidate important metrics and KPIs into a visual, easy-to-scan view so decision-makers can monitor performance quickly.

• A. Pie chart
• B. Scatter plot
• C. Line chart ✓
• D. Treemap

Why: Line charts plot data points across a time axis, making trends and changes over time easy to see.

• A. Key Process Index
• B. Knowledge Performance Indicator
• C. Key Performance Indicator ✓
• D. Kernel Processing Interface

Why: KPI stands for Key Performance Indicator, a measurable value that shows how effectively an organization is achieving its objectives.

• A. Bar chart ✓
• B. Histogram
• C. Heat map
• D. Box plot

Why: Bar charts make it easy to compare values across discrete categories by showing each category as a bar of comparable length.

• A. Using as many colors and 3D effects as possible
• B. Displaying every available metric on one screen
• C. Limiting the display to the most important metrics with clear labels and consistent colors ✓
• D. Hiding axis labels to keep the design minimal

Why: Focusing on the most important metrics with clear labels and consistent color use reduces clutter and helps users interpret the data quickly.

• A. To store raw transactional data from business systems
• B. To measure progress toward a specific business objective ✓
• C. To replace the need for financial statements
• D. To automatically generate marketing campaigns

Why: KPIs are quantifiable measures used to evaluate how effectively an organization is achieving its key business objectives, such as revenue growth or customer satisfaction.

• A. Annual net profit
• B. Total revenue from last quarter
• C. Number of qualified sales leads generated this month ✓
• D. Employee turnover rate for the past year

Why: Leading indicators predict future performance. Qualified sales leads signal likely future revenue, whereas profit and revenue are lagging indicators that reflect past results.

• A. Simple, Measurable, Actionable, Realistic, Timely
• B. Specific, Measurable, Achievable, Relevant, Time-bound ✓
• C. Strategic, Monitored, Accurate, Reliable, Trackable
• D. Standardized, Measured, Adjusted, Reviewed, Tested

Why: SMART is a widely used framework stating that good KPIs should be Specific, Measurable, Achievable, Relevant, and Time-bound.

• A. The percentage of customers who stop doing business with a company over a given period ✓
• B. The average amount a customer spends per purchase
• C. The total number of new customers acquired in a year
• D. The cost of acquiring a single new customer

Why: Customer churn rate measures the share of customers lost during a specific time frame, making it a key indicator of customer retention and satisfaction.

• A. Current Ratio ✓
• B. Employee Net Promoter Score
• C. Website Bounce Rate
• D. Social Media Follower Count

Why: The Current Ratio (current assets divided by current liabilities) measures a company's ability to meet short-term obligations, making it a core liquidity KPI for finance teams.

• A. To design attractive dashboards that executives find visually appealing
• B. To establish policies, roles, and standards that ensure data is accurate, consistent, secure, and used responsibly ✓
• C. To increase the speed at which queries run on the data warehouse
• D. To replace the need for a data warehouse by storing all data in spreadsheets

Why: Data governance defines who owns data, how it should be managed, and what quality and security standards apply. Its purpose is to ensure trustworthy and responsible use of data across the organization, not to handle visualization, performance, or storage directly.

• A. To identify missing, duplicate, inconsistent, or invalid records so they can be corrected ✓
• B. To determine which employees should receive access to the dashboards
• C. To compress the data so that it takes up less storage space
• D. To automatically generate the final reports for senior management

Why: A data quality assessment checks for problems such as missing values, duplicates, and inconsistent formats. Identifying these issues early prevents inaccurate analysis and loss of stakeholder trust in the BI system.

• A. Data steward ✓
• B. Network administrator
• C. Front-end web developer
• D. Hardware technician

Why: Data stewards are accountable for the definitions, quality, and appropriate use of data within their domain. They bridge business and technical teams, ensuring consistent interpretation of data elements.

• A. Data archiving
• B. Row-level security ✓
• C. Data deduplication
• D. Schema denormalization

Why: Row-level security restricts which rows of data a user can see based on their role or attributes, such as region. Archiving, deduplication, and denormalization address storage, quality, and structure rather than access control.

• A. It allows the system to run faster by caching all results permanently
• B. It eliminates the need for users to be trained on the dashboards
• C. It ensures transparency, enables trust and auditability, and prevents conflicting interpretations of the same metric ✓
• D. It reduces licensing costs for the BI software vendor

Why: Documentation, often called metadata or a data dictionary, lets users understand where numbers come from and how they were calculated. This transparency builds trust, supports audits, and avoids different departments reporting conflicting figures for the same metric.