Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Buchita
B
Buchita
Community Contributor
Quizzes Created: 1 | Total Attempts: 148
| Attempts: 148 | Questions: 95
Please wait...
Question 1 / 95
0 %
0/100
Score 0/100
1. Which memory area is allocated at instance start?

Explanation

At instance start, the memory area that is allocated is the extended memory. This is a type of memory that is used in older computer systems to extend the available memory beyond the limitations of the base memory. It is typically used for storing large amounts of data or running complex programs.

Submit
Please wait...
About This Quiz
Your Boi Amd315 Quiz - Quiz

This quiz focuses on RFC (Remote Function Call) management in enterprise systems, exploring tools, parameters, and monitoring techniques.

Tell us your name to personalize your report, certificate & get on the leaderboard!
2. What is the SAP Operating System Collector (SAPOSCOL)?

Explanation

The correct answer is that SAPOSCOL is an SAP proprietary standalone program for collecting Operating System usage information. This means that SAPOSCOL is a program developed by SAP that is used to gather data on how the operating system is being utilized. It is not an alternative to the Operating System Monitor or a built-in tool in ABAP systems, nor is it a third-party tool.

Submit
3. How is SAP Dialog Response time defined?

Explanation

The SAP Dialog Response time is defined as the timespan between the dispatcher receiving a request and sending out the final response to the front end. This means that it measures the time it takes for the dispatcher to process the request and provide the necessary information to the front end.

Submit
4. Which of the following types of RFC calls guarantees multiple communications steps in a specific order? Choose the correct answer

Explanation

Queued RFC calls guarantee multiple communication steps in a specific order. In a Queued RFC, the system queues the RFC request and processes it in the order it was received. This ensures that the steps are executed sequentially, maintaining the desired order of communication. Asynchronous RFC does not guarantee a specific order as it allows parallel processing. Transactional RFC ensures atomicity and consistency but not a specific order. Synchronous RFC also does not guarantee a specific order as it waits for a response before proceeding.

Submit
5. You are reviewing RFC data in the transaction Workload Monitor (ST03n). Which RFC profile provides information about function modules in other systems that are called from this system?

Explanation

The RFC client profile provides information about function modules in other systems that are called from this system. This profile is used to monitor the performance and usage of RFC calls made by the local system to remote systems. It tracks the number of calls, response times, and other metrics related to RFC communication between systems.

Submit
6. Which RFC type is used if you want to establish communication with a remote system, but don't want to wait for the result for further processing?

Explanation

Asynchronous RFC (aRFC) is the correct answer because it allows for establishing communication with a remote system without having to wait for the result before further processing. This type of RFC is commonly used in scenarios where the response time is not critical and the system can continue with other tasks while waiting for the result.

Submit
7. You suspect that there is an issue with the network connection from the application layer to the presentation layer. Which check do you perform in which transaction?

Explanation

In order to determine if there is an issue with the network connection from the application layer to the presentation layer, you would perform a LAN check by ping. This can be done in the transaction Operating System Monitor (ST06(n)). This check allows you to test the connectivity between different layers of the network and identify any potential issues or delays.

Submit
8. Can database request time include network time?

Explanation

Yes, the database request time can include network time because it is measured at the SAP instance level. This means that the time it takes for the request to travel over the network and reach the database can be included in the overall measurement of the database request time.

Submit
9. What is RFC+CPIC time in synchronous RFC? Choose the correct answer.

Explanation

The RFC+CPIC time in synchronous RFC refers to the total time required for establishing the RFC communication with the RFC server, including the roll-out time, roll-wait time, and roll-in time. This means that it encompasses the time needed for establishing the communication as well as the additional time required for the various stages of the roll-out process.

Submit
10. What are the main parts of SAP virtual memory? There are 2 correct answers to this question.

Explanation

The main parts of SAP virtual memory include physical memory and the OS paging file/OS swap space. Physical memory refers to the actual RAM that is used by the computer to store data and instructions for the CPU to access. The OS paging file/OS swap space is a portion of the hard drive that is used by the operating system as an extension of the physical memory when the RAM is full. It allows the system to temporarily store data that is not actively being used, freeing up space in the physical memory for other processes.

Submit
11. Which system parameters are used to set RFC quotas? There are 2 correct answers to this question

Explanation

The system parameters rdisp/rfc_use_quotas and rdisp/rfc_max_login are used to set RFC quotas. The parameter rdisp/rfc_use_quotas determines whether quotas are used for RFC connections, while rdisp/rfc_max_login sets the maximum number of allowed logins for an RFC user. These parameters help manage and control the usage of RFC connections in the system.

Submit
12. What is mean time?

Explanation

Mean time refers to the average (aggregated) execution time of the SQL statement in milliseconds. This means that it calculates the average amount of time it takes for the SQL statement to be executed. It provides a measure of the efficiency and performance of the SQL statement, allowing for comparisons and optimizations to be made.

Submit
13. In the transaction Workload Monitor (ST03n), what is the main indicator of poor database performance?

Explanation

The main indicator of poor database performance in the transaction Workload Monitor (ST03n) is when the average DB request time is more than 40% of the average response time. This suggests that a significant portion of the overall response time is being spent on database requests, which can indicate inefficiencies or bottlenecks in the database system.

Submit
14. Which of the following are valid options for table buffering types? Choose 3 correct answers.

Explanation

