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?
Select an option, then click Submit answer.
-
○
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.
-
○
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.
-
○
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.
-
○
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.
-
○
The solution should apply a filter to the Excel file to hide any row with empty cells and only load the complete rows.
