20:00

PDF|

Guide for Google Professional Cloud Database Engineer

Quiz Google Professional Cloud Database Engineer

Free Test
/ 10

Quiz

1/10
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?
Select the answer
1 correct answer
A.
Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
B.
Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
C.
Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
D.
Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.

Quiz

2/10
Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)
Select the answer
2 correct answers
A.
Set up manual backups.
B.
Create a PostgreSQL database on-premises as the HA option.
C.
Configure single zone availability for automated backups.
D.
Enable point-in-time recovery.
E.
Schedule automated backups.

Quiz

3/10
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
Select the answer
1 correct answer
A.
Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
B.
Migrate applications and Oracle databases to Compute Engine.
C.
Migrate applications to Cloud SQL.
D.
Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).

Quiz

4/10
Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?
Select the answer
1 correct answer
A.
Use query parameters to speed up frequently executed queries.
B.
Change the Cloud Spanner configuration from multi-region to single region.
C.
Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
D.
Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

Quiz

5/10
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?
Select the answer
1 correct answer
A.
Use Database Migration Service to migrate all databases to Cloud SQL.
B.
Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
C.
Use data replication tools and CDC tools to enable migration.
D.
Use a combination of Database Migration Service and partner tools to support the data migration strategy.

Quiz

6/10
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
Select the answer
1 correct answer
A.
Setup a static external IP address in your VPC network.
B.
Set up bring your own IP (BYOIP) in your VPC.
C.
Set up a Cloud NAT gateway on the Compute Engine VM.
D.
Set up Cloud NAT service.

Quiz

7/10
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?
Select the answer
1 correct answer
A.
Use Logs Explorer to analyze log data.
B.
Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
C.
Use Error Reporting to count, analyze, and aggregate the data.
D.
Use Cloud Debugger to inspect the state of an application.

Quiz

8/10
You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?
Select the answer
1 correct answer
A.
Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
B.
Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
C.
Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
D.
Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.

Quiz

9/10
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?
Select the answer
1 correct answer
A.
Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
B.
Create your database with one primary node and one read replica in the region.
C.
Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
D.
Configure your Cloud SQL instance with high availability enabled.

Quiz

10/10
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?
Select the answer
1 correct answer
A.
Identify and optimize slow running queries, or set parallel replication flags.
B.
Stop all running queries, and re-create the replicas.
C.
Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
D.
Edit the primary instance to add additional memory.
Looking for more questions?Buy now

Google Professional Cloud Database Engineer Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Google Professional Cloud Database Engineer practice test! Further deepen your knowledge on Google Simulator; by unlocking the full version of our Google Professional Cloud Database Engineer Simulator you will be able to take tests with over 132 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 132 questions.

BUY NOW

What to expect from our Google Professional Cloud Database Engineer practice tests and how to prepare for any exam?

The Google Professional Cloud Database Engineer Simulator Practice Tests are part of the Google Database and are the best way to prepare for any Google Professional Cloud Database Engineer exam. The Google Professional Cloud Database Engineer practice tests consist of 132 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Google Professional Cloud Database Engineer database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Google Professional Cloud Database Engineer Simulator will also give you an idea of the time it will take to complete each section of the Google Professional Cloud Database Engineer practice test . It is important to note that the Google Professional Cloud Database Engineer Simulator does not replace the classic Google Professional Cloud Database Engineer study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Google Professional Cloud Database Engineer exam.

BUY NOW

Google Professional Cloud Database Engineer Practice test therefore represents an excellent tool to prepare for the actual exam together with our Google practice test . Our Google Professional Cloud Database Engineer Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Google Professional Cloud Database Engineer Simulator and how our unique Google Professional Cloud Database Engineer Database made up of real questions:

Info quiz:

  • Quiz name:Google Professional Cloud Database Engineer
  • Total number of questions:132
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Google Professional Cloud Database Engineer exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Google Professional Cloud Database Engineer Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Google Professional Cloud Database Engineer Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Google Professional Cloud Database Engineer practice tests which consist of 132 questions and also provide study material to pass the final Google Professional Cloud Database Engineer exam with guaranteed success. Our Google Professional Cloud Database Engineer database contain hundreds of questions and Google Tests related to Google Professional Cloud Database Engineer Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW