You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?

• A.For the application server, set up a service account.
• B.For each application code, set up a dedicated user account.
• C.For each application code, set up a common shared user account.
• D.For the application server, set up a common shared user account.

Comment: *

Name: *

Email: *

Verification: *

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?

• A.Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
• B.Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
• C.Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
• D.Set up different organizations for each database type, and apply policy constraints at the organization level.

Comment: *

Name: *

Email: *

Verification: *

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

• A.If the corruption is significant, use backup and restore, and specify a recovery timestamp.
• B.If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
• C.If the corruption is significant, use import and export.
• D.If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
• E.If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

Comment: *

Name: *

Email: *

Verification: *

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

• A.Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
• B.Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
• C.Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
• D.Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

Comment: *

Name: *

Email: *

Verification: *

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

• A.Use external server replication.
• B.Use Data Migration Service.
• C.Use Cloud SQL for MySQL external replica.
• D.Use the mysqldump utility and binary logs.

Comment: *

Name: *

Email: *

Verification: *