UiPath-ADAv1 Files, Folders, and Data Manipulation — All Questions With Answers

Question 1

An automation needs to process files in a directory that are older than 30 days. Which combination of methods best retrieves and filters these files efficiently?

Accepted Answer

Use Directory.GetFiles, then filter the resulting array using a LINQ query based on 'New FileInfo(f).LastWriteTime'.. Option C is the correct approach. The explanation should clarify that while Directory.GetFiles returns an array of strings, using LINQ to instantiate FileInfo objects for each path allows for efficient filtering based on metadata properties like LastWriteTime, which is superior to manual looping and conditional checks.

Answer

Use a 'For Each' loop on Directory.GetFiles, then use an 'If' condition to check the file extension.

Answer

Use a 'For Each' loop to iterate through all files and use 'Get File Info' activity inside the loop.

Answer

Use the 'Move File' activity with a filter parameter set to 'LastWriteTime > 30'.

Question 2

Which activity should be used to retrieve the full path of all files with a specific extension in a directory and its subdirectories?

Accepted Answer

Use a 'For Each' loop to manually traverse folders.. UiPath does not have a native activity named 'Get Files'. The standard way to achieve this in UiPath is by using the 'Invoke Code' activity with the System.IO.Directory.GetFiles method or by using the 'Get Files' activity from the UiPath.System.Activities package (if referring to the 'Get Files' activity from the 'File' category, it is not a standard activity). The correct approach is typically using 'Directory.GetFiles(path, searchPattern, SearchOption.AllDirectories)'.

Answer

Use 'Get Files' with SearchOption.AllDirectories.

Answer

Use 'Get Files' with SearchOption.TopDirectoryOnly.

Answer

Use 'List Files' activity.

Question 3

Which TWO of the following methods are effective for managing temporary files created during an automation process? (Choose two)

Accepted Answer

Use the System.IO.Path.GetTempPath method to identify the safe directory for temp files.. Proper lifecycle management of temporary files prevents disk space depletion and security risks. Using the System.IO.Path.GetTempPath method ensures cross-machine compatibility by returning the correct temporary folder for the current user, while the Delete activity with the 'ContinueOnError' property set ensures the process doesn't crash if a file is already locked. These practices are fundamental to creating resilient, production-ready UiPath automations that don't leave residual clutter on servers.

Answer

Always use a hardcoded path like 'C:\Temp' to ensure the robot knows exactly where to look.

Answer

Create a new folder in the project root folder for every temp file created.

Answer

Rely on the operating system to automatically purge files in the user folder daily.

Question 4

An automation must append a DataTable named dtDaily to an existing .xlsx file at C:\Reports\sales.xlsx that already contains a worksheet named "Summary" with headers in row 1. The developer wants the new rows added directly beneath the existing data without loading the whole workbook into memory first. Which activity configuration accomplishes this?

Accepted Answer

Excel Application Scope with a Write Range activity targeting "Summary" and leaving the AddHeaders property unchecked. To append rows to an existing worksheet without loading the file, Write Range within Excel Application Scope is the correct activity, and unchecking AddHeaders prevents the existing header row from being duplicated. This writes only the new rows starting at the first available empty row. The alternatives either reload the entire workbook or use per-cell writes that are slow and error-prone.

Answer

Excel Application Scope with a Read Range activity followed by a Write Range activity that rewrites the entire sheet including old rows

Answer

Append Range activity inside Excel Application Scope, configured with the sheet name "Summary" and the dtDaily DataTable

Answer

Write Cell activity invoked once per row of dtDaily using a counter to compute the target cell address

Question 5

A developer needs to filter a DataTable named dtInvoices to keep only rows where the Status column equals "Open" and the Amount column is greater than 1000. The developer wants a single expression that returns a new filtered DataTable without iterating with a For Each Row activity. Which approach should be used?

Accepted Answer

Use the Filter Data Table activity, configuring two filter conditions on Status and Amount with the And operator.. Filter Data Table applies column conditions with And/Or logic and outputs a new DataTable in one step, matching the no-iteration requirement precisely. Manual looping, DataTable.Select with CopyToDataTable, and repeated Remove Data Row all either introduce loops or add fragility. The activity approach is the cleanest and most idiomatic UiPath solution.

Answer

Use a For Each Row in Data Table activity with an If activity and add matching rows to a new DataTable with Add Data Row.

Answer

Use the Select method on the DataTable with a filter string, then call CopyToDataTable on the resulting DataRow array.

Answer

Use the Remove Data Row activity repeatedly for rows that do not match the conditions.

Question 6

An automation must read a fixed-width text file where each record is 40 characters: a 10-character account ID, followed by a 20-character name, then a 10-character balance. The file has no delimiters. Which approach should the developer use to convert this file into a DataTable with three columns?

Accepted Answer

