Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A data analytics team wants to analyze customer feedback stored in BigQuery by using a pretrained Google large language model (LLM) hosted in Vertex AI. To securely query the model from BigQuery SQL without embedding API keys or user passwords in scripts, the team must establish a remote connection.
How should the team configure authentication and access for this remote connection?
This option proposes manually generating a JSON Web Token (JWT) on an administrator's machine and injecting the token as a parameter into every SQL batch query execution.
You were configuring the BigQuery Connector for SAP running in an external non-Google environment that requires JWTs for external identity federation.
This option suggests creating a static Google Cloud API key, storing it in Secret Manager, and referencing the secret directly inside a SQL query to authenticate against external LLM APIs.
This approach would be appropriate if you were connecting a custom application running on Cloud Run to a third-party non-Google API service that requires static token-based authentication.
This option suggests configuring an SSH tunnel and supplying traditional database usernames and passwords to establish communication between BigQuery and Vertex AI.
You were connecting a business intelligence tool like Looker to an on-premises or private Cloud SQL MySQL database located behind a corporate firewall.
A BigQuery Cloud resource connection (also referred to as a remote connection) is a managed Google Cloud resource that allows BigQuery to securely interact with external Google Cloud services, such as Vertex AI foundational large language models (LLMs) and Cloud Functions, directly within SQL queries.
ML.GENERATE_TEXT or ML.PREDICT functions.roles/aiplatform.user) role specifically to the connection's service account in Identity and Access Management (IAM), BigQuery obtains delegated permissions to invoke the remote model without exposing user credentials or static API keys.
CREATE OR REPLACE MODEL ... REMOTE WITH CONNECTION directly in standard BigQuery SQL syntax.Using a native Cloud resource connection with IAM service account delegation is the Google-recommended, zero-trust architecture pattern for extending BigQuery capabilities to Vertex AI foundational models.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated