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 Nov. 08, 2024 (see below)
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?
You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat
a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. 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
German
2 days agoBerry
4 days agoMaybelle
8 days agoLinn
18 days agoShayne
20 days agoDenise
1 months agoAntione
1 months agoJulie
1 months agoNathan
2 months agoKati
2 months agoLynelle
2 months agoStephen
2 months agoMelina
2 months agoPete
3 months agoSabine
4 months agoJamal
4 months agoLai
5 months agoAlpha
5 months agoDesiree
5 months agoReyes
5 months agoHelga
5 months agoAnnmarie
5 months ago