Microsoft
70-451 · Question #131
70-451 Question #131: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #131. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to create a database by using SQL Server 2008. The database has a table named Employees. The table contains records of employees and their managers. The table includes the EmployeelD and ManagerlD fields. The EmployeelD values are unique. The value in the ManagerlD field is the employee ID of the employee's manager. A Web site requires XML formatted output of all managers and employees to be displayed as a tree diagram. You need to produce the required output by querying the database without using system stored procedures. What should you do?
Options
- ACreate a table-valued function by using the hierarchyid data type.
- BCreate a scalar-valued function by using the FOR XML PATH clause and the TYPE directive.
- CCreate a scalar-valued function by using the OPENXML () function.
- DCreate a table-valued function by using a common table expression (CTE).
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.