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

1. While monitoring and analyzing expensive SQL statements, you identify an expensive statement which looks like the following: SELECT A, B FROM T WHERE C= <VALUE1> AND D= <VALUE2> Here, T is the relevant database table and A, B, C, D are its columns; each of them containing data that can be sorted. Although a clustered index and several non-clustered indexes already exist for this table, none of them is optimal, because none of them includes the columns C and D as key columns. You want to create a new index to tune the mentioned statement in an optimal way.
What is the best solution?

A) Create a clustered index with index key columns C and D
B) Option D
C) Create a non-clustered index with index key columns C, D, A, B
D) Option B
E) Create a non-clustered index with index key columns C and D
F) Option A
G) Create a non-clustered index with index key columns C and D and non-key columns (included columns) A and B
H) Option C

2. What consequences has the use of "native SQL" in ABAP programs written by customers?

A) No buffering of table content on the SAP application server
B) The use of native SQL always results in poor performance
C) Loss of database independence for these programs
D) No lock handling by the enqueue work process

3. Which of the following statements regarding the Java Message Server are correct? (Choose two)

A) It is not a critical component of SAP NetWeaver AS system and it can be stopped when not in use.
B) It can supply information to the SAP Web Dispatcher about the status of AS Java instances.
C) It keeps a list of all active AS Java instances.

4. Which of the following statements regarding the client concept and the client copy tools in ABAP-based SAP Systems (for example, SAP ECC) are true? (Choose three)

A) Client-independent customizing is always automatically copied between clients.
B) User master records cannot be copied between clients.
C) Clients can be copied between SAP Systems of the same release.
D) Clients can be copied within a single SAP System.
E) Application data can only be copied from one client to another, when all client-specific customizing is also copied.

5. Which of the following statements regarding starting and stopping an SAP system based on AS ABAP+Java 7.0 are correct? (Choose two)

A) The SAP MC is Java-based, therefore you can only start and stop the Java part of an instance.
B) The ABAP-dispatcher triggers the start of the Java part of the instance.
C) If you use the command: "stopsap J2EE DVEBMGS00" on operation system level, only the java part of the instance is stopped.
D) The Java-dispatcher and the ABAP-dispatcher of one instance write their respective developer traces in different files on the same directory.

Solutions: