C_TADM70_21 – SAP Certified Technology Associate – OSDB Migration for SAP NetWeaver 7.52 (125 Questions)

The “SAP Certified Technology Associate – OS/DB Migration for SAP NetWeaver 7.52” certification exam certifies a candidate’s technical skill and equips them to assist clients in managing and carrying out critical business activities. The candidate might use his or her understanding of OS/DB migration for SAP systems and SAP NetWeaver 7.52 in projects as a technology consultant.

Topic Areas

C_TADM70_21 – SAP Certified Technology Associate – OSDB Migration for SAP NetWeaver 7.52 exam covers the following topics:

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

Exam details:

Here is the List of MCQ’s (Multiple Choice Questions):                         (The correct answers are mentioned with *)

1. 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 STAT.XML
c. IMPORT_8.STA*
d. IMPORT_8.XML

2. Which of the following statements is TRUE regarding Operating System Level in Technical Migration Preparation? There are 2 correct answers to this question
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

3. 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
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

4. Which SAP Migration Tool writes its data in a format that is independent of database and platform? Please choose the correct answer.
a. JLOAD*
b. JSLOAD
c. JPKCT
d. JSAPINST

5. 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?
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

6. Identify the activities involved in SAP OS/DB Migration Check Verification? There are 2 correct answers to this question
a. Analyze the SAP System and database system logs*
b. Analyze the response times of the critical transactions*
c. Analyze the response of multiple component
d. Analyze the performance in the DB system

7. Which files does the JPKGCTL tool create? There are 2 correct answers to this question.
a. <PACKAGE>.xml*
b. Jsplitter_cmd.properties
c. splitrules.txt
d. sizes.xml*

8. What is the actual use of Migration Monitor – FTP Configuration Variant? Please choose the correct answer.
a. Directory
b. Environments*
c. Location
d. Systems

9. Which tables are converted into transparent tables during the migration to an SAP HANA database? Note: There are 2 correct answers to this question.
a. Pool tables*
b. Dictionary tables
c. QCM tables
d. Cluster tables*

10. Which ABAP data dictionary definations are available when you use R3LDCTL. to generate structure file for heterogeneous and homogeneous system copies?
a. Partition fields
b. Compression fields
c. Primary key fields*
d. View fields

11. Which of the following cases does not support An R3LOAD homogeneous or heterogeneous system copy of SAP systems in R3LOAD Restrictions?
There are 2 correct answers to this question
a. The Operational Table Conversion (OTC) has been started
b. The REPARE phase of improvement has been started
c. The PREPARE phase of an upgrade has been started*
d. The Incremental Table Conversion (ICNV) has been started*

12. Identify the most suitable option for- “Export JAVA stack and import into the same database, but as MCOD installation. Remove original JAVA stack”
Please choose the correct answer.
a. Move JAVA stack
b. Keep JAVA database*
c. Move Java database
d. Remove JAVA stack

13. Which file is updated dynamically by the MIGMONCTRL program during an SAP HANA import procedure?
a. SAP<CLUSTER>.STR.LOGICAL
b. MIGMONCTRL_CMD.PROPERTIES
c. CPU_USAGE.CSV
d. ORDER_BY.TXT*

14. What kind of information can be found in a R3LOAD *.STR file?
There are 3 correct answers to this question.
a. TABARTs (data classes) of tables*
b. ABAP data types of fields*
c. Database specific DDL statements
d. Initial extent values of tables
e. Primary key fields*

15. Which program is started by SAPINST to export an ABAP system?
a. DIPGNTAB
b. MIGCHECK
c. MIGMON*
d. R3LOAD

16. Which of the following File gives a good control over the unload or load process in SAPINST NetWeaver?
Please choose the correct answer.
a. *.FTP file
b. *.STAT file
c. *.STP file
d. *.STR file*

17. Which of the following option is a Technical Parameter for the ABAP Dictionary? Please choose the correct answer.
a. TABDAT
b. TABDM
c. TABDRT
d. TABKAT*

