Pass with professional Professional-Cloud-Database-Engineer actual quiz materials

Your IoT 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. Each record is 1KB with a row key format: deviceId#timestamp. Your current 12-node Bigtable cluster experiences hotspotting on specific device ranges, with three nodes handling majority ofthe traffic while others remain underutilized. Read queries typically access the last 24 hours of data for specific devices. Storage costs are becoming a concern as you retain two years of historical data (500TB total). You need to optimize performance, eliminate hotspotting, and reduce storage costs while maintaining read latency under 10ms. What should you do-

• A. Implement row key sting wth hash prefix, configure automsted sealing with an optimal min max threshold setting, and migrate data older than 6 months to Cloud Storage.
• B. Change the row key format to deviceId#timestamp, implement automated scaling with an optimal min max threshold setting based on CPU utilization, and migrate data older than 6 months to Cloud Storage
• C. Increase cluster size to 20 nodes, implement row key salting with hash prefix, and enable compression on all column families.
• D. Split the table by device type, use separate Bigtable instances for different geographic regions, and implement read replicas for query optimization.

You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read- only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

• A. Use a Cloud SQL federated query for the Sales Reporting application.
• B. Create a read replica for the Sales Reporting application.
• C. Create two separate databases in the instance, and perform dual writes from the Order Management application.
• D. Queue up all the requested reports in PubSub, and execute the reports at night.

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?

• A. Use granular instance sizing in Cloud Spanner and Autoscaler.
• B. Manually scale down the number of nodes after the peak period has passed.
• C. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
• D. Use interleaving to co-locate parent and child rows.

You are designing a solution to implement a cache to track all the products which are browsed by users on an ecommerce website, using a key-value database. Your solution needs to have the ability to connect to the database from multiple VPC networks, while having a managed service, high throughput, low latency, strong security, and private communication. What should you do-

• A. Choose Memorystore for Redis Cluster and Private Service Connect for networking connectivity.
• B. Choose Bigtable and connect using Private Google Access API endpoint(s).
• C. Choose a Memorystore for Redis instance and Private Service Access for networking connectivity.
• D. Choose a Redis instance on a VM in the Shared VPC network.

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 Firestore.
• B. Migrate the existing database to Cloud SQL for PostgreSQL.
• C. Migrate the existing database to Cloud Spanner.
• D. Migrate the existing database to PostgreSQL running on Compute Engine.