🔥 40% Off Crucial Exams Memberships — This Week Only

3 days, 7 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

An insurance company is building a star-schema warehouse to analyze claim payments. The Claims_Fact table must keep one row per claim that stores the total amount paid. Because a single claim may involve several adjusters-and each adjuster can work on many claims-business users also need to filter and group claim costs by adjuster without inflating the overall totals.

Which modeling technique will best satisfy these requirements while preserving the one-row-per-claim grain of the fact table?

  • Store a comma-separated list of all AdjusterIDs in a single column inside Claims_Fact.

  • Create a bridge (association) table that lists each ClaimID-AdjusterID combination and join it between Claims_Fact and the Adjuster dimension.

  • Snowflake the Adjuster dimension into master-detail tables and join the master table directly to Claims_Fact.

  • Insert a duplicate row in Claims_Fact for every adjuster on the claim and divide the paid amount equally among the duplicates.

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