U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Blue Prism ASD01 Exam - Topic 3 Question 19 Discussion

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?
C) The solution should 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
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.
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.

Blue Prism ASD01 Exam - Topic 3 Question 19 Discussion

Actual exam question for Blue Prism's ASD01 exam
Question #: 19
Topic #: 3
[All ASD01 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

0/2000 characters
Pedro
8 months ago
Totally with D, clean data saves time in the long run!
upvoted 0 times
...
Tresa
8 months ago
Wait, can we really trust the machine-generated file?
upvoted 0 times
...
Eden
8 months ago
B is too aggressive, we might lose valid data!
upvoted 0 times
...
Kris
8 months ago
I think A makes sense too, just mark exceptions later.
upvoted 0 times
...
Emily
8 months ago
Sounds like D is the best option. Validate first!
upvoted 0 times
...
Malissa
8 months ago
I’m leaning towards option A, but I’m not entirely convinced that skipping validation could lead to more issues down the line.
upvoted 0 times
...
Cheryl
8 months ago
I feel like option C could work too, but I wonder if looping through the collection might slow things down with a larger dataset.
upvoted 0 times
...
Zena
8 months ago
I think option D sounds familiar; it emphasizes validating data before processing, which seems like a good practice based on similar questions we practiced.
upvoted 0 times
...
Tasia
9 months ago
I remember we discussed the importance of data validation in class, but I'm not sure if it should happen before or after loading the queue.
upvoted 0 times
...
Billi
9 months ago
Okay, I think I've got a good handle on this. I'll focus on keeping the private content secure while allowing unauthenticated access to the login page.
upvoted 0 times
...
Theola
9 months ago
Okay, let's see. The key here is understanding what "service" means in this context. I think I can narrow it down.
upvoted 0 times
...

Save Cancel