Create and Manage Cloud Flows PL-200 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A company uses a cloud flow to synchronize data from a legacy system to Dataverse. The flow must create a new row in the 'Account' table if the account does not exist, and update the existing row if it does. The legacy system provides a unique external ID. You need to implement this logic efficiently. What should you do?

   • AUse the 'Update a row' action with the external ID as the key, and let the action create the row if it does not exist.
   • BUse the 'List rows' action to search for the account by the external ID, then use a Condition to decide whether to create or update.
   • CUse the 'Add a new row' action and rely on the flow to fail if the row already exists, then handle the error with a 'Run after' configuration.
   • DUse the 'Delete a row' action first, then always use 'Add a new row'.
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A company uses a cloud flow to process expense reports. The flow must check whether the expense amount exceeds $500. If it does, the flow must send an approval request to the manager; otherwise, it must update a SharePoint list item with the status 'Approved'. The flow currently uses a single action to update the list. You need to modify the flow to meet the requirement with minimal changes. What should you do?

   • AAdd a 'Do until' loop that iterates until the amount is less than $500, then run the approval action after the loop.
   • BAdd a Switch control with cases for amounts above and below $500, and place the approval and update actions in the respective cases.
   • CAdd a parallel branch after the trigger and configure both actions to run simultaneously, then use a condition to filter the results.
   • DAdd a Condition control after the trigger, place the approval action in the 'If yes' branch, and move the update action to the 'If no' branch.
   Reveal Solution Discussion Select an answer first
4. 23expert · hard

   A cloud flow receives a JSON payload from an HTTP request. The payload contains an array of objects, each with a 'price' property. You need to calculate the sum of all prices and store it in a variable. The array may be empty. Which expression should you use?

   • Asum(body('HTTP')?['items']?['price'])
   • Badd(body('HTTP')?['items'][0]?['price'], body('HTTP')?['items'][1]?['price'])
   • Csum(body('HTTP')?['items'])
   • Dsum(map(body('HTTP')?['items'], item()?['price']))
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A cloud flow has several actions that may fail, and you want to ensure that if any action fails, the flow sends a notification to the administrator and then stops. You also want to avoid sending multiple notifications if multiple actions fail. What is the best approach?

   • AWrap all the actions in a 'Scope', configure the 'Run after' of the notification action to run when the Scope fails, and set the notification action as the last action in the Scope.
   • BAdd a 'Run after' configuration to each action to send a notification if that action fails.
   • CUse a 'Condition' after each action to check if it failed and send a notification.
   • DAdd a 'Terminate' action after each action to stop the flow on failure.
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A cloud flow is triggered by a new email. The email body contains a table with product names and quantities. The flow must parse the table and calculate the total quantity for products that are in stock. The flow currently uses a 'Parse JSON' action to extract the table data. You need to sum the quantities. What expression should you use?

   • Asum(body('Parse_JSON')?['products']?['quantity'])
   • Bconcat(body('Parse_JSON')?['products']?['quantity'])
   • Clength(body('Parse_JSON')?['products']?['quantity'])
   • Dadd(body('Parse_JSON')?['products']?['quantity'])
   Reveal Solution Discussion Select an answer first