A company runs a production Cloud SQL instance. They want to ensure they can recover to any point within the last 7 days. Which configuration should they enable?

Take a manual backup every day and keep 7 backups.

Enable automated backups and set the backup start time to 1 AM.

Enable automated backups with a 7-day retention period.

Enable point-in-time recovery and configure binary logging with a 7-day retention.

An application needs to grant temporary, time-limited access to a specific object in a Cloud Storage bucket without modifying the bucket's IAM policies. Which mechanism should be used?

Add the user to the bucket's IAM policy with the Storage Object Viewer role

Create a signed URL for the object

Set a retention policy on the bucket

Enable versioning on the bucket

Google CloudAssociate Cloud Engineer

Domain 3Objective 2

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

Part of the Ensuring the successful operation of a cloud solution domain, which accounts for ~30% of the ASSOCIATE-CLOUD-ENGINEER exam.

58questions here

12free pages

24concepts

~30%of the exam

24 Concepts in This Objective

Cloud Storage bucket security
Cloud Storage object management
Object lifecycle management policies
Querying Cloud SQL
Querying BigQuery
Querying Bigtable
Querying Spanner
Querying Firestore
Querying AlloyDB
Estimating data storage costs
Backing up Cloud SQL
Restoring Cloud SQL
Backing up Firestore
Restoring Firestore
Backing up Spanner
Restoring Spanner
Backing up AlloyDB
Restoring AlloyDB
Backing up Bigtable
Restoring Bigtable
Reviewing Dataflow job status
Reviewing BigQuery job status
Using Database Center
Configuring CMEK for data storage

Questions 36–40

36application · medium
A company runs a production Cloud SQL instance. They want to ensure they can recover to any point within the last 7 days. Which configuration should they enable?
Select an answer first
37foundation · easy
Which SQL dialect does Cloud Spanner use for querying?
Select an answer first
38foundation · easy
An application needs to grant temporary, time-limited access to a specific object in a Cloud Storage bucket without modifying the bucket's IAM policies. Which mechanism should be used?
Select an answer first
39foundation · easy
Which feature in Firestore allows you to export data to a Cloud Storage bucket for backup purposes?
Select an answer first
40foundation · easy
Which tool can be used to check the status of a BigQuery job?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ASSOCIATE-CLOUD-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “ASSOCIATE-CLOUD-ENGINEER” is a trademark of its owner, used for identification only.

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

Questions 36–40

A company runs a production Cloud SQL instance. They want to ensure they can recover to any point within the last 7 days. Which configuration should they enable?

Which SQL dialect does Cloud Spanner use for querying?

An application needs to grant temporary, time-limited access to a specific object in a Cloud Storage bucket without modifying the bucket's IAM policies. Which mechanism should be used?

Which feature in Firestore allows you to export data to a Cloud Storage bucket for backup purposes?

Which tool can be used to check the status of a BigQuery job?

Keep studying — Ensuring the successful operation of a cloud solution