Google Cloud Professional Cloud Database Engineer — Question 12

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

Answer options

• 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.

Correct answer: C

Explanation

The correct choice is C because it provides sufficient resources, particularly the 4 TB of SSD, which is essential for handling the high read IOPS requirement. Option A lacks the necessary resources for optimal performance, while option B provides insufficient SSD storage, and option D, although it uses the Enterprise edition, does not offer enough SSD capacity to meet the performance needs.