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 drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

Edit the instance to change the storage type from HDD to SSD.

Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

Create a read replica of the instance with SSDs, and perform a failover to the new instance

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.

Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.

Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.

Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.

Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

Migrate the databases to Bare Metal Solution for Oracle.

Migrate the databases to Cloud Spanner.

Migrate the databases to Cloud SQL, and enable a standby database.

Migrate the databases to Compute Engine using regional persistent disks.

Migrate the databases to Bare Metal Solution for Oracle.

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 their own project. What should you do to configure the networks?

Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

Create a new VPC network in each project, and use VPC Network Peering to connect the two together.

Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

Use the default networks, and leverage Cloud VPN to connect the two together.

Place both the application VMs and the Cloud SQL instances in the default network of each project.

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?

Check 'Lag Bytes' in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

Restore the Cloud SQL instance from the automatic backups in region 3.

Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

Check 'Lag Bytes' in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

Enable high availability (HA) for the database to make it regional.

Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

Create a read replica in another region, and promote the read replica if a failure occurs.

Enable high availability (HA) for the database to make it regional.

You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?

Create a new server certificate, and download it.

Issue a rollback, and download your server certificate.

Create a new client certificate, and download it.

Create a new server certificate, and download it.

Reset your SSL configuration, and download your server certificate.

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 want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

Create a new service account, and grant it the Cloud Spanner Database Reader role.

Reuse the existing service account that populates this database.

Create a new service account, and grant it the Cloud Spanner Database Admin role.

Create a new service account, and grant it the Cloud Spanner Database Reader role.

Create a new service account, and grant it the spanner.databases.select permission.

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 microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

Watch Query Insights for long running queries.

Watch the Cloud SQL instance monitor for CPU utilization metrics.

Watch the Cloud SQL recommenders for overprovisioned instances.

Watch Cloud Trace for application requests that are failing.

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, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?

Use Cloud SQL for PostgreSQL with cross-region replicas.

Use Bigtable with multi-region clusters.

Use Memorystore for Redis with multi-zones within a region.

Use Cloud SQL for PostgreSQL with cross-region replicas.

Use Cloud Spanner with multi-region configuration.

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 need the most cost-effective solution. What should you do?

Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

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 (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

Set up all read replicas in a different region using asynchronous replication.

Set up all read replicas in the same region as the primary instance with synchronous replication.

Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

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 to isolate customer data in Country A from the rest of the customer data. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

Apply an instance data management pattern.

Apply a schema data management pattern.

Apply an instance data management pattern.

Apply a table data management pattern.

Apply a database data management pattern.

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 rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?

Use linear scaling to implement the Autoscaler-based architecture

Use direct scaling to implement the Autoscaler-based architecture.

Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

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. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?

Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.

Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.

Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.

Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.

Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.

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 availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

Create a PostgreSQL database on-premises as the HA option.

Configure single zone availability for automated backups.

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. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?

Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).

Migrate applications and Oracle databases to Compute Engine.

Migrate applications to Cloud SQL.

Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).

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 the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?

Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

Use query parameters to speed up frequently executed queries.

Change the Cloud Spanner configuration from multi-region to single region.

Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

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 downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

Use Database Migration Service to migrate all databases to Cloud SQL.

Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.

Use data replication tools and CDC tools to enable migration.

Use a combination of Database Migration Service and partner tools to support the data migration strategy.

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 internet so you can receive software updates. What should you do?

Set up a Cloud NAT gateway on the Compute Engine VM.

Setup a static external IP address in your VPC network.

Set up bring your own IP (BYOIP) in your VPC.

Set up a Cloud NAT gateway on the Compute Engine VM.

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 degradation. What should you do?

Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

Use Logs Explorer to analyze log data.

Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

Use Error Reporting to count, analyze, and aggregate the data.

Use Cloud Debugger to inspect the state of an application.

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 will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?

Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.

Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.

Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.

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 zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

Create your database with one primary node and one read replica in the region.

Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

Configure your Cloud SQL instance with high availability enabled.

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 production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?

Identify and optimize slow running queries, or set parallel replication flags.

Stop all running queries, and re-create the replicas.

Edit the primary instance to upgrade to a larger disk, and increase vCPU count.

