There are a number of different options for data serving storage in Azure.
These options vary based on the capability they offer.
Which of the following data serving storage options in Azure does not provide SQL language support?
Click on the arrows to vote for the correct answer
A. B. C. D. E.Correct Answer: E
Except Azure Analysis services, all data serving storage options like SQL Database, Azure Synapse Spark pool, Azure Synapse SQL pool, Azure Data Explorer, Azure Data Explorer, Hive LLAP on HDInsight, HBase/Phoenix on HDInsight, and Cosmos DB provide SQL language support.
Option A is incorrect.
Azure Synapse SQL pool supports SQL language.
Option B is incorrect.
Azure Synapse Spark pool supports SQL language.
Option C is incorrect.
Hive LLAP on HDInsight is one of the data serving storage options that supports SQL language.
Option D is incorrect.
Cosmos DB is one of the data serving storage options that supports SQL language.
Option E is correct.
Azure Analysis Services does not support SQL.
Reference:
To know more about analytical data store in Azure, please visit the below-given link:
Out of the given options, the data serving storage option in Azure that does not provide SQL language support is the Azure Synapse Spark pool (Option B).
Here's a brief explanation of the capabilities of each option:
A. Azure Synapse SQL pool: It is a fully-managed and scalable data warehousing service that enables you to run complex queries across large datasets using standard SQL language. Azure Synapse SQL pool supports T-SQL (Transact-SQL) which is a powerful SQL dialect used by Microsoft SQL Server.
B. Azure Synapse Spark pool: It is an Apache Spark-based analytics service that provides distributed processing for big data workloads. It allows you to use programming languages such as Python, Scala, and R to analyze and process large datasets. However, it does not provide SQL language support out of the box.
C. Hive LLAP on HDInsight: It is an Apache Hive-based service that provides a SQL-like interface to query data stored in Azure Blob Storage or Azure Data Lake Storage. It supports SQL queries and provides HiveQL, a SQL-like query language for Apache Hive.
D. Cosmos DB: It is a globally-distributed, multi-model database service that provides support for NoSQL APIs such as MongoDB, Cassandra, and Azure Table Storage. Cosmos DB provides SQL-like query language, SQL API, which supports querying data using SQL-like syntax.
E. Azure Analysis Services: It is an enterprise-grade analytics as a service (AaaS) that provides online analytical processing (OLAP) and data mining capabilities. It supports data modeling using SQL Server Data Tools (SSDT) and provides SQL language support for querying data.
Therefore, based on the above explanations, the correct answer is option B - Azure Synapse Spark pool, as it does not provide SQL language support.