ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 41 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 41
Topic #: 1
[All Professional Cloud Database Engineer Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Popa at Dec. 20, 2022, 11:58 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
fredcaram
Highly Voted 1 year, 4 months ago
Selected Answer: 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
upvoted 11 times
...
learnazureportal
Most Recent 7 months, 3 weeks ago
The correct answer is ==> 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 focus on "at least" keyword
upvoted 2 times
...
dynamic_dba
1 year, 1 month ago
C. D is wrong since the IOPS would not improve based upon the edition of SQL Server. IOPS increases with the amount of storage, so the most amount of storage is C with 4 TB. I checked this using the GCP console and C is correct.
upvoted 2 times
...
GCP72
1 year, 4 months ago
Selected Answer: C
Agree C is the correct answer
upvoted 2 times
...
pk349
1 year, 4 months ago
C: Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, ***** 104 GB of RAM, and 4 TB of SSD.
upvoted 1 times
...
Popa
1 year, 4 months ago
Selected Answer: 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
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago