Data and Analytics Business Intelligence

Question 1

What is OLAP in business intelligence?

Accepted Answer

Online Analytical Processing for multidimensional analysis

Answer

Online Linear Analytics Processing

Answer

Operational Lookup and Aggregation Protocol

Answer

Object-Level Analytics Platform

Question 2

What is a star schema in data warehousing?

Accepted Answer

A central fact table connected to multiple dimension tables

Answer

A schema with multiple fact tables connected to each other

Answer

A schema using only a single table

Answer

A database schema designed for transactional processing

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 handles reporting; OLAP handles transactions

Answer

OLTP is cloud-based; OLAP is on-premise

Answer

OLTP uses NoSQL; OLAP uses relational databases only

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

A table storing numerical measures like sales amount

Answer

A lookup table for database indexes

Answer

A table containing raw transactional data

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

A dimension whose values change very slowly due to database performance issues

Answer

A dimension table with few records

Answer

A real-time dimension updated every second

Question 6

What does 'drill down' mean in OLAP analysis?

Accepted Answer

Moving from a summary view to a more detailed level of data

Answer

Removing data from a report

Answer

Combining multiple data sources

Answer

Filtering data by a specific dimension