Edit the primary instance to add additional memory.

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 of:Person A is a database administrator.Person B is an analyst who generates metric reports.Application C is responsible for automatic backups.You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupWriter for Application C

roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupAdmin for Application C

roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner databaseReader for Application C

roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner.backupWriter for Application C

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 authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

Use granular instance sizing in Cloud Spanner and Autoscaler.

Manually scale down the number of nodes after the peak period has passed.

Use interleaving to co-locate parent and child rows.

Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

Use granular instance sizing in Cloud Spanner and Autoscaler.

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 immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?

Maintain a target of 35% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone us-central2-a cluster-c in zone asia-northeast1-b cluster-d in zone asia-east1-b

Maintain a target of 23% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone europe-west1-d cluster-c in zone asia-east1-b

Maintain a target of 23% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone us-central1-b cluster-c in zone us-east1-a

Maintain a target of 35% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone australia-southeast1-a cluster-c in zone europe-west1-d cluster-d in zone asia-east1-b

Maintain a target of 35% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone us-central2-a cluster-c in zone asia-northeast1-b cluster-d in zone asia-east1-b

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 this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?

Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.

Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.

Use Memorystore to handle your low-latency requirements and for real-time analytics.

Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.

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 from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

Promote high-cardinality attributes in multi-attribute primary keys.

Use bit-reverse sequential value as the primary key.

Use an auto-incrementing value as the primary key.

Promote low-cardinality attributes in multi-attribute primary keys.

Promote high-cardinality attributes in multi-attribute primary keys.

Use bit-reverse sequential value as the primary key.

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 with long-running and resource-intensive queries. What should you do?

Use Query Insights for Cloud SQL.

Use log messages produced by Cloud SQL.

Use Query Insights for Cloud SQL.

Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

Use Cloud SQL instance monitoring in the Google Cloud Console.

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 have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.

Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences

Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

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 database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

Create additional read replicas, and partition your analytics users to use different read replicas.

Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.

Create secondary indexes on the replica.

Create additional read replicas, and partition your analytics users to use different read replicas.

Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.

Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.

Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

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 worldwide. Your solution must support data residency requirements and include a strategy to:configure where data is storedcontrol where the encryption keys are storedgovern the access to dataWhat should you do?

Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

Replicate Cloud SQL databases across different zones.

Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.

Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.

Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

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-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

Create an external replica, and use Cloud SQL to synchronize the data to the replica.

Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.

Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.

Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.

Create an external replica, and use Cloud SQL to synchronize the data to the replica.

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 should you do?

Use Database Migration Service to complete the migration.

Export the data from the existing database, and load the data into a new Cloud SQL database.

Use Migrate for Compute Engine to complete the migration.

Use Datastream to complete the migration.

Use Database Migration Service to complete the migration.

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 of backups in this environment?

Reduce the number of automated backups that are retained to two (2).

Set the automated backups to occur every other day to lower the frequency of backups.

Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).

Select a different region to store your backups.

Reduce the number of automated backups that are retained to two (2).

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 and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?

Use query tags to add application-centric database monitoring.

Shut down and restart each application.

Write a utility to scan database query logs.

Write a utility to scan application logs.

Use query tags to add application-centric database monitoring.

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

Use Cloud Spanner in a regional configuration.

Use Cloud Spanner in a multi-region configuration.

Use Cloud SQL with cross-region replicas.

Use highly available Cloud SQL with multiple zones.

Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

Migrate the Oracle databases to Bare Metal Solution for Oracle.

Migrate the Oracle databases to Cloud Spanner.

Migrate the Oracle databases to Compute Engine.

Migrate the Oracle databases to Cloud SQL.

Migrate the Oracle databases to Bare Metal Solution for Oracle.

Google Professional Cloud Database Engineer Practice Test 1

Question 1 / 40

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 locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

Create the database with Google-managed encryption keys.

Create the database with customer-managed encryption keys.

Create the database persistent disk with Google-managed encryption keys.

Create the database persistent disk with customer-managed encryption keys.

Comment (0)

Google Professional Cloud Database Engineer Practice Test 1

Question

Google Professional Cloud Database Engineer Practice Tests

Practice Tests