Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