The question asks for valid options for table buffering types. The correct answers are Single record buffered, Generic area buffered, and Fully buffered. These options are valid because they are all types of table buffering that can be used in SAP systems. Single record buffering buffers only one record at a time, generic area buffering buffers a group of records, and fully buffering buffers the entire table. Client specific buffering is not a valid option for table buffering types.

Submit
15. What happens when a buffered table is updated by an SQL request? There are 2 correct answers to this question.

Explanation

When a buffered table is updated by an SQL request, the first correct answer states that the database is updated and the buffer of the current application server is invalidated. This means that the changes made to the table are immediately reflected in the database, and the buffer in the current application server is cleared to ensure that the most up-to-date data is retrieved. The second correct answer explains that the changes are written to table DDLOG, which is periodically read to invalidate the buffered content on the other application servers. This ensures that all application servers have the latest data by periodically updating their buffers based on the changes recorded in table DDLOG.

Submit
16. What is stored in extended memory? There are 2 correct answers to this question

Explanation

Extended memory stores user context data, which includes objects associated with individual users and their open transactions. Buffered programs and tables are stored in extended memory as well. This memory is also used to store application program data that corresponds to specific ABAP commands, such as "export to memory".

Submit
17. When you are investigating a database performance issue you find an often used expensive SQL statement that is doing a full table scan to access a small amount of data. No suitable index exists. How can you improve the performance of this query?

Explanation

To improve the performance of the query, creating an index using selective fields from the where clause is the best option. By doing this, the database can quickly locate the relevant data without having to perform a full table scan. This selective index will only include the necessary fields mentioned in the where clause, optimizing the query's performance by reducing the amount of data that needs to be scanned.

Submit
18. Which profile parameters control the buffer synchronization? There are 2 correct answers to this question

Explanation

The profile parameters "rdisp/bufrefmode" and "rdisp/bufreftime" control the buffer synchronization. "rdisp/bufrefmode" determines the buffer synchronization mode, while "rdisp/bufreftime" specifies the time interval for buffer synchronization. These parameters are used to manage the synchronization of buffers in the system.

Submit
19. 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.

Explanation

The statement is true. If the programs in the transaction profile of ST03 show a database request time that is greater than 40% of the response time minus the wait time, it indicates that these programs may contain expensive SQL statements. The high percentage suggests that a significant portion of the overall response time is due to the execution of these SQL statements, indicating potential performance issues that need to be addressed.

Submit
20. Which of the following are two key criteria when evaluating performance problems? Choose 2 correct answers

Explanation

The two key criteria when evaluating performance problems are whether the problem occurred in the past and whether the problem is happening right now. These criteria help in determining the frequency and severity of the performance problem, as well as whether it is a recurring issue or a one-time occurrence. By considering both the past and present aspects of the problem, a more comprehensive evaluation can be made to identify the root cause and find appropriate solutions. The other options, such as the user experiencing the problem and the time of day, are not directly related to evaluating performance problems.

Submit
21. How should the SAP Operating System Collector (SAPOSCOL) be deployed? There are 2 correct answers to this question.

Explanation

If there is one instance on one host, only one SAPOSCOL process is required. This means that when there is only one SAP instance running on a single host, there is no need for multiple SAPOSCOL processes.

If there are multiple instances on one host, only one SAPOSCOL process is required. This means that even if there are multiple SAP instances running on a single host, only one SAPOSCOL process is needed to collect operating system data for all the instances.

Submit
22. What does Zero administration management do? 2 right

Explanation

Zero administration management allows the extended memory to grow dynamically, meaning that it automatically adjusts the amount of memory allocated to a system based on its needs. It also allows other memory management parameters to be set automatically, further simplifying the management of memory in a system. These features help to reduce the need for manual intervention and administration in managing memory, making the system more efficient and easier to maintain.

Submit
23. What are the dynamic work processes?

Explanation

The correct answer is "Work processes that are started in certain situations and are stopped again when no longer needed." This explanation suggests that dynamic work processes are initiated based on specific conditions or events and are terminated once their purpose is fulfilled or the situation no longer requires their presence.

Submit
24. Which of the following transactions show historical data? There are 2 correct answers to this question.

Explanation

The Operating System Monitor (ST06) and Workload Monitor (ST03n) transactions show historical data. ST06 provides information about the operating system resources used by the SAP system over a period of time, allowing users to analyze historical trends and identify performance issues. ST03n is used to monitor and analyze workload and performance data over a specific time frame, providing historical data for analysis and optimization purposes.

Submit
25. How can SAP shared memory be accessed

Explanation

Shared memory in SAP can be accessed by all processes of one instance. This means that any process running within the same instance can access the shared memory. This allows for efficient communication and data sharing between different processes within the same instance, improving overall system performance and reducing the need for data replication.

Submit
26. What does Zero Administration Memory Management do?

Explanation

Zero Administration Memory Management (ZAMM) is a memory management technique that allows the total extended memory size to grow dynamically and also enables the automatic setting of other memory parameters. This means that ZAMM automatically adjusts the memory size according to the system's needs, without requiring manual intervention from the administrator. It simplifies the memory management process by eliminating the need for administrators to manually set memory parameters, allowing for more efficient and hassle-free memory management.

Submit
27. What are some of the evaluation criteria for the impact of SQL statements on performance? There are 2 correct answers to this question.

Explanation

The evaluation criteria for the impact of SQL statements on performance include how often the statement is executed and what the contribution is to the system's overall response. The frequency of execution helps determine the potential impact on performance, as frequently executed statements may have a larger impact. Additionally, understanding the contribution of the statement to the system's overall response helps identify any bottlenecks or areas for optimization.

Submit
28. What are some of the reasons for buffer swaps, which are visible in transaction Buffer Monitor (ST02)? There are 2 correct answers to this question.

Explanation

The two correct reasons for buffer swaps visible in the transaction Buffer Monitor (ST02) are not enough space left in the buffer for buffering the new object and not enough directory entries to buffer the new object. These reasons suggest that the buffer is running out of capacity to store new objects, either because there is not enough physical space available or because there are not enough directory entries to keep track of the objects in the buffer. This can lead to buffer swaps, where objects are removed from the buffer to make room for new ones.

Submit
29. What is an expensive SQL statement?

Explanation

An expensive SQL statement refers to an SQL statement that causes the database to read many blocks from disk or the database buffer. This means that the statement requires a large amount of data to be retrieved, which can result in slower performance and increased resource usage. It is important to optimize these statements to improve overall database efficiency.

Submit
30. Virtual memory is made up of OS swap or page file and physical memory components. Determine whether this statement is true or false.

Explanation

This statement is true. Virtual memory is indeed composed of both the operating system's swap or page file and physical memory components. The swap or page file is a portion of the computer's hard drive that is used as an extension of physical memory when the physical memory becomes full. It allows the operating system to temporarily store data that is not actively being used by programs. The physical memory, on the other hand, refers to the actual RAM (Random Access Memory) installed in the computer. Together, these components make up the virtual memory system.

Submit
31. Where and when is ABAP heap memory allocated?

Explanation

ABAP heap memory is allocated in the local memory of the work process when required. This means that when a program or process in ABAP requires memory to store data, it will allocate that memory in the local memory of the work process. This memory is specific to that particular work process and is not shared with other processes or programs. The allocation happens dynamically as and when required, allowing for efficient memory usage.

Submit
32. In transaction Operating System Monitor (STDG) in an ABAP-only system, how can you recognize a memory bottleneck? There are 2 correct answers to this question.

Explanation

A memory bottleneck can be recognized in a Unix system when more than 20% of RAM is paged out or swapped out per hour. This indicates that the system is constantly moving data between RAM and disk, which can slow down the overall performance. In a Windows system, a memory bottleneck can be identified when more than 25% of RAM is paged in per hour. This suggests that the system is frequently loading data from disk into RAM, which can also impact the system's performance.

Submit
33. What are some of the measures used to optimize SAP performance at a technical level? There are 3 correct answers to this question.

Explanation

Some of the measures used to optimize SAP performance at a technical level include optimizing SAP system parameters, optimizing database and operating system configuration, and optimizing workload distribution. These measures focus on fine-tuning the settings and configurations of the SAP system, database, and operating system to improve performance and efficiency. By optimizing system parameters, database and operating system configuration, and workload distribution, organizations can enhance the overall performance of their SAP systems.

Submit
34. Where is the default location of the statistical records that are written to the file system? Choose the correct answer.

Explanation

The correct answer is "/usr/sap//DVEBMGS##/data". This is the default location where the statistical records are written to the file system. The "/usr/sap//DVEBMGS##" directory represents the SAP instance and the "data" directory within it is where the statistical records are stored.

Submit
35. Where can you find the top expensive SQL statements on the system?

Explanation

The top expensive SQL statements on the system can be found in the cursor cache of the DBA cockpit.

Submit
36. Which of the following is not a component of dialog response time? Choose the correct answer.

Explanation

The question asks for a component that is not a part of dialog response time. Dialog response time refers to the time it takes for a system to respond to a user's input or request. The options given are wait time, roll in/out time, database request time, and CPU idle time. Wait time, roll in/out time, and database request time are all factors that can contribute to the overall response time. However, CPU idle time does not directly affect the dialog response time as it refers to the amount of time the CPU is not actively processing tasks.

Submit
37. With transaction Operating System Monitor (STO6) - Top 40 CPU Processes, you identified a process with unusually high CPU utilization. What are next steps to check the root cause? There are 2 correct answers to this question.

Explanation

To identify the root cause of the process with high CPU utilization, there are two next steps to consider. Firstly, if it is a database process, the database monitor (ST04) can be used to analyze if the activity can be optimized or scheduled for a different time. Secondly, if it is an SAP work process, comparing the process ID (PID) to the list of transactions in SM50 can help determine the specific activity causing the high load. These steps will help in identifying and addressing the root cause of the high CPU utilization.

Submit
38. In transaction Operating System Monitor (ST06) you detect that CPU idle value on a server, with dedicated resources, is often below 20%. How should you investigate this situation? There are 2 correct answers to this question

Explanation

To investigate the situation of CPU idle value often being below 20%, you should check if the load can be distributed to other servers with spare CPU capacity. This would help balance the workload and alleviate the strain on the server in question. Additionally, you should also check the 'Top 40 CPU Processes' in transaction Operating System Monitor (ST06(n)) to identify any specific processes consuming excessive CPU resources.

Submit
39. When you run transaction Table Call Statistics (ST10), which of the following indicates that a table should be unbuffered? There are 3 correct answers to this question

Explanation

When running transaction Table Call Statistics (ST10), a high number of invalidations, a high number of "Rows affected," and a large buffer size all indicate that a table should be unbuffered. Invalidations occur when data in the table is changed, which can cause performance issues if the table is buffered. "Rows affected" refers to the number of rows that are modified or accessed, which can also cause performance issues if the table is buffered. A large buffer size indicates that the table is consuming a significant amount of memory, which may be unnecessary if the table is not frequently accessed.

Submit
40. Are you hungry?

