A team needs to load data from a transactional database (Cloud SQL) into BigQuery for analytics. The data changes frequently, and they need the analytics to be as up-to-date as possible, but they can tolerate a few minutes of delay. They want to minimize operational overhead. What is the best approach?

Use a scheduled Cloud Function to export the Cloud SQL table to Cloud Storage and then load into BigQuery.

Use Dataflow to continuously read from Cloud SQL and write to BigQuery.

Use Cloud Functions to trigger on Cloud SQL changes and insert into BigQuery.

Use Datastream to replicate data from Cloud SQL to BigQuery.

A company is migrating a legacy application from an on-premises PostgreSQL database to Google Cloud. The application requires strong consistency for financial transactions. The team is considering Cloud SQL and Cloud Spanner. What is the most important factor in their decision?

Cloud SQL is regional, while Spanner is global.

Cloud SQL is cheaper than Spanner for all workloads.

Cloud SQL is a fully-managed relational database, while Spanner is a NoSQL database.

Cloud SQL provides strong consistency, while Spanner provides eventual consistency.

A company needs to store and analyze clickstream data from their website. The data is high-volume, append-only, and used for real-time dashboards and ad-hoc analytical queries. They also need to store user profile data that is read frequently and updated occasionally. Which combination of services is most appropriate?

Cloud Spanner for clickstream data and Cloud SQL for user profiles.

BigQuery for clickstream data and Cloud Firestore for user profiles.

Cloud Bigtable for clickstream data and Cloud Firestore for user profiles.

Cloud Storage for clickstream data and Cloud Bigtable for user profiles.

A company stores monthly financial reports in Cloud Storage. They want to share a specific report with an external auditor for 7 days without making the bucket public. What is the most secure and appropriate method?

Copy the object to a new bucket with a random name and share the bucket path.

Generate a signed URL for the object with a 7-day expiration and share it with the auditor.

Create a new IAM role for the auditor and grant them Storage Object Viewer on the project.

Make the bucket public for 7 days and then make it private again.

Google CloudProfessional Cloud Developer

Domain 1Objective 3

1.3 Storing and Accessing Data PROFESSIONAL-CLOUD-DEVELOPER Practice Questions (Page 4)

Part of the Designing highly scalable, secure, and reliable cloud-native applications domain, which accounts for ~32% of the PROFESSIONAL-CLOUD-DEVELOPER exam.

24questions here

5free pages

6concepts

~32%of the exam

Questions 16–20

16expert · hard
A team needs to load data from a transactional database (Cloud SQL) into BigQuery for analytics. The data changes frequently, and they need the analytics to be as up-to-date as possible, but they can tolerate a few minutes of delay. They want to minimize operational overhead. What is the best approach?
Select an answer first
17expert · hard
A company is migrating a legacy application from an on-premises PostgreSQL database to Google Cloud. The application requires strong consistency for financial transactions. The team is considering Cloud SQL and Cloud Spanner. What is the most important factor in their decision?
Select an answer first
18expert · medium
A company needs to store and analyze clickstream data from their website. The data is high-volume, append-only, and used for real-time dashboards and ad-hoc analytical queries. They also need to store user profile data that is read frequently and updated occasionally. Which combination of services is most appropriate?
Select an answer first
19application · medium
A company stores monthly financial reports in Cloud Storage. They want to share a specific report with an external auditor for 7 days without making the bucket public. What is the most secure and appropriate method?
Select an answer first
20foundation · easy
Which component is required to generate a signed URL for a Cloud Storage object?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-CLOUD-DEVELOPER

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. “PROFESSIONAL-CLOUD-DEVELOPER” is a trademark of its owner, used for identification only.

1.3 Storing and Accessing Data PROFESSIONAL-CLOUD-DEVELOPER Practice Questions (Page 4)

Questions 16–20

A company is migrating a legacy application from an on-premises PostgreSQL database to Google Cloud. The application requires strong consistency for financial transactions. The team is considering Cloud SQL and Cloud Spanner. What is the most important factor in their decision?

A company stores monthly financial reports in Cloud Storage. They want to share a specific report with an external auditor for 7 days without making the bucket public. What is the most secure and appropriate method?

Which component is required to generate a signed URL for a Cloud Storage object?

Keep studying — Designing highly scalable, secure, and reliable cloud-native applications