Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam UiARD All Questions

View all questions & answers for the UiARD exam

Exam UiARD topic 1 question 4 discussion

Actual exam question from UiPath 's UiARD
Question #: 4
Topic #: 1
[All UiARD Questions]

A developer wants to extract data from "Sheet1" of the "Test.xls" file using the following code:

In addition, the developer configured the following properties of the Read Range activity:

Based on the exhibits, what is the result of the execution?

  • A. OutputDataTable object will have 2 columns and 1 row containing values of cells "A1" and "B1"
  • B. OutputDataTable object will have 2 columns and 1 row containing values of cells "A2" and "B2"
  • C. OutputDataTable object will have 2 columns and 2 rows containing values of cells "A2" and "B2"
  • D. OutputDataTable object will have 2 columns and 10000 rows; the first row will contain values of cells "A1" and "B1"
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?).
Switch to a voting comment New
nosavotor
1 year, 1 month ago
Could someone please verify the accuracy of this answer
upvoted 1 times
...
nosavotor
1 year, 1 month ago
I'm not sure about that
upvoted 1 times
...
nosavotor
1 year, 1 month ago
Could someone please verify the accuracy of this answer
upvoted 1 times
...
phileraene
1 year, 3 months ago
Selected Answer: B
First excel row used as Header Second excel row used as data value.
upvoted 2 times
...
atobon
1 year, 4 months ago
B. OutputDataTable object will have 2 columns and 1 row containing values of cells "A2" and "B2" Studio OutputDataTable: ID Name Dapartment 1 James Account 2 Mary science 3 Patricia math 4 Robert literature The answer in studio for "A1:B2": [ID, Name 1, James]
upvoted 1 times
...
Mirjalol
1 year, 4 months ago
Selected Answer: B
Well, this is tricky one. I will go with 'B' because answers are mentioning row(s) containing values. A1 and B1 are headers even if they got printed when you using output datatable and printing the result in string format. While A2 and B2 are row values and there will be only only 1 row.
upvoted 1 times
...
Martalolo
1 year, 5 months ago
Selected Answer: B
B is the correct one
upvoted 1 times
...
karthikreddy7850
1 year, 6 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
LarcAi_Training
1 year, 6 months ago
Correct answer is B go test it in studio after the example code add a message box add look at the dt_output.Rows.Count and you will see its 1 so there is only 1 row. Then foreach the dataable and log the currentItem(0).ToString and currentItem(1).ToString and you will see its the values of A2 and B2
upvoted 1 times
...
Sameer11
1 year, 6 months ago
The Correct answer is C tested in studio
upvoted 1 times
...
Manche
1 year, 6 months ago
The correct answer is B
upvoted 1 times
...
Fonmincc
1 year, 7 months ago
Selected Answer: B
For sure is B
upvoted 1 times
...
Engineer24
1 year, 7 months ago
If the names of the columns that are read as table headers are defined on the first row, the result will be the values ​​on A1 B1 A2 and B2, so in total two rows will be read, row 1 which represents the table header and row 2 which represents the actual values. The question is NOT very logical. If we assume that the table header is not considered as a value then the correct answer would be B.. but it is a bit strange.
upvoted 1 times
...
EduardoRamirez
1 year, 7 months ago
Selected Answer: B
The correct answer is B.
upvoted 2 times
...
Online
1 year, 7 months ago
Thank you for confirming!
upvoted 1 times
...
titanium192
1 year, 7 months ago
Hello guys! The correct answer is B.
upvoted 1 times
...
Online
1 year, 8 months ago
Selected Answer: C
I tested this and the headings get printed so I believe C is the correct answer?
upvoted 1 times
Online
1 year, 8 months ago
I take that back, based on the next question, the row count is 1 so I think B is correct.
upvoted 2 times
Online
1 year, 8 months ago
Hi moderator, please remove my comments for this topic. Thanks. I still think C is the correct answer, even though the row count is 1, the headings get printed. It's a tricky one.
upvoted 2 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...