Free E20-007 Sample Questions — Data Science and Big Data Analytics

Which word or phrase completes the statement? Business Intelligence is to monitoring trends as Data Science is to ________ trends.

• A. Predicting
• B. Discarding
• C. Driving
• D. Optimizing

Data visualization is used in the final presentation of an analytics project. For what else is this technique commonly used?

• A. Data exploration
• B. Descriptive statistics
• C. ETLT
• D. Model selection

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?

• A. Pig
• B. Hive
• C. Howl
• D. HBase

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

• A. Probability
• B. p-value
• C. Any integer
• D. Any real number

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?

• A. Sqoop
• B. Pig
• C. Chukwa
• D. Scribe

You are using the Apriori algorithm to determine the likelihood that a person who owns a home has a good credit score. You have determined that the confidence for the rules used in the algorithm is > 75%. You calculate lift = 1.011 for the rule, "People with good credit are homeowners". What can you determine from the lift calculation?

• A. Support for the association is low
• B. Leverage of the rules is low
• C. The rule is coincidental
• D. The rule is true

You are testing two new weight-gain formulas for puppies. The test gives the results: Control group: 1% weight gain - Formula A. 3% weight gain - Formula B. 4% weight gain - A one-way ANOVA returns a p-value = 0.027 What can you conclude?

• A. Either Formula A or Formula B is effective at promoting weight gain
• B. Formula B is more effective at promoting weight gain than Formula A
• C. Formula A and Formula B are both effective at promoting weight gain
• D. Formula A and Formula B are about equally effective at promoting weight gain

A data scientist plans to classify the sentiment polarity of 10, 000 product reviews collected from the Internet. What is the most appropriate model to use? Suppose labeled training data is available.

• A. Naïve Bayesian classifier
• B. Linear regression
• C. Logistic regression
• D. K-means clustering

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?

• A. (pn, vn)
• B. ( (pn, vn), (pn) )
• C. ( (pn, vn) , (pn), (vn) )
• D. ( (pn, vn) , (pn), (vn) , ( ) )

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

• A. where all subtotals and grand totals are to be included in the output
• B. where only the subtotals are to be included in the output
• C. where only the grand totals are to be included in the output
• D. where only specific subtotals and grand totals for a combination of variables are to be included in the output