Question-7: A data warehouse is a centralized collection of information that can be evaluated in order to make choices that are more in line with reality. A data warehouse receives data from several sources, including transactional systems, relational databases, and other sources, on a cycle that is often rather consistent. Your organization has decided to go with BigQuery as their corporate data warehouse solution. The data is dispersed among many projects hosted on Google Cloud. It is necessary for all queries to be invoiced under a single project when using BigQuery. You will want to check to see that the projects that include the data do not incur any charges associated with queries. Enterprise data warehouses (also known as EDWs), operational data stores (also known as ODSs), and data marts are the three primary categories of data warehouses. It is necessary for users to be able to query the datasets, but they should not be able to alter them. How should the roles that users have access to be configured?
A. Arrange everyone into separate groups. A BigQuery user role should be assigned to the group on the billing project, and the BigQuery dataViewer role should be assigned to the group on the data-containing projects.
B. Everyone should join one of the groups. It would be helpful if you could assign the group the responsibilities of BigQuery dataViewer on the billing project and BigQuery user on the projects that hold the data.
C. Everyone should join one of the groups. The group should be given the BigQuery jobUser role on the billing project as well as the BigQuery dataViewer role on the projects that contain data.
D. Everyone should join one of the groups. Give the group the BigQuery jobUser role on the data-containing projects, as well as the BigQuery dataViewer role on the billing project.
Correct Answer
Get All 340 Questions and Answer for Google Professional Cloud Architect
: Explanation: 3 Option 3 is the answer that is right, whereas Option 1 is the incorrect choice since bq User Permission would provide you the ability to alter the dataset, which is something that we do not want in this particular circumstance. Option 2 and Option 4 are incorrect because You want to make sure that no query costs are incurred on the projects that contain the data, which means that you don't want users to fire queries on the Project that contains the dataset, hence the dataViewer permission. Option 1 and Option 3 are both correct, but using the principle of least privileges, Option 3 is the most appropriate. BigQuery User: (roles/bigquery.user) When applied to a dataset, this role provides the ability to read