Exam SC-100 topic 3 question 23 discussion

Azure SQL Database is a general-purpose relational database, provided as a managed service. Categorized as a platform as a service (PaaS), Azure SQL Databases are built on standardized hardware and software that is owned, hosted, and maintained by Microsoft. When using Azure SQL Database, you pay-as-you-go, with the option to scale up or out with no service interruption. Within Azure SQL Database, you have the option to deploy a managed instance. Azure SQL Database Managed Instance is a collection of system and user databases with a shared set of resources. In addition to all the PaaS benefits of Azure SQL Database, this option provides a native virtual network (VNet) and near 100 percent compatibility with on-premises SQL Server. Azure SQL Database Managed Instance provides you with full SQL Server access and feature compatibility for migrating SQL Servers to Azure. Recommendation: Choose Azure SQL Database for your modern cloud applications, or when you have time constraints in development and marketing.

SQL managed Instance is best for most migrations to the cloud.

A SQL database is a cheaper option than a Azure SQL Managed Instance

SQL MI is a very expensive solution, so Azure SQL Database is the right answer.

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql-mi

Azure SQL Database Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. It also has built-in features such as dynamic data masking, which allows you to automatically hide sensitive data in the result sets of queries. Since it's a PaaS offering, it helps reduce operational management overhead and costs associated with managing the infrastructure.

https://www.bridgeall.com/2023/03/23/what-is-the-difference-between-azure-managed-instance-and-azure-sql/

I will go with C https://www.bridgeall.com/2023/03/23/what-is-the-difference-between-azure-managed-instance-and-azure-sql/

Azure SQL Database is cheaper (The solution must minimize costs.), and also has limited control (minimize operational requirements) https://learn.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?view=azuresql https://www.ccslearningacademy.com/azure-sql-database-vs-managed-instance/#:~:text=Azure%20SQL%20Database%20provides%20a,lift%2Dand%2Dshift%20scenarios.

Based on the video with the link below on cost saving and ease of management, going with option A https://docs.microsoft.com/en-us/powershell/scripting/learn/remoting/jea/overview?view=powershell-7.2 https://docs.microsoft.com/en-us/azure/defender-for-cloud/just-in-time-access-usage https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles

Gee! wish there could be a definite answer 🤔

A is correct with SQL MI

1. Operational Requirements and Complexity: If you prefer a fully managed service with minimal operational overhead: Azure SQL Database is a fully managed service that abstracts away much of the operational complexity, making it a simpler choice for those who want a fully managed database without having to worry about underlying infrastructure. 2. Dynamic Data Masking (DDM): If dynamic data masking is a critical requirement: Both Azure SQL Managed Instance and Azure SQL Database support Dynamic Data Masking (DDM). You can implement DDM in both services to protect sensitive data at the query result level. 3. Cost Considerations: If you prioritize cost-effectiveness and flexibility: Azure SQL Database offers more flexibility in terms of pricing tiers, allowing you to choose the performance level that aligns with your budget and requirements. It may be a cost-effective option for many scenarios. Azure SQL Database is the correct answer

I think both A and C are correct. But the question emphasises on cost. Since nothing MI has over the AzSQL, i'd say C is correct.

since you are migrating databaseS

Recommend Azure SQL Database because: It's fully managed, reducing patching efforts. Supports dynamic data masking. Typically more cost-effective than the other options for single databases. Here's why: Azure SQL Database: It's a fully managed database service, which means Azure handles most of the operational tasks like patching for you. It also supports dynamic data masking out of the box, which allows you to mask sensitive data. It's usually the most cost-effective option for a single database without requiring the overhead of managing an entire instance or VM. Azure SQL Managed Instance: While it's also a fully managed service and supports dynamic data masking, it might be more expensive than Azure SQL Database, especially if you only need to host a few databases. It's a better option if you need a higher level of compatibility with SQL Server and VNET integration.

A https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql-mi