Your Analytics System Executes Queries Against a BigQuery Dataset

question 44

Multiple Choice

Your analytics system executes queries against a BigQuery dataset. The SQL query is executed in batch and passes the contents of a SQL file to the BigQuery CLI. Then it redirects the BigQuery CLI output to another process. However, you are getting a permission error from the BigQuery CLI when the queries are executed. You want to resolve the issue. What should you do?

• A) Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
• B) Grant the service account BigQuery Data Editor and BigQuery Data Viewer roles.
• C) Create a view in BigQuery from the SQL query and SELECT* from the view in the CLI. Create a view in BigQuery from the SQL query and SELECT* from the view in the CLI.
• D) Create a new dataset in BigQuery, and copy the source table to the new dataset Query the new dataset and table from the CLI.

Comprehend the impact of attitude strength, formation, and change on behavior and persuasion.

Recognize how attitudes are formed from personal experience versus other sources and their predictive power on behavior.

Explain the theory of planned behavior and how attitudes, subjective norms, and perceived behavioral control interact to influence behavior.

Understand the concept and different levels of processing in memory.

---

Definitions:

Personnel Psychology

An I/O psychology subfield that helps with job seeking, and with employee recruitment, selection, placement, training, appraisal, and development.

Placing Employees

The process of assigning or reassigning employees to positions where they can be most effective and where their skills are best utilized.

Career Counseling

A type of advice-giving and support provided to help individuals manage their career development and make informed occupational and educational choices.

Person-Environment Fit

The degree to which individual characteristics match with aspects of the environment, affecting well-being and performance.