Microsoft
70-451 · Question #129
You are designing a new database. The tables of the database will be replicated to multiple offices. You need to design the tables to meet the following requirements: - A row identifier must be set…
The correct answer is D. Add a column to all the tables that have a uniqueidentifier data type. See the full explanation below for the reasoning.
Question
You are designing a new database. The tables of the database will be replicated to multiple offices. You need to design the tables to meet the following requirements:
- A row identifier must be set when a row is created
- The row identifier must be unique across the entire organization
What should you recommend?
Options
- AAdd a column to all the tables that have the hierarchyid data type.
- BAdd a column to all the tables that have a time data type.
- CAdd a column to all the tables that have the identity property.
- DAdd a column to all the tables that have a uniqueidentifier data type.
How the community answered
(59 responses)- A15% (9)
- B3% (2)
- C5% (3)
- D76% (45)
Community Discussion
No community discussion yet for this question.