ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-120 All Questions

View all questions & answers for the AZ-120 exam
Go to Exam

Exam AZ-120 topic 1 question 2 discussion

Actual exam question from Microsoft's AZ-120
Question #: 2
Topic #: 1
[All AZ-120 Questions]

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 Hide 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

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
Submit Cancel
Sourabh1703
Highly Voted 4 years, 4 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 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 9 months, 2 weeks ago
Selected Answer: A
R3load, SSMS is not recommended for heterogeneous migration in SAP landscapes
upvoted 1 times
...
petercorn
1 year, 10 months 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, 4 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, 6 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, 5 months ago
This is a 16 year old post. A lot has changed since then.
upvoted 1 times
...
...
Kaiju
3 years, 7 months ago
A. R3load
upvoted 4 times
...
Bhagirathi
3 years, 10 months ago
It is R3load - pls do not confuse .
upvoted 3 times
...
SOUMALYASEN89
3 years, 10 months ago
Answer is correct.. it should SSMS ..
upvoted 1 times
...
kEissa1
4 years, 1 month ago
Guys, What is the pass score for this certificate ?
upvoted 1 times
gursimran_s
2 years, 5 months ago
700 it is.
upvoted 1 times
...
shaark18
3 years, 4 months ago
700/1000
upvoted 1 times
...
...
vk100001
4 years, 1 month ago
R3load should be the answer
upvoted 2 times
...
sap_umesh
4 years, 2 months ago
Correct answer is R3load
upvoted 3 times
...
Kapsy
4 years, 2 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, 3 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, 3 months ago
The correct answer should be A. The SAP tool for Hetherogenous System Copy is R3load.
upvoted 4 times
...
cbits
4 years, 3 months ago
A: because its having OS migration too(not only DB migration)
upvoted 1 times
...
Kalyansarkar
4 years, 3 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, 2 months ago
SSMS or SSMA is not supported for SAP migrations. It is only for Non-SAP environments
upvoted 1 times
...
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago