Microsoft
70-451 · Question #142
70-451 Question #142: Real Exam Question with Answer & Explanation
The correct answer is A. Create one table that contains the hierarchyid data type.. See the full explanation below for the reasoning.
Question
You need to create an application that will represent the relationship between managers and employees. You must achieve this goal by using the minimum amount of tables. What should you do?
Options
- ACreate one table that contains the hierarchyid data type.
- BCreate one table that contains the uniqueidentifer data type.
- CCreate two tables. Establish a foreign key relationship between the tables.
- DCreate two tables. Create a trigger that maintains the relationship between the two tables.
Community Discussion
No community discussion yet for this question.