Examtopics

Professional Data Engineer
  • Topic 1 Question 75

    An organization maintains a Google BigQuery dataset that contains tables with user-level data. They want to expose aggregates of this data to other Google Cloud projects, while still controlling access to the user-level data. Additionally, they need to minimize their overall storage cost and ensure the analysis cost for other projects is assigned to those projects. What should they do?

    • Create and share an authorized view that provides the aggregate results.

    • Create and share a new dataset and view that provides the aggregate results.

    • Create and share a new dataset and table that contains the aggregate results.

    • Create dataViewer Identity and Access Management (IAM) roles on the dataset to enable sharing.


    シャッフルモード