Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

• A.Migrate to Compute Engine.
• B.Migrate to Google Kubernetes Engine (GKE).
• C.Migrate to Cloud SQL for SQL Server.
• D.Migrate to Cloud SQL for PostgreSQL.

Comment: *

Name: *

Email: *

Verification: *

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?

• A.Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
• B.Use sharded Cloud SQL instances with one or more stores per database instance.
• C.Use a Biglable cluster with autoscaling.
• D.Use Cloud Spanner with a custom autoscaling solution.

Comment: *

Name: *

Email: *

Verification: *

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 need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

• A.Configure Firestore, and modify your application to offload queries.
• B.Configure Cloud SQL for PostgreSQL read replicas to offload queries.
• C.Configure Memorystore, and modify your application to offload queries.
• D.Configure Bigtable, and modify your application to offload queries.

Comment: *

Name: *

Email: *

Verification: *

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

• A.Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
• B.Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
• C.Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
• D.Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

Comment: *

Name: *

Email: *

Verification: *