Provisioning SQL Databases — Question 51

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?

Answer options

Correct answer: B

Explanation

Disabling write-caching on the RAID controller is essential for ensuring data integrity and consistency, especially for database applications like SQL Server. The other options do not directly address the potential risks associated with using a RAID controller that is not designed for DBMS systems or do not improve the immediate configuration for best practices.