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 if your 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. What is 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
the order 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 ________?