Your organization has been collecting and analyzing data in Google BigQuery for 6 months.

Vendor: Google
Product: Professional-Data-Engineer
Update on: Jan 30, 2026
Questions: 387

Google Professional-Data-Engineer Question Answer

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 namedevents_partitioned. To reduce the cost of queries, your organization created a view calledevents, which queries only the last 14 days of data. The view is described in legacy SQL. Next month, existing applications will be connecting to BigQuery to read theeventsdata via an ODBC connection. You need to ensure the applications can connect. Which two actions should you take? (Choose two.)

Create a new view over events using standard SQL

Create a new partitioned table using a standard SQL query

Create a new view over events_partitioned using standard SQL

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

Create a Google Cloud Identity and Access Management (Cloud IAM) role for the ODBC connection and shared “events”