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

1. Which of the following are possible assignments when setting up output devices in SAP systems based on AS ABAP? (Choose two)

A) An output device can be directly assigned to a logical spool server.
B) An output device must be assigned to a specific spool work process.
C) An output device does not need to be assigned to a spool server.
D) An output device can be directly assigned to a physical spool server.

2. To be sure that the SAP database <SID> can be restored without internal inconsistencies at any time, the database administrator needs to develop a strategy that guaranties a regular database backup together with a consistency check. With which scenarios can this goal be achieved? (Choose two)

A) In the SQL Server Management Studio, schedule a regular job with two steps, using the statement DBCC CHECKDBCONS ('<SID>') in the first step and BACKUP DATABASE <SID> TO <BACKUP_DEVICE> in the second step.
B) In the SQL Server Management Studio, schedule a regular job with two steps, using the statement DBCC CHECKDB ('<SID>') WITH NO_INFOMSGS in the first step and BACKUP DATABASE <SID> TO <BACKUP_DEVICE>... in the second step.
C) In the SQL Server Management Studio, schedule a regular job for a full database backup, selecting perform checksum before writing to the media option.
D) In the DBA Planning Calendar DB13, schedule a regular job for the database consistency check and a subsequent job for the full database backup.

3. Business APIs (BAPIs) can be used to trigger and execute transactions in an SAP landscape. Which of the following statements regarding BAPIs are correct? (Choose two)

A) BAPIs are specialized remote function calls
B) BAPI communication requires a connection to a central LDAP directory server
C) Data exchange by BAPI can only be done by asynchronous RFC
D) BAPIs can be used for connecting external software to SAP systems

4. 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) The Solution Manager is part of an SAP ECC 6.0 installation. No additional steps are required.
B) To install an SAP ECC 6.0 system, a key provided by an SAP Solution Manager is required.
C) Together with the SAP Solution Manager, a System Landscape Directory (SLD) can be installed.
D) SAP Solution Manager must be installed first, otherwise the SAP ECC 6.0 system cannot be installed.

5. When the transaction log of the SAP database <SID> becomes full, no changes to data in this database can be performed. Which action can be taken to resolve this problem? (Choose three)

A) Perform an immediate backup of the transaction log.
B) As the first step, analyze the ABAP short dump generated when the transaction log becomes full.
C) Terminate long-running transactions and backup the transaction log.
D) Set the recovery model to simple.
E) When the administrator wants to resolve the problem by extending the existing transaction log, but it cannot be extended on its volume due to an exhausted disk space, then he/she must set the database offline, create an additional transaction log file on another drive, and set the database back to online.

Solutions: