Azure Analysis Services: Suitable for Your Analytical Data Store Needs
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 Analysis Services suitable for this?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B.Correct Answer: B.
Azure Analysis Services uses a tabular semantics model and does not support SQL language.
Row-level security and Query scale out capability are available.
So, this may not be the right choice.
Azure Analysis Services (AAS) is a fully managed cloud service that enables data modeling with business semantics for better decision-making. AAS supports tabular models that can be deployed to the cloud or on-premises. However, it is primarily designed for creating analytical models that can be used to analyze data using visualizations, dashboards, and reports.
Based on the primary considerations mentioned in the question, AAS may not be the best fit for the analytical data store for the following reasons:
Primary database model should be relational: AAS uses tabular models, which are not strictly relational. Although tabular models can handle relationships between tables, they may not offer the same level of control over referential integrity as a relational database.
SQL language support: AAS supports Data Analysis Expressions (DAX) and Multidimensional Expressions (MDX), which are used for querying tabular models. However, it does not offer support for SQL, which is a standard language for querying relational databases.
Supports Query Scale out: AAS is designed to scale up, meaning that it can handle larger workloads by adding more resources to a single instance. However, it does not offer built-in support for scaling out, which is the ability to distribute workloads across multiple instances.
Row level security must be supported: AAS does support role-based security, which can be used to restrict access to certain data based on user roles. However, it may not offer the same level of granularity as a relational database, which can support row-level security.
Based on these considerations, the answer to the question is B. No, Azure Analysis Services may not be suitable for an analytical data store that requires a relational database model, SQL language support, query scale out, and row level security. A better option may be Azure SQL Database, which is a fully managed relational database service that offers these features and more.
