EMC EMC Specialist E20-026 Questions & Answers

• Question 141:

  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.

  Correct Answer: A

• Question 142:

  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),( ) )

  Correct Answer: D

• Question 143:

  In MADlib what does MAD stand for?

  A. Magnetic,Agile,Deep

  B. Machine Learning,Algorithms for Databases

  C. Mathematical Algorithms for Databases

  D. Modular,Accurate,Dependable

  Correct Answer: C

• Question 144:

  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 should they use to export the structured data from Hadoop?

  A. Sqoop

  B. Pig

  C. Chukwa

  D. Scribe

  Correct Answer: A

• Question 145:

  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 and programming. Which query interface would you recommend?

  A. Pig

  B. Hive

  C. Howl

  D. HBase

  Correct Answer: A

• Question 146:

  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. They collaborate with the production team to import the data into Hadoop. Which tool should they use?

  A. Sqoop

  B. Pig

  C. Chukwa

  D. Scribe

  Correct Answer: A

• Question 147:

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

  A. generic functions

  B. virtual methods

  C. virtual functions

  D. generic methods

  Correct Answer: B

• Question 148:

  What is an appropriate data visualization to use in a presentation for an analyst audience?

  A. Pie chart

  B. Area chart

  C. Stacked bar chart

  D. ROC curve

  Correct Answer: D

• Question 149:

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

  A. where all subtotals and grand totals are to be included in the output

  B. where only the subtotals are to be included in the output

  C. where only the grand totals are to be included in the output

  D. where only specific subtotals and grand totals for a combination of variables are to be included in the output

  Correct Answer: A

• Question 150:

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

  A. Probability

  B. A p-value

  C. Any integer

  D. Any real number

  Correct Answer: A