Online Access Free C-TADM53-70 Exam Questions

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

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

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

Which of the following terms are correlated to the (ABAP-based) SAP system monitoring infrastructure? (Choose two)

• A.Data Supplier
• B.Monitoring Tree Element
• C.Alert Server
• D.Alert Memory

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 non-clustered index with index key columns C and D
• B.Create a non-clustered index with index key columns C and D and non-key columns (included columns) A and B
• C.Option B
• D.Option D
• E.Option A
• F.Create a clustered index with index key columns C and D
• G.Option C
• H.Create a non-clustered index with index key columns C, D, A, B

In SAP NetWeaver AS Java, you can configure the severity for logs and traces. Which statement is true?

• A.You can configure the severity for a logging category with SAP NetWeaver Administrator (NWA).
• B.You can configure the severity for a whole sub-tree of logging destinations with SAP NetWeaver Administrator (NWA).
• C.You can configure the severity for a tracing location with the Standalone Log Viewer.