Home » Microsoft » AZ-305 » What should you include in the recommendation?
You have 100 Microsoft SQL Server integration Services (SSIS) packages that are configured to use 10 on-premises SQL Server databases as their destinations.
You plan to migrate the 10 on-premises databases to Azure SQL Database You need to recommend a solution to host the SSlS packages in Azure. The solution must ensure that the packages can target the SQL Database instances as their destinations.
What should you include in the recommendation?
A. SQL Server Migration Assistant (SSMA)
B. Azure Data Catalog
C. Data Migration Assistant
D. Azure Data Factory
Correct Answer: D
Explanation/Reference:
Explanation:
https://docs.microsoft.com/bs-cyrl-ba/azure/sql-database/sql-database-managed-instance-migrateQuote from that page “Azure SQL Database and SQL Server databases in an Azure Virtual Machine.
DMS is the recommended method of migration for your enterprise workloads.
If you use SQL Server Integration Services (SSIS) on your SQL Server on premises, DMS does not yet support migrating SSIS catalog (SSISDB) that stores SSIS packages, but you can provision Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF) that will create a new SSISDB in a managed instance and then you can redeploy your packages to it, see Create Azure-SSIS IR in ADF.
To learn more about this scenario and configuration steps for DMS, see Migrate your on-premises database to managed instance using DMS.”
https://docs.microsoft.com/en-us/azure/data-factory/how-to-migrate-ssis-job-ssms
How To Pass Azure AZ-305 Exam?
Microsoft Azure AZ-305 PDF dumps.
High quality AZ-305 PDF and software. VALID exam to help you pass.
|
|
How To Pass AZ-305 Exam?
Microsoft AZ-305 PDF dumps.
High quality AZ-305 pdf and software. VALID exam to help you pass.
|
|
D