- All Exams Instant Download
What is an appropriate data visualization to use in a presentation for an analyst audience?
What is an appropriate data visualization to use in a presentation for an analyst audience?A . Pie chartB . Area chartC . Stacked bar chartD . ROC curveView AnswerAnswer: D
The OVER clause makes this what type of function?
Consider this SQL statement: SELECT product, prod_cost, avg(prod_cost) OVER (PARTITION BY product) FROM product_detail The OVER clause makes this what type of function?A . Window functionB . Aggregate functionC . System functionD . User-defined functionView AnswerAnswer: A
What is the sum of the probabilities that the model assigns to all the filers in your training set that have been audited?
You are building a logistic regression model to predict whether a tax filer will be audited within the next two years. Your training set population is 1000 filers. The audit rate in your training data is 4.2%. What is the sum of the probabilities that the model assigns to all...
What is your assessment of the model?
Refer to the exhibit. You have run a linear regression model against your data, and have plotted true outcome versus predicted outcome. The R-squared of your model is 0.75. What is your assessment of the model?A . The R-squared may be biased upwards by the extreme-valued outcomes. Remove them and...
Which action should the team recommend?
A disk drive manufacturer has a defect rate of less than 1.0% with 98% confidence. A quality assurance team samples 1000 disk drives and finds 14 defective units. Which action should the team recommend?A . The manufacturing process should be inspected for problems.B . A larger sample size should be...
What is the expected result?
Consider the following SQL query: SELECT product_id FROM supplier_A UNION SELECT product_id FROM supplier_B; What is the expected result?A . All product_id values from both tables with duplicates or repeating rowsB . All product_id values from supplier_A table but not from supplier_B tableC . All product_id values from supplier_B table...
In a user-defined aggregate function, what is SFUNC?
In a user-defined aggregate function, what is SFUNC?A . Window functionB . State transition functionC . Final calculation functionD . Segment-level calculation functionView AnswerAnswer: B
If R factors are categorical variables, which data classification level are they most closely related?
If R factors are categorical variables, which data classification level are they most closely related?A . NominalB . OrdinalC . IntervalD . RatioView AnswerAnswer: A
Which process in text analysis can be used to reduce dimensionality?
Which process in text analysis can be used to reduce dimensionality?A . StemmingB . ParsingC . DigitizingD . SortingView AnswerAnswer: A
Which method is used to solve for coefficients b0, b1, .., bn in your linear regression model: Y = b0 + b1x1+b2x2+….+bnxn
Which method is used to solve for coefficients b0, b1, .., bn in your linear regression model: Y = b0 + b1x1+b2x2+….+bnxnA . Ordinary Least squaresB . Apriori AlgorithmC . Ridge and LassoD . Integer programmingView AnswerAnswer: A
