Your organization has decided to migrate their existing enterprise data warehouse to BigQuery. The existing data pipeline tools already support connectors to BigQuery. You need to identify a data migration approach that optimizes migration speed. What should you do?

• A. Use the existing data pipeline tool's BigQuery connector to reconfigure the data mapping.
• B. Use the Cloud Data Fusion web interface to build data pipelines. Create a directed acyclic graph (DAG) that facilitates pipeline orchestration.
• C. Use the BigQuery Data Transfer Service to recreate the data pipeline and migrate the data into BigQuery.
• D. Create a temporary file system to facilitate data transfer from the existing environment to Cloud Storage. Use Storage Transfer Service to migrate the data into BigQuery.

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

You created a curated dataset of market trends in BigQuery that you want to share with multiple external partners. You want to control the rows and columns that each partner has access to. You want to follow Google-recommended practices. What should you do?

• A. Publish the dataset in Analytics Hub. Grant dataset-level access to each partner by using subscriptions.
• B. Grant each partner read access to the BigQuery dataset by using 1AM roles.
• C. Create a separate Cloud Storage bucket for each partner. Export the dataset to each bucket and assign each partner to their respective bucket. Grant bucket-level access by using 1AM roles.
• D. Create a separate project for each partner and copy the dataset into each project. Publish each dataset in Analytics Hub. Grant dataset-level access to each partner by using subscriptions.

Your team wants to create a monthly report to analyze inventory data that is updated daily. You need to aggregate the inventory counts by using only the most recent month of data, and save the results to be used in a Looker Studio dashboard. What should you do?

• A. Create a materialized view in BigQuery that uses the SUM() function and the DATE_SUB() function.
• B. Create a BigQuery table that uses the SUM() function and the DATE_DIFF() function.
• C. Create a saved query in the BigQuery console that uses the SUM() function and the DATE_SUB() function. Re-run the saved query every month, and save the results to a BigQuery table.
• D. Create a BigQuery table that uses the SUM() function and the _PARTITIONDATE filter.