How to pass Google Professional-Cloud-Database-Engineer exam with the help of dumps?

Question # 1

You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do? 

A. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name. 
B. Check whether your service account has cloudsql.instances.connect permission. 
C. Enable the Cloud SQL Admin API. 
D. Ensure that you are using an external (public) IP address interface.

Show Answer

Question # 2

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do? 

A. Use Cloud SQL with cross-region replicas. 
B. Use high availability (HA) Cloud SQL with multiple zones. 
C. Use zonal Cloud SQL without high availability (HA). 
D. Use Cloud Spanner in a regional configuration. 

Show Answer

Question # 3

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

 A. Set the automated backups to occur every other day to lower the frequency of backups. 
B. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD). 
C. Select a different region to store your backups. 
D. Reduce the number of automated backups that are retained to two (2). 

Show Answer

Question # 4

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? 

A. Use Cloud Scheduler and Cloud Functions to run the daily export. 
B. Create a streaming Datatlow job to export the table. 
C. Set up Cloud Composer, and create a task to export the table daily. 
D. Run the cron job on a Compute Engine instance to continue the export. 

Show Answer

Question # 5

You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do? 

A. Disable and remove the internal IP address assignment. 
B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access. 
C. Specify an authorized network with the CIDR range of the VM.
 D. Disable and remove the external IP address assignment. 

Show Answer

Question # 6

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?

 A. Use Cloud Spanner to deploy the database. 
B. Use Bigtable with clusters in multiple regions to deploy the database 
C. Use BigQuery to deploy the database 
D. Use Cloud SQL with a regional read replica to deploy the database.

Show Answer

Question # 7

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? 

A. Maintain a target of 23% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone europe-west1-d cluster-c in zone asia-east1-b 
B. Maintain a target of 23% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone us-central1-b cluster-c in zone us-east1-a 
C. Maintain a target of 35% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone australia-southeast1-a cluster-c in zone europe-west1-d cluster-d in zone asia-east1-b 
D. Maintain a target of 35% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone us-central2-a cluster-c in zone asia-northeast1-b cluster-d in zone asia-east1-b 

Show Answer

Question # 8

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do? 

A. Take no backups, and turn off transaction log retention. 
B. Take one manual backup per day, and turn off transaction log retention.
 C. Turn on automated backup, and turn off transaction log retention. 
D. Turn on automated backup, and turn on transaction log retention. 

Show Answer

Question # 9

You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do? 

A. Create your instance with a specified external (public) IP address. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance. Use Cloud SQL Auth proxy to connect to the instance. 
B. Create your instance with a specified external (public) IP address. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance. Connect to the instance using a connection pool to best manage connections to the instance. 
C. Create your instance with a specified internal (private) IP address. Choose the VPC with private service connection configured. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance. Use Cloud SQL Auth proxy to connect to the instance. 
D. Create your instance with a specified internal (private) IP address. Choose the VPC with private service connection configured. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance. Connect to the instance using a connection pool to best manage connections to the instance. 

Show Answer

Question # 10

You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do? 

A. Set up a Shared VPC, configure multiple service projects, and create firewall rules. 
B. Set up Serverless VPC Access. 
C. Set up Private Service Connect. 
D. Set up Traffic Director. 

Show Answer

Question # 11

Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do? 

A. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption. 
B. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance. 
C. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted. 
D. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption. 

Show Answer

Question # 12

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 Googlerecommended 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? 

A. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts. 
B. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels. 
C. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
 D. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels. 

Show Answer

Question # 13

Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do? 

A. Use Firestore with Looker. 
B. Use Cloud Spanner with Data Studio. 
C. Use MongoD8 Atlas with Charts. 
D. Use Bigtable with Looker. 

Show Answer

Question # 14

Your company uses Bigtable for a user-facing application that displays a low-latency real time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do? 

A. Recommend solid-state drives (SSD). 
B. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads. 
C. Recommend hard disk drives (HDD). 
D. Recommend mixed storage types. 

Show Answer

Question # 15

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? 

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). 

Show Answer

Question # 16

You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do? 

A. Reuse the existing service account that populates this database. 
B. Create a new service account, and grant it the Cloud Spanner Database Admin role. 
C. Create a new service account, and grant it the Cloud Spanner Database Reader role. 
D. Create a new service account, and grant it the spanner.databases.select permission. 

Show Answer

Question # 17

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do? 

A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1. 
B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in useast1 and us-west1.
C. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1. 
D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in uscentral1, us-east1 and us-west1. 

Show Answer

Question # 18

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? 

A. Place the bulk of the read and write workloads closer to the default leader region. 
B. Use staleness of at least 15 seconds. C. Add more read-write replicas. 
D. Keep the total CPU utilization under 45% in each region. 

Show Answer

Question # 19

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 Googlerecommended practices. You need the database to be performant and highly available while you keep costs low. What should you do? 

A. Manually scale down the number of nodes after the peak period has passed. 
B. Use interleaving to co-locate parent and child rows.
 C. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query. 
D. Use granular instance sizing in Cloud Spanner and Autoscaler. 

Show Answer

Question # 20

You plan to use Database Migration Service to migrate data from a PostgreSQL onpremises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

 A. Drop or disable all users except database administration users. 
B. Disable all foreign key constraints on the source PostgreSQL database. 
C. Ensure that all PostgreSQL tables have a primary key. 
D. Shut down the database before the Data Migration Service task is started. 
E. Ensure that pglogical is installed on the source PostgreSQL database. 

Show Answer

Question # 21

You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an ondemand backup. You want to verify the status of the backup. What should you do?

 A. Check the cloudsql.googleapis.com/postgres.log instance log. 
B. Perform the gcloud sql operations list command. 
C. Use Cloud Audit Logs to verify the status. 
D. Use the Google Cloud Console. 

Show Answer

Question # 22

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? 

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. 

Show Answer

Question # 23

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do? 

A. Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Keep backups older than one day stored in Actifio OnVault storage. 
B. Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Keep backups older than one day stored in Actifio OnVault storage. 
C. Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket. 
D. Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket. 

Show Answer

Question # 24

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do? 

A. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD). 
B. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD. 
C. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD. 

Show Answer

Question # 25

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? 

A. Use Cloud Spanner in a regional configuration. 
B. Use Cloud Spanner in a multi-region configuration. 
C. Use Cloud SQL with cross-region replicas. 
D. Use highly available Cloud SQL with multiple zones. 

Show Answer

Question # 26

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? 

A. Configure the automated backups to use a regional Cloud Storage bucket as a custom location. 
B. Use the default configuration for the automated backups location. 
C. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket. 
D. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket. 

Show Answer