E20-007 Online Practice Questions and Answers

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 key role for a successful analytic project can consult and advise the project team on the value of end results and how these will be used on a day-to-day basis?

A. Business User

B. Project Manager

C. Data Scientist

D. Business Intelligence Analyst

A data scientist is given an R data frame (i.e., empdata) with the following columns: Age Salary Occupation Education Gender The scientist wants to examine only the Salary and Occupation columns for ages greater than `40'. Which

command extracts the appropriate rows and columns from the data frame?

A. empdata[empdata$Age > 40, c("Salary","Occupation")]

B. empdata[c("Salary","Occupation"), empdata$Age > 40]

C. empdata[Age > 40, ("Salary","Occupation")]

D. empdata[, c("Salary","Occupation")]$Age > 40

You have two tables of customers in your database. Customers in cust_table_1 were sent an e-mail promotion last year, and customers in cust_table_2 received a newsletter last year. Customers can only be entered in once per table. You want to create a table that includes all customers, and any of the communications they received last year. Which type of join would you use for this table?

A. Full outer join

B. Inner join

C. Left outer join

D. Cross join

When creating a presentation for a technical audience, what is the main objective?

A. Show that you met the project goals

B. Show how you met the project goals

C. Show if the model will meet the SLA

D. Show the technique to be used in the production environment

Consider a scale that has five (5) values that range from "not important" to "very important". Which data classification best describes this data?

A. Ordinal

B. Nominal

C. Real

D. Ratio

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

How are window functions different from regular aggregate functions?

A. Rows retain their separate identities and the window function can access more than the current row.

B. Rows are grouped into an output row and the window function can access more than the current row.

C. Rows retain their separate identities and the window function can only access the current row.

D. Rows are grouped into an output row and the window function can only access the current row.

Consider these itemsets:

(hat, scarf, coat)

(hat, scarf, coat, gloves)

(hat, scarf, gloves)

(hat, gloves)

(scarf, coat, gloves)

What is the confidence of the rule (gloves -> hat)?

A. 75%

B. 60%

C. 66%

D. 80%

In data visualization, what is used to focus the audience on a key part of a chart?

A. Emphasis colors

B. Detailed text

C. Pastel colors

D. A data table