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.

Recognize the impact of cohesiveness on group productivity.

Understand the concept of process loss and its examples.

Describe principles and effectiveness of self-managed work teams.

Understand the significance of collective efficacy in team performance.

---

Definitions:

XML

Extensible Markup Language, a flexible way to create common information formats and share both the format and the data on the World Wide Web, intranets, and elsewhere.

Development

The process of creating, testing, and maintaining software or applications to meet user needs or solve specific problems.

Google Scholar

A freely accessible web search engine that indexes the full text or metadata of scholarly literature across an array of publishing formats and disciplines.

3-D Animation Software

Programs designed to create moving images in a digital environment that simulate three-dimensional spaces.