EMC E20-007 Online Practice Questions and Exam Preparation

EMC E20-007 Online Questions & Answers

• Question 1:

  What is a property of window functions in SQL commands?

  A. They can be used to calculate moving averages over various intervals.
  B. They group rows into a single output row.
  C. They can be used between the keywords FROM and WHERE in a SELECT command.
  D. They don't require ordering of data within a window.
  A. They can be used to calculate moving averages over various intervals.

• Question 2:

  Your customer provided you with 2, 000 unlabeled records and asked you to separate them into three groups. What is the correct analytical method to use?

  A. K-means clustering
  B. Linear regression
  C. Naive Bayesian classification
  D. Logistic regression
  A. K-means clustering

• Question 3:

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

  A. Any positive real number
  B. Any integer
  C. A binary value
  D. Any real number
  C. A binary value

• Question 4:

  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, 0) using Naive Bayesian classifier?

  

  A. Classification Y = 0, Probability = 4/54
  B. Classification Y = 1, Probability = 4/54
  C. Classification Y = 0, Probability = 1/54
  D. Classification Y = 1, Probability = 1/54
  A. Classification Y = 0, Probability = 4/54

• Question 5:

  What describes a true property of Logistic Regression method?

  A. It is robust with redundant variables and correlated variables.
  B. It handles missing values well.
  C. It works well with discrete variables that have many distinct values.
  D. It works well with variables that affect the outcome in a discontinuous way.
  A. It is robust with redundant variables and correlated variables.

• Question 6:

  Trend, seasonal, and cyclical are components of a time series. What is another component?

  A. Irregular
  B. Linear
  C. Quadratic
  D. Exponential
  A. Irregular

• Question 7:

  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) , ( ) )
  D. ( (pn, vn) , (pn), (vn) , ( ) )

• Question 8:

  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}

  The minimum support is 25%. Which rule has a confidence equal to 50%?

  A. {bread, milk} => {cheese}
  B. {bread} => {milk}
  C. {juice} => {soda}
  D. {bread} => {cheese}
  A. {bread, milk} => {cheese}

• Question 9:

  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 variables that the client views as directly related to sales, and you are restricted to these variables only.

  After a preliminary analysis of the data, the following findings were made:

  1.

  Multicollinearity is not an issue among the variables

  2.

  Only three variables--A, B, and C--have significant correlation with sales

  You build a linear regression model on the dependent variable of sales with the independent variables of A, B, and C. The results of the regression are seen in the exhibit.

  Which interpretation is supported by the analysis?

  A. Variables A, B, and C are significantly impacting sales, but are not effectively estimating sales
  B. Variables A, B, and C are significantly impacting sales and are effectively estimating sales
  C. Due to the R2 of 0.10, the model is not valid ?the linear regression should be re-run with all 15 variables forced into the model to increase the R2
  D. Due to the R2 of 0.10, the model is not valid ?a different analytical model should be attempted
  A. Variables A, B, and C are significantly impacting sales, but are not effectively estimating sales

• Question 10:

  Refer to the Exhibit.

  

  In the Exhibit. For effective visualization, what is the chart's primary flaw?

  A. The use of 3 dimensions.
  B. The slanting of axis labels.
  C. The location of the legend.
  D. The order of the columns.
  A. The use of 3 dimensions.