Provisioning SQL Databases — Question 59

You manage a Microsoft SQL Server instance named SQL1 that has 32 gigabytes (GB) of total memory. The instance supports an app named App1 that only uses a single thread. App1 frequently queries the database using the same index. The operating system and App1 combined require 8 GB of memory to function.
You need to ensure that the SQL Server does not limit the performance of App1.
What configuration option should you set?

Answer options

• A. min memory per query to 4 GB
• B. index create memory to 16 GB
• C. max worker threads to 1
• D. max server memory to 16 GB

Correct answer: B

Explanation

The correct answer is B, as setting the index create memory to 16 GB allows SQL Server to allocate sufficient memory for index operations, which is crucial for the performance of App1. Options A and D do not provide adequate memory for index creation, while option C unnecessarily restricts the number of worker threads, which is not relevant to the performance of a single-threaded application.