Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft AZ-120 Exam - Topic 8 Question 43 Discussion

You plan to migrate an SAP database from Oracle to Microsoft SQL Server by using the SQL Server Migration Assistant (SSMA).You are configuring a Proof of Concept (PoC) for the database migration You plan to perform the migration multiple times as part of the PoC.You need to ensure that you can perform the migrations as quickly as possible. The solution must ensure that all Oracle schemas are migrated.Which migration method and migration mode should you use? To answer, select the appropriate options in the answer areaNOTE: Each correct selection is worth one point.
A) Explanation: Answer selected as in image below.

Microsoft AZ-120 Exam - Topic 8 Question 43 Discussion

Actual exam question for Microsoft's AZ-120 exam
Question #: 43
Topic #: 8
[All AZ-120 Questions]

You plan to migrate an SAP database from Oracle to Microsoft SQL Server by using the SQL Server Migration Assistant (SSMA).

You are configuring a Proof of Concept (PoC) for the database migration You plan to perform the migration multiple times as part of the PoC.

You need to ensure that you can perform the migrations as quickly as possible. The solution must ensure that all Oracle schemas are migrated.

Which migration method and migration mode should you use? 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: A

by Junita at May 06, 2022, 08:01 AM

Limited Time Offer

25%

Off

Get Premium AZ-120 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ramonita
10 months ago
Not sure about that, I’ve heard "Offline" mode is more reliable for complex migrations.
upvoted 0 times
...
Chantay
10 months ago
I think using the "Online" mode will speed things up significantly!
upvoted 0 times
...
Monte
11 months ago
Wait, are we sure SSMA can handle all Oracle schemas without issues?
upvoted 0 times
...
Dalene
11 months ago
I agree, Schema mode is the way to go for full migrations.
upvoted 0 times
...
Alpha
11 months ago
You should definitely use the "Schema" migration method for this.
upvoted 0 times
...
Robt
11 months ago
I recall that for multiple migrations, we should definitely consider the "Schema Only" option first to set up the structure before loading data.
upvoted 0 times
...
Cyril
11 months ago
I'm a bit confused about the migration modes. I feel like "Offline" could be faster for initial tests, but I’m not sure if it supports all schemas.
upvoted 0 times
...
Ryann
11 months ago
I think we practiced a similar question where we had to select the "Online" migration mode to minimize downtime. That might apply here too, right?
upvoted 0 times
...
Curt
11 months ago
I remember we discussed using the "Schema and Data" migration method for comprehensive migrations, but I'm not entirely sure if that's the best choice for a PoC.
upvoted 0 times
...
Francoise
11 months ago
I'm a bit confused about the UDP and NetFlow v5 options. I'm not sure if those apply to the flows between these two components. I'll need to double-check my understanding of how they work together.
upvoted 0 times
...
Romana
11 months ago
Hmm, this looks like a tricky one. I'll need to carefully read through the code and options to figure out how transactions are managed here.
upvoted 0 times
...

Save Cancel