Google Professional Cloud Database Engineer Exam Questions Instant Access

Question 1

You are setting up a new AlloyDB instance and want users to be able to use their existing identity and Access Managemen (IAM) identities to connect to AlloyDB. You have performed the following steps:

Manually enabled IAM authentication on the AlloyDB instance

Granted the allowdb-databaseUser and serviceusage.serviceusageConsumer IAM roles to the users

Created new AllowDB database users based on corresponding IAM identities

Users are able to connect but are reporting that they are not able to SELECT from application tables. What should you do?

AGrant the alloydb.client IAM role to each user.

BGrant the alloydb.viewer IAM role to each user.

CGrant the new database users access privileges to the appropriate tables.

DGrant the alloydb.alloydbreplica IAM role to each user.

Answer : C

Question 2

Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

ARecommend solid-state drives (SSD).

BRecommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.

CRecommend hard disk drives (HDD).

DRecommend mixed storage types.

Answer : A

if you plan to store extensive historical data for a large number of remote-sensing devices and then use the data to generate daily reports, the cost savings for HDD storage might justify the performance tradeoff. On the other hand, if you plan to use the data to display a real-time dashboard, it probably would not make sense to use HDD storage---reads would be much more frequent in this case, and reads that are not scans are much slower with HDD storage.

Question 3

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

AUse Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

BUse Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

CUse Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

DUse Cloud Composer to execute a select * from table(s) query and export results.

Answer : B

https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler

Question 4

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.)

AUse an auto-incrementing value as the primary key.

BNormalize the data model.

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

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

EUse bit-reverse sequential value as the primary key.

Answer : D, E

https://cloud.google.com/spanner/docs/schema-design D because high cardinality means you have more unique values in the collumn. That's a good thing for a hot-spotting issue. E because Spanner specifically has this feature to reduce hot spotting. Basically, it generates unique values https://cloud.google.com/spanner/docs/schema-design#bit_reverse_primary_key

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

This is a correct answer because promoting high-cardinality attributes in multi-attribute primary keys can help avoid hotspots in Cloud Spanner.High-cardinality attributes are those that have many distinct values, such as UUIDs, email addresses, or timestamps1.By placing high-cardinality attributes first in the primary key, you can ensure that the rows are distributed more evenly across the key space, and avoid having too many requests sent to the same server2.

E . Use bit-reverse sequential value as the primary key.

Question 5

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 SL

AYou 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?

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

BUse interleaving to co-locate parent and child rows.

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

DUse granular instance sizing in Cloud Spanner and Autoscaler.

Answer : D

Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances, https://cloud.google.com/blog/products/databases/get-more-out-of-spanner-with-granular-instance-sizing

Question 6

You are the DBA of your organization. You provided a cloned instance from the production Cloud SQL for PostSQL database to the developers for testing purposes. After the creation of the clone. Your developers notice missing data in one of the recently altered tables. What should you do to ensure that all data in included?

ATake a back up of the production database and restore It to another Cloud SQL for PostgreSQL Instance. Provide access to the new instance to the developers.

Bcheck for missing rotes and privileges in 'he cloned Cloud SQL instance. Grant missing privileges to the developers.

CClone the current production database, and restore it to an earlier point in time IPITR) Provide access to the cloned instance to the developers.

DDump the production database to a fie. Modify the dumped file to ALTER TABLE to SET LOGGED on tables that were unlogged in production. Reload the data in the new Cloud SQL for PostgreSQL Instance.

Answer : C

Question 7

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?

ABring DB-1 back online.

BDelete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

CDelete DB-2 so that DB-1 automatically reverts to the primary instance.

DCreate DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Answer : B

If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover. https://cloud.google.com/sql/docs/mysql/high-availability#failback