Exam 70-761 topic 1 question 57 discussion

Actual exam question from Microsoft's 70-761

Question #: 57
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 named Customers. Data stored in the table must be exchanged between web pages and web servers by using AJAX calls that use REST endpoint.
You need to return all customer information by using a data exchange format that is text-based and lightweight.
Which Transact-SQL statement should you run?

A.

B.

C.

D.

E.

F.

G.

H.

Show Suggested Answer

Suggested Answer: C
JSON can be used to pass AJAX updates between the client and the server.
Export data from SQL Server as JSON, or format query results as JSON, by adding the FOR JSON clause to a SELECT statement.
When you use the FOR JSON clause, you can specify the structure of the output explicitly, or let the structure of the SELECT statement determine the output.
References:
https://msdn.microsoft.com/en-us/library/dn921882.aspx

by Barbedx at Feb. 23, 2020, 6:45 p.m.

Comments

Submit Cancel

lh2607

4 years, 4 months ago

C is correct.

upvoted 2 times

...

Barbedx

5 years, 2 months ago

xml also possible answer

upvoted 1 times

loceweh520

5 years, 1 month ago

You need to return all customer information by using a data exchange format that is text-based and lightweight. XML is not lightweight when you compare with JSON.

upvoted 8 times

...

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 57 discussion

Comments

lh2607

Barbedx

loceweh520

SY0-701