Answer-first summary for fast verification
Answer: Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
To maximize read performance for a Cloud SQL instance that needs to handle around 25,000 read IOPS, it's crucial to select a machine type and configuration that can support such a high IOPS requirement. Option C is the correct choice because it provides a High Memory machine type with 16 vCPUs, 104 GB of RAM, and a large 4 TB SSD. The large SSD is particularly important as it can support the high read IOPS requirement. The High Memory machine type is suitable for memory-intensive applications, and the 16 vCPUs ensure that the instance can handle the workload efficiently. The other options either do not provide enough storage to support the required IOPS (A and B) or are unnecessarily expensive due to the Enterprise edition (D) without providing additional benefits for the read IOPS requirement.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How should you size your Cloud SQL for SQL Server instance to optimize read performance when migrating from an on-premises Microsoft SQL Server 2016 Standard Edition with peak read IOPS of 25,000 on a Windows Server 2019 Datacenter Edition?
A
Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
B
Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
C
Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
D
Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
No comments yet.