SAP
C_TADM53_70 · Question #23
C_TADM53_70 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock C_TADM53_70 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Question
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)
Options
- ATo determine the maximum size of memory used by the whole SQL Server system with help of
- BTo determine the maximum size of the buffer pool, because it never increases its memory
- CTo determine the minimum size of the buffer pool, because it never drops its memory allocation
- DTo determine the maximum size of the data cache, because it never increases its memory
- ETo determine the minimum size of the data cache, because it never drops its memory allocation
Unlock C_TADM53_70 to see the answer
You've previewed enough free C_TADM53_70 questions. Unlock C_TADM53_70 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.