Microsoft AZ-120 Exam - Topic 8 Question 43 Discussion

Actual exam question for Microsoft's AZ-120 exam

Question #: 43
Topic #: 8

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.

AExplanation:
Answer selected as in image below.

Show Suggested 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:

Submit Cancel

Ramonita

4 months ago

Not sure about that, I’ve heard "Offline" mode is more reliable for complex migrations.

upvoted 0 times

...

Chantay

4 months ago

I think using the "Online" mode will speed things up significantly!

upvoted 0 times

...

Monte

4 months ago

Wait, are we sure SSMA can handle all Oracle schemas without issues?

upvoted 0 times

...

Dalene

5 months ago

I agree, Schema mode is the way to go for full migrations.

upvoted 0 times

...

Alpha

5 months ago

You should definitely use the "Schema" migration method for this.

upvoted 0 times

...

Robt

5 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

5 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

5 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

5 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

5 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

5 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

...