exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 117 discussion

Actual exam question from Microsoft's AZ-305
Question #: 117
Topic #: 4
[All AZ-305 Questions]

HOTSPOT
-

Your on-premises datacenter contains a server named Server1 that runs Microsoft SQL Server 2022. Server1 contains a 30-TB database named DB1 that stores customer data. Server1 runs a custom application named App1 that verifies the compliance of records in DB1. App1 must run on the same server as DB1.

You have an Azure subscription.

You need to migrate DB1 to Azure. The solution must minimize administrative effort.

To which service should you migrate DB1, and what should you use to perform the migration? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
arnitjoe
Highly Voted 7 months, 1 week ago
Its SQL on Azure VM and Azure Migrate. Since the existing server has a custom app that must be installed on the local DB server and SQL is already SQL 2022 there is no need to do anything other than lift and shift. With that Azure Migrate to simply move the VM to Azure. Minimal Admin effort. https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-to-sql-on-azure-vm-migration-overview?view=azuresql
upvoted 12 times
...
bazylson
Highly Voted 8 months, 1 week ago
According to this: https://learn.microsoft.com/en-us/sql/sql-server/migrate/dma-azure-migrate-compare-migration-tools?view=sql-server-ver16#quick-comparison only Azure Migrate & DMA can handle a SQL Server migration to Azure VM. Since DMA option is not available, only Azure Migrate remains.
upvoted 10 times
bp_a_user
4 months, 2 weeks ago
the link you posted says: Migrate (and/or upgrade) SQL Server to SQL Server on Azure VM -> azure migrate: NO
upvoted 1 times
ann1730
4 months, 2 weeks ago
Lift and shift SQL Server to SQL Server on Azure VM -> azure migrate : YES Because both application and database are migrating, Lift and shift SQL Server to SQL Server on Azure VM is correct.
upvoted 3 times
...
...
...
SeMo0o0o0o
Most Recent 3 weeks ago
WRONG Migrate to: SQL Server on Azure Virtual Machines By using: Azure Migrate
upvoted 1 times
...
Thanveer
3 weeks, 1 day ago
Migrate to: SQL Server on Azure Virtual Machines By using: Azure Migrate Explanation: SQL Server on Azure Virtual Machines: App1 Requirement: This option allows you to migrate Server1 (with App1 and DB1) as a virtual machine to Azure. This ensures that App1 and DB1 remain on the same server, fulfilling the requirement. Flexibility: You have full control over the VM configuration and can customize it to meet your specific needs. Azure Migrate: Simplified Migration: Azure Migrate simplifies the migration process by assessing the on-premises server, creating a migration plan, and executing the migration. Minimal Downtime: The migration can be performed with minimal downtime, allowing for a seamless transition to Azure.
upvoted 2 times
...
Teerawee
2 months, 2 weeks ago
SQL Server on Azure Virtual Machines Azure Migrate
upvoted 2 times
...
RV3472
3 months ago
Seems like box 2 all answers are correct: - Azure migrate contains DMS - DMS offers two versions, "DMS classic" and "DMS via Azure SQL migration extension for Azure Data Studio" https://learn.microsoft.com/en-us/azure/dms/dms-overview
upvoted 2 times
...
Len83
3 months, 4 weeks ago
This question appeared in the exam, August 2024. I gave this same answer for Box 1 as listed here (SQL on Azure VM) and for Box 2 I answered Azure Migrate (because there's an App to migrate which must exist on the same VM). I scored 870
upvoted 2 times
...
Superego
6 months, 2 weeks ago
For box 2: Azure Migrate. According to the doc https://learn.microsoft.com/en-us/azure/dms/dms-overview which says: With Azure Database Migration Service currently we offer two versions: 1. Database Migration Service - via Azure SQL migration extension for Azure Data Studio, Azure portal, PowerShell and Azure CLI. It seems Azure SQL migration extension for Azure Data Studio is exactly the Database Migration Service. So both are eliminated.
upvoted 2 times
...
Lazylinux
7 months, 2 weeks ago
Agree with first box answer correct because of the App tied to the DB and hence SQL VM but Second box i would chose AZ SQL Migration Extension for AZ Data Studio as per below snippet from MS Doco The Azure SQL migration extension for Azure Data Studio provides a seamless wizard based experience to assess, get Azure recommendations and migrate your SQL Server databases on-premises to SQL Server on Azure Virtual Machines. Besides, highlighting any migration blockers or warnings, the extension also includes an option for Azure recommendations to collect your databases' performance data to recommend a right-sized Azure SQL Managed Instance to meet the performance needs of your workload (with the least price). Follow below
upvoted 1 times
Lazylinux
7 months, 2 weeks ago
Azure Migrate When to use - Discovery and assess single databases or at scale from different environments. Azure SQL Migration extension for Azure Data Studio when to use - Migrate single databases or at scale. - Offline mode only. Supported sources: - SQL Server (2008 onwards) on-premises, or on Azure Virtual Machines - SQL Server on Amazon EC2 - Amazon RDS for SQL Server - SQL Server on Google Compute Engine
upvoted 1 times
...
...
LGWJ12
8 months ago
SQL Server on Azure Virtual Machines and Azure Database Migration Service. Given the requirement that the custom application App1 must run on the same server as DB1, the best option is SQL Server on Azure Virtual Machines. For the migration process, you should use Azure Database Migration Service because the Azure SQL Migration extension for Azure Data Studio is more suited for migrating to Azure SQL Database or Azure SQL Managed Instance and not to SQL server on Azure virtual machine.
upvoted 4 times
profesorklaus
4 months, 2 weeks ago
It supports also migration to Azure VM. It also has a minimum downtime near zero. https://learn.microsoft.com/en-us/azure-data-studio/extensions/azure-sql-migration-extension?tabs=connected#azure-sql-target-readiness-assessment-and-database-migrations
upvoted 1 times
...
...
MohsenSic
8 months, 2 weeks ago
Sql database tier and DMS, 30Tb is only supported by databsetier
upvoted 1 times
...
kodjoa2024
8 months, 2 weeks ago
for the second question it sound for me Azure Migrate because there also app to migrate.
upvoted 2 times
...
ahmedkmj
8 months, 3 weeks ago
I would say also it should be Azure SQL migration extension for Azure Data Studio, according to Microsoft recommendations https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-to-sql-on-azure-vm-migration-overview?view=azuresql
upvoted 2 times
...
rumino
9 months ago
The first choice is easy, obviously we need VM to install additional app. Regarding the second, I'd go for SQL Migration extension for Azure Data Studio. It seems to be all-in-one easy to use tool. https://learn.microsoft.com/en-us/azure-data-studio/extensions/azure-sql-migration-extension?tabs=connected
upvoted 4 times
rumino
8 months, 2 weeks ago
For migration Azure Database Migration Service https://learn.microsoft.com/en-us/azure/migrate/migrate-services-overview#integrated-tools Data Studio is only for Azure SQL migration not MI or VM SQL. (link from the original comment)
upvoted 1 times
Lazylinux
7 months, 2 weeks ago
Not correct read below The Azure SQL migration extension for Azure Data Studio provides a seamless wizard based experience to assess, get Azure recommendations and migrate your SQL Server databases on-premises to SQL Server on Azure Virtual Machines. Besides, highlighting any migration blockers or warnings, the extension also includes an option for Azure recommendations to collect your databases' performance data to recommend a right-sized Azure SQL Managed Instance to meet the performance needs of your workload (with the least price).
upvoted 2 times
...
...
...
xRiot007
9 months ago
The second box is slightly ambiguous. Bot Azure Migrate and Azure Database Migration Service are correct. This is because the service sits inside the context of Azure Migrate.
upvoted 3 times
xRiot007
9 months ago
Thinking again, using the DMS might be more precise of a response, so that is more correct...
upvoted 2 times
...
...
Crossfader2208
9 months ago
given answer is correct.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...