Review the following code:
SELECT pn, vn, sum(prc*qty)
FROM sale
GROUP BY CUBE(pn, vn)
ORDER BY 1, 2, 3;
Which combination of subtotals do you expect to be returned by the query?

In MADlib what does MAD stand for?

The web analytics team uses Hadoop to process access logs. They now want to correlate this data with
structured user data residing in their massively parallel database. Which tool should they use to export the
structured data from Hadoop?

When would you prefer a Naive Bayes model to a logistic regression model for classification?

Before you build an ARMA model, how can you tell ifyour time series is weakly stationary?

What is an example of a null hypothesis?

You have fit a decision tree classifier using 12 input variables. The resulting tree used 7 of the 12 variables,
and is 5 levels deep. Some of the nodes contain only 3 data points. The AUC of the model is 0.85. Whatis
your evaluation of this model?

If your intention is to show trends over time, which chart type is the most appropriate way to depict the data?

You are analyzing a time series and want to determine its stationarity. You also want to determine theorder of
autoregressive models.
How are the autocorrelation functions used?

Which word or phrase completes the statement? A spreadsheet is to a data island as a centralized database
for reporting is to a ________?