18. Which of the following statements are TRUE regarding R3LOAD ABAP Data Export/Import?
There are 2 correct answers to this question.
a. Table Splitting for multiple data process
b. Requires syntax check for heterogeneous data import
c. Implementation is database and platform specific*
d. Efficient data compression*

19. JLOAD did not only export the table data, it also generated it own export/import job Files. How JLOAD is creating Job file?
Please choose the correct answer.
a. 6.0 JPKGCTL
b. 7 JPKGCTL
c. 7.01JPKGCTL
d. 7.02 JPKGCTL*

20. Which of the following statements are TRUE regarding SAPINST with step Browser functionality?
There are 2 correct answers to this question.
a. Repeat an installation step*
b. Rename programs like DBMIG.R3S
c. Skip an installation step*
d. Skip the export and import processes

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

21. Which of the following is not a DDL Statements for Non-Standard DDIC Objects?
Please choose the correct answer.
a. Perform database specific adaptations after conversion*
b. Mandatory for all systems based on NetWeaver’04 and later
c. Mandatory for BW and other SAP systems based on BW functionalities
d. Perform database specific adaptations after import

22. Which file does SAPINST use to continue after an error?
a. message.xml
b. control.xml
c. dialog.xml
d. keydb.xml*

23. How can the R3LOAD export / import duration be minimized?
There are 2 correct answers to this question.
a. By using parallel export / import features*
b. By defining an alphabetical package exportorder
c. By adjusting the SAP instance profileparameters
d. By splitting of the package files*

24. You use the database migration option for SUM when moving to SAP HANA. Which features are available?
Note: There are 2 correct answers to this question
a. Split the SAP source system Java dual stack during import
b. Convert the SAP system to unicode during export*
c. Import the SAP target system using MIGMON and MIGCHECK
d. Upgrade the SAP target system to the required release*

25. Which file does JPKGCTL create to enable an optimized export of packages?
a. jsplitter_cmd.properties
b. dbsize.xml
c. split_input txt
d. sizes.xml*

26. Which of the following can significantly change the size of source and target database storage units?
Please choose the correct answer.
a. Table Space
b. Storage Unit
c. Default Setting
d. Table Movement*

27. The R3LOAD tool aborted during a system copy import Flow are the entries adjusted when you merge the task files?
Note: There are 2 correct answers to this question
a. ‘xeg entries from the TSK BCK file are saved as ‘err in the TSK file*
b. ‘ok’ entries from the TSK file are saved as ‘ok’ in the TSK file*
c. ‘xeq’ entries from the TSK file are saved as ‘Ign’ in the TSK file
d. ‘ok’ entries in TSK BCK are saved as ‘xeci in the TSK file

28. List down the characteristics for both Application Server ABAP (AS ABAP) and Application Server Java (AS Java)?
There are 3 correct answer to this question.
a. Common database (with different schemas for ABAP and Java) *
b. Common startup background
c. Common SID for all application servers and the database*
d. Common target database
e. Common startup framework*

29. List down the features of Migration Monitor (MIGMON)?
There are 2 correct answers to this question
a. R3LOAD export or import parameter
b. Start R3LOAd process as soon as task starts
c. Creates R3LOAD Import command files*
d. Calls R3LOAD to generate import task files*

30. The ABAP/JAVA Dual Stack Split is not intended to be used in which of the following system? Please choose the correct answer.
a. Import system
b. Homogeneous system
c. Export system
d. Heterogeneous system*

31. Which of the following is not an Initial extent sizes for .EXT Calculation? Please choose the correct answer.
a. Secondary index
b. Target*
c. Table
d. Primary index

32. Which of the following programs generate Java Job files to support a parallel export and import?
a. JPKGCTL*
b. JMIGMON
c. JLOAD
d. JSIZECHECK

