Blue Prism Certified Solution Designer (ASD01) — Question 18

A process is required for a telecoms company to work cases supplied via a daily Excel file. Although the file will only contain around 1000 rows, the average case time is such that the workload is far too big for one machine to complete in a day, so the solution has been designed with multiple machines in mind. One machine will load the work queue while the others wait, then once the queue is ready all machines will work it together. The requirements state that the input file is machine generated, has a known format, is generally clean but may contain exceptions "" rows with an empty cell, partial phone numbers, or accounts that don't exist.
What should the solution do to combat this problem?

Answer options

• A. The solution should read the file and load the queue without validating the data. The data validation should be the first step in working a queue item, with invalid cases marked as exceptions.
• B. The solution should open the file and delete any row with either missing, incomplete or invalid data. Then the "˜clean' file should be read and the resulting collection added to the queue.
• C. The solution read the file and then loop through the resulting collection and discard any row with either missing, incomplete or invalid data. Then the "˜clean' collection should then be loaded into the queue.
• D. The solution should validate the data and check that the accounts exist in the target applications beforehand, so that only clean cases are loaded into the queue.
• E. The solution should apply a filter to the Excel file to hide any row with empty cells and only load the complete rows.

Correct answer: C

Explanation

Option C is correct because it ensures that the solution processes the file by filtering out invalid data before loading the clean collection into the queue, which maintains data integrity. Options A and B either fail to validate data appropriately or remove data without consideration of the remaining valid entries. Option D focuses on account validation but does not address the initial data cleaning effectively, while Option E merely hides invalid rows instead of removing them from consideration.