Download NWCA Business Intelligence Systems Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which of the following best describes the primary role of an information system (IS) in supporting organizational strategy? A) Automating routine transactions only B) Providing real‑time data that enables strategic decision making C) Replacing all human decision makers D) Storing data without analysis Answer: B Explanation: IS delivers timely, relevant information that executives use to formulate and adjust strategies, going beyond mere transaction processing. Question 2. In a typical corporate hierarchy, which IT role is most directly responsible for aligning technology initiatives with business objectives? A) IT Manager B) VP of Information Technology C) Network Administrator D) Help Desk Technician Answer: B Explanation: The VP of IT serves as a bridge between senior business leaders and the technology organization, ensuring alignment with corporate goals. Question 3. Business Process Management (BPM) primarily focuses on: A) Designing hardware components B) Modeling, analyzing, and improving business workflows C) Writing low‑level code for databases
D) Managing employee payroll Answer: B Explanation: BPM involves mapping processes, identifying inefficiencies, and using tools (including BI) to streamline operations. Question 4. Which statement correctly differentiates OLTP from OLAP systems? A) OLTP is optimized for complex analytical queries, while OLAP handles simple transactions. B) OLTP stores historical snapshots; OLAP stores current operational data. C) OLTP supports high‑volume transaction processing; OLAP supports multidimensional analysis. D) OLTP and OLAP are interchangeable terms. Answer: C Explanation: OLTP (Online Transaction Processing) handles many short, simple transactions, whereas OLAP (Online Analytical Processing) is designed for complex queries across aggregated data. Question 5. A data mart is best defined as: A) A full‑scale enterprise data warehouse. B) A subset of a data warehouse focused on a specific business line. C) A real‑time streaming data repository. D) An unstructured data lake. Answer: B Explanation: Data marts contain data tailored for a department or function, derived from the larger enterprise warehouse.
Answer: B Explanation: Transformation cleanses, standardizes, and applies logic to make source data suitable for analysis. Question 9. Which loading strategy is appropriate when a data warehouse must reflect only the most recent snapshot of a dimension table? A) Full refresh (truncate and reload) B) Incremental load with change data capture C) Append‑only load D) Real‑time streaming load Answer: A Explanation: A full refresh overwrites the table, ensuring only the latest snapshot is retained—useful for static dimensions. Question 10. In an OLAP cube, a "measure" is: A) A descriptive attribute such as product name. B) A numeric value that can be aggregated (e.g., sales revenue). C) The physical storage location of the cube. D) A security role assigned to users. Answer: B Explanation: Measures are quantitative data points that are summed, averaged, or otherwise aggregated across dimensions.
Question 11. Which schema design is most suitable for a data warehouse requiring high query performance and simple joins? A) Snowflake schema B) Star schema C) Third normal form (3NF) schema D) Entity‑relationship diagram Answer: B Explanation: Star schemas have denormalized dimension tables directly linked to a fact table, minimizing join complexity and boosting performance. Question 12. In a snowflake schema, dimension tables are: A) Fully denormalized for speed. B) Normalized into multiple related tables. C) Stored as flat files. D) Not used at all. Answer: B Explanation: Snowflake schemas break dimensions into additional tables to reduce redundancy, at the cost of more joins. Question 13. Cardinality in data modeling refers to: A) The number of rows in a fact table. B) The type of relationship (one‑to‑one, one‑to‑many, many‑to‑many) between tables. C) The size of the database file. D) The number of users accessing a report.
Question 16. When choosing a visual to compare sales across multiple product categories, which chart type is most appropriate? A) Scatter plot B) Pie chart C) Stacked bar chart D) Histogram Answer: C Explanation: Stacked bar charts show the contribution of each category to the total and allow easy comparison across categories. Question 17. Conditional formatting in a BI report is primarily used to: A) Change the data source. B) Highlight values that meet specific criteria (e.g., low profit margins). C. Increase the size of the dataset. D. Encrypt the report. Answer: B Explanation: Conditional formatting applies visual cues (color, icons) based on data thresholds to draw attention to important values. Question 18. A balanced scorecard typically includes which of the following perspective(s)? A) Financial only B) Customer, Internal Processes, Learning & Growth, and Financial C) Marketing and Sales only D) IT Operations only
Answer: B Explanation: The balanced scorecard framework balances four perspectives to provide a holistic view of performance. Question 19. Six Sigma methodology is most closely associated with: A) Reducing process variation and defects. B) Increasing data storage capacity. C. Designing user interfaces. D. Automating backups. Answer: A Explanation: Six Sigma uses statistical tools to identify and eliminate sources of variation, aiming for near‑perfect quality. Question 20. In the project lifecycle of a BI implementation, the phase that primarily produces the data model and ETL design is: A) Planning B) Design C) Deployment D) Maintenance Answer: B Explanation: The design phase defines architecture, data models, and ETL processes before building the system.
Answer: B Explanation: Power BI is a Microsoft product that leverages DAX and integrates tightly with Excel and other Office apps. Question 24. A key advantage of using Tableau over traditional reporting tools is: A) Native support for DAX. B) Highly interactive visual analytics with drag‑and‑drop interface. C) Requirement for extensive coding. D) Lack of data connector options. Answer: B Explanation: Tableau emphasizes user‑friendly, interactive visualizations that can be built without programming. Question 25. Documentation of dashboard specifications should include all EXCEPT: A) Data source definitions. B) Visual layout and user interactions. C) Detailed source code of the underlying ETL scripts. D) Security and access requirements. Answer: C Explanation: While ETL documentation is important, the dashboard spec focuses on reporting elements, not full source code. Question 26. Row‑Level Security (RLS) in a BI system is used to:
A) Encrypt data at rest. B) Restrict data visibility so users see only rows they are authorized to view. C) Speed up query performance. D. Backup the database daily. Answer: B Explanation: RLS applies filters at the row level based on user identity, limiting data exposure. Question 27. Which compliance framework specifically addresses the protection of health‑related personal information in the United States? A) GDPR B) HIPAA C) PCI‑DSS D) SOX Answer: B Explanation: The Health Insurance Portability and Accountability Act (HIPAA) governs PHI privacy and security. Question 28. Social media analytics can provide which of the following benefits to a business? A) Direct control over competitor pricing. B) Real‑time sentiment analysis to gauge brand perception. C) Automatic generation of financial statements. D) Replacement of all traditional market research.
A) Amazon Web Services (AWS) B) Google Cloud Platform (GCP) C) Microsoft Azure D) IBM Cloud Answer: C Explanation: Azure Analysis Services is part of Microsoft Azure and provides cloud‑based tabular modeling capabilities. Question 32. A key consideration when moving a BI solution from on‑premises to the cloud is: A) The need for a larger physical server rack. B) Network latency and data egress costs. C. The color of the server room walls. D. The brand of coffee in the break room. Answer: B Explanation: Cloud migration introduces latency and potential costs for moving data out of the cloud, impacting performance and budgeting. Question 33. In the context of AI‑enhanced BI, “forecasting” typically relies on which type of algorithm? A) Sorting algorithms B) Time‑series models (e.g., ARIMA, Prophet) C) Binary search D) Hashing functions
Answer: B Explanation: Time‑series forecasting algorithms predict future values based on historical patterns. Question 34. Which of the following is NOT a typical characteristic of a well‑designed KPI? A) Aligned with strategic objectives. B) Measurable and quantifiable. C) Ambiguous and open‑ended. D) Actionable. Answer: C Explanation: KPIs should be clear and specific; ambiguity defeats their purpose. Question 35. The term “metadata repository” most accurately refers to: A) A database that stores raw transaction data. B) A centralized location that holds metadata definitions for all data assets. C) A backup archive for source files. D. An email inbox for data requests. Answer: B Explanation: A metadata repository catalogs information about data sources, structures, lineage, and business definitions. Question 36. Which ETL tool is known for its visual, drag‑and‑drop workflow designer and strong integration with Microsoft products? A) Informatica PowerCenter
Explanation: Data lineage tracks the flow and transformations of data, enabling traceability and impact analysis. Question 39. A “heat map” visualization is most effective for: A) Showing hierarchical relationships. B) Displaying the intensity of values across two dimensions (e.g., region vs. product). C. Plotting a single time series. D. Enumerating categorical counts. Answer: B Explanation: Heat maps use color gradients to represent value intensity across a matrix of categories. Question 40. Which security principle ensures that users receive only the minimum privileges required to perform their job functions? A) Defense in depth B. Least privilege C. Single sign‑on D. Data masking Answer: B Explanation: The least‑privilege principle limits access rights to the bare minimum needed. Question 41. When integrating social media data into a BI platform, the most common data format encountered is: A. XML B. JSON
C. CSV
D. Parquet Answer: B Explanation: Social APIs (Twitter, Facebook, LinkedIn) typically return data in JSON format. Question 42. Which of the following is a primary benefit of using a “semantic layer” in a BI architecture? A. Direct access to raw tables for end users. B. Providing business‑friendly terminology and calculations independent of underlying data structures. C. Encrypting all data at rest. D. Automating hardware provisioning. Answer: B Explanation: A semantic layer abstracts technical details, allowing users to interact with familiar business terms. Question 43. In Power BI, the “Publish to Web” feature primarily raises concerns related to: A. Data refresh speed. B. Unauthorized public access to potentially sensitive data. C. Licensing costs. D. Mobile device compatibility. Answer: B Explanation: Publishing to the web creates a publicly accessible link, which can expose confidential information if not managed properly.
Answer: B Explanation: Spark can process big data, and notebooks allow interactive exploration of semi‑structured data. Question 47. In a BI governance framework, the “data steward” is primarily responsible for: A. Writing application code. B. Ensuring data quality, definitions, and compliance across the organization. C. Managing network firewalls. D. Designing user interface themes. Answer: B Explanation: Data stewards oversee data assets, enforce standards, and maintain quality. Question 48. Which of the following best describes “drill‑through” functionality in a dashboard? A. Exporting data to Excel. B. Navigating from a summary visual to a detailed report filtered on the selected item. C. Changing the color palette of the visual. D. Scheduling automatic email distribution. Answer: B Explanation: Drill‑through lets users click a summary element to see underlying detailed data. Question 49. When implementing AI‑based anomaly detection, a common pitfall is: A. Using too many data sources.
B. Setting overly sensitive thresholds that generate false positives. C. Storing data in CSV files. D. Deploying on a local workstation. Answer: B Explanation: Excessively low thresholds cause many false alerts, reducing trust in the system. Question 50. Which of the following is NOT a typical component of a BI “technology stack”? A. Data source connectors B. Data modeling layer C. Business process re‑engineering (BPR) methodology D. Visualization layer Answer: C Explanation: BPR is a process improvement discipline, not a technical component of the BI stack. Question 51. In the context of data privacy, “data minimization” means: A. Storing as much data as possible for future use. B. Collecting and retaining only the data necessary for a specific purpose. C. Encrypting all data at rest. D. Replicating data across multiple regions. Answer: B Explanation: Data minimization limits collection and retention to reduce privacy risk.