33. What are the operating levels for Technical Post-Migration Activities?
There are 3 correct answers to this question.
a. Set up database storage units
b. Install the SAP system license*
c. Perform a file system backup*
d. Set up external interfaces*
e. Install the latest SAP system

34. You perform a Java migration. What information is stored in the sizes.xml?
a. The actual size of each data dump file
b. The exported size of each table andindex
c. The calculated size of the target database
d. The expected export size of eachpackage*

35. List down the steps for Optimizing the Export / Import Process?
There are 2 correct answers to this question
a. Split existing package files*
b. Create separate package files for large tables*
c. Parallelize export method
d. Take care of files for import order

36. Which of the following option is not a PERL-Based Package Splitter? Please choose the correct answer.
a. Backward compatible up to 4.0B
b. Available since release 4.6B, used up to NetWeaver ‘04
c. Requires pearl version 5 or higher*
d. Backward compatible up to 5.0B

37. You perform a Java dual stack split. Which split options do you have?
Note: There are 3 correct answers to this question
a. Keep DB*
b. Migrate DB
c. Upgrade DB
d. Move DB*
e. Remove*

38. What does R3LOAD -ctf I→resultingtaskFilecontent?
There are 2 correct answers to this question.
a. P TAB01~0 C xeq
b. T TAB01 C xeq*
c. P TAB01~0 I xeq
d. T TAB01 _lC xeq
e. E. D TAB01 I xeq*

39. Which tasks does the JPKGCTL tool perform?
Note: There are 3 correct answers to this question.
a. It computes package size information*
b. It creates export / import job files*
c. It computes target database size
d. It performs package splitting*
e. It controls multiple JLoad processes

40. List down the requirements refer to the technical implementation of the migration?
There are 2 correct answers to this question.
a. Extensive migration planning for three weeks
b. At least one week time for final migration
c. Certified SAP Technology Consultant for OS/DB migrations*
d. SAP ABAP Dictionary Knowledge*

41. 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 where_splitter must run on the *.WHR files created by R3TA and PL/SQL table splitter.
b. The usage of Migration Monitor is mandatory*
c. The *.WHR files must be located in the same folder as the *.STR files*
d. The parallel import of packages into a single table makes sense on all databases.

42. List down the requirements refer to the technical implementation of the migration?
There are 2 correct answers to this question
a. Certified SAP Technology Consultant for OS/DB migrations*
b. Extensive migration planning for three weeks
c. SAP ABAP Dictionary Knowledge*
d. At least one week time for final migration

43. What are the steps required to migrate an ABAP based system
There are 2 correct answers to this question.
a. Unload export database
b. Generate R3LOAD control files
c. Technical migration preparation*
d. Generate .*TSK files only*

44. What is the actual use of Migration Monitor – FTP Configuration Variant?
Please choose the correct answer.
a. Environments*
b. Directory
c. Location
d. Systems

45. You perform a Java dual stack split. Which split options do you have?
Note: There are 3 correct answers to this question.
a. Migrate DB
b. Upgrade DB
c. Remove*
d. Move DB*
e. Keep DB*

46. Which of the following is not an activity of R3LOAD?
Please choose the correct answer.
a. table= Create table/extent size limit*
b. data = Load data only (table must be created manually)
c. all = Create table/index and load data
d. struct = Create table/index, but do not load any data

47. What are the important points associated with R3LOAD restart export?
There are 2 correct answers to this question
a. Export restarts*
b. Delete table content
c. Read next task with status
d. Read next write position in dump file from *.TOC*

48. What are the DISTMON – Restrictions?
There are 2 correct answers to this question
a. Only the “NET” mode of MIGMON is implemented*
b. DISTMON is making use of R3LOAD features is available below 5.40
c. DISTMON is not supported below SAP basis 6.20*
d. For SAP systems with JAVA add-in, the ABAP and the JAVA Part must be exported/ importedjointly

