DELL D-DS-FN-23 Practice Test - Questions Answers, Page 4

List of questions
Question 31

DRAG DROP
Match each task to its description.
Question 32

Executives want to determine whether a change in a shopping rewards program has been effective in getting customers to increase their spending. Which approach could be used to determine if a significant shift in spending has occurred?
Question 33

Consider this SQL statement: SELECT product, avg(prod_cost) FROM product_detail GROUP BY product. The GROUP BY clause implies what type of function?
Question 34

Which SQL OLAP grouping extension returns a result for each output row with 1 identifying a summary row and 0 identifying grouped rows?
Question 35

In a user-defined aggregate function, what is FFUNC?
Question 36

What metrics are used to help calculate relevance in text analysis?
Question 37

On which type of data should you run K-means clustering?
Question 38

What does ''MAD'' in MADlib stand for?
Question 39

In the data preparation phase of the data analytics lifecycle, what does the term ''data conditioning'' refer to?
Question 40

MapReduce is designed to process data in which way?
Question