Internet Communicator Manager (ICM) Test Quiz

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 Vanessa
V
Vanessa
Community Contributor
Quizzes Created: 1 | Total Attempts: 186
| Attempts: 186
SettingsSettings
Please wait...
  • 1/68 Questions

    In the transaction Worload Monitos (ST03N), what is he main indicatos of poor database per...

    • Average DB request time of more than 100ms
    • Average DB request time of more than 40% of average response time
    • Average DB request time is hicher than average CPU time
    • Average DB request time of more than twice the average CPU time
Please wait...
About This Quiz

This Internet Communicator Manager (ICM) Test assesses skills in configuring server caches, managing database queries, and optimizing system performance. It is crucial for professionals aiming to enhance SAP system efficiency.

Internet Communicator Manager (ICM) Test Quiz - Quiz

Quiz Preview

  • 2. 

    When you are investigationg a database issue you find an often used expensive... How can you imporve the performance of this query?

    • By educatind end users to use the program that calls this SQL statement correctly

    • By creating an index using selective fieldas from the where clause

    • By updating the statistics, so the optimizer will create an appropiate index

    • By creating an index using all fields from the where clause

    Correct Answer
    A. By creating an index using selective fieldas from the where clause
    Explanation
    Creating an index using selective fields from the WHERE clause can improve the performance of the query. This is because an index allows the database to quickly locate the relevant data based on the indexed fields, reducing the need for full table scans. By selectively choosing the fields from the WHERE clause to create the index, the database can efficiently retrieve the required data, resulting in improved query performance.

    Rate this question:

  • 3. 

    What is the purpose of buffering data in SAP table buffers?

    • To reduce load on the database

    • To save space ont he hard disk

    • To creating better access paths to data

    • To speed up access to data

    Correct Answer(s)
    A. To reduce load on the database
    A. To speed up access to data
    Explanation
    The purpose of buffering data in SAP table buffers is to reduce the load on the database and to speed up access to data. By buffering data, the system can store frequently accessed data in memory, reducing the need to retrieve it from the database every time it is requested. This helps to improve system performance and response times, as well as reduce the workload on the database server. Additionally, buffering data can also help in creating better access paths to data, further optimizing data retrieval processes.

    Rate this question:

  • 4. 

    What is the SAP Operating System Collector (SAPOSCOL)?

    • An SAP porprietary standalone program for collecting Operating System usage information..

    • A third party fool for collecting Operating System usage information

    • An altenative to transaction Operating System Monitor (ST06(n)) for non-ABAP systems

    • The built-in tool in aBAP systems for collecting Operatinf System usage information

    Correct Answer
    A. An SAP porprietary standalone program for collecting Operating System usage information..
    Explanation
    The correct answer is that SAPOSCOL is an SAP proprietary standalone program for collecting Operating System usage information.

    Rate this question:

  • 5. 

    Which RFC is used for multiple communication steps that must be completed in a p..

    • Synchronous RFC (sRFC)

    • Queued RFC (qRFC)

    • Asynchronous RFC (aRFC)

    • Transactionaly RFC (tRFC)

    Correct Answer
    A. Queued RFC (qRFC)
    Explanation
    Queued RFC (qRFC) is the correct answer because it is used for multiple communication steps that must be completed in a particular order. qRFC allows the sending system to queue the RFC request and ensures that the receiving system processes the requests in the same order they were sent. This ensures the integrity and consistency of the data being exchanged between systems. Unlike other options like Synchronous RFC (sRFC), Asynchronous RFC (aRFC), and Transactional RFC (tRFC), qRFC specifically focuses on maintaining the order of communication steps.

    Rate this question:

  • 6. 

    Why are parts of user context stored in extended memory instead of the locacl memory of a...

    • To speed up context switches (roll in/ roll out)

    • To decrease the sizer of the work porcess's local memory

    • To prevent buffer swaps

    • To prevent operating system paging

    Correct Answer
    A. To speed up context switches (roll in/ roll out)
    Explanation
    Parts of user context are stored in extended memory instead of local memory to speed up context switches. Context switches involve saving the current state of a process and loading the saved state of another process. By storing the user context in extended memory, the switching process becomes faster as the data can be accessed more efficiently. This helps in improving the overall performance of the system by reducing the time taken for context switches.

    Rate this question:

  • 7. 

    You suspects taht tehre is an issue with network connections from the application layer..Which chech do you perform in wich transaction?

    • Checj Cursor Cache in transaction DBA Cockpit (DBACOCKPIT)

    • Trace, in transaction Single Transaction Analysis (ST12)

    • Connection test in Work Process Overview

    • LAN check by ping in transaction operating System Monitor (ST06(n))

    Correct Answer
    A. LAN check by ping in transaction operating System Monitor (ST06(n))
    Explanation
    In order to determine if there is an issue with network connections from the application layer, you would perform a LAN check by ping in transaction operating System Monitor (ST06(n)). This transaction allows you to test the network connectivity by sending a ping command to a specified IP address or hostname. By checking the LAN connectivity, you can identify any potential network issues that may be affecting the application layer.

    Rate this question:

  • 8. 

    What is an expensive SQL statement?

    • An SQL statement that caused that databases to read may blockas (from disk or database)

    • An SQL statement that does not use best possible acces path

    • An SQL statement that cannot be turned by implementing database related changes

    • An SQL statement that causes that database to read more vlocks (from disk or buffer) that..

    Correct Answer
    A. An SQL statement that caused that databases to read may blockas (from disk or database)
    Explanation
    An expensive SQL statement refers to an SQL statement that causes the database to read a large number of blocks from either the disk or the database itself. This can result in slower performance and increased resource usage. It indicates that the statement is not optimized and may need to be improved by implementing changes related to the database.

    Rate this question:

  • 9. 

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

    • A) Wait time

    • B) Roll In/Out

    • C) Database Request

    • D) CPU idle time

    Correct Answer
    A. D) CPU idle time
    Explanation
    CPU idle time is not a component 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 components of dialog response time typically include wait time (the time a user waits for a response), roll in/out (the time it takes to load or unload data), and database request (the time it takes to retrieve data from a database). CPU idle time, on the other hand, refers to the time when the CPU is not actively processing any tasks.

    Rate this question:

  • 10. 

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

    • A) /usr/sap/trans

    • B) sapmnt/

    • C) /usr/sap/data

    • D) /usr/sap//DVEBMGS##/data

    Correct Answer
    A. D) /usr/sap//DVEBMGS##/data
    Explanation
    The default location of the statistical records that are written to the file system is in the directory /usr/sap//DVEBMGS##/data.

    Rate this question:

  • 11. 

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

    • A) Did the performance problem occur in the past?

    • B) Which user is experiencing the problem?

    • C) Is the problem happening right now?

    • D) How close is it to quitting time?

    Correct Answer(s)
    A. A) Did the performance problem occur in the past?
    A. C) Is the problem happening right now?
    Explanation
    The two key criteria when evaluating performance problems are whether the performance problem occurred in the past and whether the problem is happening right now. These criteria help in understanding the frequency and persistence of the performance issue, which can provide valuable insights for troubleshooting and finding solutions. The other options, such as identifying the user experiencing the problem or considering the time of day, may not be as relevant in determining the cause and resolution of the performance problem.

    Rate this question:

  • 12. 

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

    • A) rdisp/wp_no_dia

    • B) rdisp/wp_no_btc

    • C) rdisp/wp_no_enq

    • D) rdisp/dynamic_wp_check

    Correct Answer
    A. D) rdisp/dynamic_wp_check
    Explanation
    The correct answer is D) rdisp/dynamic_wp_check. This profile parameter affects the activation of dynamic work processes. When this parameter is set to a non-zero value, the system dynamically activates additional work processes based on the workload. This allows for better utilization of system resources and improved performance.

    Rate this question:

  • 13. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true. Virtual memory is indeed made up of the operating system's swap or page file and physical memory components. The swap or page file is a portion of the hard drive that the operating system uses as an extension of physical memory. It allows the operating system to temporarily store data that is not currently being used by programs in physical memory. When the data is needed again, it can be swapped back into physical memory. This helps to optimize memory usage and allows for efficient multitasking.

    Rate this question:

  • 14. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true. A hardware bottleneck occurs in the CPU when the processing time exceeds twice the CPU time. This means that the CPU is unable to handle the workload efficiently, resulting in slower processing times. A hardware bottleneck can occur due to various reasons such as outdated or insufficient hardware components, excessive heat, or inadequate memory. When a hardware bottleneck occurs, it can negatively impact the overall performance and efficiency of the system.

    Rate this question:

  • 15. 

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

    • A) rdisp/ddlogmode

    • B) rdisp/switch_bufmode

    • C) rdisp/bufremode

    • D) rdisp/auto_buf

    Correct Answer
    A. C) rdisp/bufremode
    Explanation
    The parameter "rdisp/bufremode" controls the buffer synchronization behavior in the SAP system. This parameter determines whether the buffer is shared or not between different application servers. If set to "0", the buffer is not shared and each application server has its own private buffer. If set to "1", the buffer is shared and changes made by one application server are visible to other application servers as well. Therefore, the correct answer is C) rdisp/bufremode.

    Rate this question:

  • 16. 

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

    • A) Asynchronous RFC

    • B) Transactional RFC

    • C) Queued RFC

    • D) Synchronous RFC

    Correct Answer
    A. C) Queued RFC
    Explanation
    Queued RFC calls guarantee multiple communication steps in a specific order. In a queued RFC, the calling program sends the request to a queue, and the receiving program retrieves the request from the queue and processes it. This ensures that the communication steps occur in the order they were sent, allowing for reliable and sequential execution of the RFC calls. Asynchronous RFC calls do not guarantee a specific order, while transactional RFC calls ensure atomicity but not a specific order. Synchronous RFC calls also do not guarantee a specific order.

    Rate this question:

  • 17. 

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

    • B) SM58

    • C) SMQ1

    • D) SMQ2

    • E) ST05

    Correct Answer
    A. B) 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 monitor and analyze the status of transactional RFC queues. It provides detailed information about the queued and processed RFCs, allowing users to identify and resolve any issues or errors in the queue. SM58 is specifically designed for monitoring and managing transactional RFC queues, making it the best tool for this purpose.

    Rate this question:

  • 18. 

    In which sequences do dialog work processes allocate memory?

    • 1. Roll area 2. Extended memory 3. Heap memory

    • 1. Initial part of roll area 2. Ectended memory 3. Remaining part of roll area 4. Heap memory

    • 1. Initial part of Roll area 2. Heap memory 3. Remaining part of roll area 4. Extended memory

    • 1. Roll area 2. Heap memory 3. Extended memory

    Correct Answer
    A. 1. Initial part of roll area 2. Ectended memory 3. Remaining part of roll area 4. Heap memory
    Explanation
    Dialog work processes allocate memory in the initial part of the roll area, extended memory, remaining part of the roll area, and heap memory.

    Rate this question:

  • 19. 

    How should optimizer statistics be kept up to date?

    • By using schedule periodic refreshes

    • By triggering AS ABAP update work process

    • By using updates jobs that are scheduled when an issue occurs

    • By manual update to avoid inconsistencies

    Correct Answer
    A. By using schedule periodic refreshes
    Explanation
    The optimizer statistics should be kept up to date by using scheduled periodic refreshes. This means that the statistics should be refreshed at regular intervals to ensure that the optimizer has the most accurate and current information about the data in the database. This helps the optimizer make better decisions when creating execution plans for queries and optimizing performance. By scheduling periodic refreshes, the statistics are automatically updated without the need for manual intervention, ensuring that the optimizer always has the most up-to-date information.

    Rate this question:

  • 20. 

    Wich os the followings transactions can you used to monitor the performance of an SAp system

    • ABAP Dictionary (SE11)

    • Work process Overview (SM50 and SM66)

    • System log Local Analysis (SM21)

    • SAP Operating System monitor (ST06 or OS07N)

    • Workload monitor (ST03N)

    Correct Answer(s)
    A. Work process Overview (SM50 and SM66)
    A. SAP Operating System monitor (ST06 or OS07N)
    A. Workload monitor (ST03N)
    Explanation
    3 answers

    Rate this question:

  • 21. 

    In transaction Operating System monitor (ST06(n)) you detected taht CPU idle calue on a server.. How should you investigate this situation?

    • Perform a detailed analysis of the memory configuration of the SAP system

    • Check if load can be distributed to other server with spare CPU capacity

    • Check that there are enugh Dialog work processes configurated on teh instance(s) on that...

    • Check the 'Top 40 CPU Processes' in trnasaction Operating System monitor (ST06(n))

    Correct Answer(s)
    A. Check if load can be distributed to other server with spare CPU capacity
    A. Check the 'Top 40 CPU Processes' in trnasaction Operating System monitor (ST06(n))
    Explanation
    To investigate the situation of CPU idle value on a server, it is recommended to check if the load can be distributed to other servers with spare CPU capacity. This will help balance the workload and utilize available resources efficiently. Additionally, checking the 'Top 40 CPU Processes' in the transaction Operating System monitor (ST06(n)) can provide insights into the processes consuming the most CPU resources, allowing for further investigation and optimization if necessary.

    Rate this question:

  • 22. 

    In transaction Operating System monitor (ST06(n)) in an ABAP-only system, how can you?

    • In an Unix System, more then 20% of RAM page out / swapped out per hour

    • In a Windows system, more tan 20% of RAM page out per hour

    • In a Windows system, more than 25% paged in per hour

    • In a unix system, more than 20% of RAM paged in / swapped in per houre

    Correct Answer(s)
    A. In an Unix System, more then 20% of RAM page out / swapped out per hour
    A. In a Windows system, more than 25% paged in per hour
    Explanation
    2 answers

    Rate this question:

  • 23. 

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

    • A) em/initial_size_MB

    • B) em/max_size_MB

    • C) rdisp/roll_SHM

    • D) Ztta/roll_extension

    Correct Answer(s)
    A. B) em/max_size_MB
    A. D) Ztta/roll_extension
    Explanation
    The correct answers for the question are B) em/max_size_MB and D) Ztta/roll_extension. These parameters are responsible for allocating heap memory for dialog processes. em/max_size_MB determines the maximum heap memory size in megabytes that can be allocated for a dialog process, while Ztta/roll_extension determines the size of the extended memory that can be used for roll area in dialog processes.

    Rate this question:

  • 24. 

    4. The user’s context is initially stored in the heap area in the shared memory..  Determine whether this statement is true or false.

    • True

    • False

    Correct Answer
    A. 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, register values, and stack pointer, and it is usually stored in the stack area of memory. The heap area is used for dynamically allocated memory.

    Rate this question:

  • 25. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true. If the database request time is greater than 40% of the response time minus the wait time in the transaction profile of ST03, it indicates that the SQL statements used in the program are taking a significant amount of time to execute. This suggests that these SQL statements are expensive and may need to be optimized or improved for better performance.

    Rate this question:

  • 26. 

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

    • A) Time needed to establish the RFC communication to the RFC server.

    • B) Time needed to establish the RFC communication plus roll out time, roll wait time, and roll in time.

    • C) Roll wait time caused by RFC communication.

    • D) GUI time.

    Correct Answer
    A. 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 plus the roll out time, roll wait time, and roll in time. This means that it includes the time required to establish the communication with the RFC server, as well as the additional time for the various roll operations.

    Rate this question:

  • 27. 

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

    • A) rdisp/rfc_max_own_wp

    • B) rdisp/rfc_min_wait_dia_wp

    • C) rdisp/rfc_max_own_login

    • D) rdisp/rfc_max_comm_entries

    Correct Answer
    A. B) rdisp/rfc_min_wait_dia_wp
    Explanation
    The correct answer is B) 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.

    Rate this question:

  • 28. 

    What are potential measures for the Internet Communicator manager (ICM)?

    • Configure the Internet Server Cache of the ICM

    • Identity expensive SQL statemets via ICM Monitor (SMICM)

    • Adjust the number of ICM Worker Threads and Connections

    • Make use of the ICM parameter rsdb/disable_memory_pipes

    Correct Answer(s)
    A. Configure the Internet Server Cache of the ICM
    A. Adjust the number of ICM Worker Threads and Connections
    Explanation
    There are 2 correct answers to this question.

    Rate this question:

  • 29. 

    Which of the following areas fo an instance's shared memory have corresponding files on the ...

    • Paging buffer

    • Extended memory (user contexts)

    • Roll buffer

    • SAP buffer (Programs, tables, etc.)

    Correct Answer(s)
    A. Paging buffer
    A. Roll buffer
    Explanation
    2 correct answers

    Rate this question:

  • 30. 

    Why is buffer synchronization important in an SAP system with more than one instance?

    • To imporve performance

    • To prevent outdated data being committed to the database

    • To reduce the load on the database

    • To prevent outdated data from being selected from buffers

    Correct Answer(s)
    A. To prevent outdated data being committed to the database
    A. To reduce the load on the database
    Explanation
    2 correct answers

    Rate this question:

  • 31. 

    You are reviewing RRC data in the transaction Worload Monitor (ST03N).Which RFC profile provides information about function modules in other systems that are...

    • RFC server profile

    • RFC client profile

    • RFC server-destination profile

    • RFC client-destination profile

    Correct Answer
    A. RFC client profile
    Explanation
    The correct answer is RFC client profile. In the transaction Worload Monitor (ST03N), the RFC client profile provides information about function modules in other systems that are called by the current system. This profile helps in analyzing the performance and usage of RFC calls made by the current system to other systems.

    Rate this question:

  • 32. 

    When you run transaction Table Call Statisctics (ST10), which of the followinf indicates that...

    • Tables with buffer state 'pending'

    • Tables with a high number of 'Rows affected'

    • Tables with more direct reads than sequential reads

    • Tales with a large buffer size

    • Tables with a high number of invalidations

    Correct Answer(s)
    A. Tables with a high number of 'Rows affected'
    A. Tales with a large buffer size
    A. Tables with a high number of invalidations
    Explanation
    The correct answer indicates that when running transaction Table Call Statistics (ST10), tables with a high number of 'Rows affected', tables with a large buffer size, and tables with a high number of invalidations are indicators of certain characteristics or issues within the tables. These indicators may suggest that these tables are experiencing frequent updates or modifications, have a large amount of data stored in memory, and are prone to becoming invalidated or outdated frequently. These indicators can provide insights into the performance and usage of the tables.

    Rate this question:

  • 33. 

    A customer's system is set up with many identical instances. Some instances have a....How can the custimer resolve this issue?

    • Increase the size of the Internet Server Cache (ISC) and Unfound Object Cache (UF..)

    • Use the SAP Web Dispatcher or, if already in use, check its configuration

    • Increase the number of work processes on all instances

    • Disavble the ICM for the high-load instances

    Correct Answer
    A. Use the SAP Web Dispatcher or, if already in use, check its configuration
    Explanation
    The customer can resolve the issue by using the SAP Web Dispatcher or checking its configuration. This suggests that the problem may be related to the configuration of the SAP Web Dispatcher, which is responsible for distributing incoming requests to the appropriate instances. By checking its configuration, the customer can identify any potential issues and make necessary adjustments to resolve the problem.

    Rate this question:

  • 34. 

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement "A Single Statistical Record captures an entire transaction in SAP" is false. A Single Statistical Record in SAP captures statistical data related to a transaction, such as the time it took to complete or the number of times it occurred. However, it does not capture the entire transaction itself, including all the details and data associated with it.

    Rate this question:

  • 35. 

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

    • A) ST03

    • B) SM04

    • C) SM66

    • D) SM36

    Correct Answer(s)
    A. A) ST03
    A. B) SM04
    A. C) SM66
    Explanation
    The transactions ST03, SM04, and SM66 are used in evaluating system performance. ST03 is used to analyze workload and performance data, SM04 is used to monitor the number of active users and sessions, and SM66 is used to monitor and analyze system-wide performance and workload distribution. These transactions provide valuable information and insights into the performance of the system, allowing for optimization and troubleshooting.

    Rate this question:

  • 36. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In transaction ST02, there can indeed be a problem if there is a lot of swapping in the SAP buffers. Swapping refers to the process of moving data between the main memory and the disk, and excessive swapping can lead to performance issues and slower response times. Therefore, it is true that there can be a problem if there is a lot of swapping in the SAP buffers.

    Rate this question:

  • 37. 

    1. 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 the correct answers.

    • A) High CPU utilization near 100%

    • B) High CPU idle time

    • C) High swap/paging activity

    • D) High DB time

    Correct Answer(s)
    A. A) High CPU utilization near 100%
    A. C) High swap/paging activity
    Explanation
    High CPU utilization near 100% indicates that the CPU is constantly being utilized to its maximum capacity, which can be a sign of a hardware bottleneck in the SAP system. High swap/paging activity indicates that the system is frequently swapping data between the RAM and the hard disk, which can also be a sign of a hardware bottleneck. Both of these indicators suggest that the system is struggling to handle the workload efficiently, potentially due to limitations in the hardware resources.

    Rate this question:

  • 38. 

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

    • A) Transaction ST02

    • B) SAP Management Console

    • C) Executable program sappfpar

    • D) Transaction RZ10

    Correct Answer
    A. C) Executable program sappfpar
    Explanation
    The correct answer is C) Executable program sappfpar. This program can be used to check the formulas and the values used in the formula-based memory parameters.

    Rate this question:

  • 39. 

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

    • A) SQL statements used by ABAP programs

    • B) SQL statements used by SAP Basis Tables

    • C) Recursive SQL Statements

    • D) SQL statements used by Database Administration Tools

    Correct Answer(s)
    A. B) SQL statements used by SAP Basis Tables
    A. C) Recursive SQL Statements
    A. D) SQL statements used by Database Administration Tools
  • 40. 

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

    • A) Execution plan (table/index access)

    • B) Estimated costs/ Estimated rows

    • C) Memory usage

    • D) Table/indexes statistics

    Correct Answer(s)
    A. A) Execution plan (table/index access)
    A. B) Estimated costs/ Estimated rows
    A. 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 provides statistics about the tables and indexes used in the query.

    Rate this question:

  • 41. 

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

    • A) Single record buffered

    • B) Generic area buffered

    • C) Fully buffered

    • D) Client specific buffered

    Correct Answer(s)
    A. A) Single record buffered
    A. B) Generic area buffered
    A. C) Fully buffered
    Explanation
    The valid options for table buffering types are: Single record buffered, Generic area buffered, and Fully buffered. These buffering types determine how data is stored and accessed in memory for a table. Single record buffered means that only one record is loaded into memory at a time, while generic area buffered means that a range of records is loaded. Fully buffered means that the entire table is loaded into memory. Client specific buffered is not a valid option for table buffering types.

    Rate this question:

  • 42. 

    In transaction Workload Analysis monitor (ST03(N)) average roll-wait time for task type DI..Which of the following can cause this issue?

    • Not enough dialog work processes configured

    • Communication problems with the GUI front end

    • SAP roll Area is too small

    • Problems with the external RFC communication

    Correct Answer(s)
    A. Communication problems with the GUI front end
    A. Problems with the external RFC communication
    Explanation
    Communication problems with the GUI front end and problems with the external RFC communication can cause the average roll-wait time for task type DI to increase. These issues can lead to delays in the communication between the SAP system and the front end or external systems, resulting in longer wait times for the tasks to complete. This can impact the overall performance and efficiency of the system.

    Rate this question:

  • 43. 

    What does Zero Administration memory management do?

    • It makes entering PRIV mode impossible

    • It prevents the adminsitrator of the system from setting any memory parameters

    • It allows all memory parameters to be set autmatically

    • It allows total extendes memory size to grow dymacally and allows other memory param..

    Correct Answer
    A. It allows total extendes memory size to grow dymacally and allows other memory param..
    Explanation
    Zero Administration memory management allows the total extended memory size to grow dynamically and also allows other memory parameters to be set automatically. This means that the system can automatically adjust the memory allocation based on the needs of the applications running, without the need for manual intervention from the administrator. This ensures optimal memory usage and eliminates the need for constant monitoring and adjustment of memory parameters.

    Rate this question:

  • 44. 

    Which buffering types are avaible in SAP table buffers?

    • Definition only buffered

    • Partially buffered

    • Generic key buffered

    • Fully buffered

    • Single record bufferd

    Correct Answer(s)
    A. Generic key buffered
    A. Fully buffered
    A. Single record bufferd
    Explanation
    3 answers

    Rate this question:

  • 45. 

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

    • A) SM50

    • B) ST06

    • C) SM66

    • D) ST02

    Correct Answer(s)
    A. A) SM50
    A. C) SM66
    Explanation
    Transactions SM50 and SM66 are used to evaluate the work process statuses and activities that are currently happening. SM50 is used to monitor the work processes in the SAP system, providing information about their status, CPU usage, and memory usage. SM66 is used to monitor the server processes and their status, allowing administrators to identify any performance issues or bottlenecks. Both transactions provide real-time information about the work processes and activities, making them suitable for evaluating the current state of the system.

    Rate this question:

  • 46. 

    3. Table buffering is recommended for which of the following scenarios? Choose the correct answers.

    • A) Tables that are seldom changed.

    • B) Large tables that are often accessed.

    • C) Customizing data.

    • D) Transaction data.

    Correct Answer(s)
    A. A) Tables that are seldom changed.
    A. C) Customizing data.
    Explanation
    Table buffering is recommended for tables that are seldom changed and for customizing data. Table buffering helps improve performance by storing frequently accessed data in memory, reducing the need to access the database. This is particularly beneficial for tables that are not frequently updated, as it allows for faster retrieval of data. Additionally, buffering customizing data can help improve the performance of applications that rely on this data for customization purposes.

    Rate this question:

  • 47. 

    Which elements of totak response time should be under 20ms?

    • Roll-in time

    • Satabase request time

    • Wait time

    • Processing time

    Correct Answer(s)
    A. Roll-in time
    A. Wait time
    Explanation
    2 answers correct

    Rate this question:

  • 48. 

    Where and when is ABAP heap memory allocated?

    • In teh local memory of the work process, when the work process is started

    • In teh local memory of the work process, when required

    • In shared memory, when required

    • In shared memory, when the system started

    Correct Answer
    A. In teh local memory of the work process, when required
    Explanation
    ABAP heap memory is allocated in the local memory of the work process when required. This means that the memory is allocated dynamically as needed during the execution of the program. The work process is responsible for managing its own local memory and allocating heap memory when necessary to store data and objects. This allows for efficient memory usage as memory is only allocated when it is actually needed, and it is deallocated when it is no longer required.

    Rate this question:

  • 49. 

    .... explain plan for an expensive SQL statement?

    • Transaction SQL Trace (ST05 or ST12)

    • Transaction Workload Monitor (ST03N)

    • Transaction SAP Buffer monitor (ST02)

    • Transaction DBACOCKPIT or Performance Overview (ST04)

    Correct Answer(s)
    A. Transaction SQL Trace (ST05 or ST12)
    A. Transaction DBACOCKPIT or Performance Overview (ST04)
    Explanation
    2 correct answers to this question

    Rate this question:

Quiz Review Timeline (Updated): Oct 28, 2024 +

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

  • Current Version
  • Oct 28, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 14, 2017
    Quiz Created by
    Vanessa
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.