UiPath アカデミー 問題 解答 lesson 3 英語版
lesson 3 学習した内容をまとめます。
宜しければ、この解答集を参考してください。
Lesson 3 – Data Manipulation
Contents
- 1. UiPath アカデミー 問題 解答 lesson 2 英語版
- 2. The String.Format(“Input = {0} and Output = {1}”, “1”,”2”) expression returns which of the following text:
- 3. How can a string variable called myString be converted to an all-capitals representation for future use?
- 4. Which activity can be used to loop through each row from a DataTable?
- 5. What key combination allows you to automatically create a variable from an activity’s property field?
- 6. Which activity can be used to modify the value of an existing cell in a DataTable?
- 7. Which of the following data types are included in the Collections category?
- 8. How can we test if a given address (a string variable called fullAddress) can be found on a particular street (a string variable called streetName)?
- 9. Which activities can be used to iterate through an Array?
- 10. How can the index integer variable be displayed inside a Message Box activity?
- 11. If the dtNewHires datatable has 4 columns, in this order : [ID, Name, Age, Sex] and 2 rows: [1, Daniel, 38, M] ; [2, Andra, 24, F], what is the result of the expression dtNewHires.Rows(0)(1)?
- 12. Which of the following statements are true regarding Lists and Arrays?
- 13. How can you identify a column in a data table?(Select all that apply.)
- 14. Which variable types can be used as output for the Read CSV activity?
- 15. Which activity can you use to get the value from a certain cell, from a specific data table row?
- 16. Which .Net method of the datatable object can be used to filter a table by a condition?
- 17. Which variable type can you use to efficiently store the current time inside your workflows?
- 18. If currentRow represents a row from a DataTable with two columns in this order: Name and Age, which expressions can be used to obtain the value from the column Age?(Select all that apply.)
- 19. Which of the following statements are true regarding the Output DataTable activity?
- 20. UiPath アカデミー 問題 解答 lesson 4 英語版
UiPath アカデミー 問題 解答 lesson 2 英語版
The String.Format(“Input = {0} and Output = {1}”, “1”,”2”) expression returns which of the following text:
- Input = {0} and Output = {1}
- Input = 1 and Output = 1
- Input = 1 and Output = 2
- Input = 0 and Output = 0
How can a string variable called myString be converted to an all-capitals representation for future use?
- By using an Invoke Method activity with the TargetType property set to String, the TargetObject property set to myString and the MethodName property to ToUpper.
- By using an Assign activity with myString on the left side and myString.ToUpper on the right side.
- By using a Write Line with the Text property set to myString.ToUpper.
- By using an Invoke Method activity with the TargetType property set to null, the TargetObject property set to myString and the MethodName property to ToUpper.
Which activity can be used to loop through each row from a DataTable?
- If
- For Each Row
- Build DataTable
- Flow Decision
What key combination allows you to automatically create a variable from an activity’s property field?
- Ctrl + P
- Ctrl + N
- Ctrl + K
- Ctrl + A
Which activity can be used to modify the value of an existing cell in a DataTable?
- Add Data Column activity
- Add Data Row activity
- Assign activity
- Modify Cell activity
Which of the following data types are included in the Collections category?
- Int32
- Dictionary
- List
- Array
How can we test if a given address (a string variable called fullAddress) can be found on a particular street (a string variable called streetName)?
- fullAddress.Contains(streetName)
- streetName.Contains(fullAddress)
- streetName.Has(fullAddresss)
- fullAddress.Has(streetName)
Which activities can be used to iterate through an Array?
- Flow Decision
- While
- For Each Row
- For Each
How can the index integer variable be displayed inside a Message Box activity?
- “Current index is: + index.ToString”
- “Current index is: $index”
- “Current index is: “ + index
- “Current index is: “ + index.ToString
If the dtNewHires datatable has 4 columns, in this order : [ID, Name, Age, Sex] and 2 rows: [1, Daniel, 38, M] ; [2, Andra, 24, F], what is the result of the expression dtNewHires.Rows(0)(1)?
- Andra
- 2
- Daniel
- 1
Which of the following statements are true regarding Lists and Arrays?
- List items can be added using an Add to Collection activity.
- You can iterate through a List using a For Each loop activity.
- You can add maximum 100 elements to an array.
- Array and List elements can be accessed by index.
How can you identify a column in a data table?(Select all that apply.)
- Using the column index
- Using the row name
- Using the column name
- Using the row index
Which variable types can be used as output for the Read CSV activity?
- List variables
- DataTable variables
- Array variables
- String variables
Which activity can you use to get the value from a certain cell, from a specific data table row?
- Write Cell
- Get Row Item
- Read Cell
- Remove Data Row
Which .Net method of the datatable object can be used to filter a table by a condition?
- Filter
- ToString
- Select
- Clone
Which variable type can you use to efficiently store the current time inside your workflows?
- String
- Array<String>
- Integer
- DateTime
If currentRow represents a row from a DataTable with two columns in this order: Name and Age, which expressions can be used to obtain the value from the column Age?(Select all that apply.)
- currentRow(“Age")
- currentRow.Age
- currentRow(2)
- currentRow(1)
Which of the following statements are true regarding the Output DataTable activity?
- Writes a DataTable to an Excel file
- Writes a DataTable to a csv file
- Returns the data contained in a DataTable as a string in a csv format
- Returns a DataTable object
ディスカッション
コメント一覧
まだ、コメントがありません