SQL Quiz #9 – JSON Support

Hi all,

Let’s start the week with an exciting new quiz.
This quiz is related to the JSON support in SQL Server 2016.

As Microsoft says here: “JSON is a popular textual data format used for exchanging data in modern web and mobile applications. JSON is also used for storing unstructured data in log files or NoSQL databases like Microsoft Azure DocumentDB. Many REST web services return results formatted as JSON text or accept data formatted as JSON. Most Azure services such as Azure Search, Azure Storage, and Azure DocumentDb have REST endpoints that return or consume JSON. JSON is also the main format for exchanging data between web pages and web servers using AJAX calls.”

If this is quite new to you, read the entire MSDN article and then test your knowledge here.
Or, if you have a Pluralsight account, you can check out this course: https://app.pluralsight.com/library/courses/sql-server-2016-features-real-world-data/table-of-contents. There are some sections dedicated to the JSON support in SQL Server 2016.

Happy quizzing 🙂