Question 1

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

Options :

A : Use Identity and Access Management (IAM) authentication.

B : Use Managed Active Directory authentication.

C : Use Cloud SQL federated queries.

D : Use PostgreSQL database-s built-in authentication.

Answer: A

Question 2

Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?

Options :

A : Select Bare Metal Solution for Oracle.

B : Select Cloud SQL.

C : Select Bigtable.

D : Select Cloud Spanner.

Answer: D

Question 3

Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?

Options :

A : Use Firestore with Looker.

B : Use Cloud Spanner with Data Studio.

C : Use MongoD8 Atlas with Charts.

D : Use Bigtable with Looker.

Answer: C

Question 4

You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?

Options :

A : For each application code, set up a common shared user account.

B : For each application code, set up a dedicated user account.

C : For the application server, set up a service account.

D : For the application server, set up a common shared user account.

Answer: C

Question 5

You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine

whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize

operational costs and overhead. What should you do?

Options :

A : Create a VM in Compute Engine, and run a cron job.

B : Create a Cloud Composer instance, and create a directed acyclic graph (DAG).

C : Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.

D : Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

Answer: C

Smartly Prepare Exam with Free Online Professional-Cloud-Database-Engineer Practice Test

Buying Options: