Microsoft
70-451 · Question #10
You are a database developer. You plan to design a database solution by using SQL Server 2008. You create a table that contains information about Web pages that are added to a Web site. The Web site…
The correct answer is B. Use the hierarchyid data type. See the full explanation below for the reasoning.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. You create a table that contains information about Web pages that are added to a Web site. The Web site has a home page and contains various other Web pages. The home page is the root page of the site. All pages except the root page have a link to an upper-level page. The table must support the following design considerations:
- Records of the Web pages that are linked to a particular page can be
quickly retrieved.
- The position of a Web page in a collection of linked pages can be
quickly retrieved.
- Changing the links to the upper-level pages is a rare requirement.
You need to ensure that the table is designed appropriately. What should you use?
Options
- AUse the XML data type.
- BUse the hierarchyid data type.
- CUse a Parent/Child mechanism that references the same table.
- DUse a Parent/Child mechanism that references one or more additional tables.
How the community answered
(50 responses)- A4% (2)
- B74% (37)
- C14% (7)
- D8% (4)
Community Discussion
No community discussion yet for this question.