UiPath-ADPv1 Advanced Data Manipulation Practice Test 3 — 15 Questions

Question 1

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

Accepted Answer

DateTime.ParseExact(dateString, "yyyy-MM-dd", CultureInfo.InvariantCulture). Parsing dates with non-standard formats requires explicit format providers to ensure the conversion is unambiguous. 'DateTime.ParseExact' allows developers to define the expected format string, which is critical when dealing with international data or legacy systems that do not follow standard ISO formats. This precision prevents unexpected date values and ensures the robustness of time-sensitive business logic in the automation process.

Answer

CDate(dateString)

Answer

DateTime.Parse(dateString)

Answer

Convert.ToDateTime(dateString)

Question 2

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?

Accepted Answer

(?<=Account Number: )\d{10}(?= $Active$). Using Positive Lookbehind and Positive Lookahead ensures that the extraction is precise and does not include the surrounding anchor text in the result. In advanced automation, using zero-width assertions like these is preferred over simple matching because it eliminates the need for additional string trimming or sub-stringing after the Regex match is found.

Answer

Account Number: \d{10} (Active)

Answer

[0-9]{10}(?=Active)

Answer

(?<=Account Number: ).*(?=Active)

Question 3

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?

Accepted Answer

jsonObj("status").ToString. Accessing JSON properties in UiPath using the Newtonsoft.Json library can be done through indexing or dedicated methods. Understanding these various access methods is crucial for handling dynamic JSON responses where properties might be nested or optional. Both the indexer and the SelectToken method are standard ways to interact with JObject and JToken structures in VB.NET.

Answer

jsonObj.Get("status")

Answer

jsonObj.Property("status").Value.ToString

Answer

jsonObj.Parse("status")

Question 4

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?

Accepted Answer

Using the 'Filter Data Table' activity. UiPath offers multiple ways to filter data, ranging from visual activities to programmatic methods. The Filter Data Table activity is the most accessible for beginners, while the Select method and LINQ offer more control for complex logic. Understanding when to use each method allows developers to balance ease of maintenance with execution performance in professional automation projects.

Answer

Using the 'Lookup Data Table' activity

Answer

dt_Orders.Rows.Find("High")

Question 5

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?

Accepted Answer

Use the 'Group By' LINQ query to group rows by Region, compute the sum of Amount for each group, and then use 'CopyToDataTable' to create the result DataTable.. The correct answer uses LINQ Group By to aggregate data in one pass, which is both time and memory efficient. CopyToDataTable then creates the required DataTable. This avoids iterative filtering or manual updates, making it ideal for large datasets and ensuring minimal resource consumption.

Answer

Use the 'Aggregate' activity within a 'For Each Row' loop to compute the sum for each region, storing results in a Dictionary, then convert the Dictionary to a DataTable.

Answer

Use 'Build Data Table' to create an empty result table, then use 'For Each Row' to manually update the total for each region by searching the result table.

Answer

Use a 'For Each Row' activity to iterate through dt_Sales, and for each unique Region, use 'Filter DataTable' to sum the Amount values.

Question 6

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?

Accepted Answer

Use the 'Matches' activity from the Programming > RegEx category, which returns a collection of Match objects.. The Matches activity is the correct choice because it returns all regex matches as a collection of Match objects. It is efficient and designed for this purpose, unlike IsMatch, Split, or Find, which either do not return matches or return only the first match.

Answer

Use the 'Split' string method with the regex pattern as the delimiter.

Answer

Use the 'Find' activity from the Programming > RegEx category to locate the first match, then loop until no more matches are found.

Answer

Use the 'IsMatch' activity to check if the pattern exists, then use 'Replace' to extract the matches.

Question 7

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?

Accepted Answer

Use a 'For Each Row' loop, convert each row's 'OrderDate' to DateTime using DateTime.Parse, and use an If activity to check if the date is after January 1, 2023.. The correct approach is to iterate through each row, convert the string date to a DateTime object using DateTime.Parse, and then compare it to the target date. This ensures chronological accuracy. Filtering a string column directly, whether via Filter Data Table or Select, performs lexicographical comparison, which is unreliable for dates. Automatic conversion does not occur, so explicit parsing is necessary.

Answer

Use the 'Filter Data Table' activity with the condition 'OrderDate' 'Is greater than' and provide a DateTime variable set to January 1, 2023. The activity will automatically convert the string column to DateTime.

Answer

Use the 'Select' method on the DataTable with a filter expression like "OrderDate > '2023-01-01'". This leverages the DataTable's built-in filtering capabilities.

Answer

Use the 'Filter Data Table' activity with a condition on the 'OrderDate' column, selecting 'Is greater than' and entering '2023-01-01' as a string.

Question 8

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?

Accepted Answer

The 'Delimiter' property must be set to a semicolon (";") to correctly parse the file.. The 'Read CSV' activity uses a comma as the default delimiter. When the file uses semicolons, the activity fails to split columns, resulting in a single column containing the entire line. Setting the 'Delimiter' property to a semicolon resolves the issue. This is a common configuration oversight when working with regional CSV formats.

Answer

The 'ColumnNames' property must be set to the first row index to use headers.

Answer

The file encoding is incorrect, causing the parser to merge all columns.

Answer

