UiPath-ADPv1 Advanced Data Manipulation — 10 Questions

Question 1

You need to update a specific value in a DataTable based on a matching ID in another DataTable. Which approach is best for performance?

Accepted Answer

Create a Dictionary of IDs and values, then iterate once through the primary table.. The correct option (C) describes using a Dictionary for lookups, but the explanation describes using LINQ Joins. While both are performant, the explanation must align with the chosen correct answer.

Answer

Use a nested For Each loop to compare IDs and update values.

Answer

Use a Lookup Data Table activity inside a For Each loop.

Answer

Use the 'Update Data Row' activity with an SQL query.

Question 2

Which method is best for removing duplicate rows from a DataTable based on a specific column?

Accepted Answer

Use the 'Remove Duplicate Rows' activity.. The 'Remove Duplicate Rows' activity is the most efficient, native UiPath Studio way to remove duplicate rows from a DataTable based on specific columns without needing complex code or LINQ queries. It provides a direct, configurable interface in the designer panel.

Answer

Use a nested For Each loop to compare rows.

Answer

Use a LINQ query with .GroupBy() and .First().

Answer

Export to Excel and use the 'Remove Duplicates' feature.

Question 3

Which approach correctly converts the JSON 'data' property into a DataTable object?

Accepted Answer

Use Newtonsoft.Json.JsonConvert.DeserializeObject(Of DataTable)(myJsonObj("data").ToString). The explanation states 'Simply calling ToString() on a JToken returns a string representation, not a structured DataTable. Using 'JsonConvert.DeserializeObject' is the standard approach', but option B (the correct answer) specifically uses '.ToString()' on 'myJsonObj("data")' before passing it to 'DeserializeObject(Of DataTable)'. The explanation should clarify that you must convert the JToken to a string using ToString() first, because DeserializeObject expects a JSON string, not a JToken.

Answer

Use CType(myJsonObj("data"), DataTable)

Answer

Use DirectCast(myJsonObj("data"), DataTable)

Answer

Use the 'Convert' class: Convert.ToDataTable(myJsonObj("data"))

Question 4

You need to perform a regex match on a multi-line string to find all occurrences of a specific pattern. Which configuration ensures the newline characters are handled correctly?

Accepted Answer

Use RegexOptions.Multiline. In .NET regular expressions (used by UiPath), `RegexOptions.Singleline` (or the `s` inline flag) makes the dot (.) character match every character, including newline characters. Conversely, `RegexOptions.Multiline` (or the `m` inline flag) changes the behavior of the anchors '^' and '$' to match the start and end of any line, rather than the start and end of the entire string. Since the stem asks to find occurrences in a 'multi-line string' where newline characters need to be handled correctly for pattern matching (typically involving line anchors, or alternatively dot-matching), Option A (Multiline) or Option D are standard for line-based matching. However, if the question implies the dot matching across newlines, Singleline is correct for the dot, but the standard trap for 'multi-line string' regex is Multiline. Actually, the .NET definition of Multiline affects ^ and $. The explanation states 'treats the entire input as a single stream' which defines Singleline (dot matches newline), but the option marked correct versus the standard exam knowledge for multi-line string usually expects Multiline for line anchors. Let's fix the correct option to A and update the explanation to match standard .NET regex definitions.

Answer

Use RegexOptions.Singleline

Answer

Use RegexOptions.IgnorePatternWhitespace

Answer

Use the (?m) inline flag

Question 5

Which index access will correctly return 'RPA'?

Accepted Answer

parts(1). String manipulation using the Split method converts a single string into a zero-indexed array based on a delimiter. In this instance, 'UiPath' is index 0, 'RPA' is index 1, and 'Developer' is index 2. Understanding array indexing is fundamental for parsing data, such as log file strings or system path components, and is a core competency for any UiPath developer handling string-based data.

Answer

parts(0)

Answer

parts(2)

Answer

parts.ElementAt(1)

Question 6

You are processing an XML document and need to retrieve the text content of a tag named 'ID' that is nested within a 'Customer' tag. Which LINQ to XML query is most robust?

Accepted Answer

xmlDoc.Descendants("ID").Value. To robustly retrieve a tag nested within another tag regardless of exact tree depth or direct root-child relationships, using Descendants or descendants-matching methods combined with null-checking (or FirstOrDefault) is preferred. Option A's underlying LINQ pattern (though simplified in the options) targets descendants properly, whereas strict chaining with .Element() fails if the hierarchy varies.

Answer

xmlDoc.Element("Customer").Element("ID").Value

Answer

xmlDoc.Root.Attribute("ID").Value

Answer

xmlDoc.Find("ID").Text

Question 7

