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

Questions 21–25

1. 21foundation · easy

   An application needs to store and query unstructured text documents with flexible schemas and support full-text search. Which type of database is most appropriate?

   • AA time-series database
   • BA NoSQL document database
   • CA graph database
   • DA relational database with a fixed schema
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A healthcare organization is deploying a new patient records system on Google Cloud. They must comply with data residency requirements that mandate all patient data remain within the European Union. The application requires a relational database with strong consistency. Which database solution should they choose?

   • AUse Cloud SQL for PostgreSQL in the europe-west1 region
   • BUse Cloud Spanner in the europe-west1 region with a multi-region configuration
   • CUse Firestore in the nam5 (United States) region
   • DUse BigQuery in the europe-west4 region for all patient data
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   A company's procurement policy requires that all new cloud services undergo a security review before approval. How does this policy affect database selection?

   • AIt may delay or restrict the use of database services that do not meet security standards
   • BIt has no effect on database selection
   • CIt only affects the cost of the database
   • DIt requires the use of a specific database vendor
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   An organization requires full control over the database operating system and kernel parameters for a specialized workload. Which database deployment approach provides the highest level of control?

   • ABare Metal Solution
   • BFirestore
   • CCloud SQL
   • DCloud Spanner
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A financial services company is migrating a legacy application from an on-premises Oracle database to Google Cloud. The application uses stored procedures, triggers, and complex SQL with Oracle-specific syntax. The team wants to minimize application changes and is evaluating Cloud SQL for PostgreSQL and Cloud Spanner. Which consideration is most important in this decision?

   • AThe cost of the database service in the long term
   • BThe scalability of the database service
   • CThe compatibility of the application's SQL and stored procedures with the target database
   • DThe availability of managed backups and high availability
   Reveal Solution Discussion Select an answer first