E20-007 Exam Questions

How does Pig's use of a schema differ from that of a traditional RDBMS?

You are provided four different datasets. Initial analysis on these datasets show that they have identical mean, variance and correlation values. What should your next step in the...

You are asked to create a model to predict the total number of monthly subscribers for a specific magazine. You are provided with 1 year's worth of subscription and payment data, u...

Which word or phrase completes the statement? Structured data is to OLAP data as quasi- structured data is to____

What describes a true property of Logistic Regression method?

You have been assigned to do a study of the daily revenue effect of a pricing model of online transactions. You have tested all the theoretical models in the previous model plannin...

What is a core deliverable at the end of the analytic project?

You have been assigned to run a logistic regression model for each of 100 countries, and all the data is currently stored in a PostgreSQL database. Which tool/library would you use...

Your organization has a website where visitors randomly receive one of two coupons. It is also possible that visitors to the website will not receive a coupon. You have been asked...

Imagine you are trying to hire a Data Scientist for your team. In addition to technical ability and quantitative background, which additional essential trait would you look for in...

What describes the use of UNION clause in a SQL statement?

You have run the association rules algorithm on your data set, and the two rules {banana, apple} => {grape} and {apple, orange}=> {grape} have been found to be relevant. What else...

When would you use a Wilcoxson Rank Sum test?

In the MapReduce framework, what is the purpose of the Reduce function?

Which of the following is an example of quasi-structured data?

A Data Scientist is assigned to build a model from a reporting data warehouse. The warehouse contains data collected from many sources and transformed through a complex, multi-stag...

Which word or phrase completes the statement? Emphasis color is to standard color as _______ .

Which activity might be performed in the Operationalize phase of the Data Analytics Lifecycle?

Refer to the exhibit. You are asked to write a report on how specific variables impact your client's sales using a data set provided to you by the client. The data includes 15 vari...

Refer to the Exhibit. In the Exhibit, the table shows the values for the input Boolean attributes "A", "B", and "C". It also shows the values for the output attribute "class". Whic...

Refer to the Exhibit. In the Exhibit, the table shows the values for the input Boolean attributes "A", "B", and "C". It also shows the values for the output attribute "class". Whic...

Refer to the exhibit. You are building a decision tree. In this exhibit, four variables are listed with their respective values of info-gain. Based on this information, on which at...

Refer to the exhibit. You are assigned to do an end of the year sales analysis of 1, 000 different products, based on the transaction table. Which column in the end of year report...

Refer to the exhibit. After analyzing a dataset, you report findings to your team: 1. Variables A and C are significantly and positively impacting the dependent variable. 2. Variab...

Refer to the Exhibit. You are working on creating an OLAP query that outputs several rows of with summary rows of subtotals and grand totals in addition to regular rows that may co...

Refer to the exhibit. Click on the calculator icon in the upper left corner. You are given a list of pre-defined association rules:

Refer to the exhibit. You have run a linear regression model against your data, and have plotted true outcome versus predicted outcome. The R-squared of your model is 0.75. What is...

Refer to the exhibit. You are using K-means clustering to classify customer behavior for a large retailer. You need to determine the optimum number of customer groups. You plot the...

Refer to the exhibit. You are using k-means clustering to discover groupings within a data set. You plot within-sum-of- squares (wss) of multiple cluster sizes. Based on the exhibi...

Refer to the exhibit Consider the training data set shown in the exhibit. What are the classification (Y = 0 or 1) and the probability of the classification for the tupleX(0, 0, 1)...

Refer to the exhibit. In the exhibit, a correlogram is provided based on an autocorrelation analysis of a sample dataset. What can you conclude from only this exhibit?

Refer to the exhibit. Which type of data issue would you suspect based on the exhibit?

Refer to the exhibit. Click on the calculator icon in the upper left corner. An analyst is searching a corpus of documents for the topic "solid state disk". In the Exhibit, Table A...

Refer to the exhibit. What provides the decision tree for predicting whether or not someone is a good or bad credit risk. What would be the assigned probability, p(good), of a sing...

Refer to the exhibit. You ran a linear regression, and the final output is seen in the exhibit. Based only on the information in the exhibit and an acceptable confidence level of 9...

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

Refer to the exhibit. The graph represents an ROC space with four classifiers labelled A through

Refer to the exhibit. Consider the training data set shown in the exhibit. What are the classification (Y = 0 or 1) and the probability of the classification for the tuple X(1, 0,...

Refer to the exhibit. You have scored your Naive bayesian classifier model on a hold out test data for cross validation and determined the way the samples scored and tabluated them...

You are using MADlib for Linear Regression analysis. Which value does the statement return? SELECT (linregr(depvar, indepvar)).r2 FROM zeta1;

Refer to the exhibit. You have scored your Naive bayesian classifier model on a hold out test data for cross validation and determined the way the samples scored and tabulated them...

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

In which lifecycle stage are test and training data sets created?

When creating a presentation for a technical audience, what is the main objective?

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

In data visualization, what is used to focus the audience on a key part of a chart?

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

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

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

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