UiPath-ADAv1 Files, Folders, and Data Manipulation Practice Question
A 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.)
⚠ Common exam trap
The trap here is assuming the default comma delimiter will work, or confusing the Encoding property with delimiter handling.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Leave the Read CSV activity's IncludeColumnNames property checked so the header line becomes the DataTable column names
Read CSV is the activity designed to turn delimited text into a DataTable. Because this file uses semicolons, the Delimiter property must be changed from the default comma, and because the first line holds headers, IncludeColumnNames must remain enabled so those headers become the DataTable's column names. Together these two settings produce the expected structured data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use the Read Text File activity to load the whole file and then split each line manually in a loop
Why it's wrong here
Read Text File returns a single string, not a DataTable, so the developer would have to parse delimiters, build column names, and construct rows manually. This is exactly the work Read CSV already performs. Choosing this path adds complexity and bug surface without any benefit, and it does not satisfy the requirement of producing a DataTable directly.
- ✓
Leave the Read CSV activity's IncludeColumnNames property checked so the header line becomes the DataTable column names
Why this is correct
The IncludeColumnNames property, when enabled, causes the first line of the file to be interpreted as column headers rather than data. Since the scenario states the first line contains headers, keeping this property checked produces a DataTable whose columns are named from that line, which is exactly what downstream processing expects.
- ✗
Set the Read CSV activity's Encoding property to a specific code page to change the delimiter interpretation
Why it's wrong here
The Encoding property controls how bytes are decoded into characters, which matters for accented or non-Latin text, but it has no effect on which character separates fields. Delimiter selection is governed solely by the Delimiter property. Setting an encoding to fix a delimiter problem misdiagnoses the issue and leaves the parsed DataTable malformed.
- ✓
Use the Read CSV activity and set its Delimiter property to ";"
Why this is correct
Read CSV parses a delimited text file into a DataTable and exposes a Delimiter property that defaults to a comma. Because this file uses semicolons, setting the delimiter to ";" is mandatory; otherwise the entire line is treated as a single column and the resulting DataTable will have one wide column instead of the expected separate fields.
- ✗
Use the Excel Read Range activity inside Excel Application Scope, pointing at invoices.csv
Why it's wrong here
Excel Application Scope and Read Range operate on Excel workbooks such as .xlsx files, not on plain delimited text files. Pointing them at a .csv typically fails or yields unexpected results because the file lacks the workbook structure the activity expects. The correct tool for a semicolon-delimited text file is the Read CSV activity.
About these practice questions
Courseiva writes every UiPath-ADAv1 question from scratch — 285 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official UiPath exam blueprint
This UiPath-ADAv1 practice question is part of Courseiva's free UiPath certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the UiPath-ADAv1 exam.