3.2 Managing Storage and Data Solutions ASSOCIATE-CLOUD-ENGINEER Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   Which component in AlloyDB is backed up when you create a backup?

   • AThe entire cluster
   • BA single database
   • CA single table
   • DThe primary instance only
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A developer needs to query a Cloud SQL instance from a local machine using the gcloud command-line tool. They have the necessary IAM permissions. What is the correct command to run a SQL query?

   • Agcloud sql query INSTANCE_NAME --sql='SELECT * FROM table'
   • Bgcloud sql connect INSTANCE_NAME --user=USER
   • Cgcloud sql instances describe INSTANCE_NAME
   • Dgcloud sql instances list --filter='name=INSTANCE_NAME'
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which gcloud command lists Dataflow jobs?

   • Agcloud dataflow list
   • Bgcloud dataflow jobs list
   • Cgcloud dataflow status
   • Dgcloud jobs list
   Reveal Solution Discussion Select an answer first
5. 24application · easy

   A company has a fleet of Google Cloud databases including Cloud SQL, Spanner, and AlloyDB. They want a single view to monitor and manage all of them. Which service should they use?

   • ACloud Console's SQL page
   • BCloud Monitoring
   • CDatabase Center
   • DBigQuery console
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   Which feature in Cloud SQL automatically creates backups on a regular schedule?

   • AFailover
   • BPoint-in-time recovery
   • CAutomated backups
   • DReplication
   Reveal Solution Discussion Select an answer first