Microsoft
70-450 · Question #43
70-450 Question #43: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
Question
You are the database administrator for a SQL Server that hosts an application defined as follows: The database consists of 4 data files and one log file. The physical server has 16 CPUs and 64 GB of memory. Hardware non-uniform memory access (NUMA) is not available on this server platform. Users of the application report that it is responding slowly. You use SQL Server Profiler to find out that the I/O performance issue is related to the lazywriter process. You need to improve the performance of the application by reducing the I/O performance issue. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- AAdd additional RAM to the server.
- BAdd additional data files to the database.
- CConfigure four software non-uniform memory access (soft NUMA) nodes on the server.
- DConfigure a CPU affinity mask on the server to limit the instance of SQL Server to four
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 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.