We're so confident of our products that we provide no hassle product exchange.
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) Option B
B) Option D
C) Option A
D) Create a clustered index with index key columns C and D
E) Create a non-clustered index with index key columns C, D, A, B
F) Create a non-clustered index with index key columns C and D
G) Option C
H) Create a non-clustered index with index key columns C and D and non-key columns (included columns) A and B
2. Which one of the following tools is used to configure VM parameters for AS Java?
A) Config Tool
B) Visual Administrator
C) SAPinst
D) NetWeaver Developer Studio
3. Which program, on the operating system level, performs and controls transports between ABAP based SAP-systems? Note that this program is controlled by your actions, for example in transactions SE09 (Transport Organizer) and STMS (Transport Management System).
A) RDDIMPDP.bat
B) import.exe
C) RDDEXPPP.exe
D) tp.exe
E) transport.exe
4. Which statement regarding front end printing with SAP NetWeaver AS ABAP is correct?
A) If you want to configure an output for front end printing with SAP GUI for HTML, you have to choose access method G.
B) If you want to configure an output device for front end printing with SAP GUI for Windows, you should choose access method G.
C) It is not possible to configure an output device for front end printing with SAP GUI for Java.
5. Which statement regarding remote printing with SAP NetWeaver AS ABAP is correct?
A) If you want to configure remote printing for an output device, you need to choose access method C for Windows operating systems.
B) If you want to configure remote printing for an output device, you have to choose access method R in every case (on all operating systems).
C) If you want to configure remote printing for an output device, you can use access methods U and S, depending on your operating system.
Solutions:
| Question # 1 Answer: F | Question # 2 Answer: A | Question # 3 Answer: D | Question # 4 Answer: B | Question # 5 Answer: C |
By Ed
