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?

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?

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?

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?

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?

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?

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

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?

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

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

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

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?

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?

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?

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)

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?

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?

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?

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?

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

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?

Leave a Comment