Professional-Cloud-Database-Engineer 무료 덤프문제 온라인 액세스

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

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS).
You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy.
What should you do?

• A.Use data replication tools and CDC tools to enable migration.
• B.Use a combination of Database Migration Service and partner tools to support the data migration strategy.
• C.Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
• D.Use Database Migration Service to migrate all databases to Cloud SQL.

You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?

• A.Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
• B.Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
• C.Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
• D.Create a VM in Compute Engine, and run a cron job.

You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL.
You need to be able to monitor database performance to easily identify applications with long- running and resource-intensive queries. What should you do?

• A.Use Cloud SQL instance monitoring in the Google Cloud Console.
• B.Use log messages produced by Cloud SQL.
• C.Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
• D.Use Query Insights for Cloud SQL.

You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?

• A.Use Bigtable with default encryption.
• B.Use Cloud SQL with a customer-managed encryption key (CMEK).
• C.Use Cloud Spanner with a customer-managed encryption key (CMEK).
• D.Use Cloud Spanner with default encryption.