FirstTry

Objective 3.3

PDE

Using a data lake

Objective 3.3 sits in Storing the data, which carries 20% 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.

3-3Storing the data

A team grants an analyst access to a BigQuery external table over Cloud Storage, and the analyst's queries still fail. What else does the analyst need?

Membership in the dataset owner groupDataset ownership does not reach the underlying store.
A connection resource in the same regionNo connection object is involved in this table kind.
The Fine-Grained Reader role on the tableColumn tags are not what blocks the read here.
Permissions on the Cloud Storage data itselfCorrect · your answerCorrect. Two grants stand behind one query.

Correct.

Concept

Without delegation a query runs with the reader's own reach, so every store the query touches has to grant that reader directly.

Why D

Querying an external table requires permissions on both the external table and the external data source, including storage.buckets.get and storage.objects.get for a Cloud Storage source.

Source

To query an external table, you must have permissions to both the external table and the external data source. For example, to query an external table that uses a data source in Cloud Storage, you must have the following permissions: bigquery.tables.getData bigquery.jobs.create storage.buckets.get storage.objects.get

Google Cloud: Introduction to external data sources, checked August 2026
#gcp#bigquery#external-tables#iam

Now you: objective 3.3 questions

No account needed. The explanation opens when you answer.

Sample question 1 of 3

3-3Storing the data

An organization wants analysts to query Cloud Storage data without holding any access to the bucket itself. Which external data source kind supports that?

Sample question 2 of 3

3-3Storing the data

A team creates an object table over a bucket of scanned PDF files and runs a select against it. What does each row represent?

Sample question 3 of 3

3-3Storing the data

A company keeps several datasets in Amazon S3 and wants to query them from BigQuery. Which external data source kind works with S3?

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.

More objectives in Storing the data