GCP Google Cloud Professional Cloud Database Engineer Practice Questions At Vantorix Health, you are designing a highly available Cloud SQL for PostgreSQL environment for 100 databases.
GCP Google Cloud Professional Cloud Database Engineer Practice Questions
0% Completed
Premium Set: 1 [ + Detailed Explanations] Free Preview
At Nexalume Retail, the server CA certificate used by a Cloud SQL for MySQL instance is approaching expiration.
Reading
At Kestrelune Services, you are migrating an on-premises application to Google Cloud.
Reading
Zorvella Retail is a large retail and ecommerce company expanding globally and migrating to Google Cloud.
Reading
At Lumivora Media, you operate Cloud SQL for PostgreSQL with regional high availability in the primary region and a cross-region read replica in a secondary region for disaster recovery.
Reading
At Ecliptora Financial, your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle.
Reading
At Avenlora Health, you are designing a physician portal whose user-facing clients must work in hospitals and clinics with intermittent internet connectivity.
Reading
At Veltriona Services, you are managing a Cloud SQL for PostgreSQL deployment in Google Cloud.
Reading
At Brinovexa Retail, you have a Cloud SQL for MySQL instance containing product information, including a text column of product descriptions.
Reading
At Zorivexa Media, your organization runs a high-volume, low-latency application on Bigtable.
Reading
At Ceryntra Financial, you have a Cloud SQL for MySQL Enterprise edition primary instance with four read replicas.
Reading
At Lumivanta Enterprises, your company wants to migrate Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud.
Reading
At Virellex Commerce, your company uses Cloud SQL for MySQL with a private IP address and wants to replicate selected tables into BigQuery in near real time for analytics and machine learning.
Reading
At Pelorvanta Systems, your company is migrating a legacy on-premises Oracle database to Cloud SQL for PostgreSQL.
Reading
At Nexorvia Payments, you manage a Cloud SQL for PostgreSQL instance configured for high availability.
Reading
Meridexa Services hosts an application in Google Cloud.
Reading
Quoralis Media recently released a new version of a heavily used application to accommodate additional traffic.
Reading
At Asterlyn Software, you administer Cloud SQL for PostgreSQL.
Reading
At Ceralume Technologies, you are migrating a 2 TB on-premises PostgreSQL cluster to PostgreSQL running on an Ubuntu Compute Engine VM.
Reading
At Orbinexa Manufacturing, you need to migrate databases from Microsoft SQL Server 2016 Standard Edition on a Windows Server 2019 Datacenter server to a single Cloud SQL for SQL Server instance.
Reading
Avenquor Commerce runs a MySQL workload in Cloud SQL.
Reading
At Merilora Applications, you use Memorystore for Redis to cache frequently accessed application data.
Reading
At Zorvanta Retail, you manage a production Cloud SQL for MySQL database.
Reading
At Vantorix Health, you are designing a highly available Cloud SQL for PostgreSQL environment for 100 databases.
Reading
At Meridexa Holdings, you want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link.
Reading
At Pelorvexa Health, you want to migrate a mission-critical on-premises PostgreSQL database to Cloud SQL for PostgreSQL.
Reading
Kestrelune Industries is setting up a Bare Metal Solution environment.
Reading
At Zenvella Applications, you are a DBA for a Spanner instance containing multiple databases.
Reading
At Pelorix Logistics, the data-analysis team needs a daily CSV extract from Cloud SQL for MySQL to train a machine-learning model that optimizes next-day delivery routes.
Reading
Orbinexa Holdings wants to move to Google Cloud. Its current data center is closing in six months.
Reading
At Quoralis Platforms, you need to provision several hundred Cloud SQL for MySQL instances for multiple project teams during one week.
Reading
At Quorivanta Payments, your company is evaluating Google Cloud database options for a mission-critical global payments gateway.
Reading
At Velorixa Commerce, your application uses a Cloud SQL for MySQL instance.
Reading
Nexacrest Digital runs its database workloads on Cloud SQL.
Reading
At Nexavelle Scheduling, you manage a meeting-booking application that uses Cloud SQL.
Reading
At Merivanta Financial, you have deployed a Cloud SQL for SQL Server primary instance and a cross-region read replica for disaster recovery.
Reading
At Lumidora Media, your team runs a Cloud SQL for MySQL instance containing a 5 TB database that must remain available 24 hours a day.
Reading
At Asterlix Global, your company uses a multi-region Spanner instance for an application that performs many writes and very few reads.
Reading
At Brinovexa Holdings, your company is migrating legacy applications to Google Cloud.
Reading
At Cerynox Labs, you manage a small Cloud SQL instance used by developers for testing.
Reading
At Brinovex Retail, you manage a Cloud SQL for MySQL environment. A primary instance is in Zone A, and a read replica is in Zone B of the same region.
Reading
At Zenvoria Commerce, you are migrating an on-premises application to Compute Engine and Cloud SQL.
Reading
Trivanta Dataworks has PostgreSQL databases on-premises and on Amazon Web Services (AWS).
Reading
At Pelorune Analytics, you use Python scripts to generate weekly SQL reports that assess database health and determine whether tables need maintenance or updated statistics.
Reading
At Novalune Systems, you are migrating an on-premises PostgreSQL database to Spanner.
Reading
At Velquora Systems, you are choosing a database backend for a new application.
Reading
At Quoralyx Commerce, you are designing a new ecommerce application on Google Cloud.
Reading
Lumivane Labs has a global chat application that uses a multi-region Spanner instance.
Reading
At Velmora Systems, you are developing a new application on a VM that is on your corporate network.
Reading
At Avenlith DevOps, your team uses Terraform to deploy applications and Cloud SQL databases.
Reading
At Nexalith Payments, you are designing a payment-processing application on Google Cloud.
Reading
Premium Set: 2 [ + Detailed Explanations]
At Avenquill Airways, you are designing a new database for an airline ticketing application in Google Cloud.
Reading
At Pelorixa Software, you are developing a Python application that uses AlloyDB for PostgreSQL as its backend.
Reading
At Virelixa Platforms, you are creating Cloud SQL for PostgreSQL instances in us-east1 and us-east4 and assigning private IP addresses through a Shared VPC.
Reading
At Orbinexa Reporting, your organization runs a low-latency reporting application on Microsoft SQL Server.
Reading
At Ceralune Digital, you are writing an application that runs on Cloud Run and uses Cloud SQL.
Reading
At Velmora Systems, your project uses Bigtable to store sensitive data that must never be accessed from the public internet, even if a requester possesses a valid service account key.
Reading
At Zorvanta Logistics, your team is building a global inventory-management application that requires read and write database access in multiple Google Cloud regions.
Reading
At Meridoxa Services, you are troubleshooting a connection problem with a newly deployed Cloud SQL instance.
Reading
At Merovixa Services, you have several on-premises Percona Server for MySQL 8.0 instances supporting mission-critical applications.
Reading
At Asterlume Technologies, you are migrating an on-premises OLTP PostgreSQL database to Google Cloud.
Reading
Brivexa Analytics uses Cloud SQL for MySQL.
Reading
Veloryn Foods runs a MySQL database on-premises with read replicas.
Reading
At Brivora Commerce, you are designing a write-heavy application.
Reading
Brinovia Financial operates in a highly regulated industry where separation of concerns and the principle of least privilege are critical.
Reading
At Avenora Games, your company is launching a gaming application that uses Firestore.
Reading
At Asterlume Retail, you have a Cloud SQL for MySQL primary instance named DB-1 with two cross-region read replicas, DB-2 and DB-3. During a business-continuity test, DB-1 was taken offline and DB-2 was promoted to become the writable primary.
Reading
At Quorivexa Enterprises, your company wants to migrate an Oracle-based application to Google Cloud.
Reading
At Veltrionix Global, your company is launching a new globally distributed application with strict requirements for low latency, strong consistency, zero downtime, and high availability.
Reading
At Merovexa Insights, you are building a BigQuery data warehouse.
Reading
At Trinovara Analytics, an analytics service needs to read data from Cloud SQL for SQL Server and update a table in Spanner.
Reading
Terracrest Media is evaluating Cloud SQL for PostgreSQL as a destination for its on-premises PostgreSQL databases.
Reading
At Zenvella Commerce, you are designing a managed key-value cache that tracks products browsed by users on an ecommerce website.
Reading
Novalune Experiences is building an application that lets users customize their website and mobile experiences.
Reading
At Lumorix Systems, you run Cloud SQL for PostgreSQL 13 on Cloud SQL Enterprise edition with point-in-time recovery enabled.
Reading
At Quorivex Health, you are configuring a new Cloud SQL for PostgreSQL environment.
Reading
Novalith Products recently launched a new product in the US market.
Reading
At Pelorune Learning, an e-learning platform runs on a Cloud SQL for PostgreSQL instance with 16 vCPUs, approximately 60 GB of memory, and 1 TB of SSD storage.
Reading
At Zorivanta Manufacturing, you are migrating an application to Google Cloud.
Reading
At Ecliptora Commerce, you manage a production Cloud SQL for MySQL instance configured with 16 vCPUs and 104 GB of RAM.
Reading
At Quellivex Health, you are migrating a 10 TB relational database from an on-premises environment to Cloud SQL for PostgreSQL.
Reading
At Quoralyx Digital, your company is migrating a monolithic application to microservices on Google Cloud.
Reading
At Quorivexa Retail, your company currently stores product-catalog data in Amazon DynamoDB and plans to migrate it to Bigtable for greater scale, cost efficiency, and access to current Bigtable capabilities.
Reading
At Pelorvanta Retail, you are designing a centralized inventory-management system for 200 stores, each with approximately 500 GB of data.
Reading
At Braventra Media, you manage a 10 GB Cloud SQL for MySQL database for a noncritical application.
Reading
Vantrelix Supply uses Spanner for a mission-critical, globally available inventory-management system.
Reading
At Orbilume Global, your mission-critical application uses Spanner.
Reading
At Zenvorix Financial, you perform a daily native BAK export from Cloud SQL for SQL Server to Cloud Storage at 6:00 AM by using gcloud sql export bak.
Reading
Pixelmora Games is designing an augmented-reality game for iOS and Android devices.
Reading
At Asterivon Commerce, you are migrating a critical ecommerce platform from an on-premises PostgreSQL database that uses PostgreSQL stored procedures.
Reading
At Vantrelix Financial, an internal audit found that an existing Cloud SQL for MySQL instance is not configured for high availability.
Reading
At Lumivexa Analytics, your company is migrating from an on-premises database to a regional Spanner instance.
Reading
At Zenvoric Finance, your organization has strict policies for tracking database changes that are promoted into production and periodically provides the change history to external auditors.
Reading
At Virelora Software, you are deploying a new Cloud SQL instance and using the Cloud SQL Auth Proxy.
Reading
Eclipsera Commerce captures ecommerce clickstream data to analyze customer traffic patterns in real time and support website personalization.
Reading
At Asterquill Systems, you are managing multiple applications that connect to a Cloud SQL for PostgreSQL database.
Reading
At Pelorixa Commerce, you are configuring a new Cloud SQL for PostgreSQL instance.
Reading
At Merivexa Software, you administer a Cloud SQL for PostgreSQL instance where pgAudit is disabled. Users report that queries have gradually become slower over the past few months.
Reading
At Novelyra Commerce, your ecommerce company is migrating analytics workloads to AlloyDB for PostgreSQL.
Reading
At Lumicrest Health, you are migrating a telehealth company's on-premises data center to Google Cloud.
Reading
At Nexivanta Tickets, your organization has a ticketing system and needs a new online marketing analytics and reporting application.
Reading
Premium Set: 3 [ + Detailed Explanations]
At Asterquill Global, you are designing a database architecture for an application that stores information about public parks worldwide.
Reading
Avenlith Services uses the Cloud SQL out-of-disk recommender to analyze production database storage-utilization trends over the previous 30 days.
Reading
At Vantressa Analytics, you are designing a global 24/7 real-time analytics platform that stores large volumes of versioned time-series data.
Reading
At Pelovex Digital, your application uses Memorystore for Redis as a cache.
Reading
Nexoria Commerce deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability and binary logging enabled.
Reading
At Lumivora Health, your organization works with sensitive data and requires direct control over the encryption keys used for data at rest.
Reading
At Velmora Systems, you are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud.
Reading
At Pelorvanta Services, your organization needs to migrate a critical on-premises MySQL database to Cloud SQL for MySQL.
Reading
At Lumivora Financial, your company uses Spanner for a fully managed transactional database.
Reading
At Astervane Bank, your organization runs Oracle 12.2 on-premises and wants to modernize to an open-source-compatible PostgreSQL platform.
Reading
At Velmirex Platforms, you are running a mission-critical application on Google Kubernetes Engine (GKE) and using private IP connectivity to Cloud SQL for PostgreSQL in us-central1.
Reading
At Lumirexa Platforms, multiple tenants share one Bigtable table.
Reading
At Lumivexa Manufacturing, you recently migrated an on-premises MySQL database to Cloud SQL.
Reading
At Nexoriva Financial, a large Spanner Enterprise edition database stores transaction history for seven years.
Reading
At Orbinexa Payments, a mission-critical application uses Spanner for transactional data.
Reading
At Cerynexa Research, you manage several Cloud SQL databases.
Reading
At Ceryntra Applications, a production application performs continuous reads and writes against a single Bigtable cluster.
Reading
Eclipsera Logistics plans to use Database Migration Service to migrate an on-premises PostgreSQL instance to Cloud SQL for PostgreSQL.
Reading
At Velquorin Systems, your organization has hundreds of Cloud SQL for MySQL instances.
Reading
At Novaceryx Commerce, your company is migrating a MySQL database to Cloud SQL and cannot accept planned Cloud SQL maintenance during the month of December because of peak holiday traffic.
Reading
Trivanta Markets is moving the infrastructure for a highly transactional application to Google Cloud.
Reading
At Quorvexa IoT, your monitoring platform ingests sensor data from 100,000 devices, generating 2 million writes per second during peak hours and 500,000 writes per second during off-peak hours.
Reading
Marovex Industries operates MySQL databases both on Compute Engine in Google Cloud and in its own data center as a hybrid environment.
Reading
Lumicrest Retail needs to perform a one-time migration from a running Cloud SQL for MySQL instance in us-central1 to a new Cloud SQL for MySQL instance in us-east1.
Reading
Kestrelix Apps uses a microservices architecture backed by a single large Cloud SQL instance.
Reading
At Cerynox Financial, an application sends banking events to Bigtable cluster-a in one US region.
Reading
At Brinova Analytics, a Bigtable instance serves a latency-sensitive production API throughout the day.
Reading
At Ecliptorix Commerce, you are migrating a production Amazon RDS for MySQL database to Cloud SQL for MySQL by using Database Migration Service.
Reading
At Avenlith Search, an application stores operational product data in AlloyDB for PostgreSQL.
Reading
At Eclipsera Hospitality, your hotel-booking company is expanding into Country A, where personally identifiable information (PII) must satisfy strict regional data-residency and audit requirements.
Reading
At Quorilume Analytics, you are configuring a new application that reads an existing Spanner database to gather statistics for a dashboard.
Reading
At Nexorune Labs, a noncritical application runs on Google Kubernetes Engine (GKE) in the app-dev VPC network.
Reading
At Orbinara Dataworks, you configured AlloyDB for PostgreSQL IAM database authentication.
Reading
At Pelorixa Digital, an application currently uses MongoDB 6.x with standard MongoDB drivers and Mongoose.
Reading
Zenvora Holdings is shutting down its data center and migrating several MySQL and PostgreSQL databases to Google Cloud.
Reading
At Brivanta Services, you want to migrate an on-premises PostgreSQL database to PostgreSQL running on Compute Engine.
Reading
At Orbinexa Commerce, your ecommerce application connects to Cloud SQL for SQL Server and is expected to experience heavy holiday-weekend traffic.
Reading
At Zenvoria Migration Labs, you are migrating an on-premises relational database to Spanner.
Reading
At Merilune Software, you clone a production Cloud SQL for PostgreSQL database for developers.
Reading
At Merovanta Delivery, your online retail-delivery application uses Cloud SQL for MySQL for inventory and scheduling.
Reading
At Nexavora Health, your organization has a security policy requiring all Cloud SQL for PostgreSQL databases to protect sensitive data with an encryption key that meets specific locality or residency requirements.
Reading
Orbinova Energy uses thousands of connected IoT devices to collect device-maintenance data from oil and gas customers in real time.
Reading
At Ceryvanta Holdings, the database platform team manages hundreds of Cloud SQL, AlloyDB for PostgreSQL, Spanner, Bigtable, Firestore, and Memorystore resources across many Google Cloud projects.
Reading
At Brinexa Digital, an existing application has gone viral.
Reading
At Zenvorix Commerce, your company is developing a global ecommerce website.
Reading
At Virelanta Retail, your organization is preparing for the holiday season.
Reading
At Virelune Commerce, a set of stateless microservices running on Cloud Run connects to a Cloud SQL for PostgreSQL Enterprise Plus edition instance.
Reading
Quorvanta Finance runs a mission-critical application on Cloud SQL for PostgreSQL.
Reading
At Novalith Dataworks, your organization is running a critical production database on a Compute Engine VM.
Reading
At Avenlix Insights, you use Cloud SQL for MySQL with a read replica in another zone to support a non-mission-critical analytics workload.
Reading
Premium Set: 4 [ + Detailed Explanations]
At Ceryvora Digital, you are designing a database strategy for a new web application.
Reading
At Orbinexa Holdings, your company is shutting down its on-premises data center and migrating Oracle databases that use Oracle Real Application Clusters (RAC) to Google Cloud.
Reading
At Ceralora Commerce, your rapidly growing ecommerce application uses Cloud SQL for MySQL.
Reading
At Cerynexa Technologies, your company is developing a new global relational transactional application that must be ACID-compliant, use SQL semantics, and provide a 99.999% availability SLA across regions.
Reading
At Avenquor Technologies, your organization is updating a corporate application that runs in another public cloud so that it can access managed database services in Google Cloud.
Reading
At Velquoria Systems, you are planning the migration of a large Oracle database to AlloyDB for PostgreSQL.
Reading
At Zorvella Commerce, your organization has a busy transactional Cloud SQL for MySQL primary instance.
Reading
At Quenlora Commerce, a critical business application uses Cloud SQL for MySQL.
Reading
At Quorvella IoT, your organization operates a high-volume, low-latency sensor-ingestion system.
Reading
At Peloriva Platforms, your company has nearly doubled its North American user base in six months.
Reading
At Orbinexa Games, you are designing a new gaming application that uses a highly transactional relational database for player authentication and inventory data.
Reading
At Brivanta Media, your company uses Bigtable for a user-facing application that displays a low-latency, real-time dashboard.
Reading
At Lumivanta Commerce, you are designing the backup and recovery strategy for a write-heavy Cloud SQL for MySQL database.
Reading
At Asterlyn Commerce, you run Spanner as the backend for an ecommerce website.
Reading
At Brivellum Services, you are the primary DBA for a Cloud SQL for PostgreSQL database that supports six enterprise production applications.
Reading
At Quorilume Software, you are choosing a new database backend for an existing application.
Reading
At Brivexa Retail, your production databases run on Cloud SQL for MySQL Enterprise Plus edition, version 8.0.34, in the us-central1 region.
Reading
At Asterivex Retail, you have a regional Spanner instance with manually allocated compute capacity and no autoscaler.
Reading
At Pelorix Dataworks, your organization stores customer preferences and purchase history in Bigtable.
Reading
At Trivanta Global, your company wants to migrate self-managed on-premises MySQL, PostgreSQL, and Microsoft SQL Server databases to the corresponding managed Cloud SQL database engines.
Reading
At Marovella Enterprises, you are migrating a data center to Google Cloud.
Reading
At Pelorixa Markets, your team is building an application that stores and analyzes streaming financial time-series data.
Reading
At Nexorvia Learning, you are the DBA for an online tutoring application that uses Cloud SQL for PostgreSQL.
Reading
At Nexoriva Applications, your company uses a custom application that serves thousands of users.
Reading
At Kelmora Analytics, you are starting a large CSV import into a Cloud SQL for MySQL instance that currently has many open connections.
Reading
At Vantelora News, your organization runs a Firestore-backed Firebase application that serves the same ten top news stories each day to a very large global audience.
Reading
At Eclipsera Commerce, you manage two applications named Order Management and Sales Reporting.
Reading
At Novarixa Media, you have a large Cloud SQL for PostgreSQL instance.
Reading
At Merovanta Industries, you are running a large, highly transactional multi-tenant application on Oracle Real Application Clusters (RAC) with shared storage.
Reading
At Veltrixa Systems, you need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL.
Reading
At Virellex Services, you need to redesign an application that currently uses Cloud SQL for PostgreSQL.
Reading
At Vantelora Commerce, you are designing a database strategy for a new application whose users and application servers are located in a single Google Cloud region.
Reading
At Velmoran Systems, you are managing a mission-critical Cloud SQL for PostgreSQL instance.
Reading
At Orbinexa Financial, your organization's databases run on Cloud SQL.
Reading
At Zorvanta Interactive, you released a popular mobile game and use a 50 TB Spanner database with point-in-time recovery enabled for production game data.
Reading
At Orbinova Platforms, you want to migrate a PostgreSQL database from another cloud provider to Cloud SQL for PostgreSQL by using Database Migration Service.
Reading
At Lumivexa Games, you are building an Android game that needs to store data in a Google Cloud serverless database.
Reading
At Novacrest Retail, you support a consumer inventory application that runs on a multi-region Spanner instance.
Reading
At Zorvella Platforms, you are configuring networking for a Cloud SQL for MySQL instance.
Reading
At Vireluma Commerce, you want to migrate an on-premises MySQL database to Cloud SQL for MySQL.
Reading
Announcements Reviews Live Classes Course Info
PreviousNext

Action Disabled

<strong>Please enable JavaScript in your browser settings and refresh this page.</strong>

error:

Printing Disabled

Exporting or saving lessons as PDF is not permitted.
Please study online in your KloudExams account.

KLOUDExams • Protected