Use Read Text File to load the content, then use Generate Data Table with the 'Fixed width' option and specify the column positions 0-10, 10-30, and 30-40.. Fixed-width files require position-based parsing rather than delimiter-based parsing. Generate Data Table's fixed-width mode lets the developer define character ranges per column, which directly matches the 10/20/10 layout described. Using space delimiters, CSV parsing, or manual substring loops either corrupts records or adds unnecessary complexity, so the fixed-width configuration is the correct choice.

Answer

Use Generate Data Table with the space as the column separator and enable 'Column headers'.

Answer

Use Read CSV with the 'Delimiter' property set to a space and the 'ColumnCount' property set to 3.

Answer

Use Read Text File, then loop through each line with a While activity and use Substring to build a DataTable manually.

Question 7

A developer needs to write a DataTable to an Excel file using the Write Range activity and wants to ensure the output includes column headers and that existing data in the target sheet is not silently overwritten. Which two actions should the developer take? (Choose two.)

Accepted Answer

Enable the 'AddHeaders' property on the Write Range activity.. To include headers, AddHeaders must be enabled. To avoid replacing existing data, Append Range should be used when the intent is to add rows. Together, these actions ensure the output is labeled and existing content is preserved unless explicitly replaced. Clearing the sheet or writing to A1 would defeat the preservation goal, and visibility settings do not affect data integrity.

Answer

Set the 'Range' property to an empty string so data is appended after the last used row.

Answer

Clear the target sheet's contents before writing by using a Delete Range or Clear Range activity.

Answer

Enable the 'Visible' property on the Write Range activity to confirm the write operation to the user.

Question 8

An automation processes a folder containing files with various extensions. The developer needs to retrieve only files with the .pdf extension and read their full paths into a collection for later processing. Which activity and configuration should be used?

Accepted Answer

Use For Each File in Folder with the Filter property set to '*.pdf' and the IncludeSubfolders property set to False.. For Each File in Folder with a wildcard filter and subfolders disabled directly enumerates only PDF files in the target folder, providing full paths for each. This matches the requirement precisely. The other options either include subdirectories, require extra filtering, or return paths without the file objects needed for downstream processing.

Answer

Use the Directory.GetFiles method with the search pattern '*.pdf' and the SearchOption.AllDirectories parameter.

Answer

Use For Each File in Folder without a filter and use an If activity to check the extension inside the loop.

Answer

Use Get Files from Folder with the Filter property set to '*.pdf' and then loop through the resulting array.

Question 9

A developer is building a UiPath automation that reads a pipe-delimited text file into a DataTable. The file is generated by a third-party system and always contains the same columns in the same order, but it is stored with a .txt extension and cannot be renamed. Which activity should the developer use to load this file directly into a DataTable in a single step?

Accepted Answer

Read CSV. Because the file is delimited text with a consistent structure, the Read CSV activity is the intended tool. It accepts a custom delimiter such as the pipe character and handles the header row, producing a DataTable directly. Renaming the file is not required, and no additional parsing logic is needed.

Answer

Generate Data Table

Answer

Excel Application Scope with Read Range

Answer

Read Text File

Question 10

Which TWO methods are recommended for safely handling file paths in UiPath to ensure cross-platform compatibility?

Accepted Answer

Using Path.Combine for joining directory and file names.. Using Path.Combine ensures that directory separators are handled according to the host operating system, preventing issues when migrating between Windows and Linux environments. Path.GetFullPath is equally critical for resolving relative paths into absolute ones, which prevents ambiguity during runtime execution. Together, these methods form the foundation of secure and portable automation design, ensuring that file operations consistently point to the correct locations regardless of the execution context or environment variables.

Answer

Concatenating strings using the '+' operator.

Answer

Hardcoding full paths using double backslashes in all variables.

Answer

Always using forward slashes for all file operations.

Question 11

Refer 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?

Accepted Answer

Use 'Read Text File', then 'Deserialize JSON', then 'Move File'.. Deserializing the JSON string into a custom object or JObject allows for type-safe access to configuration values. Using the 'Deserialize JSON' activity is the standard approach to convert raw text into a manageable format. Once parsed, the resulting object can be passed into the 'Move File' activity. This pattern ensures that configuration changes are reflected dynamically without modifying the underlying workflow logic, which is essential for maintaining scalable and robust automation solutions.

Answer

Use 'Read CSV' and map the columns directly to the 'Move File' input arguments.

Answer

Use 'Read Text File' and regex extract the paths, then move the file.

Answer

Use 'Get Environment Variable' to read the JSON file contents.

Question 12

Which THREE actions are essential for ensuring data integrity when overwriting an existing file during a data export operation?

Accepted Answer

