adplus-dvertising
frame-decoration

Question

What is the primary purpose of the fact table in a dimensional model?

a.

To hold business dimensions

b.

To store measurement or metric data

c.

To contain attribute information

d.

To facilitate query optimization

Answer: (b).To store measurement or metric data Explanation:The fact table holds measurement or metric data for analysis.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What is the primary purpose of the fact table in a dimensional model?

Similar Questions

Discover Related MCQs

Q. What is the main role of the product dimension table in a dimensional model?

Q. How are dimension tables typically formed in a dimensional model?

Q. What is the primary purpose of arranging fact and dimension tables in a dimensional model?

Q. What type of relationship exists between dimension tables and the fact table in a STAR schema?

Q. Which of the following criteria does the STAR schema aim to satisfy?

Q. How are dimension tables arranged around the fact table in a STAR schema?

Q. In the STAR schema, what type of relationship exists between the fact table and dimension tables?

Q. What is the primary focus of Entity-Relationship (E-R) modeling?

Q. What is the main purpose of a data warehouse (DW)?

Q. In the context of data warehouses, what does dimensional modeling emphasize?

Q. What are the primary characteristics of data suited for E-R modeling in operational systems?

Q. Which modeling technique is particularly intuitive to business users?

Q. What can CASE tools be used for in data modeling?

Q. In the context of data modeling for data warehouses, what is a STAR schema?

Q. What does forward-engineering in data modeling involve?

Q. What is the primary purpose of a STAR schema in a data warehouse?

Q. In a STAR schema, which part of the structure is used to answer specific business questions?

Q. How are queries formulated in a STAR schema when analyzing data?

Q. What does a STAR schema provide an intuitive view of?

Q. How does a STAR schema support drill-down analysis?