PDBE-2

You're creating a new VM application on your corporate network that will be used. To connect to the Cloud SQL database for PostgreSQL, the application will use the Java Database Connectivity, JDBC. An IP address of 192.168.3.48 has been configured for your Cloud SQL instance, and SSL is not supported. In order to ensure that your application is able to access a database instance without requiring configuration changes for the database, you want to make sure. What are you supposed to do?

• Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL

  instance.

• Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL

  instance.

• . 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.

• 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.

Your Digitalnative business uses Cloud SQL to run its database workload. You must be able to access your website anywhere in the world 24 hours a day. You've got to get ready Cloud SQL instance for high availability (HA). You'd like to follow the Googlerecommended practice. What are you going to do? (Choose two.)

• Set up manual backups.

• Create a PostgreSQL database on-premises as the HA option.

• Configure single zone availability for automated backups.

• Enable point-in-time recovery

• Schedule automated backups.

Your company wants to move to Google Cloud. Six months from now, your current data center will be closing. You're running a very large, highly commercial business. Oracle application footprint on VMWare. In order to provide ease of migration to Google Cloud, you must design a solution that does not disrupt the current architecture in any way. What are you supposed to be doing?

• Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine)

• Migrate applications and Oracle databases to Compute Engine.

• Migrate applications to Cloud SQL.

• Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).

A multiregional Cloud Spanner instance is being used by your customer's global chat application. After the new version of the application was released, it has recently encountered a drop in performance. You've been requested to assist your client. You have observed high reading delays in your first troubleshooting session. What are you supposed to do?

• Use query parameters to speed up frequently executed queries.

• Change the Cloud Spanner configuration from multi-region to single region.

• Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

• Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables

PostgreSQL databases are available at your company's premises and in Amazon Web ServicesAWS: You plan to move the database multiple times Cloud SQL in an effort to reduce costs and downtime. Use Google's native data migration tools if you want to comply with the recommendations of Google. You also want to closely monitor the migrations as part of the cutover strategy. What are you going to do?

• Use Database Migration Service to migrate all databases to Cloud SQL.

• Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style

  migrations.

• Use data replication tools and CDC tools to enable migration.

• Use a combination of Database Migration Service and partner tools to support the data migration strategy.

You're setting up a bare metal solution environment. The latest version of the operating system needs to be updated. You'll have to make the connection. Bare Metal Solution environment to the internet so you can receive software updates. What are you supposed to do?

• Setup a static external IP address in your VPC network.

• Set up bring your own IP (BYOIP) in your VPC.

• Set up a Cloud NAT gateway on the Compute Engine VM.

• Set up Cloud NAT service.

In Cloud SQL, your organization is running a MySQL workload. You'll notice a slowdown in database performance at this point. The root cause of performance degradation must be determined. What's your thing to do?

• Use Logs Explorer to analyze log data.

• Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

• Use Error Reporting to count, analyze, and aggregate the data.

• Use Cloud Debugger to inspect the state of an application.

You're working for a large retail and e commerce company, which is beginning to expand its business worldwide. You're planning to migrate your company to Google. Cloud. Platforms that can scale easily, handle transactions with the least latency and provide a reliable customer experience are what you need to use. For sales transactions and the existing inventory level, you need a storage layer. You'd like to keep your existing platform's Relational Schema in place. What are you going to do?

• Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.

• Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

• Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

• D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region

You're running an application on Google Cloud. The application is based on a single area, using cloud SQL to store transactions data. The majority of your users are located in the same time zone, and expect the application to be available seven days a week, from 6:00 a.m. to 10:00 p.m. Without causing users to have their computers unavailable, you want your Cloud SQL Instance to be regularly updated. What should you do ?

• Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting nonproduction instances to earlier and production instances to later.

• Create your database with one primary node and one read replica in the region.

• Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

• Configure your Cloud SQL instance with high availability enabled.

In order to accommodate more users, your team just released a new version of an application that's been extremely heavily used. You received an alert from your production monitoring team shortly after the release that there was a persistent high replication lag between the primary instance and the read replicas of your Cloud SQL for MySQL Instances. A replication delay needs to be resolved. What are you supposed to be doing?

• Identify and optimize slow running queries, or set parallel replication flags.

• Stop all running queries, and re-create the replicas.

• Edit the primary instance to upgrade to a larger disk, and increase vCPU count.

• Edit the primary instance to add additional memory.