1.3 Determine How Applications Will Connect to the Database PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A company runs a batch job that opens a new connection to Cloud SQL for PostgreSQL for each of 10,000 records it processes. The job is slow and the database CPU is high. The team wants to improve performance without changing the job's logic. What should they do?

   • AIncrease the database's max_connections parameter.
   • BUse the Cloud SQL Auth Proxy to handle connections.
   • CUse a connection pooler like PgBouncer to reuse connections.
   • DSwitch to a larger machine type for the database.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is a potential trade-off of using connection pooling?

   • AIt increases the number of database connections required.
   • BIt reduces database security.
   • CIt requires more storage for the database.
   • DIt adds complexity to the application architecture.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   What is the purpose of key rotation in Cloud KMS?

   • ATo change the encryption algorithm used for data at rest.
   • BTo make the key unreadable by any user.
   • CTo periodically generate a new key version to limit the impact of a key compromise.
   • DTo automatically encrypt data in transit.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A startup runs a web application on Google Kubernetes Engine (GKE) that connects to a Cloud SQL for PostgreSQL instance. The application experiences connection errors when traffic spikes because the database reaches its maximum connection limit. The team wants to reduce the number of connections from the application without changing the application code. What should they do?

   • ADeploy a sidecar container running the Cloud SQL Auth Proxy alongside the application pods.
   • BIncrease the database's max_connections parameter to a higher value.
   • CUse a Cloud SQL Auth Proxy with connection pooling enabled.
   • DDeploy a connection pooler like PgBouncer in front of the database and configure the application to connect to the pooler.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   Which connectivity option allows an on-premises application to securely reach a Cloud SQL instance over a dedicated, low-latency connection without traversing the public internet?

   • ACloud Load Balancing
   • BCloud Interconnect
   • CCloud CDN
   • DCloud NAT
   Reveal Solution Discussion Select an answer first