1.4 Evaluate Appropriate Database Solutions on Google Cloud PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A company is choosing between Cloud SQL for PostgreSQL and a self-managed PostgreSQL on Compute Engine for a new application. The workload is predictable and the team has limited database administration experience. Which factor is most important in this decision?

   • AThe scalability of the database solution
   • BThe cost of the Compute Engine VM and Cloud SQL instances
   • CThe operational overhead of managing the database
   • DThe availability of the database solution
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   An application performs many read operations that join data from multiple tables. Which database feature is most important to evaluate when selecting a database?

   • ASupport for complex SQL queries and indexing
   • BSupport for flexible schemas
   • CSupport for vector similarity search
   • DSupport for eventual consistency
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   An organization has a policy that all database backups must be encrypted with customer-managed keys. Which database feature is required to comply with this policy?

   • APoint-in-time recovery
   • BCustomer-managed encryption keys (CMEK)
   • CAutomatic failover
   • DRead replicas
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A media company is building a recommendation engine. The data includes user profiles, viewing history, and item metadata. The application needs to query 'find items similar to this item' using vector embeddings of content. The team also needs to store user preferences as key-value pairs for fast retrieval. Which database solution should they choose?

   • AUse Cloud SQL for MySQL for user preferences and a separate Redis instance for item embeddings
   • BUse Firestore for user preferences and AlloyDB with the vector extension for item embeddings
   • CUse Cloud Spanner for all data, storing vectors as BYTES and performing similarity search in the application
   • DUse BigQuery for both user preferences and item embeddings, with a scheduled query for similarity
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   A financial application must ensure that all database changes are recorded for audit purposes. Which database feature is essential?

   • AIn-memory caching
   • BRead replicas
   • CAudit logging
   • DAutomatic failover
   Reveal Solution Discussion Select an answer first