Exam Professional Data Engineer topic 1 question 75 discussion

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

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.

When other projects query the authorized view, the query costs are billed to the project that runs the query

I think both A and B are totally valid answers, making this a fairly stupid question. But as a DBA, B would be easier to implement, easier to manage, easier to audit. So even if it's the wrong answer, it's still the right solution, so I can't help but choose B.

B is the correct Ans You are correct in noting that creating a view within an existing dataset could potentially expose other tables within that dataset if the dataset-level permissions are not carefully managed. To ensure that only the aggregate results are shared and to avoid inadvertently exposing other tables, it is indeed a good practice to create a new dataset specifically for the view. Revised Answer: B. Create and share a new dataset and view that provides the aggregate results.

A. Create and share an authorized view that provides the aggregate results. An authorized view is a BigQuery feature that allows you to share only a specific subset of data from a table, while still keeping the original data private. This way, the organization can expose only the aggregate data to other projects, while still controlling access to the user-level data. By using an authorized view, the organization can minimize their overall storage cost as the aggregate data takes up less storage space than the original data. Additionally, by using authorized view, the analysis cost for other projects is assigned to those projects.

I thing that is B because for security yo need to create a new data set when share a view, apart when yo grant access the top level is a data set if you share a view in same dataset that you have your tables, that access can see all tables inside dataset.

"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." https://cloud.google.com/bigquery/docs/share-access-views?hl=en#console_5

Selected Answer: A B is wrong by itself. why do you need to create a view, if you have already created an aggregated dataset?

"they need to minimize their overall storage cost". Also, you are sharing the aggregate's results, not the underlying table

minimize cost so view

A should be the answer, as we need to separate costs according to projects. As in the following SO question (and the attached google resources), the 'project that runs the queries is the project that gets billed.' So we can generate a view and give it's access to the other project to run the analysis https://stackoverflow.com/questions/52201034/bigquery-authorized-view-cost-billing-account

I will go with A, as i wanna save cost, dont need to create separate dataset for permanent storage.

A. Create and share an authorized view that provides the aggregate results. An authorized view is a BigQuery feature that allows you to share only a specific subset of data from a table, while still keeping the original data private. This way, the organization can expose only the aggregate data to other projects, while still controlling access to the user-level data. By using an authorized view, the organization can minimize their overall storage cost as the aggregate data takes up less storage space than the original data. Additionally, by using authorized view, the analysis cost for other projects is assigned to those projects.

Ensure the analysis cost for other projects is assigned to those projects indicates B is the correct answer.

B is the correct answer

I would say 1 too