Certification Test

SAP Technology Consultant SAP NetWeaver Web AS Implementation & Operation for MS SQL Server (2003)

Booking Code

C_TADM53_03

This certificate proves that the candidate has a basic understanding within this consultant profile based on the MS SQL Server, and can implement this knowledge practically in projects. This certification test only includes questions about the administration of the MS SQL Server within a SAP installation. Questions about the non database dependant part of the consultant profile are covered in the intermediate test (certification booking code C_TADM12_03). Please note, that the certificate is only handed out, if the certification participant suceeded in both tests.

Software

Number of Questions

Duration

Notes

Competency Areas

The following list helps you to identify the competency areas covered in this test. The percentage indicates the portion of the test dedicated to a particular competency area.

Weighting per Topic (not listed for all exams):

+ = <8%

++ = 8-12%

+++ = >12%

Competency

Importance

	Way(s) to attain
Topic	Primary	Alternative	Other

Administration

> 20%

Authentication	TADM53
Database connections of Web AS	TADM53
Locking	TADM53
Maintaining SQL Server configuration parameters and database opt	TADM53
Memory management	TADM53
SAP dictionary objects - database objects	TADM53
SAP statistics on stored procedures	TADM53
Transaction logging	TADM53
Update statistics	TADM53
Windows services, processes, and threads	TADM53

Backup

11-20%

Backup strategies	TADM53
Backup types	TADM53
Backups with CCMS and SQL Server tools	TADM53
Tape management and tape options	TADM53

Device Configuration

> 20%

Data and storage architecture using databases, files, and indexe	TADM53
File size management	TADM53
Files of a Web AS database	TADM53

Restore and Recovery

11-20%

Point in time recovery	TADM53
Reasons for a restore and resulting restore procedures	TADM53
Steps of a restore	TADM53

Troubleshooting

11-20%

Checking database error messages	TADM53
Client/Server communication	TADM53
Detecting poorly qualified SQL statements	TADM53
Handle exceptional situations on SQL Server	TADM53
Index statistics	TADM53
Lock wait situations	TADM53