Practice Test 2 | Google Cloud Certified Professional Cloud Architect | Dumps | Mock Test
For this question, refer to the EHR Healthcare case study.
EHR Healthcare needs to set up a general DR policy for all its relation Databases, distributed in all its Data Centers on-premises.
The activity is preparatory to the migration to the Cloud, which includes managed services.
EHR Healthcare wants to migrate data into managed services in the future without major impact on applications, which will all need to be containerized.
Later it will adopt a global DB solution.
The DR will be the first step towards migration
The requirements are RPO and RTO in less than 1 hour.
Which of the following solutions do you think are the best (Select TWO)?
A. Create daily snapshots of the Database and transfer them to Cloud Storage
B. Create MySQL external replica promotion migration into Cloud SQL
C. Create a SQL Server external replica promotion migration into Cloud SQL
D. Save Backup folders of the SQL Server Databases to Cloud Storage with gsutil rsync with hourly update procs to Cloud SQL
E. Save Backup folders of the MySQL Databases to Cloud Storage with gsutil rsync with daily update procs to Cloud SQL
Correct Answers: B and D
For MySQL Database it is possible to create a Cloud SQL read replica of a local DB. The Cloud SQL read replica is asynchronously synchronized and may be promoted to master DB. An easy and elegant solution.
With SQL Server it is not possible; Cloud SQL read replicas for SQL Server are not supported so the traditional way (incremental backups and transaction logs) have to be followed
- Option A is incorrect because don’t ensure RPO and RTO requirements
- Option C is incorrect because Cloud SQL read replicas for SQL Server are not supported
- Option E is incorrect because Cloud SQL read replicas for MySQL are supported
For any further detail:
- https://cloud.google.com/architecture/dr-scenarios-for-data
- https://cloud.google.com/architecture/disaster-recovery-for-microsoft-sql-server
- https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets
- https://cloud.google.com/architecture/migrating-mysql-to-cloudsql-concept#external_replica_promotion_migration
Comments are closed, but trackbacks and pingbacks are open.