13. In which of the following visual recipes is the Pre-filter step NOT available?

Group

Window

Prepare

Pivot

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

14. Use the Advanced Designer Certificate Assessment project to answer this question. The Group recipe that creates the Product_Aggregated Dataset uses a Post-filter step to remove products with low quantities of sales. It would have been more efficient to use a Pre-filter step.

False. The column used as the filter condition is only created in the Group step.

Both options are exactly the same.

True. These rows could be removed before the Group operation.

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

15. Use the Advanced Designer Certificate Assessment project to answer this question. For stock item 22197, what was the largest gap in days between any two weeks of qualifying purchases in the windowed output?

14

84

7

182

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

16. Which of the following are the two minimum required components for a functioning scenario? Select two.

A sequence of steps or a custom script to run when the scenario launches.

Metrics and checks defined for any dataset built by the scenario.

Trigger(s) that activate the scenario.

A reporter to send scenario information via several available channels.

A code snippet to stop the scenario on certain conditions.

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

17. Which of the following Formulas correctly uses the substring function to retrieve only the last two characters of a string column named "my_column"?

substring(my_column, 0, -2)

substring(my_column, 2, 0)

substring(my_column, -2)

substring(my_column, 2)

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

18. The output to a Window recipe will have the same number of rows as its input dataset.

False. The number of rows depends on the number of groups in the partitioning column.

It cannot be known without knowing the kinds of aggregations included.

Always true. This is the key differentiator between Group and Window recipes.

Sometimes true. If a pre- or post-filter step is used, the number of rows may be different.