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

Questions 11–15

1. 11foundation · easy

   What is a primary benefit of using Looker to visualize data stored in BigQuery?

   • ALooker requires data to be exported to CSV files before analysis
   • BLooker automatically migrates BigQuery data to a separate database
   • CLooker replaces BigQuery as the data storage engine
   • DLooker can query BigQuery directly to create interactive dashboards
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   What is a key business value of streaming analytics?

   • AIt enables immediate action on data as events occur
   • BIt replaces all batch processing
   • CIt reduces the need for data storage
   • DIt eliminates the need for data quality checks
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A retail chain wants to detect and respond to fraudulent transactions as they occur, rather than after the fact. They currently batch-load transaction data into a data warehouse nightly. Which approach would best meet their need?

   • AMove the warehouse to BigQuery and run scheduled queries every 10 minutes.
   • BIncrease the frequency of the nightly batch load to every hour.
   • CUse Looker to create a dashboard that refreshes every 15 minutes from the nightly warehouse data.
   • DUse Pub/Sub to ingest transactions in real time and Dataflow to run streaming analytics that trigger alerts on suspicious patterns.
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A global retail company wants to provide real-time sales dashboards to regional managers. The data is streamed into BigQuery from thousands of stores. Managers need to see sales by region, product, and store, and they want to create their own views. However, the company also needs to control which managers can see which regions' data. What is the best way to meet these requirements?

   • AUse Looker with row-level access controls to restrict managers to their region, and build dashboards on BigQuery streaming data.
   • BCreate a separate BigQuery table for each region and give managers access to their region's table.
   • CUse Dataflow to filter the data by region before loading into BigQuery, and give all managers access to the filtered data.
   • DUse Looker to build dashboards but rely on managers to only look at their own region's data.
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A large enterprise has multiple business units, each with its own data warehouse. They want to provide a unified self-service BI platform that allows users to access data from all warehouses without moving the data. They also want to enforce consistent data definitions across the organization. What should they do?

   • AGive users direct access to each warehouse and let them combine data manually.
   • BUse Looker to connect to each warehouse and build a unified semantic layer with consistent definitions.
   • CMigrate all data into a single BigQuery instance and use Looker on top.
   • DUse Dataflow to copy data from all warehouses into a single Cloud Storage bucket and use Looker on that.
   Reveal Solution Discussion Select an answer first