You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?

• A.Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
• B.Check whether your service account has cloudsql.instances.connect permission.
• C.Enable the Cloud SQL Admin API.
• D.Ensure that you are using an external (public) IP address interface.

Comment: *

Name: *

Email: *

Verification: *

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

• A.Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
• B.Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
• C.Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
• D.Configure the primary, standby, and read replica instances in zone A, all in the same region.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Use Firestore with Looker.
• B.Use Cloud Spanner with Data Studio.
• C.Use MongoD8 Atlas with Charts.
• D.Use Bigtable with Looker.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
• B.Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
• C.Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
• D.Use Cloud Composer to execute a select * from table(s) query and export results.

Comment: *

Name: *

Email: *

Verification: *

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 Spanner
• B.BigQuery
• C.Bigtable
• D.Cloud SQL

Comment: *

Name: *

Email: *

Verification: *