E20-007 Exam Questions

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

In R, functions like plot() and hist() are known as what?

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...

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?

In a Student's t-test, what is the meaning of the p-value?

In addition to less data movement and the ability to use larger datasets in calculations, what is a benefit of analytical calculations in a database?

You have been assigned to do a study of the daily revenue effect of a pricing model of online transactions. When have you completed the analytics lifecycle?

Consider these itemsets: (hat, scarf, coat) (hat, scarf, coat, gloves) (hat, scarf, gloves) (hat, gloves) (scarf, coat, gloves) What is the confidence of the rule (gloves -> hat)?

What is holdout data?

Which characteristic applies mainly to Data Science as opposed to Business Intelligence?

Which word or phrase completes the statement? Theater actor is to "Artistic and Expressive" as Data Scientist is to ________________

Which process in text analysis can be used to reduce dimensionality?

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

Which data type value is used for the observed response variable in a logistic regression model?

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...

What is required in a presentation for business analysts?

What is LOESS used for?

Which word or phrase completes the statement? Mahout is to Hadoop as MADlib is to ____________ .

In linear regression modeling, which action can be taken to improve the linearity of the relationship between the dependent and independent variables?

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

Which data asset is an example of semi-structured data?

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 previously worked extensively with SQL and...

In linear regression, what indicates that an estimated coefficient is significantly different than zero?

Which graphical representation shows the distribution and multiple summary statistics of a continuous variable for each value of a corresponding discrete variable?

Assume that you have a data frame in R. Which function would you use to display descriptive statistics about this variable?

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

What is the purpose of the process step "parsing" in text analysis?

Which word or phrase completes the statement? A data warehouse is to a centralized database for reporting as an analytic sandbox is to a _______?

You do a Student's t-test to compare the average test scores of sample groups from populations A and B. Group A averaged 10 points higher than group B. You find that this differenc...

Which word or phrase completes the statement? Business Intelligence is to ad-hoc reporting and dashboards as Data Science is to ______________ .

What is a property of window functions in SQL commands?

You are attempting to find the Euclidean distance between two centroids: Centroid A's coordinates: (X = 2, Y = 4) Centroid B's coordinates (X = 8, Y = 10) Which formula finds the c...

In data visualization, which type of chart is recommended to represent frequency data?

A data scientist is asked to implement an article recommendation feature for an on-line magazine. The magazine does not want to use client tracking technologies such as cookies or...

How are window functions different from regular aggregate functions?

Consider these itemsets: (hat, scarf, coat) (hat, scarf, coat, gloves) (hat, scarf, gloves) (hat, gloves) (scarf, coat, gloves) What is the confidence of the rule (hat, scarf) -> g...

In the MapReduce framework, what is the purpose of the Map Function?

You have completed your model and are handing it off to be deployed in production. What should you deliver to the production team, along with your commented code?

While having a discussion with your colleague, this person mentions that they want to perform K- means clustering on text file data stored in HDFS. Which tool would you recommend t...

Which method is used to solve for coefficients b0, b1, .., bn in your linear regression model : Y = b0 + b1x1+b2x2+....+bnxn

What describes a true limitation of Logistic Regression method?

You submit a MapReduce job to a Hadoop cluster and notice that although the job was successfully submitted, it is not completing. What should you do?

A disk drive manufacturer has a defect rate of less than 1.5% with 98% confidence. A quality assurance team samples 1000 disk drives and finds 14 defective units. Which action shou...

Which word or phrase completes the statement? Data-ink ratio is to data visualization as __________ .

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 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...

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}...