What should you recommend?

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

View Answer

Answer: D

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