MENU
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.
Suggested Answer: A
Get Premium AZ-120 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
11 comments · newest first
RA
Ramonita
12 months ago
Not sure about that, I’ve heard "Offline" mode is more reliable for complex migrations.
CH
Chantay
1 year ago
I think using the "Online" mode will speed things up significantly!
MO
Monte
1 year ago
Wait, are we sure SSMA can handle all Oracle schemas without issues?
DA
Dalene
1 year ago
I agree, Schema mode is the way to go for full migrations.
AL
Alpha
1 year ago
You should definitely use the "Schema" migration method for this.
RO
Robt
1 year ago
I recall that for multiple migrations, we should definitely consider the "Schema Only" option first to set up the structure before loading data.
CY
Cyril
1 year 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.
RY
Ryann
1 year 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?
CU
Curt
1 year 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.
FR
Francoise
1 year 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.
RO
Romana
1 year 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.