Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

During a star-schema redesign, you are asked to modify the Customer dimension so that analysts can compare sales using the attributes that were valid at the time of each purchase (for example, the customer's region on the sale date). The data team is comfortable generating surrogate keys and adding effective and end-date columns, and they do not want to overwrite or delete historical rows. Which slowly changing dimension technique best satisfies these requirements?

  • Type 4 - maintain a separate history table while the main table holds the current row

  • Type 2 - insert a new row with a new surrogate key and effective-date range for every change

  • Type 1 - overwrite the existing row so only the current state is kept

  • Type 3 - add additional columns to store the previous value, keeping only limited history

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