25. Use the Advanced Designer Certificate Assessment project to answer this question. What are the two most popular colors among product descriptions according to the word cloud on the distinct dataset? Select two.

Red

Black

Pink

White

Blue

------------------------------------------------------------

26. Which two settings are required in order to run a Top N recipe? Select two answers.

The column to identify groups of rows

Statistics to compute for each row

The number of top and/or bottom rows to display

At least one column to sort by

An explicit list of columns to retrieve

------------------------------------------------------------------

27. Use the Advanced Designer Certificate Assessment project to answer this question. What was the average quantity for the stock item "84077" (World War 2 Gliders Asstd Designs) that was sold during the week of "2010-11-01"? Tip: Look in the Product-Centric-Flow using the Tag views.

1006.56

13.08

402.46

12.04

89.14

--------------------------------------------------------------

28. Use the Advanced Designer Certificate Assessment project to answer this question. Which object is NOT tagged as being "Skeleton Project"?

Online_Retail_Distinct

Stacked_Online_Retail

compute_Online_Retail_Stacked

Product_Aggregated

Online_Retail_Prepared

--------------------------------------------------------------

29. Your dataset contains the predicted revenue for five customers, where rows contain the values of 2565, 4398, 3571, 4432, and 5598. You have configured the Top N recipe to retrieve the top and bottom row and sort the data in descending order. Which of the following best represents the values in the output dataset?

2565, 3571

5598, 4398

4398, 5598

5598, 2565

2565, 5598

-----------------------------------------------------------------------------------

30. What two settings are the absolute minimum requirement in order to run a Pivot recipe? Select two answers.

Custom aggregations

At least one aggregation to populate the pivoted columns

Pivot column

Row identifier column