PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #22
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 disc
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #22. The question stem and answer options stay visible for context.
Question
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?
Options
- ACreate a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM,
- BCreate a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104
- CCreate a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of
- DCreate a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.