Check if the file is currently in use by another process.. Data integrity requires verifying file state before writing. Checking if the file is locked prevents I/O exceptions. Taking a backup of the original file provides a rollback mechanism if the write process fails, while verifying existence and permissions ensures the bot has the authority to complete the task. These steps are crucial in production environments to avoid data loss and maintain a reliable audit trail for all file modifications during execution.

Answer

Always delete the file before starting the write operation.

Answer

Set file attributes to Read-Only during the move.

Question 13

Which data manipulation approach is most efficient for transforming a DataTable with 10,000 rows without using activities in a loop?

Accepted Answer

Use the 'Invoke Code' activity with a LINQ query.. Using LINQ on a DataTable allows for high-performance data transformation in memory. By leveraging 'AsEnumerable', you can perform complex filtering, sorting, and grouping operations without the overhead of UI-based activities. This approach is highly efficient for large datasets, significantly reducing the execution time compared to iterating row-by-row, as it utilizes optimized .NET underlying collection processing which is designed for speed and memory efficiency in enterprise-grade automation scenarios.

Answer

Use the 'For Each Row' activity to update values.

Answer

Write the data to Excel, perform the transformation there, and read it back.

Answer

Use the 'Filter Data Table' activity 10,000 times.

Question 14

When extracting a specific column from a DataTable into an array, which method provides the most concise and efficient syntax?

Accepted Answer

Use LINQ: DataTable.AsEnumerable.Select(Function(row) row("Col").ToString).ToArray().. Using LINQ's 'Select' method on a DataTable's Rows collection allows for a direct projection to an array. This is the idiomatic way to handle column extraction in .NET and UiPath, providing both readability and speed. By using 'AsEnumerable().Select(Function(r) r("ColumnName").ToString()).ToArray()', you avoid manual loops and temporary variable management, resulting in cleaner and more maintainable code that effectively isolates data for subsequent processing tasks.

Answer

Use a 'For Each' activity to iterate and assign values to an array.

Answer

Use the 'Filter Data Table' activity.

Answer

Use the 'Read Range' activity with a specific range.

Question 15

Which activity is best suited for deleting a folder along with all its contents?

Accepted Answer

Use the 'Delete' activity with 'IsFolder' checked.. The 'Delete' activity in UiPath supports an 'IsFolder' property. When set to true, it recursively deletes the directory and all contained files. This is the native and most efficient way to perform a cleanup operation. It is important to handle this with care, as it is a destructive action, necessitating robust error handling and validation before the activity is executed in any production automation workflow to prevent accidental data loss.

Answer

Use the 'Remove Directory' activity.

Answer

Use a 'For Each' to delete all files, then 'Delete' the folder.

Answer

Use 'Invoke Power Shell' with the 'rmdir' command.

Question 16

You need to update a specific cell in an Excel file without loading the entire document into a DataTable. Which approach is most efficient?

Accepted Answer

Use 'Write Cell' within an 'Excel Process Scope'.. Using the 'Excel Process Scope' and 'Write Cell' activity is the most efficient method for localized updates. By keeping the Excel process active and performing direct writes, you avoid the overhead of reading, modifying, and rewriting the entire file structure. This approach is significantly faster and more resource-efficient, especially for large Excel files where the modification is limited to a single cell or small range of data values.

Answer

Read the entire file into a DataTable, update, and write back.

Answer

Use 'Invoke VBA' to update the cell.

Answer

Use 'Append Range' to add the new value.

Question 17

When writing data to a CSV file, which property should be set to true if you want to avoid overwriting existing data?

Accepted Answer

Set 'Append' to true.. The 'Append' property in the 'Write CSV' activity is specifically designed for this purpose. By setting 'Append' to true, the automation adds new rows to the end of the file instead of clearing the existing content. This is essential for logging, audit trails, and batch data processing, where maintaining historical data is a critical business requirement that must be handled safely to avoid accidental data loss during export operations.

Answer

Set 'Overwrite' to false.

Answer

Set 'Create' to false.

Answer

Set 'Delimiter' to 'New'.

Question 18

Which method is the most appropriate for checking if a specific string contains a key piece of information in a file path?

Accepted Answer

Use the 'Contains' method.. The 'Contains' method is the standard .NET string comparison operator. It is case-sensitive by default but can be made case-insensitive, providing a flexible and efficient way to validate paths. This is superior to using regular expressions for simple substring checks, as it is much faster and easier for other developers to read and understand, which is critical for maintaining long-term project viability and reducing the complexity of common string validation tasks in automation.

Answer

Use a Regular Expression (Regex) for every check.

Answer

Convert the string to an array and iterate through it.

Answer

Use the 'String.Equals' method.

Question 19

You need to retrieve the name of a file without its extension from a full path string. Which method should you use?

Accepted Answer

