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"
correct ans is option - B = OutputDataTable object will have 2 columns and 1 row containing values of cells "A2" and "B2" ...
first row "A1" and "B1" containing headers because of add headers property selected in properties so only 2nd number row have 2 values "A2" and "B2" cells value
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]
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.
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
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.
This section is not available anymore. Please use the main Exam Page.UiARD Exam Questions
Log in to ExamTopics
Sign in:
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.
Sharad_Bailkar
1 month, 2 weeks agonosavotor
6 months, 3 weeks agonosavotor
6 months, 3 weeks agonosavotor
6 months, 3 weeks agophileraene
8 months, 2 weeks agoatobon
9 months agoMirjalol
9 months, 1 week agoMartalolo
10 months, 1 week agokarthikreddy7850
10 months, 4 weeks agoLarcAi_Training
11 months agoSameer11
11 months, 3 weeks agoManche
11 months, 3 weeks agoFonmincc
12 months agoEngineer24
1 year agoEduardoRamirez
1 year agoOnline
1 year agotitanium192
1 year ago