E20-026 Online Practice Questions and Answers

Which word or phrase completes the statement? A spreadsheet is to a data island as a centralized database for reporting is to a ________?

A. Data Warehouse

B. Data Repository

C. Analytic Sandbox

D. Data Mart

Which word or phrase completes the statement? Business Intelligence is to monitoring trends as Data Science is to ________ trends.

A. Predicting

B. Discarding

C. Driving

D. Optimizing

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

A. Irregular

B. Linear

C. Quadratic

D. Exponential

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

What is required in a presentation for business analysts?

A. Budgetary considerations and requests

B. Operational process changes

C. Detailed statistical explanation of the applicable modeling theory

D. The presentation author's credentials

Which SQL OLAP extension provides all possible grouping combinations?

A. CUBE

B. ROLLUP

C. UNION ALL

D. CROSS JOIN

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 26 / 55

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

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

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

A. Classification Y = 1,Probability = 4/54

B. Classification Y = 0,Probability = 1/54

C. Classification Y = 1,Probability = 1/54

D. Classification Y = 0,Probability = 4/54