70-464 Exam - Question 67

Question

You need to implement a change to usp_ExportOpenings that meets the integration requirements.

What should you modify in usp_ExportOpenings? (Each correct answer presents part of the solution. Choose all that apply?)

Examice · Accepted Answer

To meet the integration requirements for usp_ExportOpenings, one approach involves leveraging XML capabilities within SQL Server. This can enhance interoperability with systems that consume XML data. Specifically, adding FOR XML AUTO to line 10 enables automatic generation of XML from query results in a nested format, useful for preserving relational data structures. Incorporating [Opening] at the end of line 04 and [Opening! title] at the end of line 05 helps in accurately mapping relational attributes to XML elements, ensuring the output is well-structured and meaningful. These modifications collectively facilitate the desired XML integration.

LiamLin · Answer

This is the result :D
SELECT
    Title AS [Opening],
    FirstName AS [Opening!FirstName], 
    LastName AS [Opening!LastName]   
FROM Person.Person
WHERE FirstName = 'Gustavo'
FOR XML AUTO

LiamLin · Answer

SELECT 
   FirstName AS [Opening/@FirstName], 
   LastName AS [Opening/@LastName],
   Title AS [Opening]
FROM
    Person.Person
WHERE FirstName = 'Gustavo'
FOR XML PATH ('');

SELECT    
    1 AS  Tag,
    NULL AS  Parent,
    Title AS [Opening!1!],
    FirstName AS [Opening!1!FirstName], 
    LastName AS [Opening!1!LastName]   
FROM Person.Person
WHERE FirstName = 'Gustavo'
FOR XML EXPLICIT

70-464 Exam - Question 67

Discussion