49. Which of the following statement is TRUE regarding Required Source System Technical Information?
Please choose the correct answer.
a. Limited disk space for unloading the data
b. Internal files and target systems
c. Tables in ABAP Dictionary but not in DB or vice versa*
d. Transport tables from source to target system

50. List down the reasons for common Heterogeneous system copy?
There are 3 correct answers to this question.
a. Cost reduction*
b. Verification sessions
c. Project analysis
d. Hardware enhancements*
e. Performance improvement*

51. In which directory are the EXPDUMP_<PACKAGE>.<nnn> files located?
a. ABAP/DATA
b. JAVA/DB/<BDS>
c. <export_dir>/JDMP*
d. ABAP/DB/<DBS>

52. Which of the following cases does not support An R3LOAD homogeneous or heterogeneous system copy of SAP systems in R3LOAD Restrictions?
There are 2 correct answers to this question
a. The REPARE phase of improvement has been started
b. The Operational Table Conversion (OTC) has been started
c. The Incremental Table Conversion (ICNV) has been started*
d. The PREPARE phase of an upgrade has been started*

53. An import of the package IMPORT_8 failed. Which file does the JLOAD tool examine during restart to identify the error?
a. IMPORT_8.STA*
b. IMPORT_8.XML
c. IMPORT_I8 STAT.XML
d. IMPORT_8.LOG

54. What are the operating levels for Technical Post-Migration Activities?
There are 3 correct answers to this question
a. Set up external interfaces*
b. Perform a file system backup*
c. Install the latest SAP system
d. Install the SAP system license
e. Set up database storage units*

55. Which file does JPKGCTL create to enable an optimized export of packages?
a. split_input txt
b. jsplitter_cmd.properties
c. sizes.xml*
d. dbsize.xml

56. What was the main purpose of the JSPLITTER development?
Please choose the correct answer.
a. To reduce the Import/Export runtime for large JAVA system*
b. To run migration system over different application server
c. To improve the Import/Export support requirement
d. To check the resource availability for JAVA system

57. How does an Importing MIGMON process identify if all packages were successfully exported in a parallel export/import scenario?
a. it checks the export statistics properties file for errors*
b. it compares the number of packages web the number of signal files.
c. it analyzes the content of the export tasks files.
d. it verifies the export logs for proper termination.

58. The SAP system copy tools can be used for system copies or migrations on any SAP supported operating system and database combination as of R/3 Release 3.0D. Name the system copies?
There are 2 correct answers to this question
a. Heterogenous*
b. Homogenous*
c. OP Migration
d. OB Migration

59. What information can be found in a *.TOC file?
There are 3 correct answers to this question.
a. The total number of rows exported for all packages of a splitted table.
b. The identifier into which database the export dump can be imported.
c. The first and last data block of the exported table data in the dump file*
d. The table name, dump file name and header data*
e. The where condition in case of table splitting*

60. Which of the following statements are TRUE regarding R3LOAD ABAP Data Export/Import?
There are 2 correct answers to this question.
a. Efficient data compression*
b. Requires syntax check for heterogeneous data import
c. Table Splitting for multiple data process
d. Implementation is database and platform specific*

Join SAP Learner Community on LinkedIn – https://www.linkedin.com/showcase/sap-learner-community

61. Which one of the following is not a feature of Time Analyzer (MIGTIME / JMIGTIME)?
Please choose the correct answer.
a. Calculate the export/import runtime per package
b. Join import/export information information
c. Provides common list for data load
d. Export/Import statistics are generated separately

62. Which of the following is a support tool for ABAP system copies?
Please choose the correct answer.
a. ANAMON
b. AUTOMON
c. TABMON
d. DISTMON*

63. In which Export Dump directory do you find the SQLFiles.LST file?
a. <Export Dump>/DB/<DBS>
b. <Export Dump>/DATA
c. <Export Dump>/<Install Directory>
d. <Export Dump>/DB*

