Azure Data Explorer
Question
Your new application requires an analytical data store.
The following are the primary considerations.
-> Primary database model should be relational -> SQL language support -> Supports Query Scale out -> Row level security must be supported Is Azure Data Explorer suitable for this?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B.Correct Answer: B.
Azure Data Explorer is a relational data store.
It supports SQL language and query scale out.
But when it comes to the Row Level Security capability, it lacks the capability.
A better choice here will be the Azure Synapse SQL pool.
Based on the given primary considerations, Azure Data Explorer (ADX) may not be suitable for the requirements of the new application.
Primary database model should be relational: ADX is not a relational database management system (RDBMS). It is designed for high-speed, low-latency analytics on large volumes of semi-structured and unstructured data, such as logs, telemetry, and IoT data. ADX uses a columnar data model, which is different from the row-based data model used by relational databases.
SQL language support: ADX uses a proprietary query language called Kusto Query Language (KQL), which is similar to SQL in syntax but has some differences. While KQL can be learned easily by users with SQL experience, it may require some learning curve for those who are not familiar with it.
Supports Query Scale out: ADX is designed for high-scale analytics workloads and supports horizontal scaling by distributing data and queries across multiple nodes. However, the scale-out capabilities of ADX may not be suitable for applications that require relational database features such as joins, transactions, and referential integrity constraints.
Row level security must be supported: ADX has built-in security features that allow data access control at the cluster, database, table, and column levels. However, row-level security (RLS) is not currently supported in ADX, which may be a significant limitation for some applications.
In summary, based on the given primary considerations, Azure Data Explorer may not be the most suitable choice for the new application, as it is not a relational database and does not support some of the required features such as SQL language support and row-level security. A relational database management system such as Azure SQL Database or Azure Database for PostgreSQL may be a better fit for the application.
