Download ALBERTA BUSINESS INTELLIGENCE ANALYST EXAM and more Exams International Business in PDF only on Docsity!
ALBERTA BUSINESS INTELLIGENCE ANALYST EXAM
QUESTIONS AND CORRECT ANSWER (VERIFIED
ANSWERS) PLUS RATIONALE 2026 Q&A|INSTANT
DOWNLOAD PDF
1 – 15: BI Fundamentals
1. Business Intelligence focuses on: A. Gaming systems B. Data-driven decision making C. Hardware design D. Networking Answer: B Rationale: BI converts data into actionable insights. 2. BI systems primarily use: A. Random data B. Historical data C. Images only D. Audio only Answer: B Rationale: BI relies on past and current data. 3. KPI stands for: A. Key Process Indicator B. Key Performance Indicator C. Knowledge Performance Index D. Key Program Input Answer: B Rationale: Measures business performance.
4. BI dashboards are used for: A. Training models B. Data visualization C. Image editing D. Coding Answer: B Rationale: Visual representation of KPIs. 5. OLAP stands for: A. Online Analytical Processing B. Offline Analytical Processing C. Online Application Protocol D. Operational Layer Access Process Answer: A Rationale: Analytical data processing. 6. OLTP is used for: A. Analytics B. Transactions C. Dashboards D. Visualization Answer: B Rationale: Real-time transaction systems. 7. BI tools include: A. TensorFlow B. Power BI C. PyTorch D. OpenCV Answer: B Rationale: Popular BI visualization tool. 8. Data warehouse stores: A. Raw logs only
D. Training models Answer: B Rationale: Improves data quality.
13. BI insights are mainly used by: A. Developers only B. Business decision makers C. Hardware engineers D. Gamers Answer: B Rationale: Supports decision making. 14. Dashboards typically show: A. Code B. KPIs and metrics C. Images D. Audio Answer: B Rationale: Business performance view. 15. Data-driven decision making means: A. Guessing B. Using data evidence C. Random choices D. Manual coding Answer: B Rationale: Evidence-based decisions. **16 – 35: SQL & Data Querying
- SQL is used for:** A. Image processing B. Querying structured data C. Video editing D. AI training
Answer: B Rationale: Database querying language.
17. SELECT statement is used to: A. Delete data B. Retrieve data C. Encrypt data D. Update hardware Answer: B Rationale: Fetches data from tables. 18. WHERE clause filters: A. Columns B. Rows C. Databases D. Servers Answer: B Rationale: Filters records. 19. GROUP BY is used for: A. Sorting B. Aggregation C. Deleting D. Encryption Answer: B Rationale: Groups data for aggregation. 20. JOIN combines: A. Tables B. Images C. Files D. Models Answer: A Rationale: Merges related tables.
25. Foreign key links: A. Files B. Tables C. Images D. Models Answer: B Rationale: Relationship between tables. **36 – 60: Data Warehousing & Modeling
- Star schema contains:** A. Only one table B. Fact and dimension tables C. Images D. Logs only Answer: B Rationale: BI modeling structure. 27. Fact table stores: A. Descriptions B. Numeric metrics C. Images D. Metadata only Answer: B Rationale: Quantitative data. 28. Dimension table stores: A. Metrics B. Descriptive attributes C. KPIs D. Logs Answer: B Rationale: Contextual information.
29. Snowflake schema is: A. Flattened structure B. Normalized star schema C. No schema D. Random model Answer: B Rationale: More normalization. 30. ETL tools include: A. Power BI B. Informatica C. Excel only D. Chrome Answer: B Rationale: Data pipeline tools. 31. Data warehouse is optimized for: A. Transactions B. Analytics C. Gaming D. Storage only Answer: B Rationale: Analytical queries. 32. Data mart is: A. Enterprise-wide system B. Department-focused warehouse C. AI model D. API system Answer: B Rationale: Subset of warehouse. 33. Slowly Changing Dimensions handle: A. Images
C. CPU
D. Cloud server Answer: B Rationale: Data visualization platform.
38. KPI dashboard shows: A. Code B. Business metrics C. Images D. Audio Answer: B Rationale: Performance tracking. 39. Pie charts are best for: A. Trends B. Proportions C. Time series D. Logs Answer: B Rationale: Percentage distribution. 40. Line charts show: A. Categories B. Trends over time C. Images D. Tables Answer: B Rationale: Time-based analysis. **86 – 100: Advanced BI & Governance
- Data governance ensures:** A. Chaos B. Data quality and control C. Faster GPUs
D. Random data Answer: B Rationale: Data management rules.
42. Data lineage tracks: A. Images B. Data origin and flow C. CPUs D. UI Answer: B Rationale: Traceability. 43. Data quality dimensions include: A. Speed only B. Accuracy, completeness C. GPU power D. Storage size Answer: B Rationale: Data reliability. 44. Data profiling is used to: A. Delete data B. Understand data structure C. Encrypt data D. Train models Answer: B Rationale: Data analysis. 45. BI automation reduces: A. Efficiency B. Manual reporting C. Data storage D. KPIs
Answer: A Rationale: Predict outcomes.
50. Prescriptive analytics suggests: A. Past data B. Actions C. Images D. Files Answer: B Rationale: Decision recommendations. **51 – 60: Advanced SQL & Analytics
- A window function in SQL is used for:** A. Deleting tables B. Performing calculations across a set of rows C. Encrypting data D. Creating databases Answer: B Rationale: Window functions compute analytics without collapsing rows. 52. ROW_NUMBER() is used to: A. Delete duplicates B. Assign unique row ranking C. Merge tables D. Encrypt values Answer: B Rationale: Generates sequential numbering. 53. CTE stands for: A. Common Table Expression B. Central Table Engine C. Computed Transfer Entry D. Column Table Entity Answer: A Rationale: Temporary named result set.
54. A subquery is: A. A full database B. Query inside another query C. A dashboard D. A table join only Answer: B Rationale: Nested SQL query. 55. HAVING clause is used to filter: A. Rows before grouping B. Groups after aggregation C. Tables D. Databases Answer: B Rationale: Works with GROUP BY results. 56. INDEX in SQL improves: A. Storage cost B. Query performance C. Data deletion D. Encryption Answer: B Rationale: Speeds up lookups. 57. COUNT() returns:* A. Column count B. Total rows C. Tables D. Databases Answer: B Rationale: Counts all rows.
62. Dimension tables store: A. Metrics B. Descriptive attributes C. KPIs only D. Logs Answer: B Rationale: Context for analysis. 63. Star schema is: A. Highly normalized B. Central fact table with dimensions C. No structure D. Random model Answer: B Rationale: Simple BI design. 64. Snowflake schema is: A. Denormalized B. Normalized star schema C. Flat file D. No schema Answer: B Rationale: More structured dimensions. 65. Slowly Changing Dimension (SCD) tracks: A. Images B. Historical changes C. CPU usage D. Logs only Answer: B Rationale: Time-based changes. 66. OLAP cubes support: A. Transactions
B. Multidimensional analysis C. UI design D. File storage Answer: B Rationale: Analytical structure.
67. Drill-down means: A. Summarizing data B. Viewing detailed data C. Deleting data D. Encrypting data Answer: B Rationale: Moving from summary to detail. 68. Roll-up means: A. Detail view B. Aggregation C. Deletion D. Encryption Answer: B Rationale: Summarization in OLAP. 69. Data mart is: A. Full warehouse B. Department-specific subset C. ML model D. API Answer: B Rationale: Focused data store. 70. ETL process includes: A. Extract, Transform, Load B. Encode Train Learn C. Execute Transfer Log
Answer: B Rationale: Part-to-whole relationships.
75. Line charts show: A. Categories B. Trends over time C. Images D. Tables Answer: B Rationale: Time series visualization. 76. Bar charts are used for: A. Continuous trends B. Comparing categories C. Audio data D. Logs Answer: B Rationale: Category comparison. 77. Heatmaps show: A. Text B. Intensity of values C. Audio D. Code Answer: B Rationale: Density visualization. 78. Dashboards are used by: A. Developers only B. Business users C. Hardware engineers D. Gamers Answer: B Rationale: Decision support.
79. BI reporting focuses on: A. Code execution B. Business summaries C. GPU processing D. ML training Answer: B Rationale: Reporting insights. 80. Data storytelling means: A. Writing code B. Communicating insights with visuals C. Encrypting data D. Deleting logs Answer: B Rationale: Narrative analytics. **81 – 90: Data Quality & Governance
- Data quality includes:** A. Speed only B. Accuracy, completeness C. GPU power D. Storage only Answer: B Rationale: Reliable data. 82. Data governance ensures: A. Chaos B. Controlled data usage C. Faster CPU D. Random storage Answer: B Rationale: Data management rules.
