Objective 1.1
PDEDesigning for security and compliance
Objective 1.1 sits in Designing data processing systems, which carries 22% of the Data Engineer exam. The questions below are original, written from the official objective title above, and each explanation cites the Google Cloud page it rests on.
Objective title verbatim from the official objectives. Google Cloud exam page ↗
A worked example
Shown solved, with the whole explanation open: this is what every question here carries.
An analyst without fine-grained read access on a policy-tagged column runs a plain INSERT of new rows into that table. What happens to the insert?
Correct.
Concept
Fine-grained controls guard the act of observing stored values, so an operation is gated by whether it must look at existing data, not by whether it changes the table.
Why D
An insert does not require fine-grained read access on the protected column. The person inserting still cannot read what was written unless granted that access.
Source
Google Cloud: Introduction to column-level access control, checked August 2026To write data to a row for a column that is protected by column-level access control, the user requirement depends on the type of write. If the write operation is an insert , fine-grained read access is not required. However, the user doesn't have access to read the data that was inserted, unless the user has fine-grained read access.
Now you: objective 1.1 questions
No account needed. The explanation opens when you answer.
Sample question 1 of 3
A data engineer holds dataset access but not the fine-grained reader role, and runs a MERGE statement that reads a policy-tagged column. What is the outcome?
Sample question 2 of 3
A team loads a CSV file from Cloud Storage into a table whose columns carry policy tags. Which check does BigQuery skip while running that load?
Sample question 3 of 3
A user with dataset access but no fine-grained reader role runs a wildcard select on a table holding a restricted column. What comes back?
Full Data Engineer question bank coming
We’re writing the complete bank from the official objectives right now. Leave your email and we’ll tell you when it ships, nothing else, ever.
Read the sources
These are the official pages the questions above cite. Reading them is studying the objective from the primary source, which is what the explanations point you toward anyway.