Your organization has several datasets in BigQuery. The datasets need to be shared with your external partners so that they can run SQL queries without needing to copy the data to their own projects. You have organized each partner's data in its own BigQuery dataset. Each partner should be able to access only their dat a. You want to share the data while following Google-recommended practices. What should you do?

• A. Export the BigQuery data to a Cloud Storage bucket. Grant the partners the storage.objectUser IAM role on the bucket.
• B. Use Analytics Hub to create a listing on a private data exchange for each partner dataset. Allow each partner to subscribe to their respective listings.
• C. Create a Dataflow job that reads from each BigQuery dataset and pushes the data into a dedicated Pub /Sub topic for each partner. Grant each partner the pubsub. subscriber IAM role.
• D. Grant the partners the bigquery.user IAM role on the BigQuery project.

Your organization's website uses an on-premises MySQL as a backend database. You need to migrate the on-premises MySQL database to Google Cloud while maintaining MySQL features. You want to minimize administrative overhead and downtime. What should you do?

• A. Export the database tables to CSV files, and upload the files to Cloud Storage. Convert the MySQL schema to a Spanner schema, create a JSON manifest file, and run a Google-provided Dataflow template to load the data into Spanner.
• B. Install MySQL on a Compute Engine virtual machine. Export the database files using the mysqldump command. Upload the files to Cloud Storage, and import them into the MySQL instance on Compute Engine.
• C. Use a Google-provided Dataflow template to replicate the MySQL database in BigQuery.
• D. Use Database Migration Service to transfer the data to Cloud SQL for MySQL, and configure the on premises MySQL database as the source.

Your organization has several datasets in their data warehouse in BigQuery. Several analyst teams in different departments use the datasets to run queries. Your organization is concerned about the variability of their monthly BigQuery costs. You need to identify a solution that creates a fixed budget for costs associated with the queries run by each department. What should you do?

• A. Create a single reservation by using BigQuery editions. Assign all analysts to the reservation.
• B. Create a custom quota for each analyst in BigQuery.
• C. Assign each analyst to a separate project associated with their department. Create a single reservation by using BigQuery editions. Assign all projects to the reservation.
• D. Assign each analyst to a separate project associated with their department. Create a single reservation for each department by using BigQuery editions. Create assignments for each project in the appropriate reservation.

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

Your company uses Looker as its primary business intelligence platform. You want to use LookML to visualize the profit margin for each of your company's products in your Looker Explores and dashboards.
You need to implement a solution quickly and efficiently. What should you do?

• A. Apply a filter to only show products with a positive profit margin.
• B. Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).
• C. Define a new measure that calculates the profit margin by using the existing revenue and cost fields.
• D. Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.