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

Owen

3 days ago

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

upvoted 0 times

...

Angelyn

8 days 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

13 days 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

18 days 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

23 days 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

28 days 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

1 month 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

1 month 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

1 month 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

2 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

2 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

2 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

...