You Work for an Advertising Company and Want to Understand

question 30

Multiple Choice

You work for an advertising company and want to understand the effectiveness of your company's latest advertising campaign. You have streamed 500 MB of campaign data into BigQuery. You want to query the table, and then manipulate the results of that query with a pandas dataframe in an AI Platform notebook. What should you do?

• A) Use AI Platform Notebooks' BigQuery cell magic to query the data, and ingest the results as a pandas dataframe.
• B) Export your table as a CSV file from BigQuery to Google Drive, and use the Google Drive API to ingest the file into your notebook instance.
• C) Download your table from BigQuery as a local CSV file, and upload it to your AI Platform notebook instance. Use pandas.read_csv to ingest he file as a pandas dataframe. Download your table from BigQuery as a local CSV file, and upload it to your AI Platform notebook instance. Use pandas.read_csv to ingest he file as a pandas dataframe.
• D) From a bash cell in your AI Platform notebook, use the bq extract command to export the table as a CSV file to Cloud Storage, and then use gsutil cp to copy the data into the notebook. Use pandas.read_csv to ingest the file as a pandas dataframe. From a bash cell in your AI Platform notebook, use the bq extract command to export the table as a CSV file to Cloud Storage, and then use gsutil cp to copy the data into the notebook. Use to ingest the file as a pandas dataframe.

---

Definitions:

Partial ANOVA Table

A component of the ANOVA (Analysis of Variance) output that summarizes partial calculations and results, often excluding some variables or interactions.

Degrees of Freedom

The quantity of separate variables or numbers that are allowed to fluctuate during the evaluation without breaching any restrictions.

F-test

is a statistical test used to compare the variances of two populations to determine if they are equal or not.

F-test Statistic

A value used to determine if there are significant differences between the variances of two or more datasets.