EMC E20-007 Online Practice Questions and Exam Preparation

EMC E20-007 Online Questions & Answers

• Question 191:

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

  A. Pig's schema is optional
  B. Pig's schema requires that the data is physically present when the schema is defined
  C. Pig's schema is required for ETL
  D. Pig's schema supports a single data type
  A. Pig's schema is optional

• Question 192:

  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 contain NULL as shown in the exhibit. Which function can you use in your query to distinguish the row from a regular row to a subtotal row?

  A. GROUPING
  B. RANK
  C. GROUP_ID
  D. ROLLUP
  A. GROUPING

• Question 193:

  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
  C. The rule is coincidental

• Question 194:

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

  A. Main message is to context
  B. Main message is to key findings
  C. Frequent item set is to item
  D. Pie chart is to proportions
  A. Main message is to context

• Question 195:

  You are analyzing data in order to build a classifier model. You discover non-linear data and discontinuities that will affect the model. Which analytical method would you recommend?

  A. Decision Trees
  B. Logistic Regression
  C. ARIMA
  D. Linear Regression
  A. Decision Trees

• Question 196:

  Before you build an ARMA model, how can you tell if your time series is weakly stationary?

  A. There appears to be a constant variance around a constant mean.
  B. The mean of the series is close to 0.
  C. The series is normally distributed.
  D. There appears to be no apparent trend component.
  A. There appears to be a constant variance around a constant mean.

• Question 197:

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

  A. PostgreSQL
  B. R
  C. Excel
  D. SAS
  A. PostgreSQL

• Question 198:

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

  A. Stemming
  B. Parsing
  C. Digitizing
  D. Sorting
  A. Stemming