nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #159

You are planning to migrate a 10 TB relational database from an on-premises environment to Cloud SQL for PostgreSQL. The database contains sensitive customer information. You want to follow Google-rec

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #159. The question stem and answer options stay visible for context.

Securing Database Solutions

Question

You are planning to migrate a 10 TB relational database from an on-premises environment to 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 two.)

Options

  • AConfigure Cloud SQL for automatic patching, and enable binary logging.
  • BEstablish a Private Service Connect connection between your on-premises environment and the
  • CUse an external IP address for the Cloud SQL instance, and configure firewall rules.
  • DSet up Identity and Access Management (IAM) roles to restrict access with Cloud SQL with an
  • ELeverage Storage Transfer Service with client-side encryption.

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Cloud SQL Migration#Database Security#Networking#Identity and Access Management
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice