ExamGecko
Ask Question

Google Professional Cloud Database Engineer Practice Test - Questions Answers, Page 3

Add to Whishlist

List of questions

Question 21

Report Export Collapse

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?

Setup a static external IP address in your VPC network.
Setup a static external IP address in your VPC network.
Set up bring your own IP (BYOIP) in your VPC.
Set up bring your own IP (BYOIP) in your VPC.
Set up a Cloud NAT gateway on the Compute Engine VM.
Set up a Cloud NAT gateway on the Compute Engine VM.
Set up Cloud NAT service.
Set up Cloud NAT service.
Suggested answer: C
Explanation:

https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-nat The docs specifically says 'Setting up a NAT gateway on a Compute Engine VM' is the way to give BMS internet access.

asked 18/09/2024
Nelson Mira
50 questions

Question 22

Report Export Collapse

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?

Use Logs Explorer to analyze log data.
Use Logs Explorer to analyze log data.
Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
Use Error Reporting to count, analyze, and aggregate the data.
Use Error Reporting to count, analyze, and aggregate the data.
Use Cloud Debugger to inspect the state of an application.
Use Cloud Debugger to inspect the state of an application.
Suggested answer: B
Explanation:

https://cloud.google.com/sql/docs/mysql/diagnose-issues#:~:text=If%20your%20instance%20stops%20responding%20to%20connections%20or%20performance%20is%20degraded%2C%20make%20sure%20it%20conforms%20to%20the%20Operational%20Guidelines

asked 18/09/2024
Rick James
47 questions

Question 23

Report Export Collapse

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?

Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
Suggested answer: B
asked 18/09/2024
Md. Soyaeb Hossain
44 questions

Question 24

Report Export Collapse

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?

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.
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.
Create your database with one primary node and one read replica in the region.
Create your database with one primary node and one read replica in the region.
Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
Configure your Cloud SQL instance with high availability enabled.
Configure your Cloud SQL instance with high availability enabled.
Suggested answer: A
Explanation:

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.

asked 18/09/2024
Nguyen Tan Hung
55 questions

Question 25

Report Export Collapse

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?

Identify and optimize slow running queries, or set parallel replication flags.
Identify and optimize slow running queries, or set parallel replication flags.
Stop all running queries, and re-create the replicas.
Stop all running queries, and re-create the replicas.
Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
Edit the primary instance to add additional memory.
Edit the primary instance to add additional memory.
Suggested answer: A
Explanation:

https://cloud.google.com/sql/docs/mysql/replication/replication-lag#optimize_queries_and_schema

asked 18/09/2024
Jyoti Gupta
47 questions

Question 26

Report Export Collapse

Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:

Person A is a database administrator.

Person B is an analyst who generates metric reports.

Application C is responsible for automatic backups.

You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

Become a Premium Member for full access
  Unlock Premium Member

Question 27

Report Export Collapse

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?


Become a Premium Member for full access
  Unlock Premium Member

Question 28

Report Export Collapse

You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 29

Report Export Collapse

Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 30

Report Export Collapse

Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member
Total 132 questions
Go to page: of 14
Search

Related questions