Build and operate the data processing systems behind analytics and ML on Google Cloud, including BigQuery, Dataflow, and Pub/Sub, and track your readiness for the Professional Data Engineer exam.
Advanced
Prepare and test your skills
Advanced
Prepare and test your skills
Google Cloud feature
Cloud SQL Enterprise Plus edition
Topic in 1 exam domain
Also called: Enterprise Plus, ENTERPRISE_PLUS
A higher-tier performance and availability edition available for Cloud SQL instances.
Where this appears on the exam
1 objective in 1 of 5 domains
Related topics
FoundationsBuilding blocksBuilding blocksThis topicWorks alongsideBuilds on theseAppliedCloud StorageServiceAlloyDB for PostgreSQLServiceBackup and DRServiceGemini Cloud AssistServiceFirestoreServiceCompute EngineServiceCloud SQLService
Cloud SQL Enterprise Plus editionFeature
Committed use discountsFeatureCloud RunServiceAdvanced disaster recoveryFeatureBlocked active queriesFeatureAI-assisted troubleshootingFeatureQuery insightsFeaturewrite endpointFeatureDR replicaConceptPoints to what builds on itWorks with or alternative toHover or tap a line to see what connects the two
- Cloud SQL Enterprise Plus edition is part of Cloud SQL From the official documentation: “For Cloud SQL Enterprise Plus edition instances:”
- Advanced disaster recovery depends on Cloud SQL Enterprise Plus edition From the official documentation: “Advanced DR is supported only on Cloud SQL Enterprise Plus edition instances.”
- Advanced disaster recovery is part of Cloud SQL Enterprise Plus edition From the official documentation: “If you are using Cloud SQL Enterprise Plus edition, then you have the option of using advanced disaster recovery (DR).”
- Blocked active queries depends on Cloud SQL Enterprise Plus edition From the official documentation: “In order to analyze blocked active queries, the following requirements apply: - You must use an Cloud SQL Enterprise Plus edition instance.”
- AI-assisted troubleshooting is part of Cloud SQL Enterprise Plus edition From the official documentation: “Cloud SQL Enterprise Plus edition provides the following observability enhancements: - **Query insights**: advanced query performance diagnostics and filtering with up to 30-day metric retention, up to 1 MB query length limit, and a 200 query plan sample maximum. - **Enhanced…”
- Cloud SQL Enterprise Plus edition works with Cloud Storage From the official documentation: “If your Cloud SQL Enterprise edition instance stores transaction logs for PITR on disk, then starting the upgrade process to Cloud SQL Enterprise Plus edition switches the storage location of these logs to Cloud Storage.”
- Cloud SQL Enterprise Plus edition works with Committed use discounts From the official documentation: “Cloud SQL CUDs automatically apply to both [Cloud SQL Enterprise edition and Cloud SQL Enterprise Plus edition](/sql/docs/mysql/editions-intro) instances within the same region.”
- DR replica depends on Cloud SQL Enterprise Plus edition From the official documentation: “The designated DR read replica must meet the following requirements: - Must be a Cloud SQL Enterprise Plus edition instance”
- Query insights is part of Cloud SQL Enterprise Plus edition From the official documentation: “Cloud SQL Enterprise Plus edition provides the following observability enhancements: - **Query insights**: advanced query performance diagnostics and filtering with up to 30-day metric retention, up to 1 MB query length limit, and a 200 query plan sample maximum.”
- write endpoint is part of Cloud SQL Enterprise Plus edition From the official documentation: “Cloud SQL generates a write endpoint automatically for your Cloud SQL Enterprise Plus edition instance.”
- Cloud Run works with Cloud SQL From the official documentation: “Learn how to connect to Cloud SQL from Cloud Run”
- Cloud SQL works with Cloud Storage From the official documentation: “When ingesting data from Cloud SQL, data is first staged to a Cloud Storage bucket.”
- Cloud SQL works with Compute Engine From the official documentation: “Create a Compute Engine VM Instance to host a sample web app that connects to Cloud SQL.”
- Cloud Run works with Cloud Storage From the official documentation: “Route Cloud Storage events to Cloud Run”
- Cloud SQL depends on Compute Engine From the official documentation: “Cloud SQL uses Compute Engine virtual machines (VMs) with persistent storage disks.”
- Query insights is part of Cloud SQL From the official documentation: “To disable query insights for a Cloud SQL instance by using the Google Cloud console, follow these steps:”
- Cloud SQL works with Gemini Cloud Assist From the official documentation: “To use Gemini Cloud Assist with Cloud SQL, do the following:”
- AI-assisted troubleshooting is part of Cloud SQL From the official documentation: “The following limitations apply to AI-assisted troubleshooting in Cloud SQL:”
- AlloyDB for PostgreSQL works with Cloud Storage From the official documentation: “AlloyDB supports importing and exporting compressed `.gz` files from Cloud Storage.”
- Backup and DR works with Compute Engine From the official documentation: “This page details how to use Backup and DR to back up the disks of a Compute Engine instance.”
- Cloud Run works with Firestore From the official documentation: “The Cloud Run app stores the result in Firestore.”
- Cloud Storage works with Compute Engine From the official documentation: “You can use a web browser, the Google Cloud CLI, or a programming language to transfer files between Cloud Storage and Compute Engine VMs.”
- Query insights is part of AlloyDB for PostgreSQL From the official documentation: “To help you analyze and improve query performance of the databases,<br>AlloyDB for PostgreSQL provides a Query Insights tool.”
- AlloyDB for PostgreSQL works with Cloud Run From the official documentation: “The Cloud Run service can connect to the AlloyDB instance.”
- AlloyDB for PostgreSQL is an alternative to Cloud SQL From the official documentation: “The sample code uses Cloud SQL as the vector database, whereas this reference architecture uses AlloyDB for PostgreSQL.”
- AlloyDB for PostgreSQL works with Gemini Cloud Assist From the official documentation: “You can use Gemini Cloud Assist to help you monitor and troubleshoot your AlloyDB resources.”
- Backup and DR works with Cloud SQL From the official documentation: “Enable the Backup and DR API where the Cloud SQL instances are located.”
- Backup and DR works with Cloud Storage From the official documentation: “A storage pool, which associates a Cloud Storage bucket with Backup and DR,<br>was removed from the Backup and DR management console.”
- Backup and DR secures Compute Engine From the official documentation: “Backup and DR ensures that the chosen Compute Engine instances get backed up per the frequency set in the backup policy.”
- Cloud SQL is an alternative to Firestore From the official documentation: “Check your application code for reliance on local filesystems, and replace it with file storage on [Cloud Storage](/storage) or data storage such as [Firestore](/firestore) or [Cloud SQL](/sql).”
- DR replica is part of Advanced disaster recovery From the official documentation: “As a required component of advanced DR, the DR replica has the following characteristics:”
- write endpoint is part of Cloud SQL From the official documentation: “A write endpoint is available only for Cloud SQL Enterprise Plus edition instances that have private IP addresses and associated networks.”
- Advanced disaster recovery is part of Cloud SQL From the official documentation: “Advanced DR is supported only on Cloud SQL Enterprise Plus edition instances.”
- Advanced disaster recovery depends on DR replica From the official documentation: “To perform advanced DR, you must first designate a cross-region DR replica.”
- AI-assisted troubleshooting is part of AlloyDB for PostgreSQL From the official documentation: “The following limitations apply to AI-assisted troubleshooting in AlloyDB:”
- AI-assisted troubleshooting depends on Gemini Cloud Assist From the official documentation: “For Cloud SQL Enterprise edition instances, troubleshooting with AI assistance is only available if you enable Gemini Cloud Assist.”
- AI-assisted troubleshooting works with Gemini Cloud Assist From the official documentation: “You can use the AI-assisted troubleshooting tools of AlloyDB and [Gemini Cloud Assist](/cloud-assist/overview) to [troubleshoot slow queries](#troubleshoot-slow-queries) and [troubleshoot high database load](#troubleshoot-high-database-load).”
- AlloyDB for PostgreSQL works with Committed use discounts From the official documentation: “This page describes how committed use discounts (CUDs) work with AlloyDB for PostgreSQL.”
- AlloyDB for PostgreSQL works with Compute Engine From the official documentation: “In this tutorial, you integrate an AlloyDB instance and a [Compute Engine](https://cloud.google.com/compute) VM instance on a [Virtual Private Cloud (VPC)](https://cloud.google.com/vpc) network.”
- Backup and DR secures Cloud SQL From the official documentation: “Cloud SQL is protected by Backup and DR Service”
- Backup and DR works with Committed use discounts From the official documentation: “This page describes how committed use discounts work with Backup and DR for Oracle databases.”
- Blocked active queries is part of Cloud SQL From the official documentation: “Cloud SQL gives you the option to terminate specific long-running or blocked active queries.”
- Cloud Run works with Committed use discounts From the official documentation: “Committed use discounts (CUDs) provide discounted prices in exchange for committing to continuously using Cloud Run for a specified period of time.”
- Cloud Run works with Compute Engine From the official documentation: “This lets Cloud Run clients use this backend service route to send requests directly to Compute Engine instances.”
- Cloud Run is an alternative to Compute Engine From the official documentation: “The decision of whether to use Cloud Run, GKE, or Compute Engine as your application host involves trade-offs between configuration flexibility and management effort.”
- Cloud Run works with Gemini Cloud Assist From the official documentation: “The following table provide some example prompts for using Gemini Cloud Assist with Cloud Run.”
- Cloud SQL depends on Cloud Storage From the official documentation: “When ingesting data from Cloud SQL, data is first staged to a Cloud Storage bucket.”
- Cloud Storage works with Gemini Cloud Assist From the official documentation: “When you use Gemini Cloud Assist, you can enter prompts about how Cloud Storage works in general, and when you enable a Storage Intelligence subscription, you can enter prompts about specific buckets and objects.”
- Committed use discounts is part of Cloud SQL From the official documentation: “*Committed use discounts (CUDs)* for Cloud SQL provide deeply discounted prices in exchange for your commitment to continuously use database instances in a particular region for a one- or three-year term.”
- Committed use discounts is part of Compute Engine From the official documentation: “For predictable workloads, Compute Engine provides committed use discounts (CUDs) that help to reduce the cost of your infrastructure by committing to a contract in return for heavily discounted VM usage prices.”
- Committed use discounts is part of Firestore From the official documentation: “Firestore offers two levels of discounts, depending on the commitment period:”
- Query insights is part of Firestore From the official documentation: “To view query insights for a Firestore database, open the database **Query insights** pane in the Google Cloud console.”
How learners score on this topic
Last updated