EMC EMC Certifications E20-007 Questions & Answers

• Question 141:

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

  A. OVER

  B. RANK

  C. PARTITION BY

  D. RANK BY

  Correct Answer: A

• Question 142:

  What would be considered "Big Data"?

  A. An OLAP Cube containing customer demographic information about 100, 000, 000 customers

  B. Daily Log files from a web server that receives 100, 000 hits per minute

  C. Aggregated statistical data stored in a relational database table

  D. Spreadsheets containing monthly sales data for a Global 100 corporation

  Correct Answer: B

• Question 143:

  Consider the example of an analysis for fraud detection on credit card usage. You will need to ensure higher-risk transactions that may indicate fraudulent credit card activity are retained in your data for analysis, and not dropped as outliers during pre-processing. What will be your approach for loading data into the analytical sandbox for this analysis?

  A. ELT

  B. ETL

  C. EDW

  D. OLTP

  Correct Answer: A

• Question 144:

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

  A. Data exploration

  B. Descriptive statistics

  C. ETLT

  D. Model selection

  Correct Answer: A

• Question 145:

  Refer to the exhibit.

  

  In the exhibit, the x-axis represents the derived probability of a borrower defaulting on a loan. Also in the exhibit, the pink represents borrowers that are known to have not defaulted on their loan, and the blue represents borrowers that are known to have defaulted on their loan.

  Which analytical method could produce the probabilities needed to build this exhibit?

  A. Logistic Regression

  B. Linear Regression

  C. Discriminant Analysis

  D. Association Rules

  Correct Answer: A

• Question 146:

  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". Which decision tree is valid for the data?

  A. Tree B

  B. Tree A

  C. Tree C

  D. Tree D

  Correct Answer: A

• Question 147:

  What is required in a presentation for project sponsors?

  A. The "Big Picture" takeaways for executive level stakeholders

  B. Data warehouse design changes

  C. Line by line review of the developed code

  D. Detailed statistical basis for the modeling approach used in the project

  Correct Answer: A

• Question 148:

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

  A. It aggregates the results of the Map function and generates processed output

  B. It distributes the input to multiple nodes for processing

  C. It writes the output of the Map function to storage

  D. It breaks the input into smaller components and distributes to other nodes in the cluster

  Correct Answer: A

• Question 149:

  In which lifecycle stage are initial hypotheses formed?

  A. Discovery

  B. Model planning

  C. Model building

  D. Data preparation

  Correct Answer: A

• Question 150:

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

  A. XML data file

  B. Database table

  C. Webserver log

  D. News article

  Correct Answer: A