Free Professional Cloud Database Engineer Exam Professional-Cloud-Database-Engineer Exam Practice Test

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

• Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
• Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
• Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
• Create an external replica, and use Cloud SQL to synchronize the data to the replica.

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

• Create the database with Google-managed encryption keys.
• Create the database with customer-managed encryption keys.
• Create the database persistent disk with Google-managed encryption keys.
• Create the database persistent disk with customer-managed encryption keys.

Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

• Create secondary indexes on the replica.
• Create additional read replicas, and partition your analytics users to use different read replicas.
• Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.
• Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.
• Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?

• Check the cloudsql.googleapis.com/postgres.log instance log.
• Perform the gcloud sql operations list command.
• Use Cloud Audit Logs to verify the status.
• Use the Google Cloud Console.

You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?

• Create your instance with a specified external (public) IP address. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance. Use Cloud SQL Auth proxy to connect to the instance.
• Create your instance with a specified external (public) IP address. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance. Connect to the instance using a connection pool to best manage connections to the instance.
• Create your instance with a specified internal (private) IP address. Choose the VPC with private service connection configured. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance. Use Cloud SQL Auth proxy to connect to the instance.
• Create your instance with a specified internal (private) IP address. Choose the VPC with private service connection configured. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance. Connect to the instance using a connection pool to best manage connections to the instance.

You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)

• Use a change data capture (CDC) migration strategy.
• Move the physical database servers from on-premises to Google Cloud.
• Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
• Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
• Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

• Increase the number of processing units.
• Modify the database schema, and add additional indexes.
• Shard data required by the application into multiple instances.
• Decrease the number of processing units.

Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

• Use Firestore.
• Use Cloud Spanner.
• Use Cloud SQL.
• Use Bigtable.

You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?

• Migrate the existing database to Firestore.
• Migrate the existing database to Cloud SQL for PostgreSQL.
• Migrate the existing database to Cloud Spanner.
• Migrate the existing database to PostgreSQL running on Compute Engine.

You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?

• Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
• Check whether your service account has cloudsql.instances.connect permission.
• Enable the Cloud SQL Admin API.
• Ensure that you are using an external (public) IP address interface.