You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

• A.Create the instances using the Google Cloud Console UI.
• B.Automate instance creation by writing a Dataflow job.
• C.Create clones from a template Cloud SQL instance.
• D.Automate instance creation by setting up Terraform scripts.

Comment: *

Name: *

Email: *

Verification: *

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

• A.Migrate the databases to Cloud Spanner.
• B.Migrate the databases to Cloud SQL, and enable a standby database.
• C.Migrate the databases to Compute Engine using regional persistent disks.
• D.Migrate the databases to Bare Metal Solution for Oracle.

Comment: *

Name: *

Email: *

Verification: *

You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?

• A.Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
• B.Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
• C.Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
• D.Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.

Comment: *

Name: *

Email: *

Verification: *

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

• A.Use Cloud SQL serverless exports.
• B.Create a read replica, and then use the mysqldump utility to export each table.
• C.Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
• D.Use the mysqldump utility on the primary database instance to export the backup.

Comment: *

Name: *

Email: *

Verification: *

Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?

• A.Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
• B.Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
• C.Use Memorystore to handle your low-latency requirements and for real-time analytics.
• D.Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.

Comment: *

Name: *

Email: *

Verification: *