DA0-001 · Question #547
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 B. A primary key. A primary key ensures that each record in the summary table is unique, preventing duplicate store information while providing a reliable identifier for each store.
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
(57 responses)- A4% (2)
- B93% (53)
- C2% (1)
- D2% (1)
Explanation
A primary key ensures that each record in the summary table is unique, preventing duplicate store information while providing a reliable identifier for each store.
Topics
Community Discussion
No community discussion yet for this question.