64. Name the two systems associated with the Import JAVA System?
There are 2 correct answers to this question.
a. Central System*
b. Distributed System*
c. Application System
d. File System

65. Where does R3LOAD search for *.SQL files?
a. In the export DATA directory
b. In the export DB directory*
c. In the export target <DBS> directory
d. In the export MIGMON director

66. From which file types does the MIGTIME tool retrieve time information?
Note: There are 2 correct answers to this question.
a. *.TSK
b. *.STR
c. *.TOC*
d. *.LOG*

67. Which of the following is used to determine the assignment of a table to a specific table category?
Please choose the correct answer.
a. “Max Extent”
b. “Min Extent”
c. “Next Extent” *
d. “Default Initial Extent”

68. Which of the following statement is TRUE regarding JMIGMON functions and operation variants?
Please choose the correct answer.
a. JMIGMON cannot start JLOAD processes
b. JMIGMON should not be inspected in case of export or import errors
c. JMIGMON is used to start JLOAD processes only*
d. JPKGCTL will add as many tables to a package until the size limit is reached

69. Which of the following is not a R3SETUP/SAPINST load error?
Please choose the correct answer.
a. Solve the load problem
b. Change into the install directory
c. Start many additional R3LOAD process
d. Get R3LOAD parameters from file “FILE” *

70. What are the General configuration Parameters for Migration Monitor (MIGMON)?
There are 2 correct answers to this question.
a. Socket Parameters*
b. FTP Parameters*
c. Usage Parameters
d. Process Parameters

71. Which tasks does the R3LOAD tool perform?
Note: There are 2 correct answers to this question.
a. It exports data dictionary definitions.
b. It converts data to unicode. *
c. It writes platform-dependent dumps
d. It compresses data on the block level. *

72. Which of the following is a JLOAD: Export / Import Statistic Files?
Please choose the correct answer.
a. *.<STAT>.XML
b. *.XML
c. *.STA
d. *.STAT.XML*

73. Which of the following is not a Post-Migration Test Activities
Please choose the correct answer.
a. Test typical transactions from day to day business*
b. Verify communication with internal system
c. Run reports to compare results to those in the source system
d. Set up a test environment

74. Which of the following is not a support tool for ABAP system copies?
Please choose the correct answer.
a. PACKAGE SPLITTER
b. SMIGR*
c. MIGCHECK
d. TABLE SPLITTER

75. Which of the following statement is TRUE regarding .TSK: Description?
Please choose the correct answer.
a. Simplifying the R3LOAD restart*
b. Minimize the R3LOAD to handle
c. Easy to restart tables
d. Supports table splitting since 7.0

76. Give Reasons for – During a homogeneous or heterogeneous R3LOAD system copy, tables may be moved unintentionally from one database storage unit to another.
There are 2 correct answers to this question
a. Some tables were assigned to TABMATs of other database storage units
b. R3LOAD always creates tables and indexes in locations obtained from the ABAP Dictionary*
c. ABAP Dictionary parameters were arranged after the customer had re-distributed the tables
d. Older SAP System Releases were installed with slightly different table locations than subsequent releases*

77. Which of the following is not a question for- SAP OS/DB Migration Check Project Audit?
Please choose the correct answer.
a. Name of the Migration Partner
b. Description of the Productive System(s) *
c. Description of the Target System(s)
d. Description of the Source System(s)

78. Common JLOAD Command Line Options has parameters. What are these parameters?
There are 3 correct answers to this question.
a. dbetch
b. url*
c. auth*
d. APPL
e. driver*

79. What does JLOAD do with the information from the *.STA files?
a. lt finds the restart position after an import error*
b. lt create the import <PACKAGE>.XML files.
c. It generates time information for <PACKAGE>.STAT.XML files.
d. It imports metadata into a database.

