Question-36: A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence. SQL Data Warehouse stores data in relational tables using columnar storage which reduces the data storage costs, and improves query performance. SQL Data Warehouse leverages a scale-out architecture to distribute computational processing of data across multiple nodes. Your company is using BigQuery as its enterprise data warehouse. Data is distributed over several Google Cloud projects. All queries on BigQuery need to be billed on a single project. You want to make sure that no query costs are incurred on the projects that contain the data. Users should be able to query the datasets, but not edit them. How should you configure users' access roles?
A. Include every user in a group. Grant the group the BigQuery user role on the billing project and the BigQuery dataViewer role on the data-containing projects.
B. Include every user in a group. The group should be granted the roles of BigQuery dataViewer on the billing project and BigQuery user on the data-containing projects.
C. Include every user in a group. Grant the group the BigQuery jobUser role on the billing project and the BigQuery dataViewer role on the data-containing projects.
D. Include every user in a group. Grant the group the BigQuery dataViewer and BigQuery jobUser responsibilities on the billing project and data-containing projects, respectively.

Get All 340 Questions and Answer for Google Professional Cloud Architect