Microsoft
70-451 · Question #31
70-451 Question #31: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #31. 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. A database contains a table named Employee_Vacation. You are given an updated list of employee vacations used. The list is in an XML formatted file. The extract of the XML format is written in the following manner. <Company Name ="ABC Company Pvt Ltd"> <EmployeeLeave> <Employee ID = "1" Name="Jim Reeves" /> <Leaves> <Leave Date="2008-02-12" /> <Leave Date="2008-02-13" /> <Leave Date="2008-02-14" /> </Leaves> </EmployeeLeave> You plan to import the data and update the Employee_Vacation table. You design a query to calculate the number of vacation days used by each employee. You need to ensure that vacation days are accurately counted for each employee. What should you do?
Options
- AUse an XQuery expression along with the LET clause and the count function.
- BUse an XML index. Aggregate the number of vacation days for each employee, and then
- CUse the OPENXML function to convert XML data into a standard table format.
- DUse an XQuery expression to write the information from XML format to a SQL Server table.
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.