Free Google Professional-Cloud-Database-Engineer Exam Dumps Questions & Answers

You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?

• A.  Migrate the existing database to Cloud Spanner.
• B.  Migrate the existing database to Cloud SQL for PostgreSQL.
• C.  Migrate the existing database to PostgreSQL running on Compute Engine.
• D.  Migrate the existing database to Firestore.

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

• A.  Identify whether the source database is encrypted using pgcrypto extension.
• B.  Identify whether the database has over 512 tables.
• C.  Identity all tables that do not have at least one foreign key.
• D.  Identify whether the source database uses customer-managed encryption keys (CMEK).
• E.  Identify all tables that do not have a primary key.

Your e-learning platform runs on a Cloud SQL for PostgreSQL instance (16 VCPUs, 60 GB memory and 1TB SSD) serving users in North America. Your analytics team runs complex reporting queries that often consume 80% of CPU resources, causing slow response times for student transactions during peak hours. Current workload includes 8,000 transactions per second with 60% reads and 40% writes. The reporting queries involve JOIN operations across multiple large tables with millions of rows requiring highly efficient analytical processing. The platform also experiences sudden spikes in analytical reporting demand, requiring an elastic scaling of read capacity. You need to improve the query performance for your analytics team to run their reports efficiently without impacting transactional users. You also need to plan for future traffic growth.
What should you do-

• A.  Migrate to AlloyDB for PostgreSQL and upgrade the machine type of the primary instance to 32 vCPU. Create materialized views for common analytical queries.
• B.  Migrate to AlloyDB for PostgreSQL with a 16 vCPU primary instance and enable columnar engine for analytical workloads, using read pools for query isolation.
• C.  Upgrade the Cloud SQL for PostgreSQL instance to db-n1-highmem-32and implement connection pooling with PgBouncerto handle increased load.
• D.  Upgrade to Cloud SAL for PostgreSQL Enterprise Edition and route transaction and analytical queries to the primary instance.

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

• A.  If the corruption is significant, use import and export.
• B.  If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
• C.  If the corruption is significant, use backup and restore, and specify a recovery timestamp.
• D.  If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
• E.  If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.

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 high. Which Firestore change would reduce cost while preserving performance and availability?

• A.  Add Cloud Memorystore cache
• B.  Denormalize documents
• C.  Trim Firestore indexes to only required ones
• D.  Use batched writes for lower cost