⚡️ Pass with Confidence Sale - 40% off ALL packages! ⚡️

2 days, 4 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

Your organization is designing a star schema for its e-commerce data warehouse. The model includes a very large Sales fact table that must join to a Product dimension table containing thousands of descriptive attributes (brand, category, size, color, etc.). To follow dimensional-modeling best practices and minimize storage and join costs in the fact table, which primary-key strategy is most appropriate for the Product dimension table?

  • A globally unique identifier (GUID) assigned by the e-commerce application

  • A concatenated natural key made of SupplierID and ManufacturerPartNumber

  • A composite key of ProductSKU combined with EffectiveStartDate and EffectiveEndDate

  • An auto-incrementing integer surrogate key generated within the data warehouse

CompTIA Data+ DA0-002 (V2)
Data Concepts and Environments
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot