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