You are working on a project in a financial organization and have to adhere to the laid regulatory requirements.
The project you are working for involves 3 applications on a Windows server and is using RDBMS.
To be compliant with the regulatory requirements you need to ensure that the user data remains in their specific geographic location and is secured at the level of database rows.
Which database offering from Azure would be an ideal fit for this scenario?
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answer: C.
Option A is INCORRECT.
Microsoft Azure data lake is an offering that provides storage and analytics services for big data.
Option B is INCORRECT.
Fully managed NoSQL database service, Azure Cosmos DB, is a suitable choice for storage of analyzed and transformed IoT data.
Option C is CORRECT.
SQL Server on Azure Virtual Machines facilitates the use of full versions SQL Server in the cloud.
Manage of hardware is not required as this is a managed offering with pay as you go pricing model.
Azure VMs run in different regions across the globe and can be configured to adhere to the regulatory requirements.
Option D is INCORRECT.
Azure SQL edge is a database offering from Azure that is fit for IoT and edge deployments.
In the given scenario SQL Server on Azure Virtual Machines because Azure VMs in different regions will help ensure that the user data is in the geographic location intended and also the row-level security will be maintained.
References:
The ideal database offering from Azure for this scenario would be Azure SQL Database, specifically the "Managed Instance" deployment option.
Option A, Azure Data Lake, is a distributed file system for big data analytics workloads and not suitable for relational database management.
Option B, Cosmos DB, is a globally distributed, multi-model database service designed for scalable and highly available applications that need low latency data access. However, it may not be the best fit for the given scenario as it does not provide row-level security.
Option C, SQL Server on Azure Virtual Machines, is a virtual machine deployment option of SQL Server on Azure. This deployment option provides the full flexibility and control of a SQL Server installation, but it requires more management and maintenance. It may not be the best fit for the given scenario as it does not offer automatic backups and high availability.
Option D, Azure SQL Edge, is a lightweight version of Azure SQL Database designed for edge computing scenarios where data needs to be processed locally. It is not suitable for the given scenario as it is designed for edge computing rather than central database management.
Azure SQL Database Managed Instance, on the other hand, provides a fully managed and highly available database service with built-in row-level security and automatic backups. It also allows customers to choose a specific geographic location where their data will be stored, helping to ensure compliance with regulatory requirements.