ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 93 - AZ-120 discussion

Report
Export

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
Answers
A.
log shipping
B.
deleting secondary indexes
Answers
B.
deleting secondary indexes
C.
SAP Database Migration Option (DMO) in parallel transfer mode
Answers
C.
SAP Database Migration Option (DMO) in parallel transfer mode
D.
table splitting
Answers
D.
table splitting
Suggested answer: B

Explanation:

Secondary indexes for very large tables can be removed from the STR file and built ONLINE with scripts after the main portion of the import has finished and post processing tasks such as configuring STMS are occurring.

References: https://techcommunity.microsoft.com/t5/running-sap-applications-on-the/very-large-database-migration-to-azure-8211-recommendations/ba-p/368146

asked 02/10/2024
Darren Bilmen
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first