80. In what order are tasks executed during the export of an AS ABAP-based SAP source system?
a. R3LDCTL — R3SZCHK — R3LOAD*
b. R3LDCTL — R3LOAD — R3SZCHK
c. R3SZCHK — R3LDCTL — R3LOAD
d. R3LOAD — R3SZCHK — R3LDCTL

81. Specific ROWID table splitting has limitations. What are these limitations?
There are 2 correct answers to this question
a. ROWID table splitting cannot be performed during downtime of the SAP system
b. ROWID table splitting can be used if the target database is a non Oracle database.
c. ROWID table splitting works only for transparent and nonpartitioned tables*
d. ROWID splitted tables MUST be imported with the “-load procedure fast” option of R3load*

82. Which tasks does the R3TA tool perform?
There are 2 correct answers to this question.
a. Splits tables by a specified number of splits or a specified number of records*
b. Creates WHERE conditions using the field PAGENO for de-clustering.
c. Splits tables by ROWIDs if the source system is running on an Oracle database.
d. Creates WHERE conditions containing ASCII characters for Unicode conversions*

83. Which of the following is used to determine the assignment of a table to a specific table category?
Please choose the correct answer.
a. “Min Extent”
b. “Default Initial Extent”
c. “Next Extent” *
d. “Max Extent”

84. Name the two systems associated with the Import JAVA System?
There are 2 correct answers to this question
a. Distributed System*
b. File System
c. Application System
d. Central System*

85. Which program creates the EXPORT.XML and IMPORT.XML files?
a. SAPINST
b. JPKGCTL
c. SDM
d. JLOAD*

86. Name the tables which may not exist in NetWeaver systems?
There are 2 correct answers to this question.
a. TGDB2*
b. IGDB2
c. TGAB2
d. IGAB2*

87. Which source does R3LOAD use to populate the TSK files?
a. Database data dictionary*
b. ABAP data dictionary
c. Extent files
d. Structure files

88. Identify the reasons associated with the Homogeneous system copies?
There are 2 correct answers to this question
a. System move (hardware change) *
b. System move into single database
c. System move into or out MCOD Configuration*
d. System move for multiple component

89. What is required for custom export/import order definitions and even the change of individual parameters for each single package?
Please choose the correct answer.
a. PKGNAME
b. SAPINST*
c. ORDER
d. PKGID

90. What can you do with the Software Provisioning Manager?
Please choose the correct answer.
a. SAP System automated configuration and verification
b. SAP System upgrade
c. SAP Front End installation and distribution
d. SAP System uninstall*

91. What are the General configuration Parameters for Migration Monitor (MIGMON)?
There are 2 correct answers to this question.
a. Socket Parameters*
b. Process Parameters
c. FTP Parameters*
d. Usage Parameters

92. Which of the following option is not a Technical characteristic of the ABAP Dictionary?
Please choose the correct answer.
a. Each table type belong to a certain database storage unit
b. Tables are generally assign to a table type
c. Large table type cannot be saved by storage unit*
d. Different table types can be saved in the same database storage unit

93. Which of the following are the Sockets using R3LOAD Export/Import?
There are 2 correct answers to this question
a. Released since R3LOAD6.40
b. Fully supported by the SAPINST
c. Features concurrent export and import*
d. Network connection is a must*

94. What are the features associated with the Migration / Table Checker (MIGCHECK)
There are 3 correct answers to this question.
a. Verifies the table contents
b. Can handle export and import files
c. Verifies the task file content*
d. Used by SAPINST*
e. Long running task*

95. Which information is contained in the R3LOAD dump file header?
Please choose the correct answer.
a. Migration key
b. Compression ratio
c. File checksum
d. Source system information*

96. Which actions does the R3LOAD tool perform?
Note: There are 2 correct answers to this question.
a. It executes the unicode conversion of customer systems during import.
b. It verifies the syntax of control files during export and import*
c. It identifies if a migration key is required when performing the import.
d. It always creates the primary keys before the data load*

