You have a Microsoft Azure Infrastructure as a Service (IaaS) environment that contains a 3-TB data warehouse.

You

need to recommend a solution to improve the read performance of the database. The solution must maintain data integrity.

Which task should you include in the recommendation?

A. Enable read caching.

B. Move the transaction logs to the temporary drive.

C.

Enable read/write caching.

D. Set the interleave size to 64 KB.

Explanation:

Best practices include enabling read caching on the disk(s) hosting the data files and TempDB data files.

References:

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance