Explain SQL Server on Azure VM and its use cases?
The SQL Server on Azure Virtual Machines (VM) enables users to deploy a full version of SQL Server without managing the underlying infrastructure. There is no difference from the DBA perspective in managing on-prem SQL Server and SQL Server on Azure VM, and the only difference is that your virtual machine is now in Azure infrastructure cloud.
You should use the SQL Server on Azure VM in cases:
Reading Material:
What is accelerated database recovery for Azure SQL Database?
The Accelerated Database Recovery (ADR) feature redesigns the SQL Server database engine recovery process for improving database availability, especially for long-running transactions. It provides Instantaneous transaction rollback, Fast and consistent database recovery. By default, it is enabled for the Azure database, and users cannot disable it.
Reading Material:
QWhat are Azure Site Recovery (ASR) components?
Answer: The following are Azure site recovery (ASR) components: – Hyper-V host – Storage Replica server – ASR configuration server (primary and secondary sites) – Protection group with application VM, replica vhd/vhds, and storage account for replication.
Explain different connection policies for Azure SQL Database?
Azure supports the following server’s connection policy setting:
Reading Material:
What are different service tiers in vCore based purchasing models?
The vCore purchasing model has General Purpose, Business Critical and Hyperscale service tiers.
QIn which Azure environment can I use Azure Site Recovery (ASR)?
Answer: ASR can be used in the following Azure environments: – Azure Government Cloud-US Government Cloud-Azure Germany Cloud-Azure US DoD Cloud-Azure UK Public Sector Cloud.
Q1What Azure service is recommended for Java developers?
Answer: Azure service recommended for java developers is azure functions which allow using serverless computing to develop and run small pieces of code without having to manage the underlying infrastructure. Azure Blob Storage is another Azure service for Java developers, allowing them to store unstructured data like file systems, s, videos, etc. Azure App Service provides scalable application back ends for Azure websites, Azure service fabric, Azure batch, Azure cloud, and Azure web jobs.
What is the primary difference between Azure SQL Database and Azure SQL Managed Instance (MI)?
Azure SQL Managed Instance (MI) offers fully managed SQL instances as a service. It provides almost 100% SQL Server features and is suitable for most database migrations in the cloud. While Azure SQL Database is a database as a service and does not includes all SQL Server features such as SQL Server Agent, Database mail, PolyBase.
Reading Material:
Q1What Azure services are available for web development?
Answer: The Azure services for web development are as follows- Azure App Service-Azure Functions -Azure CDN Azure Active Directory B2C -Azure Search.