Online Access Free Professional-Cloud-Database-Engineer Practice Test

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

• A.Identify all tables that do not have a primary key.
• B.Identify whether the source database uses customer-managed encryption keys (CMEK).
• C.Identify whether the source database is encrypted using pgcrypto extension.
• D.Identify whether the database has over 512 tables.
• E.Identity all tables that do not have at least one foreign key.

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 the mysqldump utility and binary logs.
• B.Use external server replication.
• C.Use Cloud SQL for MySQL external replica.
• D.Use Data Migration Service.

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?

• A.Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
• B.Use query parameters to speed up frequently executed queries.
• C.Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
• D.Change the Cloud Spanner configuration from multi-region to single region.

You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

• A.Disable and remove the internal IP address assignment.
• B.Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
• C.Specify an authorized network with the CIDR range of the VM.
• D.Disable and remove the external IP address assignment.

You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-effective way. What should you do?

• A.Connect by using the private IP address of the AlloyDB cluster directly from the application.
• B.Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.
• C.Connect by using AlloyDB Auth Proxy installed in the GKE cluster.
• D.Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.