Microsoft
70-433 · Question #171
You are a database developer working on an application hosted on Microsoft SQL Server 2008 R2. The application regularly imports employee data from XML files. These files are bulk- loaded into the…
The correct answer is C. Option C. See the full explanation below for the reasoning.
Question
You are a database developer working on an application hosted on Microsoft SQL Server 2008 R2. The application regularly imports employee data from XML files. These files are bulk- loaded into the CompanyDoc column of the CompanyXML table. The table the following definition:
You need to be able to return the data as shown in the following table:
Which Transact-SQL statements should you use?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(35 responses)- A3% (1)
- B6% (2)
- C80% (28)
- D11% (4)
Community Discussion
No community discussion yet for this question.