2.2 Planning and Implementing Storage and Data Solutions ASSOCIATE-CLOUD-ENGINEER Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   A developer needs to create a Cloud SQL instance for a new application. Which command-line tool is used to create the instance?

   • Abq mk
   • Bgcloud compute instances create
   • Cgcloud sql instances create
   • Dgsutil mb
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   When deploying a Cloud SQL instance, which of the following is a required configuration step?

   • AEnabling the Cloud SQL Admin API
   • BAssigning a static external IP address
   • CCreating a VPC peering connection to every project
   • DConfiguring a failover replica
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which command imports a CSV file from Cloud Storage into a Cloud SQL instance?

   • Agcloud sql import csv instance-name gs://my-bucket/data.csv --database=dbname
   • Bgcloud sql import instance-name gs://my-bucket/data.csv
   • Cbq load --source_format=CSV instance-name gs://my-bucket/data.csv
   • Dgsutil cp gs://my-bucket/data.csv sql://instance-name/dbname
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   When creating a Filestore instance, which of the following is a required configuration?

   • AChoosing a file share name
   • BSelecting a multi-region location
   • CSetting up a snapshot schedule
   • DEnabling VPC peering
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which feature of Cloud SQL provides automatic failover to a replica in a different zone within the same region?

   • ARead replica
   • BBackup and restore
   • CPrivate IP
   • DHigh availability (HA) configuration
   Reveal Solution Discussion Select an answer first