IKM Data Analysis and Business Intelligence

Question 1

Which type of data analysis focuses on understanding what happened in the past by examining historical data?

Accepted Answer

Descriptive analysis

Answer

Predictive analysis

Answer

Prescriptive analysis

Answer

Diagnostic analysis

Question 2

In a data warehouse, what is a 'fact table'?

Accepted Answer

A table that stores the measurable, quantitative data for analysis

Answer

A table that stores descriptive attributes about dimensions

Answer

A table that records data transformations applied during ETL

Answer

A table that stores user access permissions

Question 3

What does ETL stand for in the context of data warehousing?

Accepted Answer

Extract, Transform, Load

Answer

Evaluate, Test, Launch

Answer

Export, Transfer, Log

Answer

Execute, Track, Link

Question 4

A KPI dashboard shows sales are 15% below target. Which analytical step should be taken next to investigate further?

Accepted Answer

Diagnostic analysis to identify root causes of the shortfall

Answer

Prescriptive analysis to automate a corrective action

Answer

Descriptive analysis to create another summary report

Answer

Predictive analysis to forecast next quarter's sales

Question 5

What is a 'dimension table' in a star schema data model?

Accepted Answer

A table containing descriptive attributes used to filter or group facts

Answer

A table containing numeric metrics such as revenue or quantity

Answer

A table that stores the time-series sequence of fact records

Answer

A table that maps foreign keys between multiple fact tables

Question 6

Which of the following best describes 'data normalization' in relational database design?

Accepted Answer

Organizing data to reduce redundancy and improve data integrity

Answer

Scaling all numeric values to a 0–1 range for statistical analysis

Answer

Converting unstructured text data into structured table format

Answer

Encrypting sensitive fields to comply with data privacy regulations

Question 7

In business intelligence, what is the purpose of OLAP (Online Analytical Processing)?

Accepted Answer

To enable fast, multi-dimensional analysis of large data sets from multiple perspectives

Answer

To process individual transactional records in real time for operational systems

Answer

To automate the extraction of data from external web sources via APIs

Answer

To enforce row-level security on BI dashboards for different user roles