GCP professional database engineer practice test

This free practice exam covers all the required topics as per the professional cloud database engineer exam guide

Welcome to your gcpprofessionaldatabaseengineer

Q1.You have a microservice responsible for managing customer accounts and orders. Strong consistency, ACID transactions, and strong schemas are all important. What type of database would you use?

A.NoSQL

B. Document

C.Object

D.Relational

Q2.As a senior database engineer in your organisation, you have been tasked with deploying an application for high availability and have created web servers in multiple zones in a region. What should you do for the database to also be highly available?

A.Create a failover replica in another region.

B.Create a read replica in another region.

C.Create a failover replica in another zone

D.Replicate the database on each of the web servers.

Q3.You have a SQL Server database running on a Windows server on-premises. You want to move it to the cloud as quickly as possible with minimal changes, and the database must continue to run on a Windows server. You should run the database using which service below?

A. Cloud SQL.

B.Spanner

C.Kubernetes.

D.Compute Engine.

Q4.You are a Database engineer who has been hired by an offshore oil drilling company to help with their migration to the cloud. They have a heavy investment in Oracle and want to move their existing Oracle databases to Google Cloud. What is your advice to them?

A.Run Oracle in virtual machines on Compute Engine.

B.Run Oracle using Bare Metal Solution.

C.Use Cloud SQL for Oracle as a managed database solution.

D.Use the Oracle on Spanner migration toolkit.

Q5.You are creating a budgeting application to sell to customers. Customers will run it on the public cloud of their choice – either Google Cloud, Azure, or AWS. Some customers may even want to run the application on-premises. What would be the best deployment choice for the database?

A.Cloud SQL.

B.Compute Engine.

C. Spanner

D. Kubernetes.

Q6.You need to deploy an application to Google Cloud. The database is relatively small, and only one application uses it. It is not mission-critical, so some downtime can be tolerated. Which migration approach should you use?

A.Continuous replication.

B.Data access microservice.

C.Scheduled maintenance.

D.Split reading and writing

Q7.What are the four steps in Google’s cloud migration methodology?

A. Requirements Gathering, Analysis, Program, Test.

B. Assess, Plan, Deploy, Optimize.

C.Program, Deploy, Fix, Repeat

D. Manage, Engineer, Develop, Test.

Q8.You’ve completed the migration of a large monolithic application and its database to Google Cloud. The database included web session management data, which you’ve decided to move to a separate microservice. Which managed database service would be easiest and cheapest to use to store the session data?

A.Spanner.

B. Firestore.

C.Bigtable.

D.BigQuery.

Q9.Your company handles data processing for a number of different clients. Each client prefers to use their own suite of analytics tools, with some allowing direct query access via Google BigQuery. You need to secure the data so that clients cannot see each other's data. You want to ensure appropriate access to the data. Which three steps should you take? (Choose three.)

A.Load data into a different dataset for each client

B. Put each client’s BigQuery dataset into a different table.

C.Restrict a client’s dataset to approved users.

D.Only allow a service account to access the datasets.

E.Use the appropriate identity and access management (IAM) roles for each client’s users.

Q10.Select the managed compute platform that lets you run stateless containers through web requests or Pub/Sub events

A.Cloud Run

B.Cloud Endpoints

C.Apigee API Management

D.Cloud Source Repositories

Q11.Why would you use Terraform instead of the Google Cloud Console to create network infrastructure?

A. All of the options.

B.Allows infrastructure to be created and destroyed automatically.

C.Easier to make changes over time.

D.Less prone to human error.

Q12.You are a database administrator at your firm and want to securely connect to databases in a private Google Cloud VPC. You want to allow them to directly connect from their workstation in their office using their Windows workstation. What should you do?

A.All of the options would work.

B.Set up a Cloud Interconnect direct connection from their network.

C.Give the database a public IP address, and create a firewall rule that allows them to connect to the server.

D.Set up a VPN between their network and the VPC.

Q13.You’ve created two Google Cloud VPCs, a public one for web servers and database clients, and a private one for the databases. You want to connect them to allow communication via private IP addresses. Which should you use?

A. Cloud Interconnect.

B. Cloud VPN.

C.VPC Peering.

D. Cloud Router.

Q14.Your company wants to move a large SQL Server database to Google Cloud. They currently run Enterprise edition with a failover cluster, and they want to replicate the database across multiple regions. They also want to integrate with their Active Directory for authentication. What would you recommend?

A.Deploy SQL Server using Compute Engine.

B.Deploy SQL Server using Kubernetes on GKE.

C.All of the options would work.

D.Deploy SQL Server using Cloud SQL.

Q15.A startup has a Cloud SQL instance serving production workloads. Previously, their customers have noticed non-availability issues during maintenance events. you want to minimize the impact of such maintenance issues in the future. What should you do as their database engineer? (Choose two)

A.Use connection pools.

B.Use exponential backoff.

C. Set the order of update to Later.

D. Remove the maintenance window.

E.Opt in to maintenance notifications.

Q16. You need to export a large Cloud SQL for PostgreSQL instance. The databases in the instance are used heavily in production, and export time is not a concern. You want to conduct the export operation without affecting the performance of the database. What should you do?

A. Use Datastream.

B.Use serverless export

C. Use Database Migration Service.

D.Use Cloud SQL in high availability (HA) mode.

Q17.As the DBA at your firm, You want to automate a recurring job that runs every night. The job needs to extract data from an on-premises database, copy it to Cloud Storage, and then run a Dataflow job to transform the data and load it into BigQuery. Which would be best?

A.Shell script written with gcloud storage.

B.Storage Transfer Service.

C.Cloud Composer.

D.Cloud Data Fusion.

Q18.Analysts in your company have raised concerns about performance and failed queries from the most recent being Saturday to Sunday. You look at the logs on Monday and discover nearly 50 "deadlock detected" errors. In the future, you want to take a more proactive approach to discovering database issues. What should you do?

A. Export the logs daily to BigQuery, and run a search for “deadlock detected” on the data.

B.Create a Cloud Monitoring metric with “deadlock detected” as the text payload, and set notifications based on it.

C. Create a Cloud Monitoring dashboard, and watch for any issues related to congestion that could indicate a deadlock.

D.Write a Cloud Function to poll the database logs for “deadlock detected” errors, and schedule the Cloud Function to run every hour on Cloud Scheduler.

Q19. You are building a mobile application that allows end users to upload images. These images need to go through a series of processing steps, including converting to black and white, cropping, and other editing. Your mobile application has a feature that allows end users to notify their followers when they edit images. You want to create a scalable solution with minimal effort and cost. What should you do?

A.Use Firebase and Compute Engine.

B.Use Cloud Spanner and Cloud Run.

C.Use Bigtable and Cloud Functions for Firebase.

D. Use Firebase and Cloud Functions for Firebase.

Q20.What is an advantage of Cloud SQL over Compute Engine for running SQL Server databases?

A.Automatic storage increases.

B. Supports all SQL Server features.

C.Runs on Windows or Linux servers.

D.All of the options.

Q21.You are the DBA at a tech startup that is building an application for learning foreign languages. The data schema for different language learning levels is different. Followers of a user are notified in real-time of progress made by the user. The application's users are also able to interact with each other; interactions may contain emojis, gifs, and voice notes. You want to use a database that supports flexible schema and real-time notifications. What should you do?

A.Use Firestore in Native mode.

B.Use Firestore in Datastore mode.

C.Use federated queries between Cloud SQL and BigQuery.

D.Use Cloud Spanner, and create interleaved rows with customers as root rows.