What should you do?

You work on the data science team at a manufacturing company. You are reviewing the company’s historical sales data, which has hundreds of millions of records. For your exploratory data analysis, you need to calculate descriptive statistics such as mean, median, and mode; conduct complex statistical tests for hypothesis testing; and plot variations of the features over time You want to use as much of the sales data as possible in your analyses while minimizing computational resources.

What should you do?
A . Spin up a Vertex Al Workbench user-managed notebooks instance and import the dataset Use this data to create statistical and visual analyses
B. Visualize the time plots in Google Data Studio. Import the dataset into Vertex Al Workbench user-managed notebooks Use this data to calculate the descriptive statistics and run the statistical analyses
C. Use BigQuery to calculate the descriptive statistics. Use Vertex Al Workbench user-managed notebooks to visualize the time plots and run the statistical analyses.
D Use BigQuery to calculate the descriptive statistics, and use Google Data Studio to visualize the time plots. Use Vertex Al Workbench user-managed notebooks to run the statistical analyses.

View Answer

Answer: C

Explanation:

BigQuery is a powerful tool for analyzing large datasets and can be used to quickly calculate descriptive statistics, such as mean, median, and mode, on large amounts of data. By using BigQuery, you can analyze the entire dataset and minimize the computational resources required for your analyses.

Once you have calculated the descriptive statistics, you can use Vertex Al Workbench user-managed notebooks to visualize the time plots and run the statistical analyses. Vertex Al Workbench allows you to interactively explore the data, create visualizations, and perform advanced statistical analysis. It’s also possible to run these notebooks on a powerful GPU which will help to increase the speed of the analysis.