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: 18)

Page 18 of 34
PDF with 132 Questions

Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data.
You want to design a multi-tenancy strategy to efficiently manage costs and operations.
What should you do?

  1. Apply a schema data management pattern.
  2. Apply an instance data management pattern.
  3. Apply a table data management pattern.
  4. Apply a database data management pattern.

Answer(s): B

Explanation:

https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner#multi-tenancy- data-management-patterns https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner



You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency.
What should you do?

  1. Use linear scaling to implement the Autoscaler-based architecture
  2. Use direct scaling to implement the Autoscaler-based architecture.
  3. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
  4. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

Answer(s): A

Explanation:

Linear scaling is best used with load patterns that change more gradually or have a few large peaks. The method calculates the minimum number of nodes or processing units required to keep utilization below the scaling threshold. The number of nodes or processing units added or removed in each scaling event is not limited to a fixed step amount. https://cloud.google.com/spanner/docs/autoscaling-overview#linear



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?

  1. 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.
  2. 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.
  3. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
  4. 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.

Answer(s): B

Explanation:

"Read replicas do not have the cloudsql.iam_authentication flag enabled automatically when it is enabled on the primary instance." https://cloud.google.com/sql/docs/postgres/replication/create- replica#configure_iam_replicas



Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue.
What should you do?

  1. Isolate the data analysts and operations user groups to use different Bigtable instances.
  2. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
  3. Use Key Visualizer for Bigtable.
  4. Add more nodes to the Bigtable cluster.

Answer(s): C

Explanation:

https://cloud.google.com/bigtable/docs/performance#troubleshooting



Page 18 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