You must be able to wire activities that read CSV and JSON into DataTables or JsonObject, extract columns into arrays concisely, and test file paths with string methods. The single most important thing is matching the parsed output type to the correct accessor so downstream activities receive the expected data.
Start practicing
Files, Folders, and Data Manipulation — choose a session length
Free · No account required
Domain overview
This domain covers reading and writing files, parsing JSON and CSV into DataTables, extracting columns into arrays, and manipulating paths and strings inside UiPath Studio workflows. Questions present a scenario, such as configuring a file mover from a JSON config, and ask you to pick the correct activity sequence or . NET method invocation.
Exam objectives
Reading CSV files into a DataTable using Read CSV or Generate Data Table for For Each Row processing
Deserializing JSON with Deserialize JSON and extracting values via JsonObject, JObject, or SelectToken
Extracting a DataTable column into an array using DataTable.AsEnumerable().Select with Field or ItemArray
Checking file paths and strings with String.Contains, Path.GetFileName, or EndsWith for conditional logic
Confusing Deserialize JSON output type (JsonObject versus JObject) and then calling the wrong property accessor, causing runtime errors.
Using Read CSV without checking delimiter or headers, so the DataTable columns are misaligned and For Each Row fails.
Building arrays from DataTable columns with slow loops instead of AsEnumerable().Select, or forgetting to import System.Data.DataSetExtensions.
Click any question to see the full explanation and answer options, or start a focused practice session above.
Which TWO methods are recommended for safely handling file paths in UiPath to ensure cross-platform compatibility?
2Refer to the exhibit. You are reading this JSON file to configure a file mover. Which activity sequence correctly parses this JSON and moves the files?
3Which THREE actions are essential for ensuring data integrity when overwriting an existing file during a data export operation?
4Which data manipulation approach is most efficient for transforming a DataTable with 10,000 rows without using activities in a loop?
5When extracting a specific column from a DataTable into an array, which method provides the most concise and efficient syntax?
6Which activity is best suited for deleting a folder along with all its contents?
7You need to update a specific cell in an Excel file without loading the entire document into a DataTable. Which approach is most efficient?
8When writing data to a CSV file, which property should be set to true if you want to avoid overwriting existing data?
9Which method is the most appropriate for checking if a specific string contains a key piece of information in a file path?
10You need to retrieve the name of a file without its extension from a full path string. Which method should you use?
11You are developing an automation that processes thousands of small CSV files located in a local directory. Which approach provides the best performance while ensuring file integrity during the read operation?
12Refer to the exhibit. Your automation is failing with this error when trying to move a file. Which technique is most effective to resolve this intermittent access violation?
13A developer stores a DataTable named dtOrders that was read from an Excel file. They need to keep only the rows where the column "Status" equals "Open" and store the result in a new DataTable variable called dtOpenOrders. Which activity should they use to accomplish this with the least configuration effort?
14A developer is building a UiPath automation that must read every row of a CSV file into a DataTable so that each row can be processed by a For Each Row in Data Table activity. The CSV uses standard comma delimiters and the first row contains column headers. Which activity should the developer use?
15An automation must append new transaction rows to an existing CSV file at the end of each run without deleting the data already present. The developer is configuring the Write CSV activity. Which property must be set to achieve append behavior?
16A developer needs to read a CSV file named invoices.csv whose first line contains column headers and whose values are separated by semicolons rather than commas. The resulting data must be available as a DataTable for downstream processing. Which TWO actions are required to accomplish this correctly? (Choose two.)
17An automation downloads a daily report to a temporary folder. Before processing, the developer must confirm that the file C:\Temp\report.xlsx exists and is not currently locked by another process. Which activity should be used to check whether the file exists?
18A developer is building an automation that reads a DataTable from an Excel file, performs transformations, and must output the result to a new Excel workbook. The developer wants to ensure the output preserves data types and column structure correctly. Which two actions should the developer take? (Choose two.)
19A developer is building an automation that reads a large CSV file into a DataTable and then needs to keep only rows where the 'Status' column equals 'Active' and the 'Region' column equals 'EMEA'. The developer wants to avoid iterating through every row. Which method should be used to produce the filtered DataTable?
You must be able to wire activities that read CSV and JSON into DataTables or JsonObject, extract columns into arrays concisely, and test file paths with string methods. The single most important thing is matching the parsed output type to the correct accessor so downstream activities receive the expected data.
The Courseiva UiPath-ADAv1 question bank contains 19 questions in the Files, Folders, and Data Manipulation domain. Click any question to see the full explanation and answer breakdown.
Start with a 10-question focused session to identify your baseline accuracy in this domain. Read every explanation — even for questions you answer correctly — to understand the reasoning. Once you score consistently above 80%, move to a 20–30 question session to confirm depth before moving to the next domain.
Yes — the session launcher on this page draws questions exclusively from the Files, Folders, and Data Manipulation domain. Choose 10, 20, 30, or 50 questions for a focused session, or click individual questions to review them one by one.
Save your results, see per-domain analytics, and get readiness scores — free, for every certification.
Sign Up FreeFree forever · Every certification included