C_TADM53_70 Online Practice Questions and Answers
Which of the following statements regarding the functions offered by CCMS-based monitoring are true? (Choose two)
A. It is possible to monitor more than one SAP system by using the functions offered by CCMS monitoring.
B. Correctly configured threshold values to be used for monitoring purposes can be switched by using operation modes.
C. You need a special key (generated within SAP Solution Manager) to create your own monitor definitions in transaction RZ20.
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
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.
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.
Every SQL Server database stores its data in various types of operating system files. To administer a database, it is important to understand its physical structure. Which files are always required? (Choose three)
A. At least one secondary file is always required, because every database always uses at least two files.
B. The primary file stores the log information used to recover the database.
C. Secondary files are used to store data.
D. The primary file is always required.
E. Data and log information are never stored in the same file.
Which traces can be switched on and off from within the SAP system without restarting the instance? (Choose two)
A. Buffer Trace
B. SYSLOG Trace
C. SQL Trace for ABAP-based applications
During installation, several log files are written by SAPinst. Identify these log files. (Choose two)
A. sapinst.log
B. inst.log
C. sapinst_dev.log
For which of the following options do you need to install and configure SAProuter? (Choose two)
A. EarlyWatch session done remotely by an employee of SAP
B. Create a support message in case of problems with the SAP system
C. Remote Consulting from SAP
D. Connection to http://help.sap.com.
Which one of the following tools is used to configure VM parameters for AS Java?
A. Config Tool
B. SAPinst
C. NetWeaver Developer Studio
D. Visual Administrator
Which data sources are supported by the User Management Engine (UME) of AS Java? (Choose three)
A. A file (also called secure store)
B. A client of an AS ABAP based SAP system
C. A directory server (LDAP)
D. A UDDI provider
E. The database of the AS Java