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 fact table stores quantitative business metrics (like sales revenue or order quantity) along with foreign keys linking to dimension tables.

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 snowflake schema normalizes dimension tables into multiple related tables, reducing redundancy at the cost of more complex joins.

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

A semantic layer translates technical database structures into business terms, allowing non-technical users to query data using familiar business concepts.

Question 4

What is ad hoc reporting in business intelligence?

Accepted Answer

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

Answer

Ad hoc reporting allows business users to create custom, one-time reports on demand without relying on IT, using self-service BI tools.

Question 5

What does 'self-service BI' mean?

Accepted Answer

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

Answer

Self-service BI enables non-technical business users to create reports, dashboards, and analyses without depending on IT or data engineers.

Data and Analytics Practice Test

Data and Analytics Practice Test

Data and Analytics Business Intelligence 2