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

Questions 16–20

1. 16application · medium

   A company has a Cloud SQL instance and wants to import data from a SQL dump file stored in Cloud Storage. Which command should they use?

   • Agcloud sql import sql my-instance gs://bucket/dump.sql --database=my-db
   • Bgcloud sql import csv my-instance gs://bucket/dump.sql --database=my-db
   • Cbq load my-project:my-db.my-table gs://bucket/dump.sql
   • Dgsutil cp gs://bucket/dump.sql my-instance:my-db
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   An organization needs a fully managed, horizontally scalable NoSQL database for a global application that requires low-latency reads and writes at massive scale. Which Google Cloud data product is designed for this use case?

   • AFirestore
   • BSpanner
   • CBigtable
   • DCloud SQL
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A company needs to continuously transfer new files from an AWS S3 bucket to a Cloud Storage bucket. The transfer should be incremental, and they want to avoid manual intervention. Which solution should they use?

   • AUse Cloud Functions to trigger on S3 events and copy files to Cloud Storage.
   • BUse Transfer Appliance to continuously transfer data.
   • CSet up a Storage Transfer Service job with a schedule to run every hour.
   • DUse gsutil rsync in a cron job on a Compute Engine VM.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which Cloud Storage class is designed for data that is accessed less than once a year and has the lowest storage cost?

   • ANearline
   • BStandard
   • CColdline
   • DArchive
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company stores log files that are accessed frequently for the first 90 days, then rarely accessed but must be retained for 3 years. They want to minimize storage costs. Which storage class should they use for the initial 90 days?

   • AStandard
   • BArchive
   • CColdline
   • DNearline
   Reveal Solution Discussion Select an answer first