Data and Analytics Business Intelligence 2

Question 1

What is a fact table in a data warehouse?

Accepted Answer

A central table storing measurable, numeric business metrics and foreign keys to dimensions

Answer

A table containing only textual descriptions

Answer

A lookup table for product codes

Answer

A table containing database configuration settings

Question 2

What is a snowflake schema in data warehousing?

Accepted Answer

A variation of the star schema where dimension tables are normalized into sub-dimensions

Answer

A schema designed for cold storage data

Answer

A schema with no fact tables

Answer

A star schema with only one dimension

Question 3

What is the purpose of a BI semantic layer?

Accepted Answer

To provide a business-friendly abstraction layer between raw data and end users

Answer

To encrypt business data for security

Answer

To store raw transaction data

Answer

To manage cloud infrastructure

Question 4

What is ad hoc reporting in business intelligence?

Accepted Answer

Custom, on-demand reports created by users to answer specific questions

Answer

Scheduled reports generated automatically at fixed intervals

Answer

Reports generated by AI without user input

Answer

Standard reports built by IT departments

Question 5

What does 'self-service BI' mean?

Accepted Answer

Empowering business users to access, analyze, and visualize data without IT assistance

Answer

BI tools that don't require vendor support

Answer

Automated reporting without any human involvement

Answer

BI systems that manage their own infrastructure

Question 6

What is data governance in a BI context?

Accepted Answer

The framework of policies, processes, and standards ensuring data quality, security, and proper use

Answer

Government regulations about data storage

Answer

Technical controls on database access

Answer

A reporting process mandated by auditors