A company stores customer transaction logs that must be retained for 7 years for compliance. The logs are accessed frequently for the first 30 days, then rarely (a few times a year). They want to minimize storage costs while ensuring that logs from the first 30 days are available with low latency. What is the most cost-effective strategy?

Store in Nearline for 30 days, then move to Coldline

Store in Standard for 30 days, then move to Archive for the remaining period

A company wants to run business intelligence reports that combine data from their on-premises data warehouse and data in Google Cloud. They want to avoid moving the on-premises data and need a solution that can query both sources. Which approach should they take?

Use BigQuery to query the on-premises data via federated queries

Use Cloud SQL to replicate the on-premises data

Use Cloud Spanner as a federated query engine

Migrate all on-premises data to Cloud Storage

Google CloudCloud Digital Leader

Domain 2Objective 2

Google Cloud Data Management Solutions CLOUD-DIGITAL-LEADER Practice Questions (Page 4)

Part of the Exploring Data Transformation with Google Cloud domain, which accounts for ~16% of the CLOUD-DIGITAL-LEADER exam.

25questions here

5free pages

6concepts

~16%of the exam

Questions 16–20

16foundation · easy
Which Google Cloud data management option is a serverless data warehouse designed for analyzing large datasets using SQL?
Select an answer first
17expert · hard
A company stores customer transaction logs that must be retained for 7 years for compliance. The logs are accessed frequently for the first 30 days, then rarely (a few times a year). They want to minimize storage costs while ensuring that logs from the first 30 days are available with low latency. What is the most cost-effective strategy?
Select an answer first
18application · medium
A retail company wants to store product catalog data that is accessed frequently by a web application. The data is structured, requires strong consistency, and must support complex SQL queries with joins. The expected read/write volume is moderate, and the company prefers a fully managed service to minimize operational overhead. Which Google Cloud data management product should they choose?
Select an answer first
19application · medium
A company wants to run business intelligence reports that combine data from their on-premises data warehouse and data in Google Cloud. They want to avoid moving the on-premises data and need a solution that can query both sources. Which approach should they take?
Select an answer first
20foundation · easy
Which migration approach involves moving a database to a managed service like Cloud SQL while making minimal changes to the application?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to CLOUD-DIGITAL-LEADER

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

Google Cloud Data Management Solutions CLOUD-DIGITAL-LEADER Practice Questions (Page 4)

Questions 16–20

Which Google Cloud data management option is a serverless data warehouse designed for analyzing large datasets using SQL?

A company wants to run business intelligence reports that combine data from their on-premises data warehouse and data in Google Cloud. They want to avoid moving the on-premises data and need a solution that can query both sources. Which approach should they take?

Which migration approach involves moving a database to a managed service like Cloud SQL while making minimal changes to the application?

Keep studying — Exploring Data Transformation with Google Cloud