You Need to Create a Data Pipeline That Copies Time-Series

question 224

Multiple Choice

You need to create a data pipeline that copies time-series transaction data so that it can be queried from within BigQuery by your data science team for analysis. Every hour, thousands of transactions are updated with a new status. The size of the intitial dataset is 1.5 PB, and it will grow by 3 TB per day. The data is heavily structured, and your data science team will build machine learning models based on this data. You want to maximize performance and usability for your data science team. Which two strategies should you adopt? (Choose two.)

• A) Denormalize the data as must as possible.
• B) Preserve the structure of the data as much as possible.
• C) Use BigQuery UPDATE to further reduce the size of the dataset.
• D) Develop a data pipeline where status updates are appended to BigQuery instead of updated.
• E) Copy a daily snapshot of transaction data to Cloud Storage and store it as an Avro file. Use BigQuery's support for external data sources to query.

Understand how economic policies like price controls can impact supply and demand, and potentially lead to shortages.

Grasp the relationship between demand, supply, and employment.

Recognize the role of factors of production in determining supply of goods and services.

Understand the impact of economic growth on job opportunities, wages, and standard of living.

---

Definitions:

Asperger's Syndrome

A condition on the autism spectrum characterized by difficulties in social interaction and nonverbal communication, alongside restricted and repetitive patterns of behavior and interests.

Diagnosed

The process of identifying a disease or condition based on its signs, symptoms, and test results.

Labeling

The process of classifying and naming a phenomenon or a group of phenomena, often influencing perception and behavior towards it.

Learning Disabilities

Neurologically-based processing problems that can interfere with learning basic skills such as reading, writing, or doing math, and can also affect higher-level skills such as organization, time planning, abstract reasoning, long or short term memory, and attention.