You Use BigQuery as Your Centralized Analytics Platform

question 194

Multiple Choice

You use BigQuery as your centralized analytics platform. New data is loaded every day, and an ETL pipeline modifies the original data and prepares it for the final users. This ETL pipeline is regularly modified and can generate errors, but sometimes the errors are detected only after 2 weeks. You need to provide a method to recover from these errors, and your backups should be optimized for storage costs. How should you organize your data in BigQuery and store your backups?

• A) Organize your data in a single table, export, and compress and store the BigQuery data in Cloud Storage.
• B) Organize your data in separate tables for each month, and export, compress, and store the data in Cloud Storage.
• C) Organize your data in separate tables for each month, and duplicate your data on a separate dataset in BigQuery.
• D) Organize your data in separate tables for each month, and use snapshot decorators to restore the table to a time prior to the corruption.

---

Definitions:

Variables

Any characteristic, number, or quantity that can be measured or quantified, which changes or varies across different situations or observations.

Crime Rates

Quantitative measures that reflect the number of crimes committed per unit of population or area in a specific time frame.

Pearson Correlation Coefficients

A measure of the linear correlation between two variables X and Y, giving a value between -1 and 1 inclusive, where 1 is total positive linear correlation, 0 is no linear correlation, and -1 is total negative linear correlation.

P-Value

The estimation of observing outcomes from a test that are at least as extreme as the outcomes that were actually seen, assuming the null hypothesis stands.