The attached figure shows the first screen of the SQL Server Performance Analysis transaction (ST04). To tune the SQL Server performance, you need to interpret the information displayed on this screen correctly and possibly change some of the SQL Server settings. Which interpretations are valid and which actions should be taken? (Choose three)
A. 'SQL Memory Setting' = AUTO (note: not shown in the figure, but possible) allows the SQL Server to allocate memory dynamically.
B. The size of the procedure cache ('Proc. Cache (MB)') is always determined by the SQL Server dynamically, independently of the 'SQL Memory Setting'.
C. 'CPUs used by MSS' is determined by the SQL Server configuration parameter affinity I/O mask.
D. 'Phys. Memory (MB)' is the amount of physical memory assigned to the SQL Server instance.
E. 'SQL Memory Setting' = RANGE allows the SQL Server to allocate memory dynamically.
Due to parameter maintenance, you need to stop (and later restart) the SQL Server instance. How can you perform this? (Choose three)
A. Stop the service SQL Server (MSSQLSERVER) in Administrative Tools >> Services.
B. Stop the SQL Server instance in the SAP System Management Console (sapmmc).
C. Stop the SQL Server in SQL Server Management Studio.
D. Stop the service SQL Server (MSSQLSERVER) in Administrative Tools >> Services. To perform the stopping (and restarting) as quickly as possible, answer the question whether you also want to stop the service SQL Server Agent (MSSQLSERVER) with 'No'.
E. Stop the service SQL Server (MSSQLSERVER) in the SQL Server Configuration Manager.
You want to maintain the SQL Server parameter, lightweight pooling, to speed up the communication with the SQL Server. Which goals can you achieve with this parameter? (Choose two)
A. To determine that the SQL Server uses threads to run user commands.
B. To determine the size of the thread pool that the SQL Server system uses to maintain client connections.
C. To determine the size of the fiber pool that the SQL Server system uses to maintain client connections.
D. To determine the size of the pool of operating system processes that the SQL Server uses to maintain client connections.
E. To determine that the SQL Server uses fibers to run user commands.
You want to improve the data access performance for your SAP database
A. Use as many data files as there are CPUs dedicated to the SQL Server.
B. Use as many data files as there are CPUs on the database host.
C. When the database is growing, regularly create new data files for new data to avoid uncontrolled growth of existing files, because data access performance directly depends on the size of the data files.
D. Keep number of data files of the SAP database and of the tempdb database approximately equal.
While monitoring and analyzing expensive SQL statements, you identify an expensive statement which looks like the following:
SELECT A, B FROM T WHERE C=
What is the best solution?
A. Create a clustered index with index key columns C and D
B. Create a non-clustered index with index key columns C and D and non-key columns (included columns) A and B
C. Create a non-clustered index with index key columns C and D
D. Create a non-clustered index with index key columns C, D, A, B
What is the name of the program on the operating system level that is used when an ABAP program calls an external program?
A. saposcol
B. disp+work
C. sap_ext_prog
D. sapxpg
Using SAPDOCCD.ini, you have several options for changing the way online documentation is accessed. Which of the following statements are true? (Choose three)
A. You can change the access path to online documentation, depending on the release of the SAP system from which help is being called.
B. You can change the access path to online documentation, depending on the user ID (in the SAP system) of the user calling help.
C. You can change the access path to online documentation, depending on the logon language (in the SAP system) of the user calling help.
D. You can change the access path to online documentation, depending on the SID (System ID) of the SAP system from which help is being called.
You want to install SAP ECC 6.0 as the very first system of your landscape. Which of the following are prerequisites concerning SAP Solution Manager? (Choose three)
A. SAP Solution Manager must be installed first, otherwise the SAP ECC 6.0 system cannot be installed.
B. Together with the SAP Solution Manager, a System Landscape Directory (SLD) can be installed.
C. To install an SAP ECC 6.0 system, a key provided by an SAP Solution Manager is required.
D. The Solution Manager is part of an SAP ECC 6.0 installation. No additional steps are required.
When an external program triggers a background processing event, which operating system executable of the SAP system is used in triggering the event?
A. sapevent_launcher
B. sapevt
C. rfc
An instance of an AS ABAP-based SAP system switches to an operation mode in which fewer background work processes are configured. What happens if all background work processes are working on background jobs at the time the operation mode switch should be executed?
A. The active background jobs are allowed to finish the current work and the operation mode switch is cancelled.
B. The active background work jobs are allowed to finish the current work.
C. The active background jobs are terminated.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAP exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C_TADM53_70 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.