QUESTION 27
Consider the following SQL statement:
SELECT employee_id, year, salary, avg(salary)
OVER
(PARTITION BY employee_id ORDER BY year ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) as result_1 FROM employee ORDER BY employee_id, year For each employee_id, what is returned as result_1?

QUESTION 28
What does the Receiver Operating Characteristic (ROC) curve show?

QUESTION 29
Consider a database with 4 transactions:
Transaction 1: {cheese, bread, milk}
Transaction 2: {soda, bread, milk}
Transaction 3: {cheese, bread}
Transaction 4: {cheese, soda, juice}
You decide to run the association rules algorithm where minimum support is 50%.
Which rule has a confidence at least 50%?

QUESTION 30
Consider a database with the following four transactions:
Transaction 1: {cheese, bread, milk}
Transaction 2: {soda, bread, milk}
Transaction 3: {cheese, bread}
Transaction 4: {cheese, soda, juice}
Assuming a minimum support of 50%, which itemsets would be generated in the second step of the Apriori algorithm?

QUESTION 31
Since R factors are categorical variables, they are most closely related to which data classification level?

QUESTION 32
Which word or phrase completes the statement? Mahout is to Hadoop as MADlib is to _______.

QUESTION 33
Refer to the exhibit.

The exhibit shows four graphs labeled as Fig A thorough Fig D.
Which figure represents the entropy function relative to a Boolean classification and is represented by the formula shown in Exhibit?

QUESTION 34
What does a leaf node represent in a decision tree?

QUESTION 35
What is the mandatory Clause that must be included when using Window functions?

QUESTION 36
Which activity is performed in the Operationalize phase of the data analytics lifecycle?

QUESTION 37
Which activity is performed in the Operationalize phase of the Data Analytics Lifecycle?

QUESTION 38
Which data asset is an example of unstructured data?

QUESTION 39
When would you use a Wilcoxson Rank Sum test?

QUESTION 40
In text analysis, what makes the corpus representation dynamic?

QUESTION 41
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?

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

QUESTION 43
What is the primary function of the NameNode in Hadoop?

QUESTION 44
You are given 10, 000, 000 user profile pages of an online dating site in XML files, and they are stored in HDFS. You are assigned to divide the users into groups based on the content of their profiles.
You have been instructed to try K-means clustering on this data. How should you proceed?

QUESTION 45
Which functionality do regular expressions provide?

QUESTION 46
What is the output format from the Map function of MapReduce?

QUESTION 47
In the Map Reduce framework, what is the purpose of the Reduce function?

QUESTION 48
A data scientist is given an R data frame, “empdata”, with the columns Age, Salary, Occupation, Education, and Gender. The data scientist would like to examine only the Salary and Occupation columns for ages greater than 40.
Which command extracts the appropriate rows and columns from the data frame?

QUESTION 49
The average purchase size from your online sales site is $17, 200. The customer experience team believes a certain adjustment of the website will increase sales.
A pilot study on a few hundred customers showed an increase in average purchase size of $1.47, with a significance level of p=0.1. The team runs a larger study, of a few thousand customers.
The second study shows an increased average purchase size of $0.74, with a significance level of 0.03.
What is your assessment of this study?

QUESTION 50
Your company has 3 different sales teams. Each team’s sales manager has developed incentive offers to increase the size of each sales transaction.
Any sales manager whose incentive program can be shown to increase the size of the average sales transaction will receive a bonus. Data are available for the number and average sale amount for transactions offering one of the incentives as well as transactions offering no incentive.
The VP of Sales has asked you to determine analytically if any of the incentive programs has resulted in a demonstrable increase in the average sale amount.
Which analytical technique would be appropriate in this situation?

QUESTION 51
During a study to understand the population growth of a certain bacterial culture, you plot the data and identify a quadratic growth trend over time.
Which transformation should you apply to linearize the data?