1.2 Extract and Load Data into Appropriate Google Cloud Storage Systems ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 5)

Questions 21–23

1. 21foundation · easy

   A company needs to transfer large amounts of data from an on-premises data center to Cloud Storage on a one-time basis. The data is several terabytes. Which tool is designed for this type of transfer?

   • AStorage Transfer Service
   • Bbq CLI
   • CClient libraries
   • Dgcloud CLI
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A company needs to store application configuration data that is read frequently and must be highly available. The data is small (a few MB) and does not change often. The company wants to minimize latency for users in North America. Which storage solution and location type should they choose?

   • ACloud SQL with a regional instance in us-central1
   • BFirestore with a regional location in us-central1
   • CBigtable with a regional instance in us-central1
   • DCloud Storage with a multi-regional bucket in the US
   Reveal Solution Discussion Select an answer first
3. 23application · medium

   A data engineer needs to load a 500 GB CSV file from a local on-premises server into a BigQuery table. The file is too large to upload through the console, and the engineer wants to use a command-line tool. Which approach should they use?

   • AUse the BigQuery Data Transfer Service to load the local file
   • BUse the bq load command with the local file path
   • CUpload the file to Cloud Storage using gsutil, then use bq load to load from Cloud Storage
   • DUse the gcloud CLI to directly load the file into BigQuery
   Reveal Solution Discussion Select an answer first