Microsoft
70-451 · Question #10
70-451 Question #10: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
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.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.