Explanation

The given answer is true because the question asks if the person is hungry, and since there is no additional information provided, we can assume that the person is indeed hungry.

Submit
41. You see very high paging rates (>20% RAM per hour). What could be possible countermeasures? There are 2 correct answers to this question.

Explanation

To address the high paging rates, one possible countermeasure is to distribute processes that do not need to run on the specific hardware to other hardware with unused capacity. This helps to alleviate the memory usage on the overloaded hardware and prevent excessive paging. Another countermeasure is to identify users/programs that cause high memory consumption and optimize expensive SQL statements and suboptimal programming. By optimizing these aspects, the memory usage can be reduced, resulting in lower paging rates.

Submit
42. when you run transaction table call statistics ST10, which of the following indicates that a table should be unbuffered? 3 right 

Explanation

Tables with a high number of invalidations, tables with a high number of 'rows affected', and tables with a large buffer size indicate that a table should be unbuffered. High invalidations suggest that the data in the table is frequently changing, making it inefficient to keep it in the buffer. Tables with a high number of 'rows affected' indicate that a large number of rows are being modified, which can also make buffering less efficient. Lastly, tables with a large buffer size may indicate that the table is too large to be effectively buffered, and unbuffering it can improve performance.

Submit
43. Which option represents "Generic area buffered"?

Explanation

This option represents "Generic area buffered" because it states that only some of the key fields for a table are set to determine the data to be buffered during access. This means that not all records are buffered, but only those that meet the specified criteria.

Submit
44. 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.

Explanation

The correct answer is "Executable program sappfpar." This program can be used to check the formulas and the values used in the formula-based memory parameters. It allows users to view and modify the memory parameters in the SAP system.

Submit
45. 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.

Explanation

The statement is true. A hardware bottleneck in the CPU occurs when the processing time is more than twice the CPU time. This means that the CPU is not able to handle the workload efficiently, resulting in slower processing times. A bottleneck can occur due to various reasons such as outdated hardware, insufficient processing power, or high demand on the system. When a hardware bottleneck occurs, it is necessary to upgrade the CPU or optimize the system to improve performance.

Submit
46. What are some of the reasons for using the extended memory concept in SAP systems? There are 3 correct answers to this question.

Explanation

The extended memory concept is used in SAP systems for several reasons. Firstly, fast context switches are needed because many users share a limited number of work processes. This allows for efficient multitasking and ensures that users can quickly switch between different tasks. Secondly, extended memory is accessed through pointers, which enables fast context switches to occur. This means that data can be accessed and processed quickly, improving system performance. Lastly, SAP transactions often involve multiple steps or screens, so having extended memory allows for the storage of large amounts of data and ensures smooth execution of these transactions.

Submit
47. Which of the following parameter controls the buffer synchronization behavior in the SAP system? Choose the correct answer.

Explanation

The parameter "rdisp/bufremode" controls the buffer synchronization behavior in the SAP system. This parameter determines whether the buffer is removed from the memory after a work process is finished or if it remains in memory for reuse.

Submit
48. 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? Choose 2 correct answers.

Explanation

If the CPU utilization is consistently near 100%, it indicates that the system is using the maximum processing power available and there may be a hardware bottleneck causing the system to slow down. Similarly, high swap/paging activity suggests that the system is frequently accessing the disk to swap data between memory and disk, which can indicate a lack of available memory or a slow disk subsystem. Both of these scenarios can indicate hardware bottlenecks in the SAP system.

Submit
49. Why are parts of user contexts stored in SM50 (extended?) memory instead of local memory of a system?

Explanation

Parts of user contexts are stored in SM50 (extended) memory instead of local memory of a system to speed up context switches during roll-in and roll-out processes. Storing user contexts in SM50 memory allows for faster retrieval and loading of the necessary data when a context switch occurs, improving the overall efficiency and performance of the system.

Submit
50. What type of data is stored in PROC memory? There are 2 correct answers to this question

Explanation

The data stored in PROC memory is not bound to a specific user context and is not associated with individual users and their open transactions. It refers to the local heap memory in the work process that is not assigned to a user context. This type of data is used for storing authorization data to enable faster user access.

Submit
51. Which of the following profile parameters affect activation of dynamic work processes? Choose the correct answer.

Explanation

The profile parameter "rdisp/dynamic_wp_check" affects the activation of dynamic work processes. This parameter determines whether the system should automatically activate or deactivate additional work processes based on the workload. If this parameter is set to "1", the system will activate additional work processes as needed. If it is set to "0", the system will not activate additional work processes. The other profile parameters mentioned in the question, "rdisp/wp_no_dia", "rdisp/wp_no_btc", and "rdisp/wp_no_enq", do not directly affect the activation of dynamic work processes.

Submit
52. 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.

Explanation

In transaction ST02, if there is a lot of swapping in the SAP buffers, it indicates a problem. Swapping refers to the process of moving data between the main memory and the disk when the memory becomes full. When there is excessive swapping, it can lead to performance issues and slow down the system. Therefore, the statement is true.

Submit
53. 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.

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. This means that the system will reserve a certain number of dialog work processes to handle user requests and ensure that there are enough available for user interactions.

Submit
54. What information can be retrieved with transaction Local Work Process Overview (SM50)? There are 3 correct answers to this question.

Explanation

The transaction Local Work Process Overview (SM50) allows users to retrieve information about the status of individual work processes, such as whether they are waiting, running, on hold, etc. It also provides information about the program that is currently being executed by the work process and the process ID of the work process. This information can be useful for monitoring and troubleshooting the performance and utilization of work processes in an SAP system.

