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

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions.
You want to follow Google-recommended practices for the migration. What should you do?

• A.Create a read replica in another region, and promote the read replica if a failure occurs.
• B.Enable high availability (HA) for the database to make it regional.
• C.Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
• D.Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?

• A.Replicate Cloud SQL databases across different zones.
• B.Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
• C.Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
• D.Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on- premises. Make application changes to support both databases.

You are planning to migrate a 10TB relational database from an on-premises environment la Cloud SQL for PostgreSQL. The database contains sensitive customer Information. You want to follow Google-recommended practices to keep data secure during the migration.
What should you do?
Choose 2 answers

• A.Leverage Storage Transfer Service with client side encryption.
• B.Set up identity Access Management JIAM) roles to restrict access with Cloud SQL with an internal IP address.
• C.Establish a Private Se-vice Connect connection between your on-premises environment and the Cloud SQL instance
• D.Use an external IH address for the Cloud SQL Instance, and configure firewall rules.
• E.Configure Cloud SQL for automatic patching, and enable binary logging.

Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

• A.Promote low-cardinality attributes in multi-attribute primary keys.
• B.Use bit-reverse sequential value as the primary key.
• C.Promote high-cardinality attributes in multi-attribute primary keys.
• D.Normalize the data model.
• E.Use an auto-incrementing value as the primary key.

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.Use Query Insights to identify idle instances.
• B.Remove inactive user accounts.
• C.Build indexes on heavily accessed tables.
• D.Run the Recommender API to identify overprovisioned instances.