PDE Designing Data Processing Systems Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  IAM roles

  Why it's wrong here

  IAM roles grant principals access to the underlying tables themselves, so recipients could query the data directly rather than only the results. Authorised views are the mechanism for sharing query output without table access. IAM roles suit granting service or user permissions across Google Cloud resources, not result-only sharing.

• ✓

  Authorized views

  Why this is correct

  Authorized views run with the view owner's permissions, so grantees query the view and see results without any direct table access. This satisfies the requirement to share query results with specific users while withholding underlying table permissions.

• ✗

  Dataset access controls

  Why it's wrong here

  Dataset access controls grant principals permission to the dataset itself, so recipients can query the underlying tables directly; they do not restrict visibility to query results. They are tempting because they are the standard sharing mechanism, and would be correct where the requirement is granting table-level access rather than exposing only results.

• ✗

  Materialized views

  Why it's wrong here

  Materialized views cache precomputed results for query acceleration and refresh, but they do not grant recipients access to those results; sharing requires authorised views or authorised datasets. They are tempting because they store derived data, and would be correct where the requirement is performance rather than controlled data sharing.