Question 91
Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data. What should you do?
A. Use Identity and Access Management (IAM) for Bigtable access control.
B. Use VPC Service Controls to create a trusted network for the Bigtable service.
C. Use customer-managed encryption keys (CMEK).
D. Use Google Cloud Armor to add IP addresses to an allowlist.
Question 92
Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?
A. Cloud SQL
B. BigQuery
C. Cloud Spanner
D. Bigtable
Question 93
You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?
A. Place the bulk of the read and write workloads closer to the default leader region.
B. Use staleness of at least 15 seconds.
C. Add more read-write replicas.
D. Keep the total CPU utilization under 45% in each region.
Question 94
Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?
A. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
B. Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
C. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
D. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
Question 95
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
A. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
B. Set up different organizations for each database type, and apply policy constraints at the organization level.
C. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
D. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
Question 96
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?
A. Bring DB-1 back online.
B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
C. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
D. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
Question 97
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
A. Use Bigtable.
B. Use Firestore.
C. Use Cloud SQL for MySQL
D. Use Cloud Spanner.
Question 98
You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?
A. View Cloud SQL operations to view historical query information.
B. White a Logs Explorer query to identify database queries with high execution times.
C. Review application logs to identify database calls.
D. Use the Query Insights dashboard to identify high execution times.
Question 99
You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?
A. Create one regional Cloud SQL instance with a read replica in another region.
B. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
C. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
D. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
Question 100
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
A. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
B. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
C. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
D. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
