Data and Analytics Business Intelligence 3

Question 1

What is a balanced scorecard in business analytics?

Accepted Answer

A strategic management tool measuring performance across financial, customer, process, and learning dimensions

Answer

A SQL query performance benchmark

Answer

A type of database normalization

Answer

A dashboard showing only financial KPIs

Question 2

What is the purpose of a data catalog in modern BI?

Accepted Answer

A searchable inventory of data assets with metadata, definitions, and lineage information

Answer

A physical storage system for data backups

Answer

A catalog of BI report templates

Answer

A system for archiving old reports

Question 3

What is predictive analytics?

Accepted Answer

Using historical data and statistical models to forecast future outcomes

Answer

Analyzing what happened in the past

Answer

Creating real-time dashboards

Answer

Describing current business conditions

Question 4

What is prescriptive analytics?

Accepted Answer

Recommending specific actions to achieve desired outcomes based on data models

Answer

Analyzing past performance data

Answer

Describing the current state of business

Answer

Predicting what will happen next quarter

Question 5

What is the role of a data steward in a BI organization?

Accepted Answer

To manage data quality, definitions, and governance policies for assigned data domains

Answer

To write SQL queries for analysts

Answer

To build ETL pipelines

Answer

To manage cloud infrastructure

Question 6

What is a data mart?

Accepted Answer

A subset of a data warehouse focused on a specific business function or department

Answer

A marketplace for buying and selling data

Answer

A real-time streaming database

Answer

A type of OLTP database