Exam AZ-120 All Questions

View all questions & answers for the AZ-120 exam

Exam AZ-120 topic 1 question 2 discussion

Actual exam question from Microsoft's AZ-120

Question #: 2
Topic #: 1

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

Show Suggested Answer

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

by Sourabh1703 at June 25, 2020, 7:40 a.m.

Comments

Submit Cancel

Sourabh1703

Highly Voted 4 years, 7 months ago

Answer should be A. R3load, SSMS is not recommended for heterogeneous migration in SAP landscapes.

upvoted 10 times

...

gks8

Highly Voted 4 years, 3 months ago

SQL Server Migration Assistant (SSMA) for DB2 is a comprehensive environment that helps you quickly migrate DB2 databases to SQL Server or Azure SQL Database. By using SSMA for DB2.

upvoted 5 times

...

smudo1965

Most Recent 1 year ago

Selected Answer: A

R3load, SSMS is not recommended for heterogeneous migration in SAP landscapes

upvoted 1 times

...

petercorn

2 years, 1 month ago

Selected Answer: A

https://answers.sap.com/questions/1252760/what-is-the-difference-between-r3copy-and-r3load-p.html

upvoted 1 times

...

protagonistsvb

3 years, 7 months ago

I think the question is not complete. The question is about SAP environment, it does not if its SAP Netweaver environment. In case of migration of NW environment R3load is correct. However there are many solutions from SAP which are not NW based such as SAP ASE which can be migrated using SSMA(S).

upvoted 2 times

...

sakibmas

3 years, 9 months ago

The program module R3load is integrated in the SAP migration tools. For heterogeneous system copies (OS/DB migrations) only use the R3load procedure. soutce: https://answers.sap.com/questions/1252760/what-is-the-difference-between-r3copy-and-r3load-p.html

upvoted 2 times

gursimran_s

2 years, 9 months ago

This is a 16 year old post. A lot has changed since then.

upvoted 1 times

...

Kaiju

3 years, 10 months ago

A. R3load

upvoted 4 times

...

Bhagirathi

4 years, 1 month ago

It is R3load - pls do not confuse .

upvoted 3 times

...

SOUMALYASEN89

4 years, 1 month ago

Answer is correct.. it should SSMS ..

upvoted 1 times

...

kEissa1

4 years, 4 months ago

Guys, What is the pass score for this certificate ?

upvoted 1 times

gursimran_s

2 years, 9 months ago

700 it is.

upvoted 1 times

...

shaark18

3 years, 7 months ago

700/1000

upvoted 1 times

...

vk100001

4 years, 4 months ago

R3load should be the answer

upvoted 2 times

...

sap_umesh

4 years, 5 months ago

Correct answer is R3load

upvoted 3 times

...

Kapsy

4 years, 6 months ago

SSMA seems to be the tool to export data from DB2 and importing it into SQL server, but here the question is based on SAP workload and the scenario is Heterogeneous. In a Heterogeneous scenario the Export/Import is sometimes called R3load/Migration Monitor based or Database Independent (in the System Copy Guide). Because this method is not reliant on database-specific tools, it is the only method that can be used for heterogeneous copies. However, it can also be used for homogeneous copies. So the answer should be 'R3load'.

upvoted 4 times

...

Yogesh_g_w

4 years, 6 months ago

Experts, Someone please confirm on the answer, ideally speaking being SAP BASIS admin i would not use SSMA option..but it should be R3Load..

upvoted 1 times

...

GiuseppeF

4 years, 6 months ago

The correct answer should be A. The SAP tool for Hetherogenous System Copy is R3load.

upvoted 4 times

...

cbits

4 years, 6 months ago

A: because its having OS migration too(not only DB migration)

upvoted 1 times

...

Kalyansarkar

4 years, 6 months ago

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. SSMA stores information about the database server, but does not store passwords.I think Ans is - C

upvoted 4 times

praveenkumarh1912

4 years, 5 months ago

SSMS or SSMA is not supported for SAP migrations. It is only for Non-SAP environments

upvoted 1 times

...

Load full discussion...