Your organization has been using Google BigQuery to collect and analyze data for the past 6 months. The primary dataset being analyzed resides in a time-partitioned table called events_partitioned. To minimize query costs, your organization has created a view named events, which is configured to retrieve only the last 14 days of data. This view is defined using legacy SQL. In the upcoming month, various existing applications will start connecting to BigQuery to read the events data through an ODBC connection. What two actions should you take to ensure that these applications can connect to the events data? (Choose two.)_

Exam-Like

Create a new view over events using standard SQL

6.7%

Create a new partitioned table using a standard SQL query

7.1%

Create a new view over events_partitioned using standard SQL_

37.5%

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

39.2%

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

9.6%

Google Professional Data Engineer