Google Cloud Data Management Solutions CLOUD-DIGITAL-LEADER Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A company runs a legacy on-premises MySQL database that is critical to daily operations. They want to move to Google Cloud with minimal changes to their application code and database schema. Which migration approach should they use?

   • ARe-platform to Cloud Spanner
   • BLift-and-shift to Cloud SQL for MySQL
   • CMigrate to Firestore
   • DMove data to Cloud Storage
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   A company stores data that is accessed on average once every 90 days. Which Cloud Storage storage class is most appropriate?

   • AColdline
   • BArchive
   • CStandard
   • DNearline
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A company has a monolithic application that uses a single PostgreSQL database. They want to migrate to Google Cloud and are considering Cloud SQL. However, they anticipate significant growth and need to scale beyond the limits of a single database. They also want to minimize application changes. What should they do?

   • AUse Cloud Bigtable as a front-end cache
   • BMigrate directly to Cloud Spanner
   • CUse Cloud SQL with read replicas for scaling
   • DMigrate to Cloud SQL first, then re-architect to use Cloud Spanner when needed
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is a key benefit of BigQuery being a serverless data warehouse?

   • AIt requires you to provision and manage virtual machines to run queries.
   • BIt automatically manages infrastructure and scales resources based on query demand.
   • CIt only works with data stored in Google Cloud.
   • DIt is designed for transactional workloads with high write rates.
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A gaming company needs a leaderboard feature that updates in real-time as players score points. The data is simple key-value pairs (player ID to score) and must be highly available with low latency. They also want to run occasional analytics on the leaderboard data to understand player behavior. Which combination of products should they use?

   • ACloud Bigtable for real-time leaderboard and BigQuery for analytics
   • BCloud SQL for real-time leaderboard and Cloud Storage for analytics
   • CCloud Spanner for real-time leaderboard and Cloud SQL for analytics
   • DFirestore for real-time leaderboard and Cloud Bigtable for analytics
   Reveal Solution Discussion Select an answer first