Submit
55. Which of the following tools is best for monitoring and analyzing issues in the transactional RFC queue? Choose the correct answer

Explanation

SM58 is the correct answer because it is the transaction code used to monitor and analyze issues in the transactional RFC queue. It allows users to view and manage the inbound and outbound queues, check the status of the RFCs, and reprocess any failed RFCs. SMQ1 and SMQ2 are transaction codes used for monitoring and analyzing the qRFC (queued RFC) queues, while ST05 is used for performance tuning and analysis.

Submit
56. Am i true or false

Explanation

not-available-via-ai

Submit
57. In the transaction profile Workload Monitor (ST03), how do you identify a bottleneck? 2 right

Explanation

To identify a bottleneck in the transaction profile Workload Monitor (ST03), one can look for indications such as high average CPU time and/or database times. This suggests that the system is spending a significant amount of time on CPU processing or accessing the database, which may indicate a bottleneck. Additionally, if the processing time is greater than twice the CPU time, it could also indicate a bottleneck. These factors suggest that certain operations are taking longer than expected, potentially causing a bottleneck in the system.

Submit
58. 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.

Explanation

The given statement is false. The ABAP trace is not the tool to use for finding out more about expensive SQL statements and their execution plans. The correct tool for this purpose is the SQL Trace (transaction ST05). The ABAP trace is used to analyze the performance of ABAP programs, while the SQL Trace is specifically designed to analyze SQL statements and their execution plans.

Submit
59. What is the main indicator of a CPU bottleneck?

Explanation

The main indicator of a CPU bottleneck is when the processing time is more than twice the CPU time. This means that the CPU is not able to keep up with the processing demands, causing a delay in the overall processing time.

Submit
60. A customer complains that a particular transaction performs badly. Which of the following transaction can you use to investigate the performance details?

Explanation

The correct answer is ST03 - Workload Monitor. This transaction allows you to investigate the performance details of a particular transaction. It provides information about the workload of the system, including CPU usage, database response time, and memory usage. By analyzing the data in ST03, you can identify any performance bottlenecks and take appropriate actions to improve the performance of the transaction.

Submit
61. Which of the following transactions are used to evaluate the work process statuses and activities that are currently happening? Choose 2 correct answers.

Explanation

SM50 and SM66 are transactions used to evaluate the work process statuses and activities that are currently happening in SAP. SM50 displays the work process overview, showing the status of each work process and the tasks they are currently executing. SM66 displays the work process overview in a graphical format, allowing for easier visualization of the work process statuses and activities.

Submit
62. How should optimizer statistics be kept up to date? 2 right

Explanation

The correct answers for keeping optimizer statistics up to date are by using scheduled periodic refreshes and using the database planning calendar (transaction DB13). Scheduled periodic refreshes ensure that the optimizer statistics are regularly updated to reflect any changes in the database, allowing for more accurate query optimization. The database planning calendar (transaction DB13) is a tool in the database system that can be used to schedule jobs for updating optimizer statistics at specific times or intervals. Both methods help to maintain the accuracy and efficiency of the optimizer statistics.

Submit
63. How can you identify potentially expensive SQL statements in programs with transaction local work process overview SM50? 2 correct

Explanation

The correct answer is that the executing wp has a long running action with "sequential read" and "direct read". By monitoring the work processes in transaction SM50, one can identify when a work process is performing a long running action with either "sequential read" or "direct read". These actions typically indicate that the SQL statement being executed is potentially expensive, as it is taking a significant amount of time to read data either sequentially or directly from the database.

Submit
64. In which sequence do dialog work processes allocate memory

Explanation

In the given sequence, dialog work processes first allocate memory in the initial part of the roll area, then in the extended memory, followed by the remaining part of the roll area, and finally in the heap memory. This sequence ensures that memory is allocated in a systematic manner, starting with the roll area and then moving on to the extended memory and heap memory. This order helps in efficient memory management and allocation for dialog work processes.

Submit
65. 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.

Explanation

The statement is true. PHYS_MEMSIZE is a parameter that indicates the amount of memory used in an SAP instance. It can be used to automatically initiate changes to formula-based memory parameters, allowing for efficient memory management within the SAP system.

Submit
66. You are investigating a performance problem. In transaction Work Process Overview (SM50). What do you do next?

Explanation

To investigate a performance problem in the transaction Work Process Overview (SM50), the next step would be to analyze the SAP memory configuration. This is because memory configuration can have a significant impact on system performance. By analyzing the memory configuration, you can identify any potential issues or bottlenecks that may be causing the performance problem. This step will help in identifying and resolving any memory-related issues that may be affecting the system's performance.

Submit
67. Which elements are part of the RFC CPIC time during a synchronous RFC call to another system? There are 4 correct answers to this question.

Explanation

During a synchronous RFC call to another system, several elements are involved. Roll wait time refers to the time spent waiting for a database lock to be released. Roll out time is the time taken to transfer data from the caller system to the target system. Time to establish the RFC connection is the duration required to establish a connection between the systems. Roll in time is the time taken to transfer data back from the target system to the caller system. These elements are all part of the RFC CPIC time during a synchronous RFC call.

Submit
68. Which of the following statements is considered to be an expensive SQL statement? Choose 2 correct answers.

Explanation

