SAP
C_TADM53_70 · Question #17
C_TADM53_70 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock C_TADM53_70 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
Question
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)
Options
- A'SQL Memory Setting' = AUTO (note: not shown in the figure, but possible) allows the SQL Server
- BThe size of the procedure cache ('Proc. Cache (MB)') is always determined by the SQL Server
- C'CPUs used by MSS' is determined by the SQL Server configuration parameter affinity I/O mask.
- 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.
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.