You Have Historical Data Covering the Last Three Years in BigQuery

question 101

Multiple Choice

You have historical data covering the last three years in BigQuery and a data pipeline that delivers new data to BigQuery daily. You have noticed that when the Data Science team runs a query filtered on a date column and limited to 30-90 days of data, the query scans the entire table. You also noticed that your bill is increasing more quickly than you expected. You want to resolve the issue as cost-effectively as possible while maintaining the ability to conduct SQL queries. What should you do?

• A) Re-create the tables using DDL. Partition the tables by a column containing a TIMESTAMP or DATE Type.
• B) Recommend that the Data Science team export the table to a CSV file on Cloud Storage and use Cloud Datalab to explore the data by reading the files directly.
• C) Modify your pipeline to maintain the last 30-90 days of data in one table and the longer history in a different table to minimize full table scans over the entire history.
• D) Write an Apache Beam pipeline that creates a BigQuery table per day. Recommend that the Data Science team use wildcards on the table name suffixes to select the data they need.

Understand the key networking activities that contribute to career success.

Identify the components and implications of political skill in the workplace.

Recognize behaviors and strategies that enhance internal visibility and political networks.

Distinguish between different defensive behaviors used in organizational settings.

---

Definitions:

External Goal

An objective or target that an individual aims to achieve, which is set outside of themselves, such as career achievements or material possessions.

Motivate Behaviour

The process of influencing or stimulating an individual to act in a certain way or pursue particular goals.

Biological Motives

Innate drives arising from biological needs that are critical for the survival and reproduction of an organism.

Social Needs

Social needs refer to the human requirement for relationships and interaction with others, including the need for belonging, love, and affection.