A financial services firm wants to give its analysts a unified view of trading data that is updated continuously, with the ability to create custom reports without IT help. The data is already in BigQuery. What should they do?

Use Looker to build a semantic layer on BigQuery and let analysts create their own dashboards.

Use Cloud Functions to generate PDF reports from BigQuery data daily.

Use Pub/Sub to send BigQuery data to analysts' email inboxes.

Use Dataflow to copy BigQuery data into a spreadsheet that analysts can edit.

A non-profit organization wants to track donor engagement and campaign effectiveness. They have a small data team and want to enable program managers to create their own reports without learning SQL. What should they implement?

A custom report built by the data team and emailed monthly.

Direct access to BigQuery for program managers to run SQL queries.

A shared Google Sheet that the data team updates manually.

Looker on top of BigQuery to provide a user-friendly, self-service analytics platform.

Which scenario best illustrates the value of streaming analytics?

An analyst runs a one-time query to explore customer demographics

A data team cleans and transforms data overnight

A company generates a monthly sales report from historical data

A bank detects and blocks fraudulent credit card transactions within milliseconds

A healthcare organization wants to analyze patient outcomes and also provide clinicians with a tool to explore treatment effectiveness. They have strict data privacy requirements and need to ensure that only authorized clinicians can see patient-level data. They also want to use the data for a research study that requires aggregated data only. What is the best approach?

Use Cloud Storage to store the data and share it with clinicians and researchers via separate buckets.

Use Dataflow to anonymize the data before loading into BigQuery, and give everyone access to the anonymized data.

Use Looker for both clinician access and research, giving researchers the same access as clinicians.

Use BigQuery for analysis, Looker with row-level security for clinician access, and BigQuery views to provide aggregated data for research.

Why is the integration between BigQuery and Looker valuable for real-time reporting?

It enables Looker to process streaming data before it reaches BigQuery

It automatically creates data pipelines to load data into BigQuery

It allows dashboards to reflect the latest data as soon as it is loaded into BigQuery

It requires data to be copied to Looker's internal storage for faster access

Google CloudCloud Digital Leader

Domain 2Objective 3

Making Data Useful and Accessible 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.

27questions here

6free pages

5concepts

~16%of the exam

Questions 16–20

16application · medium
A financial services firm wants to give its analysts a unified view of trading data that is updated continuously, with the ability to create custom reports without IT help. The data is already in BigQuery. What should they do?
Select an answer first
17application · medium
A non-profit organization wants to track donor engagement and campaign effectiveness. They have a small data team and want to enable program managers to create their own reports without learning SQL. What should they implement?
Select an answer first
18foundation · easy
Which scenario best illustrates the value of streaming analytics?
Select an answer first
19expert · hard
A healthcare organization wants to analyze patient outcomes and also provide clinicians with a tool to explore treatment effectiveness. They have strict data privacy requirements and need to ensure that only authorized clinicians can see patient-level data. They also want to use the data for a research study that requires aggregated data only. What is the best approach?
Select an answer first
20foundation · easy
Why is the integration between BigQuery and Looker valuable for real-time reporting?
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.