1.

What is the difference between Azure SQL managed instance and General-purpose Instance?

Answer»
  • Azure SQL Managed Instance:  Azure SQL managed instance has dedicated RAM, CPU and storage accounts and we can enable the VNet to SECURE the DB. It’s PROVIDES nearly 100% compatibility and secure database can integrate the VNet for more secure. In SQL managed instance we can UTILIZE the private IP address.
  • Azure SQL General Purpose:  It’s PaaS services it’s shared model and we can’t integrate the Vnet and it has the limitation storage up to 4 TB. It’s is a fully managed SQL database engine based in the enterprise edition of SQL server. It’s Database-as -a-services which is hosted in the cloud. It’s has been built-in based on the standard hardware software which owned and managed by Microsoft.



Discussion

No Comment Found

Related InterviewSolutions