You have an on-premises SAP environment that uses AIX servers and IBM DB2 as the database platform.
You plan to migrate SAP to Azure. In Azure, the SAP workloads will use Windows Server and Microsoft SQL Server as the database platform.
What should you use to export from DB2 and import the data to SQL Server?

A. R3load

B. Azure SQL Data Warehouse

C. SQL Server Management Studio (SSMS)

D. R3trans








 

Suggested Answer: C

To migrate DB2 databases to SQL Server, you must connect to the DB2 database that you want to migrate. When you connect, SSMA obtains metadata about all
DB2 schemas, and then displays it in the DB2 Metadata Explorer pane.
References:
https://docs.microsoft.com/en-us/sql/ssma/db2/connecting-to-db2-database-db2tosql?view=sql-server-ver15
 https://docs.microsoft.com/en-us/biztalk/adapters-and-accelerators/adapter-sap/import-sap-data-using-sql-server-management-studio

This question is in AZ-120 Planning and Administering Microsoft Azure for SAP Workloads Exam
For getting Microsoft Certified: Azure for SAP Workloads Specialty Certificate




Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.