Data and Analytics Business Intelligence

Question 1

What is OLAP in business intelligence?

Accepted Answer

Online Analytical Processing for multidimensional analysis

Answer

OLAP (Online Analytical Processing) enables fast, multidimensional analysis of large datasets by organizing data into cubes for slicing, dicing, and drilling.

Question 2

What is a star schema in data warehousing?

Accepted Answer

A central fact table connected to multiple dimension tables

Answer

A star schema has a central fact table containing measurable metrics connected to multiple denormalized dimension tables, optimized for analytical queries.

Question 3

What is the difference between OLTP and OLAP systems?

Accepted Answer

OLTP handles real-time transactions; OLAP handles analytical queries on historical data

Answer

OLTP (Online Transaction Processing) systems handle high-volume day-to-day transactions, while OLAP systems are optimized for complex analytical queries on historical data.

Question 4

What is a dimension table in a data warehouse?

Accepted Answer

A table storing descriptive attributes used to filter and group fact data

Answer

Dimension tables contain descriptive attributes (like customer name, product category, or date) used to provide context and filtering for measures in fact tables.

Question 5

What is a slowly changing dimension (SCD) in data warehousing?

Accepted Answer

A technique for managing historical changes to dimension attributes over time

Answer

SCD (Slowly Changing Dimension) is a method for handling changes to dimension attributes over time, preserving history of how values changed.

Data and Analytics Practice Test

Data and Analytics Practice Test

Data and Analytics Business Intelligence