Use 'Path.GetFileNameWithoutExtension'.. Path.GetFileNameWithoutExtension is the built-in, platform-independent method for exactly this requirement. It correctly handles various OS-specific directory separators and edge cases in file naming. Using this method is much safer than manually parsing the string with 'LastIndexOf', as it avoids common pitfalls like unexpected dots in the path or missing extensions, ensuring the automation remains robust and predictable across different file naming conventions and operating systems.

Answer

Use 'Split' on the dot character.

Answer

Use 'Substring' with 'LastIndexOf'.

Answer

Use the 'Get File Name' activity and then remove the last 4 chars.

Question 20

You 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?

Accepted Answer

Utilize the Read CSV activity with 'Has Headers' enabled and default buffering.. Using the Read CSV activity within a For Each File In Folder loop is standard, but memory efficiency is key when processing large volumes. Streaming data or using the proper DataTable configuration prevents memory bottlenecks. Understanding file locking and stream management is critical for robust automation, as improper handling leads to read-write conflicts or resource exhaustion in high-throughput enterprise environments.

Answer

Use the Read Text File activity and manual splitting to parse the data.

Answer

Move files to a subfolder named 'Processed' immediately after reading.

Answer

Read all files into a single master DataTable using an Invoke Code activity.

UiPath-ADAv1 Files, Folders, and Data Manipulation — All Questions With Answers

An automation needs to process files in a directory that are older than 30 days. Which combination of methods best retrieves and filters these files efficiently?

Which activity should be used to retrieve the full path of all files with a specific extension in a directory and its subdirectories?

Which TWO of the following methods are effective for managing temporary files created during an automation process? (Choose two)

An automation must read a fixed-width text file where each record is 40 characters: a 10-character account ID, followed by a 20-character name, then a 10-character balance. The file has no delimiters. Which approach should the developer use to convert this file into a DataTable with three columns?

A developer needs to write a DataTable to an Excel file using the Write Range activity and wants to ensure the output includes column headers and that existing data in the target sheet is not silently overwritten. Which two actions should the developer take? (Choose two.)

An automation processes a folder containing files with various extensions. The developer needs to retrieve only files with the .pdf extension and read their full paths into a collection for later processing. Which activity and configuration should be used?

Which TWO methods are recommended for safely handling file paths in UiPath to ensure cross-platform compatibility?

Refer 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?

Exhibit

Which THREE actions are essential for ensuring data integrity when overwriting an existing file during a data export operation?

Which data manipulation approach is most efficient for transforming a DataTable with 10,000 rows without using activities in a loop?

When extracting a specific column from a DataTable into an array, which method provides the most concise and efficient syntax?

Which activity is best suited for deleting a folder along with all its contents?

You need to update a specific cell in an Excel file without loading the entire document into a DataTable. Which approach is most efficient?

When writing data to a CSV file, which property should be set to true if you want to avoid overwriting existing data?

Which method is the most appropriate for checking if a specific string contains a key piece of information in a file path?

You need to retrieve the name of a file without its extension from a full path string. Which method should you use?

You 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?

Refer 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?

Exhibit

A 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?

An 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?

An 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?

UiPath-ADAv1 Files, Folders, and Data Manipulation — All Questions With Answers

An automation needs to process files in a directory that are older than 30 days. Which combination of methods best retrieves and filters these files efficiently?

Which activity should be used to retrieve the full path of all files with a specific extension in a directory and its subdirectories?

Which TWO of the following methods are effective for managing temporary files created during an automation process? (Choose two)

An automation must read a fixed-width text file where each record is 40 characters: a 10-character account ID, followed by a 20-character name, then a 10-character balance. The file has no delimiters. Which approach should the developer use to convert this file into a DataTable with three columns?

A developer needs to write a DataTable to an Excel file using the Write Range activity and wants to ensure the output includes column headers and that existing data in the target sheet is not silently overwritten. Which two actions should the developer take? (Choose two.)

An automation processes a folder containing files with various extensions. The developer needs to retrieve only files with the .pdf extension and read their full paths into a collection for later processing. Which activity and configuration should be used?

Which TWO methods are recommended for safely handling file paths in UiPath to ensure cross-platform compatibility?

Refer 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?

Exhibit

Which THREE actions are essential for ensuring data integrity when overwriting an existing file during a data export operation?

Which data manipulation approach is most efficient for transforming a DataTable with 10,000 rows without using activities in a loop?

When extracting a specific column from a DataTable into an array, which method provides the most concise and efficient syntax?

Which activity is best suited for deleting a folder along with all its contents?

You need to update a specific cell in an Excel file without loading the entire document into a DataTable. Which approach is most efficient?

When writing data to a CSV file, which property should be set to true if you want to avoid overwriting existing data?

Which method is the most appropriate for checking if a specific string contains a key piece of information in a file path?

You need to retrieve the name of a file without its extension from a full path string. Which method should you use?

You 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?

Refer 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?

Exhibit

A 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?

An 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?

An 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?