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.
ユーザの投票
コメント(17)
- 正解だと思う選択肢: B
The link on authorized views (https://cloud.google.com/bigquery/docs/share-access-views) explicitly states "Authorized views should be created in a different dataset from the source data. That way, data owners can give users access to the authorized view without simultaneously granting access to the underlying data." therefore B is the correct answer because we are to create a new dataset and view within that dataset.
👍 11[Removed]2022/10/25 - 正解だと思う選択肢: A
A is the answer. Don't be confused by the documentation saying "Authorized views should be created in a different dataset". It is a best practice but not a technical requirement. And we don't create a new dataset for each authorized view. If you are not clear on this, try in the system, don't just read the documentation without understanding. B is wrong when saying we must SHARE Dataset. Although creating a dataset and view in it will not incur extra cost, but sharing dataset is something we always try not to do. At for the project that run the query it the project to be billed, that is standard behaviour. View only give access to data, whoever run the view will need pay for the query cost
👍 10midgoo2023/03/01 That's ambiguous. While A is correct, B is the recommended approach: "Authorized views should be created in a different dataset from the source data. That way, data owners can give users access to the authorized view without simultaneously granting access to the underlying data. The source data dataset and authorized view dataset must be in the same regional location."
Bit it doesn't say "authorised view" in B.
👍 5Gudwin2022/11/30
シャッフルモード