97. What information can be found in *.CMD files during an export/import?
There are 2 correct answers to this question.
a. The name of the dump file.
b. The where condition in case of table splitting.
c. The maximum size of a dump file. *
d. The location of the used *.TSK and *.STR file. *

98. Which program is started by SAPINST to ensure that the ABAP DDIC is consistent in the target system?
a. R3LOAD
b. MIGCHECK
c. R3SZCHK
d. DIPGNTAB*

99. What information does a DDL<DBS>.TPL file contain?
Note: There are 3 correct answers to this question.
a. Instruction to create primary keys before or after data load*
b. List of tables to be created without primary keys or secondary indexes
c. SQL templates for creating tables, Indexes and views*
d. Truncate SQL template for selectively removing split table data
e. Keyword for exporting data either sorted or unsorted*

100. Identify the migration support tools from the following options?
There are 2 correct answers to this question.
a. MIGMON*
b. TABMON
c. JSPLITTER
d. PACKAGE SPLITTER*

Join SAP Learner Community on LinkedIn – https://www.linkedin.com/showcase/sap-learner-community

101. 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?
a. The JAVA SID changes and the DBSID changes
b. The JAVA SID changes and the DBSID remain the same*
c. The ABAP SID changes and the DBSID remain thesame
d. The ABAP SID changes and the DBSID changes

102. List down the Migration Monitor – Net Configuration Variant?
There are 2 correct answers to this question
a. Network: Export directory is shared with target system
b. FTP: File transfer via ASP between source and target system
c. Network: Export directory is shared between source and target system*
d. FTP: File transfer via FTP between source and target system*

103. What are the features of the NZDT method for heterogeneous system copies?
Note: There are 2 correct answers to this question
a. It provides a proxy system as central migration controller on the target database system
b. It synchronizes data between the source and the target database system*
c. It logs table data changes based on database triggers
d. It allows restriction.free transports to the source system while triggers are active*

104. 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. Independent of 3rd party stand-alone solution
c. Standardize positions for selected migrations
d. Inspection of project schedule by SAP*
e. Standardize positions for all migrations

105. Which files can you find in the ABAP <ExportDir>/DB/DBS> directory?
Note: There are 2 correct answers to this question.
a. SQL files (*.SQL) *
b. Structure files (*.SIR)
c. Template files (*.TPL)
d. Extent files (*.EXT) *

106. What is the output of the OS/DB Migration Check?
a. Suggestion for parameter settings suited for the target system*
b. Recommendation of migration tool versions to be used
c. Verification of the data consistency within the migrated target system
d. Optimization of the export/import system setup

107. Common JLOAD Command Line Options has parameters. What are these parameters?
There are 3 correct answers to this question.
a. APPL
b. url*
c. auth *
d. dbetch
e. driver*

108. Which tasks does the R3LOAD tool perform?
Note: There are 2 correct answers to this question.
a. It converts data to unicode*
b. It exports data dictionary definitions.
c. It writes platform-dependent dumps
d. It compresses data on the block level*

109. What are the steps required to migrate an ABAP based system
There are 2 correct answers to this question
a. Technical migration preparation*
b. Generate R3LOAD control files*
c. Generate .*TSK files only
d. Unload export database

110. Which file is updated dynamically by the MIGMONCTRL program during an SAP HANA import procedure?
a. CPU_USAGE.CSV
b. ORDER_BY.TXT*
c. SAP<CLUSTER>.STR.LOGICAL
d. MIGMONCTRL_CMD.PROPERTIES

111. Select the correct sequence of ABAP DDIC – DB and Runtime from the following option?
Please choose the correct answer.
a. SAP transaction SE11->Runtime object->SelectUnit
b. SAP transactionSE11-> Database utility-> Select object
c. C.SAP transactionSE11-> Runtime-> Database Utility
d. SAP transactionSE11-> Table view-> Database utility*

112. 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?
Note: There are 2 correct answers to this question
a. .TOC
b. .STR*
c. .EXT
d. .TPL*