An expensive SQL statement is one that requires a significant amount of resources or time to execute. The first statement mentioned requires many records to be transferred to the ABAP program, indicating that a large amount of data needs to be processed, which can be resource-intensive. The fourth statement mentioned reads many blocks but retrieves only a few records from the database, suggesting that a large amount of data needs to be accessed and processed, which can also be time-consuming and resource-intensive. Both of these statements can be considered expensive in terms of their impact on performance and resource usage.

Submit
69.  Which of the following areas of an instance's shared memory have corresponding files on the instance the user is logged on to? 2 right

Explanation

The correct answer is Roll buffer and Paging buffer. The Roll buffer and Paging buffer are areas of an instance's shared memory that have corresponding files on the instance the user is logged on to. These buffers are used for temporary storage and management of data during database operations. The Roll buffer is used for storing undo logs, while the Paging buffer is used for storing data pages that are read from or written to disk.

Submit
70. A Single Statistical Record captures an entire transaction in SAP. Determine whether this statement is true or false.

Explanation

The statement is false. A Single Statistical Record in SAP does not capture an entire transaction. It is used to record statistical data related to a transaction, such as the number of times it occurs or the duration of the transaction. It does not contain all the details and information of the transaction itself.

Submit
71. In which sequence do dialogue wps allocate memory as of sap netweaver 7.40?

Explanation

The correct answer is "Extended memory, Heap memory." In SAP NetWeaver 7.40, the sequence in which dialogue work processes allocate memory is first in the extended memory and then in the heap memory. Extended memory is used for storing large amounts of data, while heap memory is used for dynamic memory allocation during program execution. Therefore, the dialogue work processes first allocate memory in the extended memory and then in the heap memory.

Submit
72. Which of the following SQL statements cannot be tuned? Choose 3 correct answers.

Explanation

The SQL statements used by SAP Basis Tables, recursive SQL statements, and SQL statements used by Database Administration Tools cannot be tuned because they are either system-generated or used for administrative tasks, which means they are not customizable or modifiable by the user for performance optimization.

Submit
73. Which of the following areas of an instance's shared memory has a corresponding file on hard disk to which sap sys will copy data that would not fit in that shared memory area?

Explanation

The paging buffer is an area of an instance's shared memory where data is temporarily stored when it does not fit in the other shared memory areas. When the data in the paging buffer exceeds its capacity, the SAP system will copy the excess data to a corresponding file on the hard disk. This allows the system to free up space in the shared memory and prevent data loss.

Submit
74. Table buffering is recommended for which of the following scenarios ? Choose 2 correct answers.

Explanation

Table buffering is recommended for tables that are seldom changed and customizing data. Table buffering helps to improve the performance of accessing data from these tables by storing the data in the buffer memory. This reduces the need to read the data from the database every time it is accessed, resulting in faster data retrieval. For tables that are seldom changed, table buffering can be beneficial as it allows for quicker access to the data without the need to constantly update the buffer. Similarly, for customizing data that is not frequently modified, table buffering can enhance performance by reducing the database access time.

Submit
75. In transaction workload analysis montior ST03n, avg roll-wait time for task type dialogue is high. which of the following can cause dis issue? 2 right

Explanation

The high average roll-wait time for task type dialogue in the transaction workload analysis monitor ST03n can be caused by problems with external RFC communication and communication problems with the GUI front end. These issues can lead to delays in communication between the SAP system and external systems, resulting in longer wait times for the dialogue tasks.

Submit
76. What is the purpose of buffering data in SAP table buffers? 2 right

Explanation

Buffering data in SAP table buffers serves the purpose of reducing the load on the database by storing frequently accessed data in memory. This helps to minimize the number of database accesses required, resulting in improved system performance. Additionally, buffering data also speeds up access to data by allowing faster retrieval of information from the buffer rather than querying the database.

Submit
77. Which of the following statements is true about the SQL Monitor? Choose 3 correct answers.

Explanation

The SQL Monitor can be switched on for all or dedicated servers, allowing for flexibility in monitoring. It is designed to trace a single process, allowing for detailed analysis of that specific process. The SQL Monitor can trace every SQL statement coming from ABAP programs, including all OPEN SQL, native SQL, and ABAP kernel SQL statements. Additionally, the SQL Monitor has low impact on the performance of the production system, ensuring that it does not significantly affect the overall system performance.

Submit
78. On which information does the data access strategy used for executing an SQL statement depend on? There are 3 correct answers to this question.

Explanation

The data access strategy used for executing an SQL statement depends on the fields specified in the WHERE clause of the SQL statement, as this determines the specific data that needs to be retrieved. It also depends on the availability of indexes for the queried tables, as indexes can greatly improve the performance of data retrieval. Additionally, the structure of the queried table, as expressed by its statistics, plays a role in determining the most efficient way to access the data.

Submit
79. the function "execute explain for SQL statements" compromises an execution plan. what details can you get from this plan? 2 right

Explanation

By executing the "execute explain for SQL statements" function, you can obtain details about the execution plan. This plan includes estimated costs, which give an indication of the resources required for executing the SQL statement. It also provides estimated rows, which estimates the number of rows that will be processed by the statement. These details are crucial for optimizing the performance of the SQL statement and improving the overall efficiency of the system. Additionally, the estimated response time and estimated CPU cost can also be obtained from the execution plan, giving further insights into the expected performance of the SQL statement.

Submit
80. Which elements of total response time should be under 20ms?   3 right

Explanation

The elements of total response time that should be under 20ms are Roll-in time, Wait time, and Roll-out time. Dialog time is not mentioned as one of the elements that should be under 20ms.

Submit
81. What is the most likely cause for a high "wait time" in a system

