Google certification preparation
CLOUD-DATABASE-ENGINEER Practice Questions
Practice exam-style questions, check your answers, and review explanations and source references where they are available.
- Exam
- CLOUD-DATABASE-ENGINEER
- Provider
- Full set
- 141 questions
- Last Update Check
Here you can practice CLOUD-DATABASE-ENGINEER exam questions for free. We provide these free CLOUD-DATABASE-ENGINEER sample questions to everyone, including detailed answer explanations. These CLOUD-DATABASE-ENGINEER practice questions will undoubtedly assist you in preparing for the actual exam. Optionally, you can get our premium files for extra help, alongside the huge number of practice questions in our free CLOUD-DATABASE-ENGINEER question bank.
Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every
new application change is rolled out, the environment is torn down and recreated, and the persistent
database layer is lost. You need to prevent the database from being dropped. What should you do?
Question 1 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Your company is developing a new global transactional application that must be ACID-compliant and
have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to
serve as a datastore for this new application. What should you do?
Question 2 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
You are designing a database strategy for a new web application. You plan to start with a small pilot
in one country and eventually expand to millions of users in a global audience. You need to ensure
that the application can run 24/7 with minimal downtime for maintenance. What should you do?
Question 3 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real
time; however, the additional analytics caused excessive load on the primary database. You created a
read replica for the analytics workloads, but now your users are complaining about the lag in data
changes and that their reports are still slow. You need to improve the report performance and
shorten the lag in data replication without making changes to the current reports. Which two
approaches should you implement? (Choose two.)
Question 4 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance
to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What
should you do? (Choose two.)
Question 5 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
You host an application in Google Cloud. The application is located in a single region and uses Cloud
SQL for transactional dat
a. Most of your users are located in the same time zone and expect the application to be available 7
days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud
SQL instance without creating downtime for your users. What should you do?
Question 6 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the
daily export of a table, which was previously a cron job running on the database server, continues.
You want the solution to minimize cost and operations overhead. What should you do?
Question 7 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental
backups are expensive and add maintenance overhead. You want to follow Google-recommended
practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What
should you do?
Question 8 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
You want to migrate an existing on-premises application to Google Cloud. Your application supports
semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second
from manufacturing plants. You need to make this data available for real-time monitoring and
analysis. What should you do?
Question 9 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to
replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to
ensure that replication is fast and reliable and uses Google-managed services. What should you do?
Question 10 discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Question 1 of 10
Source context
How this practice set is maintained
Maintained by the CertMage content team, this page loads questions from the exam dataset connected to its preparation resource. When an answer includes a supporting reference, it is shown with that answer so you can review the underlying vendor documentation.
Certification objectives, interfaces, and vendor services can change. Verify important details against the provider's current exam guide and documentation before your exam.