A developer is processing a DataTable named 'dt_Sales' containing columns 'Region' (String) and 'Revenue' (Double). They need to generate a new DataTable that contains one row per region and the sum of revenue for that region. Which LINQ expression correctly achieves this transformation?

Accepted Answer

dt_Sales.AsEnumerable().GroupBy(Function(r) r("Region")).Select(Function(g) dt_Sales.Clone().Rows.Add(g.Key, g.Sum(Function(r) Convert.ToDouble(r("Revenue"))))).CopyToDataTable(). The expression 'dt_Sales.Clone().Rows.Add(...)' returns the index of the added row (an Integer), not a DataRow object. The Select method expects a DataRow to be returned to form the new DataTable. Additionally, the columns in the cloned DataTable must be defined to match the projected data. A correct approach would involve creating a new DataRow using dt_New.NewRow() or using a projection that returns a DataRow.

Answer

dt_Sales.Select("Region, Sum(Revenue) Group By Region")

Answer

dt_Sales.AsEnumerable().Where(Function(r) r("Region").ToString.Contains("Sum")).CopyToDataTable()

Answer

dt_Sales.AsEnumerable().OrderBy(Function(r) r("Region")).Select(Function(r) r("Revenue")).CopyToDataTable()

Question 8

A developer is building a UiPath workflow that reads a CSV file containing a column of monetary amounts formatted with a European style, for example '1.234,56'. The file is loaded into a DataTable with the column stored as String. The developer needs to convert each value into a Double for aggregation. The workflow must handle values with or without thousands separators and must not throw an exception for blank cells, which should be treated as 0. Which approach should the developer use inside a For Each Row activity?

Accepted Answer

Check if the cell is blank using String.IsNullOrWhiteSpace; if blank assign 0, otherwise use Double.Parse with NumberStyles.Any and CultureInfo("de-DE").. The correct approach explicitly handles blank cells before parsing, ensuring no exception is thrown for empty values, and uses the appropriate culture and number styles to correctly interpret European-formatted monetary strings. This combination meets all stated requirements: it supports optional thousands separators, treats blanks as zero, and avoids runtime errors. The other options either throw exceptions on blanks or use invalid method overloads.

Answer

Use Double.Parse(row("Amount").ToString(), New CultureInfo("de-DE")) inside a Try Catch, and assign 0 in the Catch block.

Answer

Use Double.Parse(row("Amount").ToString(), NumberStyles.Any, New CultureInfo("de-DE")) without any blank handling.

Answer

Use Convert.ToDouble(row("Amount").ToString(), CultureInfo("de-DE")) and rely on its default behavior for blank strings.

Question 9

A developer is using the 'Deserialize JSON' activity to parse a JSON array containing 10,000 objects into a DataTable. The JSON has a property 'Date' that is a string in ISO 8601 format. Which approach ensures the 'Date' column is correctly typed as DateTime in the resulting DataTable?

Accepted Answer

Deserialize the JSON into a JArray, then use a LINQ query to project each object into a new DataRow with a DateTime property, and finally use 'CopyToDataTable'.. The correct method involves deserializing to JArray and using LINQ to project each item with a properly typed DateTime property, then converting to DataTable. This ensures the 'Date' column is DateTime, avoiding post-processing loops and leveraging .NET's strong typing.

Answer

Use the 'Deserialize JSON' activity with the 'DataTable' output, then use the 'Convert DataTable Column' activity to change the 'Date' column to DateTime.

Answer

After deserialization, use a 'For Each Row' loop to convert the 'Date' column using DateTime.Parse and assign it back, then change the column type.

Answer

Use the 'Deserialize JSON' activity and set the 'Date' property to DateTime in the JSON string before deserialization using string manipulation.

Question 10

A developer needs to extract specific values from a large JSON string returned by an API. The JSON contains nested objects and arrays, and the developer wants to avoid deserializing the entire structure into a DataTable. Which TWO activities or methods are appropriate for directly querying nested JSON data in UiPath? (Choose two.)

Accepted Answer

Use the 'Deserialize JSON' activity to convert the string into a JObject, then use select tokens with a JSONPath query.. Deserializing JSON into a JObject enables direct querying via JSONPath or property access, both of which handle nested structures efficiently. These methods avoid the overhead and limitations of converting to a DataTable. They are standard practices in UiPath for extracting specific values from complex JSON payloads.

Answer

Use the 'Read Text File' activity to load the JSON into a string, then use string manipulation functions to extract values.

Answer

Use the 'Generate Data Table' activity with the JSON string as input to automatically parse nested structures.

Answer

Use the 'Deserialize JSON Array' activity to convert the string into a JArray, then iterate through elements.