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 23 discussion

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

You have an on-premises SAP landscape that contains a 20-TB IBM DB2 database. The database contains large tables that are optimized for read operations via secondary indexes.

You plan to migrate the database platform to SQL Server on Azure virtual machines.

You need to recommend a database migration approach that minimizes the time of the export stage.

What should you recommend?

  • A. log shipping
  • B. deleting secondary indexes
  • C. SAP Database Migration Option (DMO) in parallel transfer mode
  • D. table splitting
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by pvrhere at June 27, 2023, 4:53 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
ZhanLee
8 months, 3 weeks ago
Selected Answer: D
Log shipping can only be used if the source DB is also MSS (replication). Indexes are not exported via migration/heterogeneous system copy, deleting indexes does not change anything. DMO cannot be used for target database MSS. Table spitting makes sense for export big tables Imho, correct answer is D
upvoted 2 times
...
4c78df0
8 months, 3 weeks ago
Selected Answer: C
Answer is C.
upvoted 2 times
...
4c78df0
8 months, 3 weeks ago
Answer is C.
upvoted 2 times
...
Mingzhang
10 months, 2 weeks ago
Selected Answer: C
deleting index is not a database migration approach
upvoted 1 times
...
ukocloud
1 year, 4 months ago
If you need to minimize export stage it doesn't make sense to delete secondary indexes that are used for better reading. I will say D table splitting. It's tru that DMO can only be used if your target database is HANA or Sybase ASE
upvoted 1 times
...
pvrhere
1 year, 6 months ago
Selected Answer: B
I am correcting my answer. It should be B. The index can be deleted prior to export and it can be rebuilt at target if required
upvoted 1 times
...
pvrhere
1 year, 7 months ago
I think DMO doesn't support migrating from DB2. It could be splitting table or deleting index. Deleting index may affect read performance. So, I think ' Split tables' may be the correct option
upvoted 2 times
...
pvrhere
1 year, 7 months ago
Selected Answer: C
Various features of DMO helps to reduce downtime
upvoted 2 times
...
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