Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Google Cloud Certified Professional Data Engineer · Google Cloud
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
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.