CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Google
  5. PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Braindumps (page: 10)

Page 10 of 34
PDF with 132 Questions

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out.
What should you do?

  1. Close idle connections or restart the instance before beginning the import operation.
  2. Increase the amount of memory allocated to your instance.
  3. Ensure that the service account has the Storage Admin role.
  4. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

Answer(s): A

Explanation:

https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting



You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases.
What should you do?

  1. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
  2. Set up Serverless VPC Access.
  3. Set up Private Service Connect.
  4. Set up Traffic Director.

Answer(s): A

Explanation:

https://medium.com/google-cloud/shared-vpc-in-google-cloud- 64527e0a409e#:~:text=Unlike%20VPC%20peering%2C%20Shared%20VPC%20connects%20projects

%20within%20the%20same%20organization.&text=There%20are%20a%20lot%20of,between%20VP Cs%20in%20different%20projects.



You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices.
What should you do?

  1. Use Cloud Functions to run the export in Avro format.
  2. Use Cloud Functions to run the export in text format.
  3. Use Dataflow to run the export in Avro format.
  4. Use Dataflow to run the export in text format.

Answer(s): C

Explanation:

https://cloud.google.com/spanner/docs/import-export-overview#file-format



You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency.
What should you do?

  1. Configure Firestore, and modify your application to offload queries.
  2. Configure Bigtable, and modify your application to offload queries.
  3. Configure Cloud SQL for PostgreSQL read replicas to offload queries.
  4. Configure Memorystore, and modify your application to offload queries.

Answer(s): D

Explanation:

"sub-millisecond latency" always involves Memorystore. Furthermore, as we are talking about a relational DB (Cloud SQL), BigTable is not a solution to be considered.



Page 10 of 34



Post your Comments and Discuss Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam with other Community members:

muksgreen commented on March 01, 2024
brainstorming excellent
JAPAN
upvote