最新のProfessional-Cloud-Database-Engineer問題集で試験を準備する

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?

• A. Add more nodes to the Bigtable cluster.
• B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
• C. Use Key Visualizer for Bigtable.
• D. Isolate the data analysts and operations user groups to use different Bigtable instances.

Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database.
What should you do?

• A. Recommend solid-state drives (SSD).
• B. Recommend mixed storage types.
• C. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
• D. Recommend hard disk drives (HDD).

You are designing a solution to implement a cache to track all the products which are browsed by users on an ecommerce website, using a key-value database. Your solution needs to have the ability to connect to the database from multiple VPC networks, while having a managed service, high throughput, low latency, strong security, and private communication. What should you do-

• A. Choose Bigtable and connect using Private Google Access API endpoint(s).
• B. Choose a Redis instance on a VM in the Shared VPC network.
• C. Choose Memorystore for Redis Cluster and Private Service Connect for networking connectivity.
• D. Choose a Memorystore for Redis instance and Private Service Access for networking connectivity.

At Nimbus Retail you manage a Cloud SQL for MySQL instance called reporting-sql-01. The team needs to export a full database to Cloud Storage and later import it back into the same instance using gcloud without doing any format conversion. Which command should you run to create the export so that it can be imported back into Cloud SQL?

• A. gcloud sql export csv reporting-sql-01 gs://example-bucket-42/retail_backup.sql.gz - database=analyticsdb -gzip
• B. gcloud sql import csv reporting-sql-01 gs://example-bucket-42/export.csv -database=analyticsdb - gzip
• C. gsutil cp gs://example-bucket-42/retail_backup.sql.gz | gcloud sql import sql reporting-sql-01 - database=analyticsdb -gzip
• D. gcloud sql export sql reporting-sql-01 gs://example-bucket-42/retail_backup.sql.gz - database=analyticsdb -gzip

You are planning connectivity for a global retail analytics service that runs in multiple Google Cloud regions and must reach a Cloud Spanner database with very low latency, strong security, and high reliability. Which connection approach should the application adopt to satisfy these requirements?

• A. Use the Cloud Spanner client libraries with a regional instance and enable connection pooling
• B. Access Cloud Spanner through the REST API from the app and add a cache layer to improve response time
• C. Connect to a fixed public IP address on the Cloud Spanner instance and enable SSL
• D. Use the Cloud Spanner client libraries against a multi-region instance and configure connection pooling