Google Professional Data Engineer Exam - Topic 4 Question 116 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 116
Topic #: 4

[All Professional Data Engineer Questions]

Your organization has been collecting and analyzing data in Google BigQuery for 6 months. The majority of the data analyzed is placed in a time-partitioned table named events_partitioned. To reduce the cost of queries, your organization created a view called events, which queries only the last 14 days of dat

a. The view is described in legacy SQL. Next month, existing applications will be connecting to BigQuery to read the events data via an ODBC connection. You need to ensure the applications can connect. Which two actions should you take? (Choose two.)

ACreate a new view over events using standard SQL

BCreate a new partitioned table using a standard SQL query

CCreate a new view over events_partitioned using standard SQL

DCreate a service account for the ODBC connection to use for authentication

ECreate a Google Cloud Identity and Access Management (Cloud IAM) role for the ODBC connection and shared ''events''

Show Suggested Answer

Suggested Answer: A, E

by Jerrod at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Juan

1 day ago

D) is also important for secure connections!

upvoted 0 times

...

Cristina

7 days ago

Wait, why do we need a new view? Isn't legacy SQL still supported?

upvoted 0 times

...

Ilene

12 days ago

Totally agree, standard SQL is the way to go!

upvoted 0 times

...

Gretchen

17 days ago

A) and C) are the best options here.

upvoted 0 times

...

Laquanda

22 days ago

Haha, good one Alice! BigQuery wizards are in high demand these days.

upvoted 0 times

...

Mabel

27 days ago

I'm surprised they didn't include an option to hire a BigQuery wizard to do all this for you. That would be my choice!

upvoted 0 times

...

Owen

2 months ago

D is a must. You can't connect to BigQuery without proper authentication.

upvoted 0 times

...

Angelyn

2 months ago

I agree with Adelle. The legacy SQL view won't work with the ODBC connection, so a new standard SQL view is needed.

upvoted 0 times

...

Adelle

2 months ago

C and D are the correct answers. The view should be created using standard SQL to ensure compatibility with the ODBC connection.

upvoted 0 times

...

Carissa

2 months ago

I’m a bit confused about the IAM roles. Do we really need to create a specific role for the ODBC connection, or can we just use existing permissions?

upvoted 0 times

...

Phuong

2 months ago

This question seems similar to one we practiced about views and permissions. I think we might need to create a new view over the partitioned table too.

upvoted 0 times

...

Lamonica

2 months ago

I'm not entirely sure, but I feel like creating a service account for the ODBC connection is important for authentication.

upvoted 0 times

...

Sherill

3 months ago

I remember something about legacy SQL and standard SQL compatibility issues. I think we might need to create a new view using standard SQL.

upvoted 0 times

...

Meaghan

3 months ago

I'm leaning towards creating a new standard SQL view over events. That way, the ODBC connection can use the same logical view as the existing applications, but with the updated SQL syntax.

upvoted 0 times

...

Ty

3 months ago

Definitely need to set up the service account and IAM role for the ODBC connection. That will ensure the proper authentication and access controls are in place.

upvoted 0 times

...

Leonora

3 months ago

I think creating a new view over events_partitioned using standard SQL is the way to go. That way, the ODBC connection can access the full dataset, not just the last 14 days.

upvoted 0 times

...

Toshia

3 months ago

Creating a new partitioned table using standard SQL seems like a good idea to ensure the ODBC connection can access the data. I'll need to research the best way to partition the table to match the existing data.

upvoted 0 times

...

Reyes

4 months ago

I'm a bit confused about the difference between the legacy SQL view and the standard SQL view. I'll need to review the syntax and requirements for each to determine the best approach.

upvoted 0 times

...