The 'Read CSV' activity cannot handle files with more than 1000 rows.

Question 9

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?

Accepted Answer

Use the 'Deserialize JSON' activity to convert the JSON into a JObject, then use the 'Select Token' activity with the path "$.data.items[0].details.id" to retrieve the value.. Using Deserialize JSON to create a JObject and then Select Token with a JSONPath expression is the most efficient and maintainable method. It avoids custom classes and allows precise extraction from nested structures. Other methods either require unnecessary iteration, cannot handle nesting, or rely on fragile string parsing.

Answer

Use the 'Deserialize JSON' activity to convert the JSON into a DataTable, then use DataTable methods to query the value by column names.

Answer

Use string manipulation functions like Substring and IndexOf to locate the value by searching for the key 'id' within the JSON string.

Answer

Use the 'Deserialize JSON' activity with the 'Deserialize JSON Array' option, then use a 'For Each' loop to iterate through the arrays and manually navigate to the target value.

Question 10

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?

Accepted Answer

Use dt_Orders.AsEnumerable() with GroupBy(Function(r) DateTime.Parse(r("OrderDate").ToString()).ToString("yyyy-MM")) and then Sum on the parsed amount column.. LINQ against a DataTable requires converting rows into an enumerable via AsEnumerable(), then applying standard operators. GroupBy with a month-formatted key and Sum over the amount column yields one aggregated result per month. The other options misuse filter-based APIs that cannot perform grouping, or aggregate at the wrong granularity.

Answer

Use a For Each Row activity with an Assign that increments a Dictionary(Of String, Double), using the raw OrderDate string as the key.

Answer

Use dt_Orders.Compute("Sum(Amount)", "OrderDate") to calculate totals, since Compute groups automatically by the second argument.

Answer

Use dt_Orders.Select("OrderDate = 'yyyy-MM'") with the Select method to return grouped rows, then loop through them to total the amounts.

Question 11

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.)

Accepted Answer

The 'Item' property can be used to both retrieve and update the value associated with a key.. ContainsKey and the Item property are fundamental for safe and efficient dictionary manipulation. ContainsKey allows checking existence before access, while the Item property enables retrieval and update. The Add method throws on duplicates, iteration order is not guaranteed, and TryGetValue does not throw exceptions for missing keys.

Answer

Adding a duplicate key using the 'Add' method will overwrite the existing value without throwing an exception.

Answer

The 'TryGetValue' method returns the value if the key exists, and throws an exception if the key is not found.

Answer

Keys in the dictionary are automatically sorted in ascending order when iterating.

Question 12

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?

Accepted Answer

Replace Descendants("Customer") with Descendants(XName.Get("Customer", "http://tempuri.org/")) so the query includes the namespace.. LINQ to XML compares element names including their namespace URI. A default xmlns puts every unprefixed element into that namespace, so an unqualified name string matches nothing. Supplying the namespace via XName.Get (or a namespace-aware query) makes the query resolve correctly without altering the source document.

Answer

Call doc.Descendants().Where(Function(e) e.Name.LocalName = "Customer") to match on the local name only.

Answer

Remove the xmlns attribute from the XML string before parsing so the elements become unqualified.

Answer

Convert the string to an XmlDocument and use GetElementsByTagName("Customer"), which ignores namespaces by default.

Question 13

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?

Accepted Answer

If(row.IsNull("Amount"), 0D, CDec(row("Amount"))). The correct expression uses row.IsNull to check for DBNull and the If operator to return 0D when null, otherwise convert to Decimal. This safely handles null values and avoids exceptions. Other options either throw exceptions on DBNull or incorrectly parse the value.

Answer

Decimal.Parse(row("Amount").ToString())

Answer

CDec(row("Amount"))

Answer

row.Field(Of Decimal)("Amount")

Question 14

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?

Accepted Answer

Use the 'Join Data Tables' activity with an Inner Join type.. The 'Join Data Tables' activity with an Inner Join type directly performs the required operation: it combines columns from both tables and returns only rows where the key exists in both. It is optimized for performance and is the standard UiPath method for joining DataTables, avoiding manual loops or inefficient lookups.

Answer

Use a 'For Each Row' loop over dt_Orders and use 'Lookup Data Table' to find matching rows in dt_Customers.

Answer

Use the 'Merge Data Table' activity to combine the two tables.

Answer

Use the 'Filter Data Table' activity on both tables and then concatenate the results.

Question 15

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?

Accepted Answer

Replace Generate Data Table with Read CSV configured with the pipe delimiter and the quote character, so quoted pipes are treated as data.. Quote-aware delimited parsing must happen when the file is read, because a pipe inside a quoted description is data, not a field boundary. Read CSV with an explicit delimiter and quote character honors that rule, keeping columns aligned so the 'Region' column holds the true value and downstream filtering works. Replacing delimiters, stripping pipes, or repairing columns after a bad parse all lose or corrupt data.

Answer

Set the Generate Data Table column separator to a regex pattern that only matches pipes outside quotes, and enable the CSV parsing option.

Answer

Keep Generate Data Table but first use String.Replace to remove every pipe character from the file content, then load the cleaned text.

Answer

Load the file with Generate Data Table as-is, then repair the shifted columns by shifting cell values back using a For Each Row loop.