Google Cloud Professional Data Engineer · Free practice question 8 of 12
Data Studio viewer's credentials
A Data Studio (formerly Looker Studio) report at Thursby Retail uses a BigQuery table protected by row-level security. Each regional manager who opens the report must see only the rows their own BigQuery permissions allow. How should the report's data source be configured?
- A.Set the data source credentials to the owner's credentials
- B.Set the data source credentials to the viewer's credentials
- C.Use a service account owned by the report creator for the data source
- D.Download the data to a spreadsheet for each manager
Show answer and explanation
Correct answer: B. Set the data source credentials to the viewer's credentials
Why: With viewer's credentials, each person's own identity is used to query BigQuery, so row-level security filters the data for that viewer. Owner's credentials or a single service account run every query as one identity, showing everyone the same rows. Spreadsheet copies bypass BigQuery's controls and go stale.
More free Google Cloud Professional Data Engineer questions
- Sliding windows for moving averages
- Turbo replication on dual-region buckets
- Assured Workloads for sovereign controls
- Data Validation Tool after migration
- Pub/Sub Cloud Storage subscription archive
- Bigtable garbage collection by age
- Search indexes for log lookups
- Integer-range partitioning on an ID
- Approximate distinct counts for dashboards
- Scheduled queries for a single SQL job
- Pub/Sub message storage policy regions