Exam Professional Data Engineer topic 1 question 55 discussion

C = A standard SQL query cannot reference a view defined using legacy SQL syntax. D = For the ODBC drivers is needed a service account which will get a standard Bigquery role.

Answer: CD

ODBC requires standard SQL. **A** creates a new view using standard SQL, and **D** sets up a service account for authentication. Options A and D are necessary.

To ensure applications can connect to BigQuery via an ODBC connection, take these two actions: A. Create a new view over events using standard SQL to replace the legacy SQL view, ensuring compatibility with ODBC, and D. Create a service account for the ODBC connection to authenticate and access the data. These steps ensure the applications can query the last 14 days of data efficiently and securely. Avoid unnecessary changes like creating new tables or custom IAM roles.

A. Legacy SQL views are not compatible with ODBC connections, which require standard SQL. Creating a new view in standard SQL ensures compatibility for the applications connecting via ODBC. D. ODBC connections to BigQuery require authentication, typically via a service account with the appropriate permissions. Setting up a service account ensures secure and reliable access.

I think question should be rewrite slightly like which 3 actions should you take rather than 2 .. Then answer would be A,D and E..No ambiguity then

ODBC connections require standard SQL, not legacy SQL. Service account for the ODBC connection

This dump is full of wrong answers - not sure which one to go for.

CD..... C because, ODBC drivers dont support switch b/w legacy SQL & google SQL, hence better to create a new view from recent partitioned table & D as Google best practice for role binding

the answer is C & D

answer: A & D Confusion here: Legacy SQL vs Standard, BQ supports legacy SQL but ODBC or Most RDBMS connection doesn't support Legacy SQL, so in this case we need to create a new view on existing view or replace the existing one by changing syntax. For ODBC, you just need a service account to authenticate as its external service connection. Option E is not necessary.

D. Create a service account for the ODBC connection to use for authentication. This service account will be used to authenticate the ODBC connection, and will be granted specific permissions to access the BigQuery resources. E. Create a Cloud IAM role for the ODBC connection and shared events. This role will be used to grant permissions to the service account created in step D, and will allow the applications to access the events view in BigQuery. Creating a new view over events using standard SQL may also be beneficial to improve performance and compatibility with the applications, but is not required for the ODBC connection to work.

INFO: - 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. QUESTION: 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.) -> First and foremost we need to understand the information. So our actual data is stored in events_partitioned table. The organization is currently using view called events to reduce the cost. -> Since the view called events only has last 14 days of data we cannot use that view. -> We also cannot use that view because standard SQL is not used to describe the view. In order to connectt ODBC we need a view described by standard SQL.

CE is the correct answer

needed a service account for ODBC drivers standard SQL vs legacy SQL.

1. Create Services account from IAM & Admin 2. Add Services account permission Roles as "BigQuery Admin" or any custom Role. Other options are not related ' to ensure the applications can connect'

As stated by jvg637 C = A standard SQL query cannot reference a view defined using legacy SQL syntax. D = For the ODBC drivers is needed a service account which will get a standard Bigquery role.