113. The JMIGMON network configuration is useful in environments, where file systems can be shared between source and target system. What are these systems?
There are 2 correct answers to this question
a. Create System
b. Edit System
c. Exporting System*
d. Importing System*

114. What information is contained in the <PACKAGE>.STR file?
Note: There are 2 correct answers to this question.
a. Create Primary Key Command template
b. Table storage parameters
c. Fields of the primary key*
d. User-defined database functions*

115. What file types are created by R3LDCTL?
Please choose the correct answer.
a. <PACKAGE>.STR, DBSIZE.XML
b. DDL<DBS>.TPL, <PACKAGE>.STR*
c. <PACKAGE>.STR, <PACKAGE>.EXT
d. DDL<DBS>.TPL, <TABART>.SQL

116. Name the function required to adjust the SAP JAVA target system for the new instance name, instance number, host name, etc.?
Please choose the correct answer.
a. JLOAD PART
b. LOAD Controller
c. Migration Controller*
d. Migration Director

117. How will you prevent the export or import of unwanted table data in R3LOAD activity?
Please choose the correct answer.
a. Tables marked with “struct” *
b. Tables marked with “STR”
c. Tables marked with “data”
d. Tables marked with “all”

118. Which of the following statements are TRUE regarding ABAP DDIC Export and DB Object Size Calculation?
There are 3 correct answers to this question
a. Implementation is database-specific and platform-specific*
b. Creates the view structure file (*.STR) *
c. Creates UNICODE templates
d. DB object file limits apply
e. DB object size limits apply*

119. 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 create primary key task, R3LOAD will delete data and recreate the primary key to restart the import. *
b. If the status is „err“ for a create table task, R3LOAD will drop and recreate the table to restart the import. *
c. If a status is „err“ for a create index task, R3LOAD will drop the index and recreate it to restart the import.
d. If the status is „err“ for a data import task, R3LOAD will drop the table to restart the import.

120. What are the Typical warning in R3SZCHK.log if reaching the size limit?
There are 2 correct answers to this question.
a. WARNING: REPOLOAD in SLEXC: initial extent reduced to 1782579201
b. WARNING: /BLUESKY/FECOND in APPL0: initial extent reduced to 1782579200*
c. WARNING: REPOLOAD in SLEXC: initial extent reduced to 1782579200*
d. WARNING:/BLUESKY/FECOND in APPL0:initial extent reduced to 1782579222

121. Which of the following is an activity of SAP OS/DB Migration Check Analysis?
Please choose the correct answer.
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

122. Which of the following option is called to create the DBSIZE.XML files for all target databases where this file is needed?
Please choose the correct answer.
a. SAPINST
b. JPSIZECHECK
c. JSIZECHECK*
d. JPKGCTLCHECK

123. What information is contained in the <PACKAGE>.STR file?
Note: There are 2 correct answers to this question.
a. Create Primary Key Command template
b. User-defined database functions*
c. Table storage parameters
d. Fields of the primary key*

124. How do you activate the trace option for the R3SZCHK program?
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>

125. 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 ‘TSK.BCK and a ‘TSK file while starting?
a. it deletes the TSK.BCK file and uses the TSK file.
b. it merges the TSK.BCK file into the existing TSK file.
c. it reads the TSK file and copies it over the TSK.BCK file.
d. it leaves the TSK and TSK.BCK file as they are and terminates. *

Hope these MCQ’s will help you with your SAP certification.

Good Luck!!

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

Join SAP Learner Community on LinkedIn – https://www.linkedin.com/showcase/sap-learner-community

Visit our website – https://www.zarantech.com

Keep learning & innovating!

Here is some other SAP Certification MCQ’s for your reference:

P_SECAUTH_21 – SAP Certified Technology Professional – System Security Architect (80 Questions)

C_TS410_2020 – SAP Certified Application Associate – Business Process Integration with SAP S4HANA 2020 (90 Questions)