Q: 1
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have
additional traffic due to the holiday weekend. You want to follow Google-recommended practices to
set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of
potential issues. What should you do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 2
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in
database performance. You need to identify the root cause of the performance degradation. What
should you do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 3
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are
planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You
want to follow Google-recommended practices and use Google native data migration tools. You also
want to closely monitor the migrations as part of the cutover strategy. What should you do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 4
You are choosing a new database backend for an existing application. The current database is running
PostgreSQL on an on-premises VM and is managed by a database administrator and operations
team. The application data is relational and has light traffic. You want to minimize costs and the
migration effort for this application. What should you do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 5
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database
must be able to withstand a zonal failure with less than five minutes of downtime and still not lose
any transactions. You want to follow Google-recommended practices for the migration. What should
you do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 6
Your company is evaluating Google Cloud database options for a mission-critical global payments
gateway application. The application must be available 24/7 to users worldwide, horizontally
scalable, and support open source databases. You need to select an automatically shardable, fully
managed database with 99.999% availability and strong transactional consistency. What should you
do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 7
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available
24/7. You need to save database backups on object storage with minimal operational overhead or
risk to your production workloads. What should you do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 8
You are designing a new gaming application that uses a highly transactional relational database to
store player authentication and inventory data in Google Cloud. You want to launch the game in
multiple regions. What should you do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 9
You are the DBA of your organization. You provided a cloned instance from the production Cloud SQL
for PostSQL database to the developers for testing purposes. After the creation of the clone. Your
developers notice missing data in one of the recently altered tables. What should you do to ensure
that all data in included?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 10
You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-
dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP
address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-
effective way. What should you do?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Question 1 of 20 · Page 1 / 2