Free SAP C_TADM53_70 Exam Dumps Questions & Answers

Tuning the performance of an SQL Server instance includes configuring the memory used by this instance on a given host. An optimal memory configuration depends on several aspects such as; memory requirements of the SQL Server itself, hardware resources, other applications installed on the host, or internal usage of the values of the two most important SQL Server parameters - min server memory and max server memory. For which exact purposes can the database administrator use these parameters? (Choose two)

• A.  To determine the minimum size of the buffer pool, because it never drops its memory allocation below the value specified in min server memory
• B.  To determine the maximum size of memory used by the whole SQL Server system with help of max server memory
• C.  To determine the maximum size of the buffer pool, because it never increases its memory allocation above the value specified in max server memory
• D.  To determine the maximum size of the data cache, because it never increases its memory allocation above the value specified in max server memory
• E.  To determine the minimum size of the data cache, because it never drops its memory allocation below the value specified in min server memory

How can you prevent a transaction log overflow in a normal situation?

• A.  Schedule regular log backups.
• B.  Schedule regular full database backups using the option WITH LOG_TRUNCATE in the backup command.
• C.  Schedule regular differential backups.
• D.  Set the recovery model to simple and schedule regular log backups.

Due to parameter maintenance, you need to stop (and later restart) the SQL Server instance. How can you perform this? (Choose three)

• A.  Stop the service SQL Server (MSSQLSERVER) in Administrative Tools >> Services. To perform the stopping (and restarting) as quickly as possible, answer the question whether you also want to stop the service SQL Server Agent (MSSQLSERVER) with 'No'.
• B.  Stop the SQL Server instance in the SAP System Management Console (sapmmc).
• C.  Stop the service SQL Server (MSSQLSERVER) in the SQL Server Configuration Manager.
• D.  Stop the SQL Server in SQL Server Management Studio.
• E.  Stop the service SQL Server (MSSQLSERVER) in Administrative Tools >> Services.

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

You want to configure the automatic data transfer from an SAP System Landscape Directory (SLD) to the SAP Solution Manager system. Which of the following configuration steps are necessary? (Choose two)

• A.  On the SAP Solution Manager system you need to schedule a periodic data transfer job (Job LANDSCAPE_FETCH). This can be done in transaction SMSY_SETUP.
• B.  On the SLD system, you need to trigger an event that starts the data transfer to the SAP Solution Manager system (event START_TRANSFER).
• C.  On the SLD system, you need to configure the JCo RFC Provider Service in Visual Administrator.
• D.  On the SAP Solution Manager system, you need to create a trusted RFC connection of Type "3" to the SL