SAP OS/DB Migration Sample Questions:

01. How can the R3LOAD export / import duration be minimized?

There are 2 correct answers to this question.

a) By defining an alphabetical package export order

b) By splitting of the package files
c) By using parallel export / import features
d) By adjusting the SAP instance profile parameter

02. What file types are created by R3LDCTL?

Please choose the correct answer.

a) DDL<DBS>.TPL, <PACKAGE>.STR
b) <PACKAGE>.STR, [Link]
c) DDL<DBS>.TPL, <TABART>.SQL
d) <PACKAGE>.STR, <PACKAGE>.EXT

03. How does R3LOAD handle restart situations based on the task file content?
There are 2 correct answers to this question.

a) If the status is „err“ for a data import task, R3LOAD will drop the table to restart the import.
b) If a status is „err“ for a create index task, R3LOAD will drop the index and recreate it to restart the
import.
c) If the status is „err“ for a create table task, R3LOAD will drop and recreate the table to restart
the import.
d) If the status is „err“ for a create primary key task, R3LOAD will delete data and recreate the
primary key to restart the import.

04. Which files does the JPKGCTL tool create?

There are 2 correct answers to this question.

a) [Link]
b) [Link]
c) Jsplitter_cmd.properties
d) <PACKAGE>.xml

05. What can you do with the Software Provisioning Manager?

Please choose the correct answer.

a) SAP System upgrade

b) SAP System automated configuration and verification
c) SAP System uninstall
d) SAP Front End installation and distribution
06. Which tasks does the R3TA tool perform?
There are 2 correct answers to this question.

a) Splits tables by ROWIDs if the source system is running on an Oracle database.

b) Splits tables by a specified number of splits or a specified number of records.
c) Creates WHERE conditions using the field PAGENO for de-clustering.
d) Creates WHERE conditions containing ASCII characters for Unicode conversions.

07. Which information is contained in the R3LOAD dump file header?

Please choose the correct answer.

a) File checksum
b) Compression ratio
c) Source system information
d) Migration key

08. What has to be considered if you want to use table splitting for an export/import?
There are 2 correct answers to this question.

a) The usage of Migration Monitor is mandatory.

b) The parallel import of packages into a single table makes sense on all databases.
c) The *.WHR files must be located in the same folder as the *.STR files.
d) The where_splitter must run on the *.WHR files created by R3TA and PL/SQL table splitter.

09. Which program do you use to perform table splitting during a DMO process?
Please choose the correct answer.

a) R3TA
b) R3LOAD
c) SAPup
d) MIGCHECK

10. What kind of information can be found in a R3LOAD *.STR file?

There are 3 correct answers to this question.

a) Initial extent values of tables

b) Database specific DDL statements
c) ABAP data types of fields
d) Primary key fields
e) TABARTs (data classes) of tables

11. Specific ROWID table splitting has limitations. What are these limitations? There are 2 correct
answers to this question
A. ROWID table splitting can be used if the target database is a non Oracle database
B. ROWID table splitting works only for transparent and nonpartitioned tables
C. ROWID splitted tables MUST be imported with the "-load procedure fast" option of R3load
D. ROWID table splitting cannot be performed during downtime of the SAP system
12. The ABAP/JAVA Dual Stack Split is not intended to be used in which of the following system?
Please choose the correct answer.
A. Export system
B. Homogeneous system
C. Import system
D. Heterogeneous system

13. Identify the reasons associated with the Homogeneous system copies?
There are 2 correct answers to this question
A. System move for multiple component
B. System move into or out MCOD Configuration
C. System move into single database
D. System move (hardware change)

14. How can the R3LOAD export / import duration be minimized?

There are 2 correct answers to this question.
A. By splitting of the package files
B. By adjusting the SAP instance profile parameters
C. By defining an alphabetical package export order
D. By using parallel export / import features

15. Which SAP Migration Tool writes its data in a format that is independent of database and
platform? Please choose the correct answer.
A. JSAPINST
B. JSLOAD
C. JPKCT
D. JLOAD
16. You notice that tables were loaded into the wrong database storage unit after a R3LOAD system
copy. Which of the following file types must you analyzed?
There are 2 correct answers to this question
A. .TPL
B. .STR
C. .TOC
D. .EXT
17. List down the features of Migration Monitor (MIGMON)?
There are 2 correct answers to this question
A. R3LOAD export or import parameter
B. Calls R3LOAD to generate import task files
C. Creates R3LOAD Import command files
D. Start R3LOAd process as soon as task starts

18. What does JLOAD do with the information from the *.STA files? Please choose the correct
answer
A. It finds the restart position after an import error
B. It create the import .XML files.
C. It imports metadata into a database
D. It generates time information for .[Link] files

