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?)
A.
To the end of line 04, add [Opening].
B.
To the end of line 05, add [Opening! title].
C.
To line 10, add FOR XML RAW.
D.
To line 10, add FOR XMLEXPLICIT.
E.
To line 10, add FOR XML AUTO.
F.
To the end of line 04, add [Opening!ELEMENT].
G.
To the end of line 06, add [Opening!salary!ELEMENT].
H.
To the end of line 05, add [Opening!title!ELEMENT].
Suggested Answer:ABEI🗳️
The AUTO mode generates nesting in the resulting XML by using heuristics based on the way the SELECT statement is specified. You have minimal control over the shape of the XML generated. The nested FOR XML queries can be written to generate XML hierarchy beyond the XML shape that is generated by AUTO mode heuristics.
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
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
<Person.Person Opening="Mr." Opening_x0021_FirstName="Gustavo" Opening_x0021_LastName="Achong" />
<Person.Person Opening="Sr." Opening_x0021_FirstName="Gustavo" Opening_x0021_LastName="Camargo" />
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.70-464 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
LiamLin
3 years, 9 months agoLiamLin
3 years, 9 months ago