Explanation

A high "wait time" in a system is most likely caused by an insufficient number of free work processes. This means that there are not enough resources available to handle the workload, leading to delays and increased wait times for processes to be executed. This can result in slower response times and decreased system performance.

Submit
82. What are reserved work processes?

Explanation

Reserved work processes are dialog work processes that are specifically assigned to perform a particular task. These work processes are dedicated to a specific function and cannot be used for other tasks. They are reserved and allocated for a specific purpose, ensuring efficient and optimized performance for that particular task.

Submit
83. The user's context is initially stored in the heap area in the shared memory.. Determine whether this statement is true or 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 is typically stored in the stack area of memory. The stack is a region of memory that is used for local variables and function calls. The heap area, on the other hand, is used for dynamically allocated memory.

Submit
84. Which of the following can be found in the Explain function in SQL trace? Choose 3 correct answers

Explanation

The Explain function in SQL trace can provide information about the execution plan, including table and index access. It can also provide estimated costs and estimated rows for the query. Additionally, it can provide statistics about the tables and indexes involved in the query.

Submit
85. Which of the following are parts of the dialog response time? There are 8 correct answers to this question

Explanation

not-available-via-ai

Submit
86. 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.

Explanation

The statement is false. SQL trace (transaction ST05) does offer a lot of information on table accesses, including the database activities, number of ABAP requests, and number of invalidations.

Submit
87. why is buffer synchronisation important in an sap sys w more than 1 instance? 2 right

Explanation

Buffer synchronization is important in an SAP system with more than one instance to prevent outdated data from being selected from buffers and to prevent outdated data from being committed to the database. When multiple instances are accessing and updating the same data, it is crucial to ensure that all instances have the most up-to-date information to avoid inconsistencies and errors. Synchronizing the buffers helps to maintain data integrity and accuracy across all instances, ensuring that users are always accessing and modifying the latest data. This also helps in improving performance by reducing the load on the database as the instances can share and update data efficiently.

Submit
88. Which of the following transactions are used in evaluating system performance? Choose 3 correct answers

Explanation

ST03, SM04, and SM06 are transactions that are used in evaluating system performance. ST03 is used for workload analysis and performance monitoring in SAP systems. SM04 is used for monitoring active users and their activities in the system. SM06 is used for monitoring system-wide locks and lock entries. These transactions provide valuable insights into the performance and usage of the system, allowing administrators to identify and address any performance issues.

Submit
89. Which of the following parameters lead to the allocation of heap memory for dialog processes? Choose 2 correct answers. 

Explanation

The parameter "em/max_size_MB" determines the maximum size of the extended memory (EM) that can be allocated for a dialog process. When this parameter is set, heap memory is allocated for dialog processes.

The parameter "Ztta/roll_extension" determines the size of the extended memory that can be used for roll extensions. Roll extensions are used to store data that exceeds the size of the main memory. When this parameter is set, heap memory is allocated for dialog processes.

Therefore, both "em/max_size_MB" and "Ztta/roll_extension" lead to the allocation of heap memory for dialog processes.

Submit
90. which features does the SQL monitor offer? 2 correct p145 lul

Explanation

The SQL monitor offers the ability to switch it on for all or dedicated servers of an ABAP sys. Additionally, it can trace each and every SQL statement coming from an ABAP program.

Submit
91. what are some possible effects if the program buffer was made too small in configuration? 3 right (AGAIN NOT SURE ABOUT THIS)

Explanation

If the program buffer is made too small in configuration, it can lead to an increased number of work processes (wps) accessing the table REPOLOAD. This is because a smaller program buffer size may result in more frequent access to the table, causing a higher workload on the system. Additionally, there may be an increased load and generation time in transaction ST03. This is because a smaller program buffer can slow down the generation of programs, leading to longer processing times. Furthermore, there may be an increased number of program buffer swaps visible in transaction ST02. This occurs when the program buffer is full and needs to swap out programs from memory, causing delays in program execution.

Submit
92.  When should you usually switch on table buffering? There is 1 correct answers to this question.

Explanation

Table buffering is a technique used to improve the performance of frequently accessed tables by storing them in the memory buffer. When a table is frequently accessed, enabling table buffering can help reduce the number of disk reads, resulting in faster response times. Therefore, the correct answer is that table buffering should be switched on if the table is frequently accessed.

Submit
93. SWAPS in transaction ST02 are an indication of high CPU utilization. Determine whether this statement is true or false

Explanation

This statement is false. SWAPS in transaction ST02 are not necessarily an indication of high CPU utilization. SWAPS refer to the process of moving data between the computer's memory and the hard disk. High SWAPS can indicate that the system is running out of available memory, but it does not directly indicate high CPU utilization. CPU utilization refers to the amount of time the CPU spends executing instructions, and it can be measured separately from SWAPS.

Submit
94. Which response time elements that are displayed in transaction Workload Monitor ST03? 3 right

Explanation

In transaction Workload Monitor ST03, the response time elements that are displayed include CPU Time, Roll-in Time, and Database Request Time. These elements provide information about the time taken for different processes and tasks within the system. CPU Time represents the time taken by the CPU to process the task, Roll-in Time represents the time taken to load data from disk to memory, and Database Request Time represents the time taken for database operations. These elements help in analyzing and optimizing the performance of the system.

Submit
95. what are some negative effects of incorrect table buffering settings? 2 right NOT VERY SURE BOUT THIS

Explanation

