Workflow Control and Invocation

Question 1

According to the expense policy of some company, the expenses greater than $1000 need to be accepted by the head of the department. Which of the following solutions would automate the handling of incoming expenses in this company?

1. Collect all expenses and use the Row Filter node to find the expenses above $1000. Send the output table to the head of department.
2. Create an IF or a CASE switch that checks if the amount is > $1000. If yes, the workflow branch that sends an email to the head of department activates.
3. Collect all expenses and use a Group Loop that handles the expenses that are below/above $1000 in different iterations.

Answer 1

2.

Question 2

You would like to calculate a few aggregated metrics based on the table. Which of the aggregation tasks require a Group Loop instead of a single GroupBy node? Select 2.

Customer_ID | Payment Method | Sales (Food, $) | Sales (Non-food, $)
2 | Credit | 10 | 35
7 | Debit | 5 | 42
7 | Credit | 7 | 38
5 | Credit | 9 | 27
9 | Debit | 15 | 29
2 | Credit | 12 | 33

1. Calculate the number of customers by payment method debit/credit
2. Calculate the sum of sales of food and non-food products for each customer ID
3. Find out the customer who generates the most revenue within each area
4. Find out the maximum amount spent for food in one order

Answer 2

2 and 3

Question 3

Which of the following tasks would you solve with a Counting Loop? Select 2.

1. You want to calculate KPIs by groups identified by the department name
2. You implement a game that has 5 rounds and, in each round, shows a user a random question from a question pool in an interactive view.
3. You want to generate a finite number of IDs that contain a count that increases with each iteration, for example, XX01, XX02, … XX25.

Answer 3

2 and 3

Question 4

TRUE or FALSE? You can make the loop stop if it produces an unexpected result, for example, an empty table.

Answer 4

TRUE

Question 5

TRUE or FALSE? You can inspect the intermediate results of a loop.

Answer 5

TRUE

Question 6

Loop Start, Loop Body, or Loop End?
Sends parameters and data for each iteration

Answer 6

Loop Start

Question 7

Loop Start, Loop Body, or Loop End?
Executes the task of the loop

Answer 7

Loop Body

Question 8

Loop Start, Loop Body, or Loop End?
Checks if the end condition is fulfilled. If yes, collects the results from the iterations

Answer 8

Loop End