19. A customer performs a JAVA dual stack split. The resulting ABAP and the JAVA instances stay an
the same host and the database is shared by both instances. - What is the result? * Please choose
the correct answer.
A. The JAVA SID changes and the DBSID remain the same
B. The ABAP SID changes and the DBSID changes
C. The JAVA SID changes and the DBSID changes
D. The ABAP SID changes and the DBSID remain the same

20. Where does R3LOAD search for *.SQL files? Please choose the correct answer.
A. In the export DATA directory
B. In the export DB directory
C. In the export MIGMON director
D. In the export target directory

21. Which of the following is not a benefit of SAP OS/DB Migration Check? Please choose the correct
answer.
A. Efficient Project Implementation through Migration Partners
B. Inspection of project schedule by SAP
C. Standardize positions for selected migrations
D. Independent of 3rd party stand-alone solution E. Standardize positions for all migrations
22. An import of the package IMPORT_8 failed. Which file does the JLOAD tool examine during
restart to identify the error?
A. IMPORT_8.LOG
B. IMPORT_I8 [Link]
C. IMPORT_8.STA
D. IMPORT_8.XML

23. Which of the following statements is TRUE regarding Operating System Level in Technical
Migration Preparation? There are 2 correct answers to this question Response:
A. Set up the migration file systems/directories
B. Make sure the current system has the right file system
C. Install migration tools
D. Import database with JLOAD

24. What are the special purposes of MIGMON in relation with ABAP Web AS – Target System Tasks
≥ NW 7.0? There are 2 correct answers to this question Response:
A. Generate R3LOAD command files (*.CMD)for data import
B. Generate R3LOAD task files (*.TSK) for data import (≥6.10)
C. Database update statistics
D. Import data from systems

25. Which SAP Migration Tool writes its data in a format that is independent of database and
platform? Please choose the correct answer. Response:
A. JLOAD
B. JSLOAD
C. JPKCT
D. JSAPINST

26. After a system copy. the target system is compling ABAP programs on =time. This is leading to
slow performance. How can you solve this issue? Response:
A. Update database statistics to ensure the optimal Cost Based Optimizer access path choice.
B. Repeat the import of package SAPOOOOSTR as it must have failed
C. Run transaction SGEN to generate ABAP loads
D. Execute transaction SICK to check the SAP system installation
27. Which of the following is an activity of SAP OS/DB Migration Check Analysis? Please choose the
correct answer. Response:
A. Check the production system regard to the migration system
B. Make recommendation for Hardware enhancement
C. Check DB migration set concerning the system
D. Analyze migration planning and OB system

28. Which of the following option is called to create the [Link] files for all target databases
where this file is needed? Please choose the correct answer.
Response:
A. SAPINST
B. JPSIZECHECK
C. JSIZECHECK
D. JPKGCTLCHECK

29. What information is contained in the .STR file? Note: There are 2 correct answers to this
question. Response:
A. Create Primary Key Command template
B. User-defined database functions
C. Table storage parameters
D. Fields of the primary key

30. How do you activate the trace option for the R3SZCHK program? Response:
A. Set environment variable R3SZCHK_TL=<1…4>
B. Call R3SZCHK with parameter —TL= <1…4>
C. Call R3SZCHK with parameter —TRACE_LEVEL=<1..A>
D. Set environment variable R3SZCHK _TRACE_LEVEL=<1 4>

31. The R3LOAD command line only contains the parameters required for reading the command file
and writing a log file. What happens if an R3LOAD process finds a '[Link] and a 'TSK file while
starting? Response:
A. it deletes the [Link] file and uses the TSK file.
B. it merges the [Link] file into the existing TSK file.
C. it reads the TSK file and copies it over the [Link] file.
D. it leaves the TSK and [Link] file as they are and terminates.

32. Select the correct sequence of ABAP DDIC – DB and Runtime ,

SAP Transaction SE11 Table view  Database Utility

33. Which file is updated dynamically by the MIGMONCTRL program during an SAP HANA Import
procedure.

ORDER_BY.txt

34. Steps to migrate ABAP based system

Technical Migration Preparation

Generate R3Load control files

35. R3Load tools performs the below taks,

It converts data to Unicode
It Compresses data on the block level

36. Common JLoad command line options has parameters, what are the parameters,

URL
Auth
Driver

37. What is the output of the OS/DB Migration check,

Suggestion of Parameter setting suited for the target system

38. Activities in OS/DB migration checks,

Analyze the SAP system & Database system log

Analyze the response time of the critical transactions