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. 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.
• B. Grant each partner read access to the BigQuery dataset by using 1AM roles.
• C. 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.
• D. Publish the dataset in Analytics Hub. Grant dataset-level access to each partner by using subscriptions.

Your organization uses scheduled queries to perform transformations on data stored in BigQuery. You discover that one of your scheduled queries has failed. You need to troubleshoot the issue as quickly as possible. What should you do?

• A. Set up a log sink using the gcloud CLI to export BigQuery audit logs to BigQuery. Query those logs to identify the error associated with the failed job I
• B. Request access from your admin to the BigQuery information_schema. Query the jobs view with the failed job ID, and analyze error details.
• C. Navigate to the Scheduled queries page in the Google Cloud console. Select the failed job, and analyze the error details.
• D. Navigate to the Logs Explorer page in Cloud Logging. Use filters to find the failed job, and analyze the error details.

Your organization is conducting analysis on regional sales metrics. Data from each regional sales team is stored as separate tables in BigQuery and updated monthly. You need to create a solution that identifies the top three regions with the highest monthly sales for the next three months. You want the solution to automatically provide up-to-date results. What should you do?

• A. Create a BigQuery materialized view that performs a union across all of the regional sales tables. Use the rank() window function to query the new materialized view.
• B. Create a BigQuery table that performs a union across all of the regional sales tables. Use the row_number() window function to query the new table.
• C. Create a BigQuery materialized view that performs a cross join across all of the regional sales tables. Use the row_number() window function to query the new materialized view.
• D. Create a BigQuery table that performs a cross join across all of the regional sales tables. Use the rank() window function to query the new table.

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. 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.
• B. Create a script using the Looker Python SDK, and configure user attribute filter values. Generate a new scheduled plan for each stakeholder.
• C. Create a separate LookML model for each stakeholder with predefined filters, and schedule the dashboards using the Looker Scheduler.
• D. Embed the Looker dashboard in a custom web application, and use the application's scheduling features to send the report with personalized filters.

You are a data analyst working with sensitive customer data in BigQuery. You need to ensure that only authorized personnel within your organization can query this data, while following the principle of least privilege. What should you do?

• A. Enable access control by using IAM roles.
• B. Update dataset privileges by using the SQL GRANT statement.
• C. Encrypt the data by using customer-managed encryption keys (CMEK).
• D. Export the data to Cloud Storage, and use signed URLs to authorize access.