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?
Explanation:
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.
https://msdn.microsoft.com/en-us/library/dn921882.aspx