Exam 70-765 topic 4 question 27 discussion

Actual exam question from Microsoft's 70-765

Question #: 27
Topic #: 4

You are planning a Microsoft SQL Server deployment. You do not have a Storage Area Network (SAN) or Network Attached Storage (NAS) infrastructure.
You have a physical host that has 128 gigabytes (GB) RAM, two ""core processors, and two 1 GB network interface cards (NICs). The host supports RAID through a write-caching RAID controller. The RAID controller is not specifically designed for DBMS systems. The host can support up to eight physically attached disks.
The system does not include a battery backup power supply.
You must implement SQL Server best practices when installing and configuring the server to host SQL Server.
You need to configure the system to support a SQL Server installation by using best practices.
What should you do?

A. Increase the RAM in the server.
B. Disable write-caching on the RAID controller.
C. Configure NIC Teaming.
D. Add two more processors.

Show Suggested Answer

Suggested Answer: B 🗳️

by jolsca at Sept. 10, 2020, 8:19 p.m.

Comments

Submit Cancel

jolsca

4 years, 9 months ago

Is Correct, Do not use read/write caching on any SQL Server data disk, as it can potentially lead to data loss. Disk Caching, it is recommended to use read caching on the disks hosting your data fles and TempDB fles, but not your transaction logs.

upvoted 1 times

Slava_bcd81

4 years, 9 months ago

Read cashing is good for database files, no cashing for log files

upvoted 1 times

...