PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Questions
203 real PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam questions with expert-verified answers and explanations. Page 1 of 5.
- Question #1Migrating on-premises and self-managed databases to Google Cloud
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google- rec...
Database MigrationCloud SQLMySQL ReplicationMinimal Downtime - Question #2Designing and Implementing Cloud Database Solutions
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 rep...
IoT Data ManagementMulti-Cloud DatabasesNoSQL DatabasesDatabase Selection - Question #3Optimizing Cloud Database Performance
Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Clo...
Database ScalabilityMicroservices ArchitectureCloud SQLPerformance Optimization - Question #4Migrating Data Solutions
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region....
Cloud SQLData MigrationDatabase AdministrationPerformance Optimization - Question #5Optimizing Database Operations and Performance
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in...
Cloud SQLLoad BalancingRead ReplicasDatabase Scalability - Question #6Ensuring High Availability and Disaster Recovery
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 infor...
Cloud SQLPoint-in-Time RecoveryDisaster RecoveryData Recovery - Question #7Planning and Implementing Database Migration
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating t...
Database Migration Service (DMS)PostgreSQL MigrationCloud SQLLogical Replication - Question #8Designing and Planning Database Solutions
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to of...
Cloud SQLMySQL ReplicationHybrid DatabasesManaged Services - Question #9Performing Database Migrations
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoi...
Database MigrationCloud SQLData SynchronizationGoogle Cloud Database Migration Service (DMS) - Question #10Migrating to Google Cloud Databases
Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to de...
Database MigrationCloud SQLDatabase Migration Service (DMS)Minimizing Downtime - Question #11Cloud SQL Operations and Management
Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses...
Cloud SQL StorageDatabase MonitoringCapacity ManagementOperational Alerts - Question #12Managing Database Operations
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 on-demand...
Cloud SQLDatabase backupMonitoringgcloud CLI - Question #13Optimizing Cloud Spanner Performance
You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You no...
Cloud SpannerPerformance OptimizationScalingTroubleshooting - Question #14Monitoring and Optimizing Database Solutions
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 dat...
Bigtable StoragePerformance OptimizationSSD vs HDDLow Latency - Question #15Designing and Implementing High Availability and Disaster Recovery for Cloud SQL
Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available...
Cloud SQLHigh AvailabilityDisaster RecoveryMulti-Region Architecture - Question #16Designing and Implementing Database Solutions
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game up...
FirestoreMobile DevelopmentOffline SynchronizationServerless Databases - Question #17Ensuring database reliability, availability, and recovery
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics,...
Cloud SpannerDatabase RecoveryPoint-in-Time RecoveryBackup and Restore - Question #18Optimizing Database Performance
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. Yo...
Cloud SQL for MySQLDatabase ImportConnection ManagementPerformance Tuning - Question #19Networking for Database Solutions
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 en...
Shared VPCBare Metal SolutionNetwork ConnectivityMulti-Project Architecture - Question #20Managing Database Deployments
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. Yo...
Cloud SpannerData ExportDataflowAvro Format - Question #21Ensuring reliability and performance of database solutions
You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You wan...
Database CachingMemorystoreCloud SQLPerformance Optimization - Question #22Designing database solutions
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 insta...
Cloud SQL for SQL ServerInstance SizingPerformance TuningDatabase Migration - Question #23Implementing Database Availability and Recovery
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 minimiz...
Cloud SQLBackup StrategyRecovery Point Objective (RPO)Cost Optimization - Question #24Managing Cloud SQL operations
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of mor...
Cloud SQLMaintenance WindowsOperational ManagementHigh Availability - Question #25Designing and planning a database solution
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-pre...
Cloud SQLHigh AvailabilityRead ReplicasMulti-Region DeploymentDatabase Scaling - Question #26Managing and Operating Databases
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize ne...
Cloud SQLData ExportAutomationScheduled Tasks - Question #27Designing Highly Scalable Database Solutions
You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to million...
BigtableNoSQL DatabasesScalabilityIoT Data - Question #28Designing and Planning Database Solutions
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You...
Cloud SpannerCustomer-Managed Encryption Keys (CMEK)High AvailabilityDatabase Selection - Question #29Operating a Cloud Database Environment
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. Y...
Cloud SQLRead ReplicasAutomatic RecoveryManaged Databases - Question #30Ensuring Database Reliability, Availability, and Scalability
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your com...
Cloud SQLHigh AvailabilityDisaster RecoveryRTO/RPO - Question #31Managing and Maintaining Database Solutions
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational o...
Cloud SQL for MySQLDatabase BackupManaged ExportsOperational Best Practices - Question #32Managing Cloud SQL access and security
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL in...
IAMService AccountsCloud SQL AuthenticationCompute Engine Integration - Question #33Migrating database solutions
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL...
Database MigrationSQL ServerCompute EngineLift and Shift - Question #34Ensuring database security and compliance
An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access usin...
IAMCloud SQLCloud SpannerLeast Privilege - Question #35Database Architecture Design
You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to: - Work with transactions and offer strong c...
Google Cloud DatabasesDatabase SelectionGlobal ScalabilityConsistency Models - Question #36Implementing secure database access
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...
Cloud SQLPrivate IPVPC ConnectivityNetwork Security - Question #37Monitoring, Troubleshooting, and Optimizing Cloud SQL Databases
Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microse...
Cloud SQLMonitoringTroubleshootingQuery InsightsSqlcommenter - Question #38Designing and planning database solutions
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, a...
Cloud SQLPostgreSQLGlobal Database ArchitectureDatabase Replication - Question #39Managing and maintaining database solutions
Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you nee...
Cloud SQL MaintenanceDowntime PreventionCost-EffectivenessCloud SQL Configuration - Question #40Managing database availability and resilience
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RT...
Cloud SQLHigh AvailabilityDisaster RecoveryRTO/RPO - Question #41Designing highly available, scalable, and secure database solutions
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need t...
Multi-tenancyData residencyData isolationDatabase design patterns - Question #42Managing Database Scalability
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant...
Cloud SpannerDatabase ScalingAutoscalingCapacity Management - Question #43Managing Database Operations
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide d...
Cloud SQLRead ReplicasIAM AuthenticationPerformance Optimization - Question #44Troubleshooting and Optimizing Bigtable Performance
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations...
Bigtable troubleshootingKey VisualizerDatabase performance analysis - Question #45Designing Database Solutions
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Googl...
Database selectionCloud SpannerACID transactionsHigh availability - Question #46Migrating and replicating database systems
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limit...
Database Migration ServicePostgreSQL MigrationCloud SQLMigration Limitations - Question #47Optimizing Cloud Database Performance and Cost
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content del...
FirestoreCloud CDNPerformance OptimizationCost Optimization - Question #48Migrating Databases
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What sh...
Database MigrationCloud SQLPostgreSQLMinimal Downtime - Question #49Optimizing database costs
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...
Cloud SQLBackup ManagementCost OptimizationData Retention - Question #50Monitoring and troubleshooting database performance
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries an...
Cloud SQL MonitoringQuery PerformanceApplication IdentificationQuery Tags