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?

In MADlib what does MAD stand for?

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 R, functions like plot() and hist() are known as what?

What does the R code z <- f[1:10, ] do?

The web analytics team uses Hadoop to process access logs. They now want to correlate this data with structured user data residing in a production single-instance JDBC database. They collaborate with the production team to import the data into Hadoop. Which tool should they use?

Your colleague, who is new to Hadoop, approaches you with a question. They want to know how best to access their data. This colleague has a strong background in data flow languages and programming.
Which query interface would you recommend?

Which type of numeric value does a logistic regression model estimate?

When would you use GROUP BY ROLLUP clause in your OLAP query?

What is an appropriate data visualization to use in a presentation for an analyst audience?