DAC DAC Business Intelligence & Analytics Strategy 1

Question 1

What is a Key Performance Indicator (KPI) in business analytics?

Accepted Answer

A measurable value that demonstrates how effectively an organization is achieving key business objectives

Answer

A type of database schema used in data warehouses

Answer

A visualization technique for comparing multiple datasets

Answer

An algorithm used in predictive analytics

Question 2

What distinguishes descriptive analytics from predictive analytics?

Accepted Answer

Descriptive analytics summarizes historical data; predictive analytics forecasts future outcomes

Answer

Descriptive analytics uses machine learning; predictive analytics uses SQL

Answer

Descriptive analytics is more accurate than predictive analytics

Answer

Predictive analytics only works with structured data

Question 3

What is a data warehouse in a business intelligence context?

Accepted Answer

A subject-oriented, integrated repository of historical data optimized for analytical queries

Answer

A physical server room where databases are stored

Answer

A real-time streaming data pipeline

Answer

A tool for creating interactive dashboards

Question 4

Which of the following is an example of prescriptive analytics?

Accepted Answer

An optimization model recommending the best pricing strategy to maximize revenue

Answer

A report showing last quarter's sales by region

Answer

A forecast predicting next month's customer churn rate

Answer

A dashboard displaying current website traffic

Question 5

What is the purpose of a data mart in a BI architecture?

Accepted Answer

To provide a department-specific subset of a data warehouse focused on a particular subject area

Answer

To store raw unprocessed data before ETL

Answer

To replace the data warehouse for smaller organizations

Answer

To serve as a real-time operational database

Question 6

In BI, what does a star schema consist of?

Accepted Answer

A central fact table surrounded by denormalized dimension tables

Answer

Multiple interconnected fact tables with no dimension tables

Answer

A normalized relational schema with many foreign key joins

Answer

A flat file structure without primary keys