Answer-first summary for fast verification
Answer: Create a service account and grant dataset access to that account. Use the service account's private key to access the dataset
The correct answer is C. Creating a service account and granting dataset access to that account is the most secure way to access BigQuery from an IT application. Service accounts are designed for use in automated systems and do not require user interaction, eliminating the need for individual users to authenticate to BigQuery. Additionally, by using the private key of the service account to access the dataset, you can ensure that the authentication process is secure and that only authorized users have access to the data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with integrating one of your internal IT applications with Google BigQuery to enable users to query BigQuery from the application's interface. However, you aim to ensure that individual users do not need to authenticate directly to BigQuery, nor do you wish to provide them direct access to the dataset itself. Given these requirements, what is the most secure method to facilitate access to BigQuery from your IT application?
A
Create groups for your users and give those groups access to the dataset
B
Integrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query request
C
Create a service account and grant dataset access to that account. Use the service account's private key to access the dataset
D
Create a dummy user and grant dataset access to that user. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset
No comments yet.