UiPath-ADPv1 Generic Automation Development — 10 Questions

Question 1

An automation project requires processing a large Excel file with 50,000 rows. Which approach minimizes memory usage while ensuring data integrity?

Accepted Answer

Implement a batch processing loop that reads 1,000 rows at a time using the Range property in Read Range.. The explanation correctly identifies that loading 50,000 rows into a single DataTable can cause memory issues. Option C is the correct approach because it limits the memory footprint by processing data in chunks. The explanation is accurate in its justification of why batching is necessary for stability.

Answer

Read the entire file into a DataTable using Read Range and process it inside a For Each Row loop.

Answer

Use the Excel Application Scope to read the file and save the result as a CSV, then read the CSV.

Answer

Execute a macro within the Excel file to calculate the results and retrieve only the final total.

Question 2

Refer to the exhibit. An automation fails to click a button because the UI is slow to load. Given the configuration, what is the maximum duration the robot will wait before throwing an error?

Accepted Answer

120 seconds. The Retry Scope activity does not multiply the activity's internal timeout by the number of retries. The 'Timeout' property of an activity (like Click) defines how long the robot waits for the element to appear during a single attempt. If the element is not found within that timeout, the activity fails, and the Retry Scope triggers a retry. The total maximum duration is (Number of Retries + 1) * (Timeout of the activity). If the activity has a 30-second timeout and 3 retries, the total time is 4 * 30 = 120 seconds, assuming the activity fails immediately at the end of each timeout.

Answer

30 seconds

Answer

45 seconds

Answer

135 seconds

Question 3

Which action is recommended when you need to store temporary data that must persist across multiple workflow executions within the same robot session?

Accepted Answer

Pass the data as an 'In' argument through each individual workflow.. Orchestrator Assets are designed for persistent storage across different machines and sessions, but they are not the recommended way to handle temporary data within a single robot session. For data that must persist across multiple workflow executions within the same robot session, 'Global Variables' (defined in the State Machine or a shared scope) or 'In/Out' arguments are standard. However, if the data must persist across *different* robot sessions, Orchestrator Assets are correct. Given the phrasing 'same robot session', the question is ambiguous or flawed.

Answer

Store the data in a local environment variable.

Answer

Use an Orchestrator Asset to store the data.

Answer

Save the data to a temporary text file on the local desktop.

Question 4

An automation project requires reading data from a large Excel file containing 50,000 rows. Which method provides the most efficient performance when extracting this data into a DataTable?

Accepted Answer

Use the Excel Process Scope with the Read Range activity within an Excel Application Scope.. The 'Excel Application Scope' is a legacy activity and is not used with 'Excel Process Scope'. Modern UiPath projects use the 'Excel Process Scope' activity in conjunction with the 'Use Excel File' and 'Read Range' (from the Excel activities package) to leverage the Excel API. The explanation incorrectly conflates legacy and modern activities.

Answer

Use the Read Range Workbook activity with the 'Preserve Format' option enabled.

Answer

Use a For Each Row activity combined with a Cell Read activity inside the loop.

Answer

Use the Read CSV activity converted from the Excel file to a text format.

Question 5

A developer needs to read data from a CSV file that contains columns with inconsistent delimiters and embedded commas inside quoted fields. The robot must parse the file correctly without manual preprocessing. Which activity or feature should be used?

Accepted Answer

Generate Data Table activity with a custom CSV parser configured to respect quoting.. CSV files with quoted commas and inconsistent delimiters require a parser that understands quoting rules. The Generate Data Table activity provides configurable parsing that respects quoted fields, unlike naive splitting or standard CSV readers that assume uniform delimiters. Using it avoids manual preprocessing and prevents data corruption from embedded commas.

Answer

Excel Application Scope with a workbook read range on the CSV file.

Answer

Read CSV activity with the delimiter property set to comma.

Answer

Read Text File followed by string splitting on commas.

Question 6

A developer builds a UiPath automation that uses an Excel Application Scope to read a worksheet containing 50,000 rows. During testing, the process consumes excessive memory and occasionally fails with an out-of-memory exception. The developer must reduce memory usage while preserving the ability to process every row. Which approach should be used?

Accepted Answer

Use the Read Range activity with the 'ReadRange' property set to a limited range, and process the file in chunks by using the Excel Application Scope with a dynamic range for each chunk.. Chunking the read operation limits the number of rows loaded into memory at any moment. By using a dynamic range with Excel Application Scope, the automation can process the file sequentially without holding the entire dataset. This preserves data integrity and avoids the out-of-memory condition that occurs when reading all rows at once.

Answer

Use the Workbook Read Range activity to load the file, then process rows with a For Each Row activity while periodically clearing the DataTable.

Answer

Use the Excel Application Scope with a Read Range activity inside a While loop, reading one row at a time by incrementing the range address.

Answer

Replace Excel Application Scope with the Read Range activity configured to read the entire sheet into a DataTable, then iterate with a For Each Row activity.

Question 7

An automation must interact with a desktop application that renders its UI using a custom framework. Standard selectors generated by UiPath Studio are unstable and change every time the application restarts. The developer needs a reliable way to identify elements across sessions. Which approach is most appropriate?

Accepted Answer

Use Computer Vision activities with OCR-based targeting for all UI interactions.. When the UI element tree is unstable across sessions, selector-based targeting cannot be trusted. Computer Vision targets elements by visual characteristics and spatial relationships, which remain consistent if the application renders the same layout. This makes it the most reliable option for custom frameworks where standard selectors change on each restart.

Answer

Add wildcards to every attribute in the existing selectors to absorb the changes.

Answer

Use anchor-based selectors by pairing each element with a nearby stable text label.

Answer

Switch all activities to Hardware Events to bypass selector matching.

Question 8

An automation must repeatedly type the same customer reference number into several separate fields across a form. The developer wants to avoid duplicating the literal string in every activity and wants a single place to change the value later. Which approach best meets this requirement within a single project?

Accepted Answer

Define a constant argument or a configuration value in the project's Config file and pass it to the activities that need it.. A value reused across many activities and workflows should live in one authoritative place inside the project. The configuration file pattern provides exactly that: a single declaration that workflows read, so edits propagate everywhere and no literal is duplicated. It keeps the design environment-independent and avoids the scope limits of variables and the external dependency of Orchestrator assets.

Answer

Store the value in a text file on the machine and read it with a Read Text File activity inside every workflow that needs it.

Answer

Define the value once as a project-level asset in Orchestrator and retrieve it with a Get Asset activity in each workflow.

Answer

Create a project-level variable and reference it in the Type Into activities using its name in the Input property.

Question 9

An automation developer is using the UiPath Orchestrator API to trigger a job for a process that has a queue-based trigger. The developer needs to ensure that the job starts only after a specific queue item has been added and its status is 'New'. Which Orchestrator API endpoint should be used to start the job conditionally?

Accepted Answer

POST /odata/Queues/UiPathODataSvc.AddQueueItem to add the item, then rely on a queue trigger in Orchestrator to automatically start the job when the item is added.. Queue triggers in Orchestrator monitor a queue and automatically start a job when a new item is added. By using the AddQueueItem API to enqueue the item, the trigger fires and starts the process. This is the correct way to conditionally start a job based on queue item status, as it leverages Orchestrator's native capabilities.

Answer

POST /odata/Jobs/UiPath.Server.Configuration.OData.StopJobs to stop any running job, then start a new job with the StartJobs endpoint after the queue item is added.

Answer

POST /odata/QueueProcessingRecords/UiPathODataSvc.StartTransaction with a transactionData object that includes the queue name and reference.

Answer

POST /odata/Jobs/UiPath.Server.Configuration.OData.StartJobs with a JobsStartInfo object that includes the process key and a specific queue item ID.

Question 10

An attended automation must pause and ask the user to confirm a value before continuing, but it must not block indefinitely if the user steps away. The developer wants the process to proceed with a default value if no response is received within a set time. Which approach achieves this behavior?

Accepted Answer

Use a Form activity with a confirmation field and configure a timeout so the form closes and a default result is returned if the user does not act.. The requirement combines an interactive confirmation with a bounded wait and a fallback. A Form activity with a configured timeout returns its default field values when the user does not respond, so the process resumes automatically with the predefined choice. This satisfies both the attended prompt and the non-blocking guarantee in a single, declarative control.

Answer

Use a Parallel activity containing a Message Box and a Delay, and continue when the Delay completes first.

Answer

Use an Input Dialog activity and set its TimeoutMS property so that the activity returns after the specified milliseconds if the user does not respond.

Answer

Use a Message Box activity and rely on the operator to click OK within the expected timeframe.