You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

• A.Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
• B.Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
• C.Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
• D.Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.

Comment: *

Name: *

Email: *

Verification: *

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure.
You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

• A.Create the database with Google-managed encryption keys.
• B.Create the database with customer-managed encryption keys.
• C.Create the database persistent disk with Google-managed encryption keys.
• D.Create the database persistent disk with customer-managed encryption keys.

Comment: *

Name: *

Email: *

Verification: *

You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

• A.Ensure that all PostgreSQL tables have a primary key.
• B.Disable all foreign key constraints on the source PostgreSQL database.
• C.Ensure that pglogical is installed on the source PostgreSQL database.
• D.Shut down the database before the Data Migration Service task is started.
• E.Drop or disable all users except database administration users.

Comment: *

Name: *

Email: *

Verification: *

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

• A.Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.
• B.Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage.
  Upload the changes into BigQuery, and merge them with existing tables.
• C.Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.
• D.Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.

Comment: *

Name: *

Email: *

Verification: *

Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?

• A.Build indexes on heavily accessed tables.
• B.Remove inactive user accounts.
• C.Run the Recommender API to identify overprovisioned instances.
• D.Use Query Insights to identify idle instances.

Comment: *

Name: *

Email: *

Verification: *