Advanced Data Manipulation

You are performing a string manipulation to extract a sub-string. Which method is most performant when the string length is consistently large?

Which THREE of the following are valid ways to handle dynamic JSON keys when using the 'Deserialize JSON' activity?

A developer is building a UiPath automation that processes a DataTable named dt_Orders. The DataTable contains a column 'OrderDate' of type String with values like "2023-04-15". The developer needs to filter rows where the order date is after January 1, 2023. Which approach correctly converts and filters the data?

A developer is working with a Dictionary(Of String, Integer) in UiPath to store counts of various transaction types. The dictionary is populated within a workflow. Which TWO statements are true regarding the behavior and manipulation of this dictionary? (Choose two.)

An automation developer is building a workflow that reads a CSV file into a DataTable named dt_Orders using the Read CSV activity. The 'OrderDate' column is currently stored as String. The developer needs to group all orders by month and compute a total per month using LINQ. Which approach correctly produces the monthly aggregation?

A developer needs to aggregate the total sales amount per region from a DataTable named dt_Sales, which has columns Region and Amount. The result must be a new DataTable with columns Region and TotalAmount, and the workflow must minimize memory usage and execution time. Which approach is the most efficient?

A developer is working with a JObject variable named 'jsonObj' that represents a complex API response. Which TWO methods are valid ways to retrieve the value of a property named 'status' as a string?

You are processing a large DataTable named 'dt_Inventory' and need to filter it to include only rows where the 'Status' column is 'Active' and 'Stock' is greater than 50. Which method is most efficient for a performance-optimized workflow?

When updating a DataTable row, what is the impact of using the .BeginEdit() and .EndEdit() methods?

A workflow receives a full customer name as a single string variable, for example 'Ada Lovelace', and must populate separate FirstName and LastName variables. The names always contain exactly one space separating the two parts, and surrounding whitespace may be present. Which expression correctly extracts the two parts?

A developer is using a 'For Each' activity to iterate over a DataTable and needs to access the value of a column named 'Amount' for each row. The column may contain DBNull.Value for some rows. Which expression safely retrieves the amount as a Decimal, handling DBNull by returning 0?

A developer is working with a DataTable that contains a column 'Price' of type String. The developer needs to calculate the total sum of all prices. Which approach is most appropriate?

Your team maintains a UiPath automation that reads pipe-delimited text files into a DataTable using Generate Data Table. Several files contain a literal pipe character inside quoted description fields, and downstream filtering by 'Region' silently returns wrong rows. Which change most reliably fixes the parsing without altering the source files?

An automation developer is building a UiPath workflow that reads a CSV file with thousands of rows using the 'Read CSV' activity. The 'Delimiter' property is left at its default. The CSV file uses semicolons as separators, and the first row contains column headers. After reading, the DataTable has only one column containing the entire row content. What is the most likely cause?

Which TWO methods are valid ways to add a new column to an existing DataTable?

Which of the following is the most appropriate way to handle null values when performing a calculation on a DataRow column?

Which string method effectively removes leading and trailing whitespace from a variable?

A developer needs to filter a DataTable named 'dt_Orders' to include only rows where the 'Priority' is 'High'. Which THREE methods can be used to achieve this in UiPath?

A developer is parsing a large XML string returned by a SOAP service. The document contains a default namespace declared as xmlns="http://tempuri.org/". The developer uses an XDocument variable and writes doc.Descendants("Customer") to retrieve all Customer elements, but the result is empty even though the XML clearly contains Customer elements. What is the correct fix?

A developer needs to extract a specific value from a deeply nested JSON response returned by an API. The JSON structure includes arrays and objects, and the target value is at a path like $.data.items[0].details.id. The developer wants to avoid deserializing the entire JSON into a custom class. Which approach is most efficient and maintainable in UiPath?

Which TWO methods are most efficient for performing bulk updates on a DataTable containing over 50,000 rows without impacting workflow performance significantly?

Which THREE actions are best practices when using Dictionary<TKey, TValue> for large-scale data storage within a workflow?

Which of the following is the most efficient way to merge two DataTables that have the same schema?

You are processing a large JSON string containing employee records. Which LINQ expression correctly extracts a list of names for all employees whose 'department' is 'Finance'?

A developer needs to extract a 10-digit account number from a string that always appears immediately after the phrase 'Account Number: ' and before the word ' (Active)'. Which Regex pattern is most appropriate for this specific extraction?

Which sequence of operations is correct?

When parsing a date string that follows an irregular format, which method provides the most control to avoid runtime conversion errors?

A developer needs to extract all email addresses from a large text string using a regular expression in UiPath. The pattern must match standard email formats. Which activity or method should they use to return all matches as a collection?

You have a JSON string containing nested objects and arrays. Which TWO approaches are best for parsing this data into a usable format within UiPath?

A workflow builds an in-memory lookup of 200,000 customer records keyed by a 12-character alphanumeric account code, then performs about 400,000 existence checks during invoice matching. The current implementation uses a List(Of String) of account codes and calls .Contains for each check, and the job now runs for hours. Which change best addresses the performance problem?

A developer needs to combine data from two DataTables, dt_Orders and dt_Customers, based on a common column 'CustomerID'. The result should include all columns from both tables, and only rows where CustomerID exists in both tables. Which method is most appropriate and efficient?

A UiPath process reads a monthly sales workbook where each sheet uses the same layout but the sheet name is appended with the region, for example 'Sales_EMEA'. The workbook path and region are provided as arguments at runtime. You must extract every data row from the sheet matching that region and load it into a DataTable. (Choose two.)