最新的Google Professional-Cloud-Database-Engineer免費考試真題

問題1

Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

A. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

B. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

C. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

D. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

正確答案: D

問題2

You have a Cloud SQL for MySQL instance with a table of product information including a column of product descriptions. Your application development team is building a customer facing chatbot and would like to find the product that most closely matches a freeform text description provided by the customer. How should you enable this functionality-

A. Use the LIKEoperator to match the customer's search text to the product description and return similar rows.

B. Create a SQL script that compares the product description and the customer's search text by using the SOUNDEXfunction.

C. Create a stored procedure that uses a regular expression to match the customer's search text to values in the product description column.

D. Create and populate a column of product description embeddings on the product table and perform an approximate nearest neighbor search using the customer's search text.

正確答案: D

說明：（僅 Fast2test 成員可見）

問題3

You are using Memorystore for Redis to cache frequently accessed data and improve your application's performance. Recently, your application is experiencing sudden spikes in latency when interacting with the Memorystore for Redis instance. Upon checking the logs, you discover a high number of "evicted keys" messages. You want to reduce the occurrences of latency spikes and their impact on the application. What should you do-

A. Redeploy your application to the same zone as the Memorystore instance.

B. Enable read replicas. Deploy additional read replica instances to distribute read workloads.

C. Increase the time to live (TTL) value of all the keys within the cache.

D. Scale the Memorystore instance to a larger memory size.

正確答案: D

說明：（僅 Fast2test 成員可見）

問題4

Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data. What should you do?

A. Use VPC Service Controls to create a trusted network for the Bigtable service.

B. Use Google Cloud Armor to add IP addresses to an allowlist.

C. Use customer-managed encryption keys (CMEK).

D. Use Identity and Access Management (IAM) for Bigtable access control.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題5

You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL- compliant database. What should you do?

A. Use Cloud SQL for PostgreSQL with cross-region replicas.

B. Use Cloud Spanner with multi-region configuration.

C. Use Bigtable with multi-region clusters.

D. Use Memorystore for Redis with multi-zones within a region.

正確答案: A

問題6

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?

A. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

B. Ensure that the service account has the Storage Admin role.

C. Close idle connections or restart the instance before beginning the import operation.

D. Increase the amount of memory allocated to your instance.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題7

You have an application that performs numerous reads and writes all day running in a single Bigtable cluster. A new batch analytics job needs to read the same data and you want to make sure that the new job does not affect the existing workload. What should you do-

A. Add a new cluster to the existing instance, and isolate the workloads with two app profiles.

B. Add a new cluster to the existing instance, and enable multi-cluster routing in the app profile.

C. Scale up the Bigtable instance by enabling Autoscaling.

D. Scale up the Bigtable instance by manually adding more nodes.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題8

Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

A. Migrate the Oracle databases to Cloud Spanner.

B. Migrate the Oracle databases to Compute Engine.

C. Migrate the Oracle databases to Cloud SQL.

D. Migrate the Oracle databases to Bare Metal Solution for Oracle.

正確答案: D

說明：（僅 Fast2test 成員可見）

問題9

You run a toy sales ecommerce application on Spanner. The application contains details about the various product listings such as name, category, description, and review(s). Your leadership wants to enable customers to ask free-form questions about the product catalog. You want to implement this functionality in the easiest, quickest, and least expensive way possible.
What should you do?

A. Generate vector embeddings for product information in Spanner. Find the vector with the smallest distance between the users' query and existing product information or review by using the EUCLIDEAN_DISTANCE()function in Spanner. Return the closest product information or review.

B. Create, train and deploy a custom ML model(s). Fetch toy details from Spanner and invoke ML predictions from the application layer to return the response.

C. Register an existing Generative AI Vertex model in Spanner. Use the ML.PREDICTfunction to supply the model with a user query along with the product information in a SQL query. Return the response back to the application.

D. Create a Spanner full-text search index. Find the product information or review against the user's question in a SQL query. Return the response back to the application.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題10

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

A. Create a read replica.

B. Use point-in-time-recovery (PITR) to recover the database.

C. Set Terraform deletion_protection to true.

D. Rerun terraform apply.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題11

You are migrating your on-premises PostgreSQL database to Spanner. You need to identify a solution for handling existing integer-based table primary keys. You want minimal changes to the applications while also following Google-recommended practices. What should you do-

A. Generate values by using BIT_REVERSED_POSITIVEsequences.

B. Use application generated sequential integer values as primary keys.

C. Use a UUID function that generates UUID Version 4 values as primary keys.

D. Update default primary key values to max(primary_key) + 1.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題12

Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

A. Use replication to roll out changes to higher environments.

B. Use backup and restore to roll out changes to higher environments.

C. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

D. Use Liquibase to roll out changes to higher environments.

正確答案: D

說明：（僅 Fast2test 成員可見）

問題13

You are working on a new centralized inventory management system to track items available in
200 stores, which each have 500 GB of data. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays.
What should you do?

A. Use a Biglable cluster with autoscaling.

B. Use Cloud Spanner with a custom autoscaling solution.

C. Use sharded Cloud SQL instances with one or more stores per database instance.

D. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.

正確答案: B

說明：（僅 Fast2test 成員可見）

最新的Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer免費考試真題

聯系我們

站內鏈接

最新更新