ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 38 - NCS-Core discussion

Report
Export

Refer to the exhibit.

A Microsoft SQL 2016 deployment is shown in the exhibit. The administrator receives user reports that database queries take too long to return.

Which optimization should be made to this configuration to improve performance?

A.
Combine both of the OS and SQL Binaries disks
Answers
A.
Combine both of the OS and SQL Binaries disks
B.
Add a second SCSI controller for the Database.
Answers
B.
Add a second SCSI controller for the Database.
C.
TempDB, and Logs disk Separate the Database. TempDB, and Logs onto their own disks
Answers
C.
TempDB, and Logs disk Separate the Database. TempDB, and Logs onto their own disks
D.
Configure the VM to use a PCI disk controller
Answers
D.
Configure the VM to use a PCI disk controller
Suggested answer: C
asked 23/09/2024
Adlian Akbar
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first