C_TADM53_70 · Question #23
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…
The correct answer is B. To determine the maximum size of the buffer pool, because it never increases its memory E. To determine the minimum size of the data cache, because it never drops its memory allocation. See the full explanation below for the reasoning.
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
How the community answered
(47 responses)- A15% (7)
- B72% (34)
- C4% (2)
- D9% (4)
Community Discussion
No community discussion yet for this question.