Free Preparation Discussions
MENU
Google Professional Cloud Database Engineer Exam Questions
- Topic 1: Evaluate performance and cost tradeoffs of different database configurations/ Plan database upgrades for Google Cloud-managed databases
- Topic 2: Provision high availability database solutions in Google Cloud/ Design scalable and highly available cloud database solutions
- Topic 3: Determine the correct database migration tools for a given scenario/ Size database compute and storage based on performance requirements
- Topic 4: Plan and perform database migration, including fallback plans and schema conversion/ Test high availability and disaster recovery strategies periodically
- Topic 5: Distinguish between SQL and NoSQL business requirements/ Evaluate tradeoffs between multi-region, region, and zonal database deployment strategies
- Topic 6: Apply concepts to implement highly scalable and available databases in Google Cloud/ Given a scenario, define maintenance windows and notifications based on application availability requirements
- Topic 7: Analyze relevant variables to perform database capacity and usage planning/ Design scalable, highly available, and secure databases
- Topic 8: Differentiate between managed and unmanaged database services/ Analyze the cost of running database solutions in Google Cloud
- Topic 9: Reverse replication from Google Cloud to source/ Evaluate appropriate database solutions on Google Cloud
- Topic 10: Manage database users, including authentication and access/ Continuously assess and optimize the cost of running a database solution
- Topic 11: Design for recovery time objective (RTO) and recovery point objective (RPO)/ Assess slow running queries and database locking and identify missing indexes
- Topic 12: Deploy scalable and highly available databases in Google Cloud/ Determine database connectivity and access management considerations
- Topic 13: Automate database instance provisioning/ Determine how applications will connect to the database
- Topic 14: Justify the use of session pooler services/ Given a scenario, perform solution sizing based on current environment workload metrics and future requirements
Free Google Professional Cloud Database Engineer Exam Actual Questions
Note: Premium Questions for Professional Cloud Database Engineer were last updated On Dec. 11, 2024 (see below)
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?
You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?
https://cloud.google.com/spanner/docs/instance-configurations#multi-region-best-practices Best practices For optimal performance, follow these best practices: Design a schema that prevents hotspots and other performance issues. For optimal write latency, place compute resources for write-heavy workloads within or close to the default leader region. For optimal read performance outside of the default leader region, use staleness of at least 15 seconds. To avoid single-region dependency for your workloads, place critical compute resources in at least two regions. A good option is to place them next to the two different read-write regions so that any single region outage will not impact all of your application. Provision enough compute capacity to keep high priority total CPU utilization under 45% in each region.
You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?
A. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.
You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?
https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups You can use a custom location for on-demand and automatic backups. For a complete list of valid location values, see the Instance locations.
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Jame
4 days agoGracie
5 days agoFelicitas
9 days agoDana
17 days agoTiara
20 days agoGerman
1 months agoBerry
1 months agoMaybelle
1 months agoLinn
2 months agoShayne
2 months agoDenise
2 months agoAntione
2 months agoJulie
2 months agoNathan
3 months agoKati
3 months agoLynelle
3 months agoStephen
3 months agoMelina
3 months agoPete
4 months agoSabine
5 months agoJamal
5 months agoLai
6 months agoAlpha
6 months agoDesiree
6 months agoReyes
6 months agoHelga
6 months agoAnnmarie
6 months ago