Your company uses Looker to generate and share reports with various stakeholders. You have a complex dashboard with several visualizations that needs to be delivered to specific stakeholders on a recurring basis, with customized filters applied for each recipient. You need an efficient and scalable solution to automate the delivery of this customized dashboard. You want to follow the Google- recommended approach. What should you do?

• A. Create a separate LookML model for each stakeholder with predefined filters, and schedule the dashboards using the Looker Scheduler.
• B. Embed the Looker dashboard in a custom web application, and use the application's scheduling features to send the report with personalized filters.
• C. Create a script using the Looker Python SDK, and configure user attribute filter values. Generate a new scheduled plan for each stakeholder.
• D. Use the Looker Scheduler with a user attribute filter on the dashboard, and send the dashboard with personalized filters to each stakeholder based on their attributes.

You need to design a data pipeline to process large volumes of raw server log data stored in Cloud Storage.
The data needs to be cleaned, transformed, and aggregated before being loaded into BigQuery for analysis.
The transformation involves complex data manipulation using Spark scripts that your team developed. You need to implement a solution that leverages your team's existing skillset, processes data at scale, and minimizes cost. What should you do?

• A. Use Dataproc to run the transformations on a cluster.
• B. Use Cloud Data Fusion to visually design and manage the pipeline.
• C. Use Dataflow with a custom template for the transformation logic.
• D. Use Dataform to define the transformations in SQLX.

You need to transfer approximately 300 TB of data from your company's on-premises data center to Cloud Storage. You have 100 Mbps internet bandwidth, and the transfer needs to be completed as quickly as possible. What should you do?

• A. Request a Transfer Appliance, copy the data to the appliance, and ship it back to Google.
• B. Compress the data, upload it to multiple cloud storage providers, and then transfer the data to CloudStorage.
• C. Use the gcloud storage command to transfer the data over the internet.
• D. Use Cloud Client Libraries to transfer the data over the internet.

Your company uses Looker to visualize and analyze sales dat
a. You need to create a dashboard that displays sales metrics, such as sales by region, product category, and time period. Each metric relies on its own set of attributes distributed across several tables. You need to provide users the ability to filter the data by specific sales representatives and view individual transactions. You want to follow the Google-recommended approach. What should you do?

• A. Create a single Explore with all sales metrics. Build the dashboard using this Explore.
• B. Use Looker's custom visualization capabilities to create a single visualization that displays all the sales metrics with filtering and drill-down functionality.
• C. Use BigQuery to create multiple materialized views, each focusing on a specific sales metric. Build the dashboard using these views.
• D. Create multiple Explores, each focusing on each sales metric. Link the Explores together in a dashboard using drill-down functionality.