Online Access Free DEA-7TT2 Exam Questions

Which clause is required by all window functions?
Response:

• A.PARTITION BY
• B.RANGE()
• C.OVER()
• D.ORDER BY

After which phase of the data analytics lifecycle should you determine if the model is robust enough?
Response:

• A.Model building
• B.Data preparation
• C.Discovery
• D.Operationalize

A data scientist is preparing a presentation for a meeting with the project's business sponsors. The distribution of per-sale revenue is an important finding from the analysis. The graphics illustrate four ways to plot the per-sale revenue distribution." Which graphic is most appropriate for the sponsor presentation?
Response:

• A.Figure D
• B.Figure A
• C.Figure B
• D.Figure C

In time series analysis, what function is examined to identify the order of the moving average component of an ARIMA model?
Response:

• A.Exponential function
• B.Autocorrelation function
• C.Arithmetic mean function
• D.Geometric mean function

Refer to the exhibit.

You are asked to write a report on how specific variables impact your client's sales using a data set provided to you by the client. The data includes 15 variables that the client views as directly related to sales, and you are restricted to these variables only.
After a preliminary analysis of the data, the following findings were made:
1. Multicollinearity is not an issue among the variables
2. Only three variables-A, B, and C-have significant correlation with sales You build a linear regression model on the dependent variable of sales with the independent variables of A, B, and C. The results of the regression are seen in the exhibit.
Which interpretation is supported by the analysis?
Response:

• A.Variables A, B, and C are significantly impacting sales and are effectively estimating sales
• B.Due to the R2 of 0.10, the model is not valid - the linear regression should be rerun with all 15 variables forced into the model to increase the R2
• C.Variables A, B, and C are significantly impacting sales, but are not effectively estimating sales
• D.Due to the R2 of 0.10, the model is not valid - a different analytical model should be attempted