Making Data Useful and Accessible CLOUD-DIGITAL-LEADER Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   What is a key benefit of Looker's self-service business intelligence model for business users?

   • AUsers can only view pre-built dashboards created by data engineers
   • BUsers must export data to spreadsheets for all analysis
   • CUsers can create their own reports and dashboards without needing to write complex code
   • DUsers must rely on IT to generate every report
   Reveal Solution Discussion Select an answer first
2. 22expert · hard

   A financial trading firm needs to detect anomalies in market data and execute automated trades within milliseconds. They also need to maintain a complete audit trail of all trades for regulatory compliance. Which approach best balances these requirements?

   • AUse BigQuery for real-time anomaly detection and Cloud Storage for the audit trail.
   • BUse Pub/Sub for low-latency ingestion, Dataflow for real-time anomaly detection, and BigQuery for storing the audit trail.
   • CUse Dataflow for both real-time detection and storing the audit trail in its internal state.
   • DUse Cloud Functions for real-time detection and Cloud SQL for the audit trail.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A utility company wants to detect power outages and notify customers within seconds of an outage event, rather than waiting for customer calls. Which solution best achieves this?

   • AUse Looker to visualize historical outage data and manually review it each day.
   • BStore sensor data in Cloud Storage and run a weekly analysis to identify outage trends.
   • CCollect sensor data in a nightly batch job and send notifications the next morning.
   • DStream sensor data from smart meters into Pub/Sub, use Dataflow to detect outage patterns, and trigger notifications.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A manufacturing company wants to identify which production lines are most efficient by analyzing sensor data collected over the past year. They also want to give plant managers a way to explore the data themselves. What is the best approach?

   • ALoad the historical sensor data into BigQuery and use Looker to provide self-service dashboards for plant managers.
   • BUse Cloud Functions to generate a one-time report and email it to plant managers.
   • CStore the sensor data in Cloud Storage and share it with plant managers via a download link.
   • DStream the historical data through Pub/Sub and process it with Dataflow in real time.
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A ride-sharing company wants to track the location of all active drivers in real time to optimize dispatching. They need to ingest location updates from millions of drivers and process them to identify the nearest available driver. Which Google Cloud products should they use?

   • APub/Sub to ingest location updates and Dataflow to process the stream and compute nearest drivers.
   • BCloud SQL to store locations and Cloud Scheduler to run queries every minute.
   • CCloud Storage to store location files and Cloud Functions to process them on a schedule.
   • DBigQuery to ingest location updates directly and Looker to visualize them.
   Reveal Solution Discussion Select an answer first