Topic 1 Question 41
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?
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).
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.
Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
ユーザの投票
コメント(5)
- 正解だと思う選択肢: C
A disk size of 4TB or greater provides more throughput and IOPS. Storage: >= 4TB for the best IOPS https://cloud.google.com/sql/docs/sqlserver/best-practices#admin
👍 2Popa2022/12/20 - 正解だと思う選択肢: C
Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C. https://cloud.google.com/compute/docs/disks/performance
👍 2fredcaram2022/12/20 - 正解だと思う選択肢: C
Agree C is the correct answer
👍 2GCP722022/12/25
シャッフルモード