Answer-first summary for fast verification
Answer: Create an Analytics Hub private exchange, and publish the sales dataset.
Creating an Analytics Hub private exchange in BigQuery is the optimal solution for sharing the sales dataset across departments. It offers a secure, centralized platform for dataset management and sharing, ensuring only authorized access. This method is scalable, supports compliance, and minimizes maintenance efforts. **Why other options are less suitable:** - **A:** Granting direct access to authorized views can lead to data duplication and security risks, lacking the centralized control and scalability of Analytics Hub. - **B:** Manually sharing views is inefficient for large or frequently updated datasets, lacking the automation and central management features. - **C:** The BigQuery Data Transfer Service is better suited for data replication tasks like backups, not for general dataset sharing within an organization.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You've set up a BigQuery data warehouse for sales data analysis. What's the best way to share this dataset with other departments in your organization, ensuring it's easy to use, requires minimal upkeep, and is cost-efficient?
A
Enable the other business units' projects to access the authorized views of the sales dataset.
B
Create and share views with the users in the other business units.
C
Use the BigQuery Data Transfer Service to create a schedule that copies the sales dataset to the other business units' projects.
D
Create an Analytics Hub private exchange, and publish the sales dataset.
No comments yet.