Adaptive Server Enterprise 15 Administrator Associate

Question 1

Which of the following are NOT captured by query plan metrics? (Choose two.)

A. Join order

B. Index access method

C. CPU execution time

D. Logical I/O

E. Physical I/O

Correct Answer: A,B

Question 2

What conditions must be met before altering the partition strategy of a table from round-robin to a range partitioned table?

A. Additional partitions must be added to the round-robin table

B. Table data must be truncated

C. Table indexes must be dropped

D. Table must be unpartitioned before changing partition strategy

Correct Answer: C

Question 3

What is the maximum value of vdevno that may be assigned to a device?

A. 255

B. value of the configuration setting "number of devices"

C. value of the configuration setting "number of devices" minus 1

D. 2147483647

E. no limit

Correct Answer: D

Question 4

What is the system stored procedure used to display metadata cache usage statistics?

A. sp_cacheconfig

B. sp_helpconfig

C. sp_configure

D. sp_monitorconfig

Correct Answer: D

Question 5

Which of the following are TRUE regarding creating, modifying or dropping buffer pools? (Choose two.)

A. As long as 1 pool remains in the cache, any pool can be removed

B. The maximum I/O size for any cache is 8 pages

C. New pools are created using memory from the largest pool unless otherwise specified

D. The sum of all the buffers in the pool must be less than or equal to the total memory size of cache

E. The minimum pool size is determined by a configuration parameter

Correct Answer: B,D

Question 6

Maximum database size for 2K pages is?

A. 256 GB

B. 2 TB

C. 4 TB

D. 32 GB

E. 8 TB

Correct Answer: C

SAP Adaptive Server Enterprise 15 Administrator Associate - C-SASEAA-15 Exam Practice Test

Latest Update

Useful Links

Contact Us