PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Questions
203 real PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam questions with expert-verified answers and explanations. Page 3 of 5.
- Question #101Designing and Implementing Database Connectivity
You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have t...
Shared VPCMulti-project NetworkingCloud SQL ConnectivityCompute Engine Networking - Question #102Managing Cloud SQL Infrastructure
Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, an...
TerraformCloud SQLDeletion ProtectionInfrastructure as Code - Question #103Ensuring Security and Compliance
Your company's mission-critical, globally available application is supported by a Cloud Spanner database. Experienced users of the application have read and write access to the dat...
Cloud SpannerIAM RolesAccess ControlDatabase Security - Question #104Migrating databases to Google Cloud
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 SQLDatabase Migration ServiceData Replication - Question #105Managing Database Solutions
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Y...
Cloud SQLDatabase ConnectivityCloud SQL Auth ProxySecurity - Question #106Managing Database Availability and Disaster Recovery
Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availabil...
Cloud SQLHigh AvailabilityBackupsPoint-in-time recovery - Question #107Designing Database Migration Solutions
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....
Google Cloud VMware EngineDatabase MigrationOracleLift and Shift - Question #108Troubleshooting a database solution
Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of...
Cloud Spanner PerformanceDatabase MonitoringTroubleshooting Read LatencySpanner System Tables - Question #109Migrating database solutions
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and down...
Database Migration Service (DMS)Cloud SQLPostgreSQLDatabase Migration - Question #110Managing Database Infrastructure Connectivity
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...
Bare Metal Solution NetworkingCustom NAT GatewayOutbound Internet AccessCompute Engine Networking - Question #111Monitoring and Troubleshooting Database Performance
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 degradati...
Cloud SQLPerformance MonitoringTroubleshootingCloud Monitoring - Question #112Designing and Planning Database Solutions
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...
Cloud SpannerRelational DatabasesGlobal ScalabilityOLTP - Question #113Managing Cloud SQL Instances
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zo...
Cloud SQLMaintenance WindowsAvailabilityOperational Management - Question #114Monitoring and optimizing database performance
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 produc...
Replication LagCloud SQL for MySQLPerformance OptimizationRead Replicas - Question #115Troubleshooting Cloud SQL connectivity
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: Ac...
Cloud SQL ProxyCloud SQL Admin APITroubleshootingAPI Enablement - Question #116Designing and Implementing Database Solutions
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of data. You are planning a gradual rollout of the s...
Database DesignCloud SpannerScalabilityCost Optimization - Question #117Ensuring Database Security and Compliance
Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need t...
Database Change ManagementAuditingComplianceCloud Spanner - Question #118Managing Database Solutions
Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization fo...
Cloud SQLDatabase Scalinggcloud CLIInstance Management - Question #119Designing and Implementing Database Solutions
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, an...
Cloud SQLHigh AvailabilityDatabase ArchitectureZonal Deployment - Question #120Database Recovery
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have en...
Cloud SQLPoint-in-Time Recovery (PITR)Database RecoveryPostgreSQL - Question #121Implementing Database Security
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific loca...
Cloud SQLEncryptionCustomer-Managed Encryption KeysData Security - Question #122Optimizing Database Solutions
Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk dri...
Cloud SQL for MySQLPerformance OptimizationStorage ManagementDatabase Migration - Question #123Ensuring reliability, security, and compliance for database solutions
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...
IAMCloud SpannerService AccountsLeast Privilege - Question #124Managing database security and access control
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...
Cloud Spanner IAMRole-Based Access ControlLeast PrivilegeSeparation of Concerns - Question #125Operating and Managing Cloud Spanner
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 authenticat...
Cloud SpannerCost OptimizationAutoscalingResource Management - Question #126Designing Cloud Database Solutions
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 immedia...
BigtableHigh AvailabilityMulti-Region DeploymentPerformance Best Practices - Question #127Designing and Implementing Database Solutions
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 th...
BigtableNoSQL DatabasesReal-time AnalyticsClickstream Data - Question #128Designing and planning database solutions
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...
Cloud SpannerSchema DesignPrimary KeysPerformance Optimization - Question #129Monitoring and Optimizing Database Performance
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications wit...
Cloud SQLDatabase MonitoringQuery PerformanceQuery Insights - Question #130Designing and Implementing Databases
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles ha...
FirestoreNoSQLDynamic SchemaData Integration - Question #131Optimizing Database Performance
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near- real time; however, the additional analytics caused excessive load on the primary dat...
Cloud SQLRead ReplicasReplication LagQuery Optimization - Question #132Ensuring Database Security and Compliance
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy wor...
Data ResidencyCustomer-Managed Encryption Keys (CMEK)VPC Service ControlsCloud SQL Security - Question #133Optimizing Database Performance
You are the Cloud Database Engineer for a retail analytics startup that runs a production Cloud SQL for MySQL instance supporting a product search API. Over the last 72 hours the a...
Database PerformanceQuery OptimizationCloud SQLIndexing - Question #134Database Migration
Which Google Cloud pairing offers a fully managed MongoDB service with live migration that supports continuous schema changes, data validation, rapid rollback, and cutover in under...
Managed MongoDBDatabase MigrationMongoDB AtlasGoogle Cloud Databases - Question #135Implementing High Availability and Disaster Recovery for Cloud Databases
BrightTrail Outfitters is moving an order processing platform from its data center to Google Cloud. The application depends on a MySQL backend that must remain highly available bec...
Cloud SQLHigh AvailabilityDisaster RecoveryRTO/RPO - Question #136Managing and Operating Cloud Database Solutions
Which approach delivers real time alerts for Cloud Spanner transaction failures and also reflects overall application health?
Cloud SpannerCloud MonitoringAlertingDatabase Monitoring - Question #137Migrating Databases
Riverton Analytics runs Microsoft SQL Server on premises with two read-only replicas, and the nightly differential backups for 28 databases have become expensive and difficult to m...
SQL Server migrationCloud SQL for SQL ServerDatabase replicationOn-premises to Cloud migration - Question #138Evaluating Google Cloud database services for globally distributed, strongly consistent, and transactional workloads.
Which Google Cloud database offers strongly consistent transactions, supports both relational and JSON data, and delivers globally distributed low latency across three continents?
Cloud SpannerGlobal DistributionStrong ConsistencyDatabase Selection - Question #139Designing and Planning a Database Solution
You are planning connectivity for a global retail analytics service that runs in multiple Google Cloud regions and must reach a Cloud Spanner database with very low latency, strong...
Cloud SpannerMulti-region ArchitectureDatabase ConnectivityPerformance Optimization - Question #140Securing a database
How should you configure a Cloud SQL for PostgreSQL instance in us-central1 to use a customer-managed encryption key from a Cloud KMS key ring in us-central1 with key rotation ever...
Cloud SQLCMEKCloud KMSData Encryption - Question #141Designing Cloud Database Solutions
You are building the database layer for a multinational ticketing marketplace on Google Cloud. Traffic is unpredictable and can spike by 8x during global presales and seasonal camp...
Cloud SpannerDatabase SelectionHigh AvailabilityGlobal Scalability - Question #142Designing for High Availability and Disaster Recovery
In Cloud SQL for MySQL, which deployment achieves high availability and disaster recovery while maintaining low read and write latency in the primary region?
Cloud SQLHigh AvailabilityDisaster RecoveryDatabase Architecture - Question #143Securing Database Solutions
HelioBank is deploying Cloud SQL for MySQL in europe-west1 to support payment processing for example.com. The compliance team requires that data at rest be encrypted with a key tha...
Cloud SQLCMEKData EncryptionSSL/TLS - Question #144Database Migration and Modernization Strategies
During a migration from a monolith to microservices on Google Cloud, which database strategy minimizes downtime while preserving the option to adopt service specific data stores la...
Microservices ArchitectureDatabase MigrationMonolith RefactoringDowntime Management - Question #145Operating a Cloud Database Solution
At Nimbus Retail you manage a Cloud SQL for MySQL instance called reporting-sql-01. The team needs to export a full database to Cloud Storage and later import it back into the same...
Cloud SQLgcloud CLIData Export/ImportDatabase Backup - Question #146Optimizing Cloud Database Performance and Connectivity
Which connection method should applications use to connect to a regional Cloud Memorystore for Redis instance to keep 99th percentile latency under 4 milliseconds while minimizing...
Cloud Memorystore for RedisNetworkingLow LatencyPrivate IP - Question #147Optimizing database performance and cost
mcnz.com migrated its busy ticketing platform database to Cloud SQL for MySQL six months ago and monitoring now shows persistently low CPU and memory usage which indicates the inst...
Cloud SQLCost OptimizationRightsizingPerformance Tuning - Question #148Managing and Optimizing Google Cloud Database Solutions
When comparing Google Cloud managed NoSQL services, which cost component should you consistently emphasize for a precise TCO analysis?
Google Cloud NoSQLCost AnalysisTCODatabase Billing Models - Question #149Securing database systems
You are the database specialist at BlueOrbit Logistics and you must grant access for a group of analysts who need to run queries against Cloud Spanner production databases while th...
IAM RolesCloud SpannerAccess ControlDatabase Security - Question #150Designing and Optimizing Cloud Database Solutions
Your application stores session documents in Firestore and queries them by steps, sessionDuration, and energyBurned. After a 30 day test period, latency is acceptable but costs are...
Firestore Cost OptimizationNoSQL Data ModelingDatabase DesignPerformance Tuning