SAP System Administration (MS SQL DB) with SAP NetWeaver 7.0 Sample Questions:

1. You want to improve the data access performance for your SAP database <SID> and also to avoid its deterioration in future. Which is the best strategy?

A) Keep number of data files of the SAP database and of the tempdb database approximately equal.
B) 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.
C) Use as many data files as there are CPUs on the database host.
D) Use as many data files as there are CPUs dedicated to the SQL Server.

2. In which of the following scenarios is RFC communication used as the standard communication method in SAP systems? (Choose three)

A) RFC communication is often used for exchanging business data between different SAP systems.
B) RFC communication is used for exchanging user data between AS ABAP-based SAP systems and the LDAP connector.
C) RFC communication is used for transferring monitoring data between SAP systems.
D) RFC communication is used for exchanging information between the ICM process and a web browser.

3. 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) 'Phys. Memory (MB)' is the amount of physical memory assigned to the SQL Server instance.
B) 'SQL Memory Setting' = RANGE allows the SQL Server to allocate memory dynamically.
C) 'SQL Memory Setting' = AUTO (note: not shown in the figure, but possible) allows the SQL Server to allocate memory dynamically.
D) 'CPUs used by MSS' is determined by the SQL Server configuration parameter affinity I/O mask.
E) The size of the procedure cache ('Proc. Cache (MB)') is always determined by the SQL Server dynamically, independently of the 'SQL Memory Setting'.

4. 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) The primary file is always required.
B) At least one secondary file is always required, because every database always uses at least two files.
C) Data and log information are never stored in the same file.
D) Secondary files are used to store data.
E) The primary file stores the log information used to recover the database.

5. For an AS ABAP, the connection to an LDAP Directory can be configured. Which of the following statements are true? (Choose three)

A) In AS ABAP, there is a report available which can enhance the LDAP schema of different LDAP providers.
B) Technically, the connection is done using the operating system program ldap_rfc.
C) The main configuration of an LDAP connection is done using the transaction LDAP.
D) SAP trusts the LDAP user management. Therefore, the users cannot be maintained anymore in the transaction SU01.

Solutions: