CompTIA Data+ DA0-002 (V2) Practice Question

The correct answer is a fact table. In a dimensional model like a star schema, the fact table is the central table that stores quantitative measurements or metrics about a business process. In this scenario, the quantity_sold and sale_amount are the facts. The fact table also contains foreign keys that connect to the primary keys of the surrounding dimensional tables (Date, Product, and Store), which provide context to the facts.

• A dimensional table stores the descriptive attributes related to the facts, such as product names, store addresses, or customer details, not the quantitative transactional data itself.
• A bridge table is a specific type of table used to resolve many-to-many relationships between a fact and a dimension or between two dimensions, which is not the primary purpose described in the scenario.
• A staging table is a temporary storage area used during the ETL (Extract, Transform, Load) process to clean and prepare data before it is loaded into the final destination, like a data warehouse. It is not a permanent part of the analytical schema.