Google Professional Data Engineer

Ultimate access to all questions.

Explanation:

The optimal method involves creating and sharing an authorized view that provides aggregate results. This approach ensures:

Data Control: Authorized views act as virtual tables, displaying only the results of a specified SQL query, thus restricting access to underlying user-level data.
Cost Efficiency: Since authorized views don't store additional data, they eliminate the need for separate data copies, reducing storage and analysis costs.
Ease of Sharing: These views can be easily shared across projects within or outside the organization.

Other options are less ideal due to increased storage needs, potential data inconsistencies, or lack of inherent data aggregation capabilities.

Explanation:

The optimal method involves creating and sharing an authorized view that provides aggregate results. This approach ensures:

Data Control: Authorized views act as virtual tables, displaying only the results of a specified SQL query, thus restricting access to underlying user-level data.
Cost Efficiency: Since authorized views don't store additional data, they eliminate the need for separate data copies, reducing storage and analysis costs.
Ease of Sharing: These views can be easily shared across projects within or outside the organization.

Other options are less ideal due to increased storage needs, potential data inconsistencies, or lack of inherent data aggregation capabilities.

Comments (0)

No comments yet.

Real Exam

Establish a new dataset and table containing the aggregated results for sharing.

2.9%

Create and share an authorized view that offers the aggregate results.

64.7%

Implement dataViewer IAM roles on the dataset to facilitate sharing.

23.5%

Develop a new dataset and view that provides the aggregate results for sharing.

8.8%