Answer-first summary for fast verification
Answer: Create a new view over `events_partitioned` using standard SQL., Create a service account for the ODBC connection to use for authentication.
✅ **Create a new view over `events_partitioned` using standard SQL.** The current view `events` uses legacy SQL, which is being phased out. Migrating to standard SQL ensures long-term compatibility and access to future BigQuery features. A new view based on `events_partitioned` in standard SQL offers a forward-compatible solution for applications to query the data, replicating or adapting the existing view's logic as needed. ✅ **Create a service account for the ODBC connection to use for authentication.** Applications connecting to BigQuery programmatically require proper authentication. A service account is a secure, non-interactive method for applications to authenticate to Google Cloud services like BigQuery, ensuring stable and manageable connections independent of individual user accounts. Incorrect Options: ❌ **Create a new view over `events` using standard SQL.** Creating a new view over the existing legacy SQL view in standard SQL may introduce complexities or limitations in query optimization and could still be affected by the eventual deprecation of legacy SQL. Directly querying the underlying partitioned table with standard SQL is preferable. ❌ **Create a new partitioned table using a standard SQL query.** The data is already optimally stored in a time-partitioned table (`events_partitioned`). Creating a new partitioned table would duplicate data and potentially disrupt existing data ingestion pipelines, without addressing the immediate need for application connectivity. ❌ **Create a Google Cloud Identity and Access Management (Cloud IAM) role for the ODBC connection and shared events.** While Cloud IAM roles are crucial for controlling access to BigQuery datasets and tables, creating a specific role for the ODBC connection isn't the direct solution for ensuring application connectivity. The focus should be on the authentication mechanism (service account) and the authorization to access the data (IAM roles on the dataset/table).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
To ensure that existing applications can connect to the events data in Google BigQuery next month, which two actions are recommended? The data is primarily in a time-partitioned table named events_partitioned. A view called events, which queries only the last 14 days of data and uses legacy SQL, has been created to reduce query costs.
A
Create a new view over events_partitioned using standard SQL.
B
Create a service account for the ODBC connection to use for authentication.
C
Create a new view over events using standard SQL.
D
Create a new partitioned table using a standard SQL query.
E
Create a Google Cloud Identity and Access Management (Cloud IAM) role for the ODBC connection and shared events.