Download Fundamentals of Business Intelligence FBI Ultimate Exam and more Exams Technology in PDF only on Docsity!
Intelligence FBI Ultimate Exam
Question 1. Which of the following best describes the primary purpose of Business Intelligence (BI)? A) To replace all manual decision-making processes B) To collect raw data without analysis C) To transform data into actionable insights for better decisions D) To store data indefinitely for compliance Answer: C Explanation: BI’s core goal is to convert data into useful information that supports strategic and operational decisions, not merely to collect or store data. Question 2. In the evolution from Decision Support Systems (DSS) to modern BI, which capability became a standard feature? A) Only batch reporting B) Real-time interactive dashboards C) Manual spreadsheet calculations D) Paper-based scorecards Answer: B Explanation: Modern BI adds real-time, interactive visualizations and self-service capabilities that were not common in early DSS. Question 3. Which analytic type answers the question “What will happen next?” A) Descriptive analytics B) Diagnostic analytics
Intelligence FBI Ultimate Exam
C) Predictive analytics D) Prescriptive analytics Answer: C Explanation: Predictive analytics uses statistical models and machine learning to forecast future events. Question 4. Which of the following is a direct business impact of effective BI implementation? A) Increased data storage costs only B) Higher employee turnover C) Improved ROI through faster, data-driven decisions D) Longer product development cycles Answer: C Explanation: BI enables quicker insights, leading to better resource allocation and higher return on investment. Question 5. The first phase of the BI life cycle is: A) Insight delivery B) Data discovery and collection C) Action planning D) Report distribution Answer: B Explanation: BI starts with discovering relevant data sources and collecting raw data before analysis.
Intelligence FBI Ultimate Exam
D) Archive Answer: B Explanation: Data transformation includes cleansing activities such as deduplication. Question 9. Incremental loading in ETL is primarily used to: A) Load the entire data set each night B) Load only new or changed records since the last run C) Delete old data from the warehouse D) Perform data profiling Answer: B Explanation: Incremental loads improve efficiency by processing only delta records. Question 10. Which loading strategy is most suitable for high-velocity streaming data? A) Batch processing every 24 hours B) Real-time streaming load C) Manual file upload D) Monthly bulk import Answer: B Explanation: Real-time streaming loads ingest data continuously, matching high-velocity sources.
Intelligence FBI Ultimate Exam
Question 11. In dimensional modeling, a star schema differs from a snowflake schema because: A) It normalizes dimension tables into multiple levels B) It stores all dimensions in a single denormalized table C) It uses only fact tables without dimensions D) It eliminates the need for foreign keys Answer: B Explanation: A star schema keeps dimension tables denormalized (flat), simplifying queries compared to the normalized snowflake design. Question 12. Which of the following best defines a fact table? A) Stores descriptive attributes of business entities B) Contains quantitative measurements linked to dimensions C) Holds metadata about the warehouse structure D) Provides a list of all users and roles Answer: B Explanation: Fact tables record numeric metrics (sales, quantity) that are analyzed across dimensions. Question 13. A dimension hierarchy is used to: A) Encrypt fact data B) Create drill-down levels for analysis (e.g., Year → Quarter → Month) C) Store transaction logs D) Replace primary keys in fact tables
Intelligence FBI Ultimate Exam
B) Ensure a single, consistent view of core entities (e.g., customers, products) across systems C) Perform ad-hoc analysis on unstructured data D) Generate random synthetic data Answer: B Explanation: MDM creates a “single source of truth” for master entities, improving data quality and consistency. Question 17. Data profiling is most useful for: A) Designing user interfaces B) Assessing data accuracy, completeness, and consistency before loading C) Encrypting sensitive columns D) Scheduling batch jobs Answer: B Explanation: Profiling examines source data characteristics to identify quality issues early. Question 18. Which metric would you most likely include in a data quality framework? A. Number of dashboards created per month B. Percentage of records with valid email formats C. Average query response time D. Number of data warehouses in the organization Answer: B
Intelligence FBI Ultimate Exam
Explanation: Valid email format percentage directly measures data accuracy, a core data-quality dimension. Question 19. A data dictionary is primarily used to: A) Store raw transaction logs B) Define metadata such as column definitions, data types, and business meanings C) Archive old reports D) Automate ETL scheduling Answer: B Explanation: Data dictionaries provide a catalog of metadata, supporting a “single version of the truth.” Question 20. Which OLAP operation describes selecting a single slice of a cube across one dimension? A) Drill-through B) Slicing C) Dicing D) Pivoting Answer: B Explanation: Slicing extracts a two-dimensional view by fixing one dimension’s value. Question 21. In OLAP, “drill-down” refers to: A) Aggregating data to a higher level B) Moving from a summary to a more detailed level of data
Intelligence FBI Ultimate Exam
Question 24. Which chart type is most appropriate for showing a trend over time? A) Bar chart B) Scatter plot C) Line chart D) Pie chart Answer: C Explanation: Line charts connect data points chronologically, highlighting trends. Question 25. According to Gestalt principles, the “proximity” rule suggests that elements that are: A) Same color are perceived as a group B) Close together are seen as related C) Have similar shapes belong together D) Appear larger are more important Answer: B Explanation: Proximity groups nearby visual elements, aiding quick comprehension. Question 26. In a dashboard, a slicer is used to: A) Export data to CSV B) Filter data dynamically based on user selection C) Change the underlying database schema D) Schedule automatic report delivery
Intelligence FBI Ultimate Exam
Answer: B Explanation: Slicers provide interactive filtering for end-users. Question 27. A tactical dashboard is typically designed for: A) Executives monitoring long-term strategy B) Operational staff tracking day-to-day performance C) Mid-level managers needing actionable metrics for the current period D) IT administrators managing server health Answer: C Explanation: Tactical dashboards give managers near-real-time metrics to adjust short-term actions. Question 28. Which KPI would be most appropriate for measuring customer satisfaction? A) Gross profit margin B) Net promoter score (NPS) C) Inventory turnover D) Average order processing time Answer: B Explanation: NPS directly gauges how likely customers are to recommend the company. Question 29. Balanced Scorecard perspectives typically include all EXCEPT:
Intelligence FBI Ultimate Exam
Explanation: Data Stewards own the quality, definitions, and usage policies of their data domains. Question 32. Role-Based Access Control (RBAC) restricts data access based on: A) The time of day B) User’s job role and associated permissions C) Random assignment D. Data size Answer: B Explanation: RBAC grants privileges according to predefined roles (e.g., Analyst, Manager). Question 33. GDPR primarily protects: A) Intellectual property patents B) Personal data of EU residents C. Financial transaction logs D. Open-source software licenses Answer: B Explanation: The General Data Protection Regulation safeguards EU citizens’ personal information. Question 34. Algorithmic bias in BI can be mitigated by: A. Ignoring data outliers B. Using diverse training data and regularly auditing model outputs
Intelligence FBI Ultimate Exam
C. Encrypting all model parameters D. Limiting model complexity Answer: B Explanation: Diverse data and audits help identify and correct biased predictions. Question 35. Self-service BI enables business users to: A. Directly modify production ETL pipelines B. Create their own reports and analyses without heavy IT involvement C. Access source code of the data warehouse D. Bypass all security controls Answer: B Explanation: Self-service tools empower users to explore data while maintaining governance. Question 36. Augmented analytics incorporates which technology to automate insight generation? A. Manual spreadsheet calculations B. Artificial intelligence and machine-learning algorithms C. Paper-based reporting D. Static PDFs Answer: B Explanation: AI/ML automatically surface patterns, recommendations, and visualizations.
Intelligence FBI Ultimate Exam
Answer: B Explanation: NoSQL systems are optimized for flexible schemas and varied data formats. Question 40. Real-time BI dashboards rely on which of the following architectural components? A. Batch-only ETL jobs running nightly B. Streaming data ingestion (e.g., Kafka, Kinesis) and in-memory analytics engines C. Manual data entry forms D. Paper-based scorecards Answer: B Explanation: Streaming platforms feed data continuously to analytics engines for up-to-the-minute visualizations. Question 41. Which of the following is a characteristic of a descriptive analytics report? A. Predicts future sales using regression B. Shows historical sales trends and totals C. Recommends actions to improve margins D. Optimizes pricing using simulation Answer: B Explanation: Descriptive analytics summarizes past events without forecasting or prescribing actions.
Intelligence FBI Ultimate Exam
Question 42. When designing a BI solution, the term “single version of the truth” refers to: A. Storing multiple copies of the same data for redundancy B. Maintaining one authoritative data source that all users trust C. Using only one visualization type across the organization D. Encrypting all data at rest Answer: B Explanation: It ensures consistency by having a unified, authoritative data set. Question 43. In data warehousing, a surrogate key is used to: A. Encrypt sensitive columns B. Provide a stable, system-generated identifier for dimension rows C. Replace foreign keys in fact tables D. Store raw source system IDs only Answer: B Explanation: Surrogate keys are internal, non-business identifiers that simplify joins and handle slowly changing dimensions. Question 44. Which of the following best describes a “slowly changing dimension” (SCD) Type 2? A. Overwrites the existing record with new attribute values B. Creates a new record with a new surrogate key while preserving history C. Deletes the old record entirely D. Stores only the most recent version in a cache
Intelligence FBI Ultimate Exam
B. Events or relationships that have no measurable value (e.g., attendance) C. Metadata about dimensions D. System logs Answer: B Explanation: Factless fact tables capture many-to-many relationships or events without a numeric metric. Question 48. Which of the following best illustrates a “drill-through” operation? A. Summarizing sales by region in a cube B. Clicking a summary cell to open a detailed transaction list from the source system C. Changing the chart type from bar to line D. Exporting data to Excel Answer: B Explanation: Drill-through provides row-level detail behind an aggregated view. Question 49. In a BI project, the “Insight delivery” phase typically involves: A. Extracting raw data from source systems B. Designing ETL pipelines C. Publishing dashboards, reports, and alerts to end users D. Archiving old data Answer: C
Intelligence FBI Ultimate Exam
Explanation: Insight delivery is the stage where analytical outputs are distributed for consumption. Question 50. Which of the following is a key benefit of cloud-based ELT over traditional on-premise ETL? A. Requires no network connectivity B. Leverages scalable compute resources for transformation after loading, reducing data movement C. Eliminates the need for any data transformation D. Guarantees zero latency Answer: B Explanation: Cloud ELT offloads transformation to powerful cloud engines, improving performance and flexibility. Question 51. Which of the following is a typical use case for a “data mart” in a retail organization? A. Storing all corporate financial data B. Providing the marketing team with product-level sales and promotion effectiveness data C. Hosting the enterprise-wide master data hub D. Managing employee payroll Answer: B Explanation: Marketing data marts focus on specific analytical needs like promotion ROI. Question 52. A “metadata repository” is used to store:
