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?

Exam-Like

Create groups for your users and give those groups access to the dataset

14.0%

Integrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query request

9.3%

Create a service account and grant dataset access to that account. Use the service account's private key to access the dataset

69.8%

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

7.0%

Google Professional Data Engineer

Get started today

Comments