Exit 70-761 Querying Data with Transact-SQL
Question 3 of 5
0% complete
Q3 Single choice

You have a table that was created by running the following Transact-SQL statement:

You need to query the Courses table and return the result set as JSON. The output from the query must resemble the following format:

  • A

    SELECT CourseID AS [Course ID], Course as Name FROM Courses
    FOR JSON PATH('Courses')

  • B

    SELECT CourseID AS 'Course ID', Course AS Name
    FROM Courses
    FOR JSON ROOT('Courses')

  • C

    SELECT CourseID AS [Course ID], Course AS Name
    FROM Courses
    FOR JSON AUTO, ROOT('Courses')

  • D

    SELECT CourseID AS 'Course ID', Course AS Name
    FROM Courses
    FOR JSON AUTO, INCLUDE_NULL_VALUES('Courses')

Previous Next