The latest Microsoft AZ-303 Microsoft Azure Architect Technologies certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft AZ-303 Microsoft Azure Architect Technologies exam and earn Microsoft AZ-303 Microsoft Azure Architect Technologies certification.
Exam Question 191
You are migrating an on-premise SQL Server 2017 Enterprise Edition instance to Azure.
The server uses SQL Server Agent to run internal routines in the databases.
You need to migrate the server to Azure using a lift-and-shift approach.
Which two services can you use? Each correct answer presents a complete solution.
A. Azure SQL Database elastic pool
B. Azure Synapse Analytics
C. SQL Server on Azure Virtual Machines (VM)
D. Azure SQL Managed Instance
Correct Answer:
C. SQL Server on Azure Virtual Machines (VM)
D. Azure SQL Managed Instance
Answer Description:
You can use Azure SQL Managed Instance. You can use a managed instance to deploy SQL Databases with near 100 percent compatibility with the latest SQL Server engine. Managed Instance supports SQL Server Agent.
You can also use SQL Server on Azure VM. You can use SQL Server on Azure VM to migrate your databases to the cloud without having to manage any on-premises hardware. This option supports the SQL Server 2017 Enterprise Edition with Windows Server 2016 and the SQL Server Agent. It is also possible to use Azure Hybrid Benefit to save costs on licensing for both the Windows operating system and SQL Server.
You should not use Azure SQL Database elastic pool. Elastic pool is a solution to manage and scale multiple SQL Databases in a cost-effective way. It does not support SQL Server Agent and you would need to rewrite the internal routines as elastic jobs.
You should not use Azure Synapse Analytics. This is a service that combines Enterprise Data Warehouse and Big Data analytics capable of quickly running complex queries across a large amount of data. Azure Synapse Analytics does not support SQL Server Agent.
References:
Microsoft Docs > Features comparison: Azure SQL Database and Azure SQL Managed Instance
Microsoft Docs > What is Azure SQL Managed Instance?
Microsoft Docs > What is SQL Server on Azure Virtual Machines (Windows)
Microsoft Docs > Azure Hybrid Benefit FAQ
Microsoft Docs > Elastic pools help you manage and scale multiple databases in Azure SQL Database
Microsoft Docs > What is Azure Synapse Analytics (formerly SQL DW)?
Exam Question 192
You implement a solution that runs on an Azure virtual machine (VM) scale set.
The solution requires a SQL Server relational database that runs exclusively in the virtual network that the scale set is running. Administrative efforts to maintain the database solution, such as applying security patches and operating system updates, should be minimized.
You need to implement the database solution.
What should you use?
A. Azure Cosmos DB
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Database
Correct Answer:
B. Azure SQL Managed Instance
Answer Description:
You should use Azure SQL Managed Instance. You can use a managed instance to deploy relational databases with near 100 percent compatibility with the latest SQL Server Enterprise engine. Managed instances provide a native virtual network implementation, security patches and operating system updates. It is fully managed by Azure.
You should not use SQL Server on Azure VM. You can use SQL Server on Azure VM to migrate your databases to the cloud without having to manage any on-premises hardware. However, you would need to maintain operating system updates and apply security patches in SQL Server by yourself, increasing the Administrative efforts.
You should not use Azure SQL Database. You can use Azure SQL Database to deploy relational databases in a completely managed platform as a service (PaaS) database engine. Using Azure SQL Database does not increase administrative efforts, but it is not natively integrated with Azure virtual networks.
You should not use Azure Cosmos DB. You can use Cosmos DB to provision a non-relational database, like graphs, documents, column families, and key-value databases.
References:
Microsoft Docs > Features comparison: Azure SQL Database and Azure SQL Managed Instance
Microsoft Docs > What is Azure SQL Managed Instance?
Microsoft Docs > What is SQL Server on Azure Virtual Machines (Windows)
Microsoft Docs > What is Azure SQL Database?
Microsoft Docs > Welcome to Azure Cosmos DB
Microsoft Docs > Understanding the differences between NoSQL and relational databases