1.
Which of the following transactions are used to evaluate the work process statuses and activities that are currently happening?
Correct Answer(s)
A. SM50
C. SM66
Explanation
SM50 and SM66 are transactions in SAP that are used to evaluate the work process statuses and activities that are currently happening. SM50 is used to monitor the work processes in SAP system and provides information about the current status of each work process. SM66 is used to monitor the work process overview and displays the status of all work processes in the system. Therefore, these transactions are used to evaluate the work process statuses and activities that are currently happening.
2.
Which of the following are two key criteria when evaluating performance problems? Choose the correct answers.
Correct Answer(s)
A. Did the performance problem occurin the past
C. Is the problem happening right now?
Explanation
When evaluating performance problems, two key criteria to consider are whether the performance problem occurred in the past and whether the problem is happening right now. These criteria help to determine the frequency and persistence of the issue, which can provide insights into potential causes and solutions. The other options, such as which user is experiencing the problem and how close it is to quitting time, are not directly relevant to evaluating performance problems.
3.
SWAPS in transaction ST02 are an indication of high CPU utilization. Determine whether this statement is true or false.
Correct Answer
B. False
Explanation
The given statement is false. SWAPS in transaction ST02 are not an indication of high CPU utilization. SWAPS refer to the process of moving data between the main memory and the disk when the available memory is not sufficient. It is a measure of memory usage and not directly related to CPU utilization. High SWAPS may indicate a lack of memory, but it does not necessarily imply high CPU utilization.
4.
Which of the following profile parameters affect activation of dynamic work processes? Choose the correct answer.
Correct Answer
D. rdisp/dynamic_wp_check
Explanation
The profile parameter "rdisp/dynamic_wp_check" affects the activation of dynamic work processes. This parameter determines whether the system should check for the availability of dynamic work processes before executing a transaction. If this parameter is set to "1", the system will check for available work processes dynamically. If it is set to "0", the system will not perform this check. This parameter helps in managing the workload efficiently by activating additional work processes only when needed.
5.
Virtual memory is made up of OS swap or page file and physical memory components. Determine whether this statement is true or false.
Correct Answer
A. True
Explanation
The statement is true. Virtual memory is indeed made up of OS swap or page file and physical memory components. The OS swap or page file is a portion of the hard drive that is used as an extension of the computer's physical memory. When the physical memory becomes full, the operating system moves some data from the RAM to the swap file to free up space for other processes. This allows the computer to efficiently manage memory and run multiple programs simultaneously.
6.
In transaction ST02, there is a problem if there is a lot of swapping in the SAP buffers. Determine whether this statement is true or false.
Correct Answer
A. True
Explanation
In transaction ST02, there is a problem if there is a lot of swapping in the SAP buffers. This statement is true. Swapping refers to the process of moving data between the main memory and the disk when there is limited memory available. If there is excessive swapping in the SAP buffers, it can lead to performance issues and slow down the system. Therefore, it is considered a problem if there is a lot of swapping in the SAP buffers.
7.
Which of the following parameters lead to the allocation of heap memory for dialog processes? Choose the correct answers.
Correct Answer(s)
B. Em/max_size_MB
D. Ztta/roll_extension
Explanation
The parameters "em/max_size_MB" and "Ztta/roll_extension" lead to the allocation of heap memory for dialog processes. The "em/max_size_MB" parameter determines the maximum size of the extended memory (heap memory) that can be allocated for a dialog process, while the "Ztta/roll_extension" parameter determines the size of the extended memory (heap memory) used for roll area extensions in a dialog process.
8.
The user’s context is initially stored in the heap area in the shared memory.. Determine whether this statement is true or false.
Correct Answer
B. False
Explanation
The statement is false. The user's context is not initially stored in the heap area in the shared memory. The user's context typically includes information such as the program counter, registers, and stack pointer, and it is usually stored in the stack area of the memory. The heap area is used for dynamically allocated memory, while the shared memory is a region of memory that can be accessed by multiple processes or threads.
9.
Which of the following from the Operating System Monitor (transaction ST06) indicates that there is some hardware bottleneck in the SAP system if it happens all the time?
Correct Answer(s)
A. High CPU utilization near 100%
C. High swap/paging activity
Explanation
High CPU utilization near 100% indicates that the CPU is constantly busy and unable to handle the workload efficiently. This can be a sign of a hardware bottleneck as the CPU is unable to keep up with the demands of the system. High swap/paging activity also suggests a hardware bottleneck as it indicates that the system is frequently using disk space as virtual memory, which can slow down performance. Both of these factors point to a potential hardware limitation in the SAP system.
10.
There is hardware bottleneck in the CPU if processing time is more than twice the CPU time. Determine whether this statement is true or false.
Correct Answer
A. True
Explanation
The statement is true because a hardware bottleneck occurs when the processing time is significantly longer than the CPU time. If the processing time is more than twice the CPU time, it indicates that the CPU is not able to handle the workload efficiently, resulting in a bottleneck. This can lead to slower overall performance and reduced efficiency in processing tasks.
11.
Which of the following tools can be used to check the formulas and the values used in the formula-based memory parameters? Choose the correct answer.
Correct Answer
C. Executable program sappfpar
Explanation
The executable program sappfpar can be used to check the formulas and the values used in the formula-based memory parameters. This program allows users to analyze and display the current settings of the memory parameters and their formulas. It provides a comprehensive overview of the memory settings and allows for easy troubleshooting and adjustment of these parameters.
12.
pHYS_MEMSIZE indicates how much memory is used in an SAP instance and it can be used to automatically initiate changes of those formula-based memory parameters. Determine whether this statement is true or false.
Correct Answer
A. True
Explanation
The given statement is true. PHYS_MEMSIZE is a parameter in SAP that indicates the amount of memory used in an SAP instance. This parameter can be used to automatically adjust the values of other formula-based memory parameters based on the available memory. By monitoring the PHYS_MEMSIZE parameter, SAP can dynamically allocate memory resources and optimize performance.
13.
Which of the following statements is considered to be an expensive SQL statement? Choose the correct answers.
Correct Answer(s)
A. SQL statement which requires many records to be transferred to the ABAP program.
C. SQL statement which reads many blocks but retrieves only a few records from the database.
Explanation
An expensive SQL statement is one that requires a large number of records to be transferred to the ABAP program or reads many blocks but retrieves only a few records from the database. These operations can be time-consuming and resource-intensive, leading to slower performance and increased costs. SQL statements that use indexes during data retrieval or table buffering can actually improve performance by optimizing data access and reducing the need for full table scans.
14.
Which of the following statements is true about the SQL Monitor? Choose the correct answers.
Correct Answer(s)
A. SQL Monitor can be switched on for all or dedicated servers.
C. SQL Monitor can trace every SQL statement coming from ABAP programs, which include all OPEN SQL, native SQL, and ABAP kernel SQL statements.
D. SQL Monitor has low impact on the performance of the production system.
Explanation
The SQL Monitor can be switched on for all or dedicated servers, allowing for flexibility in monitoring options. It is designed to trace every SQL statement coming from ABAP programs, including OPEN SQL, native SQL, and ABAP kernel SQL statements. Additionally, the SQL Monitor has a low impact on the performance of the production system, ensuring that it does not significantly affect the overall system performance.
15.
Which of the following SQL statements cannot be tuned? Choose the correct answers.
Correct Answer(s)
B. SQL statements used by SAP Basis Tables
C. Recursive SQL Statements
D. SQL statements used by Database Administration Tools
16.
The ABAP trace (transaction SE30 or SAT) is the tool to use if we want to find out more about the expensive SQL statement and its execution plan. Determine whether this statement is true or false.
Correct Answer
B. False
Explanation
The statement is false. The ABAP trace is not the tool to use if we want to find out more about the expensive SQL statement and its execution plan. The ABAP trace is used to analyze the performance of ABAP programs and to identify performance bottlenecks within the ABAP code. To find out more about the expensive SQL statement and its execution plan, we should use tools like the SQL Trace (transaction ST05) or the SQL Performance Tuning Workbench (transaction SQLM).
17.
Which of the following can be found in the Explain function in SQL trace? Choose the correct answers.
Correct Answer(s)
A. Execution plan (table/index access)
B. Estimated costs/ Estimated rows
D. Table/indexes statistics
Explanation
The Explain function in SQL trace provides information about the execution plan, including table and index access. It also provides estimated costs and estimated rows for the query. Additionally, it includes table and index statistics that can help in analyzing the query performance. Memory usage, however, is not typically found in the Explain function.
18.
Programs which show database request time > 40 % (response time – wait time) in the transaction profile of ST03 are potential candidates for containing expensive SQL statements. Determine whether this statement is true or false.
Correct Answer
A. True
Explanation
The statement is true. In the transaction profile of ST03, if the database request time is greater than 40% of the response time minus the wait time, it indicates that the SQL statements used in the program are taking a significant amount of time to execute. This suggests that the program may contain expensive SQL statements, which could be optimized to improve performance.
19.
Which of the following are valid options for table buffering types? Choose the correct answers.
Correct Answer(s)
A. Single record buffered
B. Generic area buffered
C. Fully buffered
Explanation
The valid options for table buffering types are "Single record buffered," "Generic area buffered," and "Fully buffered." These buffering types are used in different scenarios to optimize data access and improve performance in SAP systems. "Single record buffered" buffers only one record at a time, "Generic area buffered" buffers a range of records, and "Fully buffered" buffers the entire table. These buffering types allow for faster data retrieval and reduce the need for frequent database access, improving overall system performance.
20.
Which of the following parameter controls the buffer synchronization behavior in the SAP system? Choose the correct answer.
Correct Answer
C. rdisp/bufremode
Explanation
The parameter "rdisp/bufremode" controls the buffer synchronization behavior in the SAP system. This parameter determines whether the buffer should be removed or not when a process is terminated. By setting this parameter to a specific value, the system can be configured to either remove the buffer or keep it intact when a process is terminated.
21.
Table buffering is recommended for which of the following scenarios ? Choose the correct answers.
Correct Answer(s)
A. Tables that are seldom changed.
C. Customizing data.
Explanation
Table buffering is recommended for tables that are seldom changed and for customizing data. Table buffering involves storing frequently accessed data in the application server's memory, which improves performance by reducing the number of database accesses. This is particularly useful for tables that are seldom changed, as it allows for faster retrieval of data without the need to constantly access the database. Additionally, customizing data, which refers to data that is specific to a particular system or organization, can also benefit from table buffering as it often remains unchanged and is frequently accessed.
22.
SQL trace (transaction ST05) offers a lot of information on table accesses, which includes the database activities, number of ABAP requests, and number of invalidations. Determine whether this statement is true or false.
Correct Answer
B. False
Explanation
The statement is false because SQL trace (transaction ST05) provides information on SQL statement execution and performance, not on table accesses, database activities, ABAP requests, or invalidations.
23.
Which of the following types of RFC calls guarantees multiple communications steps in a specific order?
Correct Answer
C. Queued RFC
Explanation
Queued RFC calls guarantee multiple communication steps in a specific order. In a Queued RFC, the system stores the request in a queue and processes it in the order it was received. This ensures that the communication steps are executed sequentially and in the desired order. Unlike other types of RFC calls, Queued RFCs allow for reliable and ordered message processing, making them suitable for scenarios where strict sequencing is required.
24.
What is RFC+CPIC time in synchronous RFC? Choose the correct answer.
Correct Answer
B. Time needed to establish the RFC communication plus roll out time, roll wait time, and roll in time.
Explanation
The RFC+CPIC time in synchronous RFC refers to the time needed to establish the RFC communication to the RFC server, as well as the roll out time, roll wait time, and roll in time. This means that it includes the time required for establishing the communication channel and also the time for data transfer and processing. Additionally, it takes into account any delays caused by the roll out, roll wait, and roll in processes. The GUI time, on the other hand, is not relevant to the RFC+CPIC time in synchronous RFC.
25.
Which of the following tools is best for monitoring and analyzing issues in the transactional RFC queue? Choose the correct answer.
Correct Answer
A. SM58
Explanation
SM58 is the correct answer for monitoring and analyzing issues in the transactional RFC queue. SM58 is a transaction code in SAP that allows users to view and manage the transactional RFC queue. It provides detailed information about the status of each transaction, such as whether it was successfully executed or if there were any errors or issues. Users can also use SM58 to reprocess failed transactions and monitor the overall performance of the RFC queue.
26.
Which of the following RFC quota parameters should be set to maintain the number of dialog work processes that should be kept free for users? Choose the correct answer.
Correct Answer
B. rdisp/rfc_min_wait_dia_wp
Explanation
The correct answer is "rdisp/rfc_min_wait_dia_wp". This parameter should be set to maintain the number of dialog work processes that should be kept free for users. It determines the minimum number of dialog work processes that should be available for user requests, ensuring that there are enough processes to handle user interactions efficiently.