If a buffered table is accessed too often, there is a risk that the statistics of the database optimizer will become outdated. This is because the optimizer relies on accurate statistics to make efficient decisions about query execution plans. If the statistics are outdated, the optimizer may choose suboptimal plans, leading to slower performance. Additionally, if the content of a buffered table is changed very often, the process of refilling the table buffer can reduce the overall system performance. This is because frequent changes to the table require constant updates to the buffer, which can consume system resources and slow down other operations.

Submit
View My Results

Quiz Review Timeline (Updated): Jan 23, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jan 23, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 28, 2019
    Quiz Created by
    Buchita
Cancel
  • All
    All (95)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Which memory area is allocated at instance start?
What is the SAP Operating System Collector (SAPOSCOL)?
How is SAP Dialog Response time defined?
Which of the following types of RFC calls guarantees multiple...
You are reviewing RFC data in the transaction Workload Monitor...
Which RFC type is used if you want to establish communication with a...
You suspect that there is an issue with the network connection from...
Can database request time include network time?
What is RFC+CPIC time in synchronous RFC? Choose the correct answer.
What are the main parts of SAP virtual memory? There are 2 correct...
Which system parameters are used to set RFC quotas? There are 2...
What is mean time?
In the transaction Workload Monitor (ST03n), what is the main...
Which of the following are valid options for table buffering types?...
What happens when a buffered table is updated by an SQL request? There...
What is stored in extended memory? There are 2 correct answers to this...
When you are investigating a database performance issue you find an...
Which profile parameters control the buffer synchronization? There are...
Programs which show database request time > 40 % (response time...
Which of the following are two key criteria when evaluating...
How should the SAP Operating System Collector (SAPOSCOL) be deployed?...
What does Zero administration management do? 2 right
What are the dynamic work processes?
Which of the following transactions show historical data? There are 2...
How can SAP shared memory be accessed
What does Zero Administration Memory Management do?
What are some of the evaluation criteria for the impact of SQL...
What are some of the reasons for buffer swaps, which are visible in...
What is an expensive SQL statement?
Virtual memory is made up of OS swap or page file and physical memory...
Where and when is ABAP heap memory allocated?
In transaction Operating System Monitor (STDG) in an ABAP-only system,...
What are some of the measures used to optimize SAP performance at a...
Where is the default location of the statistical records that are...
Where can you find the top expensive SQL statements on the system?
Which of the following is not a component of dialog response time?...
With transaction Operating System Monitor (STO6) - Top 40 CPU...
In transaction Operating System Monitor (ST06) you detect that CPU...
When you run transaction Table Call Statistics (ST10), which of the...
Are you hungry?
You see very high paging rates (>20% RAM per hour). What could be...
When you run transaction table call statistics ST10, which of the...
Which option represents "Generic area buffered"?
Which of the following tools can be used to check the formulas and the...
There is hardware bottleneck in the CPU if processing time is more...
What are some of the reasons for using the extended memory concept in...
Which of the following parameter controls the buffer synchronization...
Which of the following from the Operating System Monitor (transaction...
Why are parts of user contexts stored in SM50 (extended?) memory...
What type of data is stored in PROC memory? There are 2 correct...
Which of the following profile parameters affect activation of dynamic...
In transaction ST02, there is a problem if there is a lot of swapping...
Which of the following RFC quota parameters should be set to maintain...
What information can be retrieved with transaction Local Work Process...
Which of the following tools is best for monitoring and analyzing...
Am i true or false
In the transaction profile Workload Monitor (ST03), how do you...
The ABAP trace (transaction SE30 or SAT) is the tool to use if we want...
What is the main indicator of a CPU bottleneck?
A customer complains that a particular transaction performs badly....
Which of the following transactions are used to evaluate the work...
How should optimizer statistics be kept up to date? 2 right
How can you identify potentially expensive SQL statements in programs...
In which sequence do dialog work processes allocate memory
PHYS_MEMSIZE indicates how much memory is used in an SAP instance and...
You are investigating a performance problem. In transaction Work...
Which elements are part of the RFC CPIC time during a synchronous RFC...
Which of the following statements is considered to be an expensive SQL...
 Which of the following areas of an instance's shared memory have...
A Single Statistical Record captures an entire transaction in SAP....
In which sequence do dialogue wps allocate memory as of sap netweaver...
Which of the following SQL statements cannot be tuned? Choose 3...
Which of the following areas of an instance's shared memory has a...
Table buffering is recommended for which of the following scenarios ?...
In transaction workload analysis montior ST03n, avg roll-wait time for...
What is the purpose of buffering data in SAP table buffers? 2 right
Which of the following statements is true about the SQL Monitor?...
On which information does the data access strategy used for executing...
The function "execute explain for SQL statements"...
Which elements of total response time should be under 20ms? ...
What is the most likely cause for a high "wait time" in a system
What are reserved work processes?
The user's context is initially stored in the heap area in the shared...
Which of the following can be found in the Explain function in SQL...
Which of the following are parts of the dialog response time? There...
SQL trace (transaction ST05) offers a lot of information on table...
Why is buffer synchronisation important in an sap sys w more than 1...
Which of the following transactions are used in evaluating system...
Which of the following parameters lead to the allocation of heap...
Which features does the SQL monitor offer? 2 correct p145 lul
What are some possible effects if the program buffer was made too...
 When should you usually switch on table buffering? There is 1...
SWAPS in transaction ST02 are an indication of high CPU utilization....
Which response time elements that are displayed in transaction...
What are some negative effects of incorrect table buffering settings?...
Alert!

Advertisement