4.1 Integrating Applications with Data and Storage Services PROFESSIONAL-CLOUD-DEVELOPER Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   What is the primary purpose of connection pooling when an application connects to Cloud SQL?

   • ATo encrypt all data transmitted between the application and the database
   • BTo authenticate users before they can access the database
   • CTo reduce the number of database connections created and destroyed, improving performance and resource usage
   • DTo automatically scale the database instance based on load
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which Firestore query feature allows an application to receive updates whenever a document's data changes?

   • AComposite indexes
   • BReal-time listeners
   • CTransactions
   • DPagination
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   In a Pub/Sub pull subscription, what is the purpose of acknowledging a message?

   • ATo mark the message as a duplicate for deduplication
   • BTo indicate that the message has been successfully processed and can be removed from the subscription
   • CTo send the message to a dead-letter topic
   • DTo extend the message's acknowledgment deadline
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A retail company runs a Java application on Compute Engine that reads product inventory from Cloud SQL (PostgreSQL). The application experiences intermittent connection timeouts during peak traffic. The team wants to minimize connection overhead and improve resilience. What should they implement?

   • ACreate a new connection for each query and close it immediately after the query completes
   • BConfigure a connection pool with a reasonable maximum size, connection validation, and a retry mechanism for transient failures
   • CUse a connection pool with a maximum size equal to the database's max connections and a short idle timeout
   • DIncrease the database's max_connections setting to a very high value to accommodate all possible application connections
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Before an application can publish messages to a Pub/Sub topic, what must exist in the project?

   • AA topic
   • BA subscription
   • CA push endpoint
   • DA dead-letter queue
   Reveal Solution Discussion Select an answer first