Exam 70-761 topic 1 question 59 discussion

Actual exam question from Microsoft's 70-761

Question #: 59
Topic #: 1

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You create a table by running the following Transact-SQL statement:

You need to develop a query that meets the following requirements:
✑ Output data by using a tree-like structure.
✑ Allow mixed content types.
✑ Use custom metadata attributes.
Which Transact-SQL statement should you run?

A.

B.

C.

D.

E.

F.

G.

H.

Show Suggested Answer

Suggested Answer: F
In a FOR XML clause, you specify one of these modes: RAW, AUTO, EXPLICIT, and PATH.
✑ The EXPLICIT mode allows more control over the shape of the XML. You can mix attributes and elements at will in deciding the shape of the XML. It requires a specific format for the resulting rowset that is generated because of query execution. This row set format is then mapped into XML shape. The power of
EXPLICIT mode is to mix attributes and elements at will, create wrappers and nested complex properties, create space-separated values (for example,
OrderID attribute may have a list of order ID values), and mixed contents.
✑ The PATH mode together with the nested FOR XML query capability provides the flexibility of the EXPLICIT mode in a simpler manner.
References:
https://msdn.microsoft.com/en-us/library/ms178107.aspx

by lh2607 at Dec. 15, 2020, 5:01 p.m.

Comments

Submit Cancel

lh2607

4 years, 4 months ago

Correctimundo

upvoted 2 times

...

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 59 discussion

Comments

lh2607

SY0-701