DA0-001 · Question #409
A data architect is designing a data solution for a retail clothing store chain. Each store has a database that tracks sales transactions. The data architect needs to create a summary table that…
The correct answer is D. A unique constraint. A unique constraint ensures that no duplicate values exist in a specified column of a table. This is essential for creating summary tables where each store should only appear once in the dataset.
Question
A data architect is designing a data solution for a retail clothing store chain. Each store has a database that tracks sales transactions. The data architect needs to create a summary table that will be used for a senior executive dashboard. The summary table should not contain duplicate store information. Which of the following should the data architect create?
Options
- AA check constraint
- BA primary key
- CA foreign key
- DA unique constraint
How the community answered
(44 responses)- A11% (5)
- B2% (1)
- C7% (3)
- D80% (35)
Explanation
A unique constraint ensures that no duplicate values exist in a specified column of a table. This is essential for creating summary tables where each store should only appear once in the dataset.
Topics
Community Discussion
No community discussion yet for this question.