Google Cloud Professional Data Engineer PDE — Topic 1 Question 55

Question

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 data. 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.)

Accepted Answer

Correct answer: D, E. The correct answer is D, E. Option D: Create a service account for the ODBC connection to use for authentication Option E: Create a Google Cloud Identity and Access Management (Cloud IAM) role for the ODBC connection and shared "events" A service account provides an identity for workloads to access Google Cloud APIs securely. Cloud IAM grants fine-grained, least-privilege access to Google Cloud resources. Cloud Identity manages users, groups, and device policies as a managed identity platform.

Google Cloud Professional Data Engineer PDE — Question 55