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

Questions 46–50

1. 46expert · medium

   A company stores sensitive documents in a Cloud Storage bucket. They have a compliance requirement to keep documents for 5 years, but they also want to minimize storage costs by moving older documents to a cheaper storage class. They also need to ensure that documents cannot be deleted before the 5-year period. Which configuration should they implement?

   • ASet a lifecycle rule to transition to Archive after 1 year and delete after 5 years.
   • BSet a lifecycle rule to delete objects after 5 years and enable versioning.
   • CUse object holds and a lifecycle rule to transition to Coldline after 1 year.
   • DSet a retention policy of 5 years and a lifecycle rule to transition objects to Coldline after 1 year.
   Reveal Solution Discussion Select an answer first
2. 47foundation · easy

   Which service charges based on the amount of data processed by queries rather than storage?

   • AFirestore
   • BCloud Storage
   • CCloud SQL
   • DBigQuery
   Reveal Solution Discussion Select an answer first
4. 48foundation · easy

   Which tool can be used to connect to an AlloyDB instance and run SQL queries?

   • Amongo
   • Bmysql
   • Credis-cli
   • Dpsql
   Reveal Solution Discussion Select an answer first
5. 49foundation · easy

   A developer wants to run a SQL query against a Cloud SQL instance from the command line. Which tool should be used?

   • Agcloud compute ssh
   • Bgcloud storage cp
   • Cgcloud functions call
   • Dgcloud sql connect
   Reveal Solution Discussion Select an answer first
6. 50foundation · easy

   Which factor directly affects the cost of a BigQuery query?

   • AThe storage class of the dataset
   • BThe number of tables in the dataset
   • CThe number of users running the query
   • DThe amount of data processed by the query
   Reveal Solution Discussion Select an answer first