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

Questions 1–5

1. 1foundation · easy

   Which feature in Cloud Bigtable protects table data by creating a backup?

   • ASnapshot
   • BBigtable backups
   • CExport
   • DReplication
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which client library should a Python application use to execute SQL queries against a Cloud SQL for PostgreSQL instance?

   • Agoogle-cloud-bigquery
   • Bgoogle-cloud-spanner
   • Cpsycopg2
   • Dpymongo
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which tool can be used to schedule regular exports of Firestore data for backup?

   • ACloud Functions
   • BCloud SQL Proxy
   • CBigQuery Data Transfer Service
   • DCloud Scheduler
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A company uses Bigtable for time-series data. They need to protect against accidental deletion of a table. What should they do?

   • ASet a retention policy on the table.
   • BEnable versioning on the table.
   • CCreate a backup of the table and store it in the same instance.
   • DCreate a backup and store it in a different region.
   Reveal Solution Discussion Select an answer first
6. 5expert · medium

   A company runs frequent interactive queries on a BigQuery dataset. They notice that costs are higher than expected. They want to reduce costs without significantly impacting performance. Which approach is most effective?

   • AUse the bq command-line tool instead of the console.
   • BIncrease the number of slots for the project.
   • CPartition tables by date and filter queries by partition.
   • DUse the BigQuery storage write API for data ingestion.
   Reveal Solution Discussion Select an answer first