UIPath Study Flashcards
ow can we purposely pause the debugging process on an activity which may trigger execution issues?
Choose one of the options that apply.
By using the Step Into button from the Debug tab while debugging.
By enabling the Highlight Elements function from the Debug tab before debugging.
By using the Step Out button from the Debug tab while debugging.
By right-clicking the activity, and selecting Toggle Breakpoint to add and enable the breakpoint.
By using the Step Into button from the Debug tab while debugging.
What are three reasons for which an RPA Developer must have a clear understanding of the ‘to-be’ process steps?
To make sure that the automation outcome is the one agreed upon with the business.
Because the RPA Developer follows the ‘to-be’ process diagram to write the code.
If changes or bug fixes are needed, the RPA Developer will refer to the diagram for cross-checking and removing ambiguities.
What activity can we use to iterate through emails and process each piece of information individually?
The ‘For Each’ activity
What is one way we can make sure our selector is reliable when interacting with various windows, buttons, drop-down lists, and other user interface elements?
By using other UI elements as anchors, e.g. a label or title.
What method can we use to check if a string contains a specific fragment of type string?
The ‘Contains’ method.
How can we publish to the ‘Orchestrator Personal Workspace Feed’?
By first enabling the option in Orchestrator and then selecting ‘Orchestrator Personal Workspace Feed’ when publishing in Studio.
What debugging action can we use to debug activities one at a time?
Step Into
Use Step Into to debug activities one at a time. When this action is triggered, the debugger opens and highlights the activity before it is executed.
When Step Into is used with Invoke Workflow File activities, the workflow is opened in a new tab in ‘ReadOnly’ mode and each activity is executed one by one.
The keyboard shortcut for Step Into is F11.
How can we convert a variable of type string to a double?
- By using the CDbl method inside the Expression Editor in Studio.
- From the Variables panel in Studio, by selecting Variable type and searching for the System.Double type.
- By using the Double.Parse method inside the Expression Editor in Studio.
- By using the Convert.ToDouble method inside the Expression Editor in Studio.
What happens if the files saved in the specified folder have the same name as the email attachments?
- The files with the same name get overwritten.
What filtering expression must we add inside the ‘Filter’ property of the ‘Get Outlook Mail Messages’ activity to retrieve only emails that have ‘Course Invoices’ in the subject line?
“[Subject] = ‘Course Invoices’”
How can we leave out a specific file from the publishing package?
By right-clicking it in the Project panel, and then selecting Ignore from Publish in Studio.
Which of the following responsibilities are performed by the RPA Developer throughout the implementation process?
- Build code modules as outlined and assigned (either as workflow files or libraries, as needed).
- Monitor logs and review any exception cases that occur.
- Finalize process logging (in line with logging guidelines) and sync standards with customer for post-deployment care.
- Ensure code is in line with development best practices.
- Conduct unit tests on created modules as development progresses to catch and fix any bugs that may arise.
What are the topics on which an RPA Developer collaborates with the RPA Solution Architect throughout the stages of an implementation?
- When troubleshooting
- Reviewing and signing-off on the Development Specifications Document (DSD.
- When debugging
- For mentoring
- When testing
In which of the stages does an RPA Developer have the highest contribution and responsibility?
In the development and Unit Testing, Integration and UAT, and Deployment and Hypercare stages.
What are the correct categories for the following factors used to assess the automation potential of a process?
- No RPA = Processes where change is frequent and multiple manual actions are needed.
- Semi-Automation = Processes that can be broken down into automated steps, and steps that must remain manual.
- High-Cost RPA = Processes that are rather digital and can be automated, but use some complex technologies.
- Zero-touch automation = Processes that are digital and involve a highly static system and process environment.
Is there any difference when it comes to documenting a process versus documenting a procedure?
A process is typically documented via a diagram, be it a flowchart or workflow, which aims to highlight the logical sequence of the process steps.
A procedure, on the other hand, is often a complex, written document, focused on providing guidelines
What is the correct description for each of the six RPA implementation stages?
- Discovery and kickoff = The initial implementation team assesses the potential automation complexity.
- Process analysis = Implementation team analyses and identifies the requirements of the customer’s process.
- Solution Design = Technical team designs a future state flow and maps out the various modules to be built.
- Development and Unit Testing = The modules outlined in the design whiteboard are created by the development team.
- Integration and User Acceptance Testing (UAT) = The implementation team conducts integration and UAT together with the business team.
- Deployment and hypercare = Final process packages, libraries, and assets are migrated to the production Orchestrator.
Which of the following three fields are mandatory when creating a variable in the variable panel?
- Scope
- Name
- Variable type
Data Type: String:
System.String: used to store text. This type of data comes with many specific methods of processing, and will be addressed in depth in another lesson, namely Data Manipulation with Strings in Studio.
Data Type: Numeric (category):
Used to store numbers. There are different sub-types of numerical variables. For a few examples:
Int32 - System.Int32 (signed integers): 10, 299, -100
Long - System.Int64 (long integers): 54354353430, -11332424D
Double - System.Double (allows decimals, 15-16 digits precision): 19.1234567891011
Data Type: Boolean:
System.Boolean: Used to store one of two values - True or False.
Data Type: Collection (category)
This category reunites all collections of objects. Collections are largely used for handling and processing complex data. Some of the most encountered collections are:
Array - ArrayOf or System.DataType[]: used to store multiple values of the same data type. The size (number of objects) is defined at creation.
List - System.Collections.Generic.List: used to store multiple values of the same data type, just like Arrays. Unlike Arrays, their size is dynamic.
Dictionary - System.Collections.Generic.Dictionary: used to store objects in the form of (key, value) pairs, where each of the two can be of a separate data type.
Data Type: DataTable:
DataTable variables represent a type of variable that can store big pieces of information, and act as a database or a simple spreadsheet with rows and columns.
Data Type: Date and Time (category):
DateTime - System.DateTime: Used to store specific time coordinates (mm/dd/yyyy hh:mm:ss).
This kind of variable provides a series of specific processing methods (subtracting days, calculating time remaining vs. today, and so on).
For example, to get the current time, assign the expression DateTime.Now to a variable of type DateTime.
TimeSpan - System.TimeSpan: Used to store information about a duration (dd:hh:mm:ss). You can use it to measure the duration between two variables of the type DateTime.
For example, you can save the time at the start of the process in one variable (of type DateTime), the time at the end in another (of type DateTime) and store the difference in a variable of type TimeSpan.
Data Type: GenericValue:
This is a UiPath proprietary variable type that can store any kind of data, including text, numbers, dates, and arrays. This type is mainly used in activities in which we aren’t sure what type of data we’ll receive, yet in general, using this is temporary.
Conversion Method: Convert.ToString Method:
This method converts the specified value to its equivalent string representation.
It can be Int32 to String.
ToString(Int32, Int32) - Converts the value of a 32-bit signed integer to its equivalent string representation in a specified base.
Eg: StrVar = Convert.Tostring(IntVar)
Conversion Method: Convert.ToInt32:
This method converts a specified value to a 32-bit signed integer.
ToInt32(String) - Converts the specified string representation of a number to an equivalent 32-bit signed integer.
There’s another method to convert a string to an integer - CInt(String)
ToInt32(Double) - Converts the value of the specified double-precision floating-point number to an equivalent 32-bit signed integer.
Eg:
IntVar = ToInt32(StrVar)
IntVar = CInt(StrVar)
IntVar = ToInt32(DblVar)
Conversion Method: Double.ToString Method
This method converts the numeric value of this instance to its equivalent string representation.
Eg: StrVar = DblVar.ToString - This method displays the string representations of a number of Double values.
Conversion Method: Double.Parse Method:
This method converts the string representation of a number to its double-precision floating-point number equivalent.
Eg: DblVar = Parse(StrVar)
Conversion Method: Boolean.ToString Method:
This method converts the value of this instance to its equivalent string representation (either “True” or “False”).
Eg: ToString()
Conversion Method: Convert.ToBoolean Method:
This method converts a specified value to an equivalent Boolean value.
Eg:ToBoolean(Int32) - Converts the value of the specified 32-bit signed integer to an equivalent Boolean value.
Conversion Method: Convert DateTime to String:
DateTime.Now Property - Gets a DateTime object that’s set to the current date, and time on this computer, expressed as the local time.
ToString(DateTime) - Converts the value of the specified DateTime to its equivalent string representation.
Eg: Now.ToString(“dd-MM-yyyy”) or DateTimeVar.ToString(“dd-MM-yyyy”) - Provides the date format: 01-06-2022.
Which of the following is a VB.NET data type that measures the duration between two variables of the type DateTime.
TimeSpan
What is a workflow?
A workflow represents a relatively small piece of an automation project, typically executing a specific part of the process. Once built, it can be reused across different projects.
A workflow is made of Studio activities, interconnected through variables to form a routine. The routine typically has an input and an output. Basically, it defines the flow of automation. Hence the name, workflow.
What are arguments?
Arguments are very similar to variables:
They store data dynamically.
They have the same data types.
They support the same methods and properties.
The difference is that they pass data between workflows, and they have an additional property for this – the direction. Arguments have specific directions: In, Out, and In/Out. These tell the Robot where the information stored in them is supposed to go.
Creating arguments
Argument names should be in PascalCase with a prefix stating the argument direction, such as in_DefaultTimeout, in_FileName, out_TextResult, io_RetryNumber.
What is the keyboard shortcut to create an argument of direction IN?
Ctrl + M
What is the keyboard shortcut to create an argument of direction OUT
Ctrl + Shift + M
What is an array?
An array variable or argument is a type that enables storing multiple values of the same data type. Think of it as a group of elements with a size that is defined at creation, and where each item can be identified by its index.
In UiPath Studio, you can create arrays of numbers, of strings, of Boolean values, and so on. All these arrays are of fixed size and cannot be increased dynamically.
Eg: An array of months of a year, an array of odd numbers between one to hundred, etc.
Which of the following types of collection is the best option when you have to extract the unique ID’s of employees from a database?
Arrays
vbLf
visual basic line feed: This will add a new line in the text. Similar methods: Environment.NewLine, “\n”, “\r\n”
Math Round
Math.Round = rounds the floating number to a given precision.
Eg: Math.Round(2.34123, 2) = 2.34; Math.Round(2.34678, 2) = 2.35.
Which one of the following is a data type particular to UiPath and can store any kind of data, including text, numbers, dates, and arrays?
GenericValue
You are saving the input from users to a variable of string type in Main.xaml. The user info is stored in an Excel spreadsheet by a Write Range activity added in WriteData.xaml. WriteData.xaml is invoked in Main.xaml.
What direction will your argument have?
In
Review Question: Which of the following tasks can be taken over by RPA robots?
Validate data classification results
Validate data extraction results
Make decisions based on predefined rules
Correctly checked
Start applications
Correctly checked
Capture data from text fields
Tasks can be taken over by RPA robots:
Start applications
Capture data from text fields
Make decisions based on predefined rules
Collections are largely used for handling and processing complex data. Which one of the following is the most encountered collection with a dynamic size?
List
Which of the following are the three ways to create a new variable in UiPath Studio?
Press Ctrl+Shift+K in an activity input field that requires a variable
Press Ctrl+Shift+K in an input field that requires a variable in the Properties panel
Press Ctrl+K in an input field that requires a variable in the Properties panel
Select the Create new Variable option in the Variables panel
Press Ctrl+K in an activity input field that requires a variable
Ways to create a variable in UiPath Studio:
Press Ctrl+K in an activity input field that requires a variable.
Select the Create new Variable option in the Variables panel.
Press Ctrl+K in an input field that requires a variable in the Properties panel.
By performing right-click in the input field and selecting the create variable option.
Consider the array UserNames = { “John”, “Jane”, “Dave”, “Sandra”}.
What value will the expression UserNames(1) return?
Jane
Review Question: Which of the three (3) characteristics below make a process more suitable for RPA automation?
High exception rate
Stable
Repetitive
Validation based
Rule-based
The characteristics that make a process more suitable for RPA automation:
Stable
Rule-based
Repetitive
Match the following variable properties with their definitions:
Name - Defines how the variable will be identified.
Type - Defines what kind of data can be stored in the variable.
Scope - Defines the part of the workflow where the variable can be used.
Default - Defines the value the variable is initialized with.
What is the correct way to concatenate a string variable (UserName) with a string (“ is online”)?
UserName + “ is online” is the correct way to concatenate a string variable (UserName) with a string (“ is online”).
Review Question: Match the following UiPath Platform components with the descriptions provided:
UiPath Studio - Designing automation workflows.
UiPath Orchestrator - Managing and monitoring the execution of automation.
UiPath Robot - Executing automation workflows.
UiPath Automation Hub - Discovering automation opportunities and managing their journey from discovery to implementation.
Which one of the following is used to pass data from one workflow file to another in UiPath Studio.
Arguments are used to pass data from one workflow file to another in UiPath Studio.
To improve readability, variable and argument names must align to a naming convention. If a variable is written as FirstName, then what is the naming convention followed?
PascalCase
Which one of the following decision-making activities in UiPath Studio lets us add multiple conditions to the workflow?
Else If Activity
Loops: Do While
It executes a specific sequence while a condition is met. The condition is evaluated after each execution of the statements.
For example, a robot could perform a refresh command on a website and then check if a relevant element was loaded. It will continue the refresh - check cycle until the element is loaded.
The key difference between Do While and While is that for Do While, the activities contained within it are executed at least once.
The graphic depicts how a Do While loop appears in a simple workflow in UiPath Studio.
Loops: While
It executes a specific sequence while a condition is met. The condition is evaluated before each execution of the statements.
For example, if a Robot would play Blackjack, it should calculate the hand before deciding whether to draw another card.
Loops: For Each
It performs an activity or a series of activities on each element of an input collection.
This is very useful in data processing. Consider an Array of integers. For Each would enable the robot to check whether each numeric item fulfills a certain condition.
Which one of the following activities enables you to stop the loop at a chosen point, and then continue with the next activity?
Break
What is the minimum number of potential courses of action does a Switch activity require?
Three
What are the activities inside a Parallel container called?
Child Activities
A Break Activity is used to stop the segment of automation that’s repetitive at a chosen point, and then continue with the next activity. Which of the following three (3) activities enables you to insert Break Activity within them?
For Each
Do While
While
Which one of the following activities enables your project to take multiple different courses of action, depending on whether a series of specified conditions are met?
Else If activity lets you add multiple conditions using the drop-down options Else If and Else.
Consider an Int32 variable (Counter), initially assigned with the value 10. The value decreases by 1 every time a sequence is executed in a Do While activity.
How many times will the sequence be executed if the expression in the Condition field of the Do While activity is V > 0?
Do While activities are evaluated only after the body has been executed once. The answer is 10.
Review question: Match the following variable properties with their definitions:
Name - Defines how the variable will be identified.
Type - Defines what kind of data can be stored in the variable.
Scope - Defines the part of the workflow where the variable can be used.
Default value - Defines the value the variable is initialized with.
Review question: Which of the following is used to pass data from one workflow file to another in UiPath Studio?
Only Arguments
Match the following activity with its description:
While - Checks if the expression is True and then executes the activities in the Body section.
Do While - Executes the activities in the body section and then checks the expression.
For Each - Performs series of activities in the body section on each element of a collection.
Switch - Used when at least three potential courses of action are needed.
Which one of the following activities consists of a conditional expression and a collection of cases, with a corresponding set of activities?
The Switch activity can be useful to categorize data according to a custom number of cases.
Which activity can be used to process every item in a collection individually?
The For Each activity enables you to step through arrays, lists, data tables or other types of collections, so that you can iterate through the data and process each piece of information individually.
When creating a process with multiple nested decisions, you’d opt for the Flowchart layout?
True - Flowcharts can be used in a variety of settings, from large jobs to small projects that you can reuse in other projects.
How does the Parallel Activity perform its execution asynchronously?
From top to bottom, left to right
Which of the following statements about UI automation are true?
User interface automation is accomplished by imitating real human user interactions.
Complex applications can’t be automated through UI automation.
All UiPath Studio activities are universal and can be used when automating any application.
User interface automation is accomplished by imitating real human user interactions.
Match the below definitions with the key UI Automation concepts.
Activities - Tells the robot what actions to take.
Properties - Determine how activities behave.
Targeting methods - Identify the UI Element to take action on.
Input and output methods - Define how what technology is used when sending input or getting output from an UI.
Recorders and wizards - Help developers create UI Automation faster.
Object repository - Helps store and share UI Element targets.
AI Computer Vision - Uses a neural network to identify elements on screen.
ChromiumAPI is a?
Input method
Match the below definitions with the key UI Automation concepts.
Activities - Tell the robot what actions to take.
Properties - Determine how activities behave.
Targeting methods - Identify the UI Element to take an action on.
Input and output methods - Define how what technology is used when sending input or getting output from an UI.
Recorders and wizards - Help developers create UI Automation faster.
Object repository - Helps store and share UI Element targets.
AI Computer Vision - Uses a neural network to identify elements on screen.
Chromium API is a…
Input method
Object Repository is available in both the experiences, modern and classic.
False
Which targeting methods does the Unified targeting method use to identify the Required UI Element?
Selector, Fuzzy Selector, or Image
From the given options. Identify the key differences between Modern and Classic design experiences.
Input Methods Used, Activities, and Activities Properties
Which of the following variable types is best suited for storing the student’s birth month?
Array
Which of the following are container activities?
Use Application/Browser
Open Application
Not - Get Text
Not - Click
You have just created a new project. How would you set the classic experience for this specific project?
Project Settings > General
Which design experience does the full text output method belong to? Modern, Classic, or Both?
Both
Before creating a robot path that defines a UI Automation project, RPA Developers first need to:
Identify the human path that achieves the same goal by breaking down each individual step.
Which of the following statements are true?
T Modern activities uses a targeting technology called Unified Target that cycles through all of the available targeting methods.
T Developers can use modern and classic activities regardless of the automation project’s design experience.
F In overall UI automation scenarios, more than 90% of classic activities utilize the most reliable targeting method, namely Image.
T Object repository is only available in the modern design experience.
Which of the following criteria are considered a best fit for automation?
T Rule-based
T Repetitive process
F Processes that are digital and involve a highly static system and process environment.
T Processes with Standard Input
Which of the below options are true for ‘SendWindowsMessages’?
T Input method
F Output method
T Activity Property
F Activity
Studio is with the default design experience. You have opened the project, which uses a Classic design experience. You want to extract data from a web application. Based on the given scenario, which scraping wizard will be available to you?
F Recorder
T Data Scraping
T Screen Scraping
F Table Extraction
You are running the classic design experience at Studio level. What path would you use to enable the modern design experience for all new projects?
1 Access the Studio Backstage View
2 Click Settings
3 Click Design
4 Enable Use Modern for New Projects
What are the key features of ChromiumAPI?
X It’s the fastest input method among all four input methods.
X It doesn’t support hotkeys.
Y It can empty the field before typing.
Y It works in the background.
Which of the following actions/functions that aren’t background compatible?
Y Activities using image as targeting method.
X Activities using Sendwindowmessage inputmethod.
X Activities using fuzzy selector as targeting method.
X Activities using Selector as targeting method.
Which of the following actions gets captured automatically by the App/Web recorder.
Y Clicking Action
Y Typing text
Y Sending keyboard shortcuts using your keyboard
X Copying text
X Hovering over an element
X Highlighting an element
Which of the following output activities are supported in the modern design experience?
Y Get Text actvity
N Get Full text
N Get visible text
Y CV GetText
Which of the following Activities gets generated using the table extraction wizard?
Y Extract Table Data
N Data Table
N Output Data Table activity
N Write Range activity
Which of the following options does Verify execution feature support to verify a UI element?
Y Checks whether the element appears
Y Check whether the element disappears
Y Text Changed
Y Visually Changed
Image exists
Image appears
The workflow contains a Get Text Activity and the scraping method is set to Full text. While running the automation, the application is minimized. What’s the outcome of the Get Text Activity?
It extracts both the text and the text position.
The Get Text activity doesn’t allow you to select the scraping method.
It throws an error.
Y Extract the correct required text.
Review Question: which of the following statements are true about Switch Activity?
Y In the Case input field, quotation marks aren’t used to write strings.
Y Uses a condition that isn’t boolean.
Y Useful when we need at least three potential sources of action.
Useful only with two potential courses of action.
Uses a condition that’s boolean in nature.
Which of the below options are true for ‘Chromium API’?
Y Hot key support.
Y Works in the background.
100% compatible with all sort of the applications.
Execution speed is fastest in compared to Hardware events.
Review Question: From the given options, identify the scraping wizard used in the modern design experience.
APP/web Recorder
Screen Scraping
Data Scraping
Y Table Extraction
Match the following with their respective functionalities.
Pause - Helps to adjust required settings in the application while indicating the Target.
Hoverable Selection - Helps to indicate hoverable elements
Image Selection Mode - Uses only Image as targeting method to identify the UI element.
Anchor - UI element which helps to uniquely identify the correct UI element required for UI action.
Target - UI element required to perform UI actions on it.
UI elements Highlighted in yellow - Duplicates found
UI elements Highlighted in red - Target element not identified.
Review Question: A job is executed from Orchestrator. What was the type of the Robot used?
Unattended Robot
Check App state activity can be used outside the scope of Use application browser card.
True
By using table extraction wizard you have already scraped the structured data with the required configuration. Later you realized that you didn’t set a limit for the extraction. How can you solve that?
Y Accessing the Editing Extract Data option in the context menu of Extract Table Data Activity.
Use Data table/excel activities to alter the limit.
Y Re-configure the table extraction wizard from start.
Edit the value in the properties panel of Extract Table Data Activity.
App/web recorder doesn’t support image targeting method.
False
You are building an automation with Notepad. You want it to perform a UI action on a specific Notepad file. To indicate the required Notepad file to be opened, which property of Use Application/Browser activity do you need to configure?
Selector
Application path
Browser URL
Y Application arguments
Which of the following statements apply to Simulate input method?
Y Uses the technology of the target application (the API level) to send instructions.
Y Automatically erases previously written text.
N Doesn’t work in the background.
Y Does not support special keys like ‘Enter’, ‘Tab’, and other hotkeys.
Identify the output methods from the following options.
Choose all the options that apply
Y Full Text
N Simulate Type
Y Native
N Send Window Messages
Y OCR
What is the type of output variable returned by Find Element activity?
Choose one of the options below
DataTable
Y UiElement
Boolean
String
Which of the following output activities from the screen scraping method extract the hidden text from a UI element?
Choose one of the options below
Get Text
Get OCR Text
Y Get Full Text
Get Visible Text
Which of the following are input actions?
Choose all the options that apply
Y Send Hotkey
Y Type into
N Get Text
Y Click
What happens when a Find Element activity does not find the desired element within the set Timeout property?
Choose one of the options below
The activity pauses for a specified time and resumes the execution
The next activity is executed immediately.
Y The activity throws an exception and stops the execution
The activity returns a False value in a Boolean variable.
Which of the following activities has a Boolean variable as the output?
Choose one of the options below
Find Element
Y Element Exists
Wait Element Vanish
On Element Appears
What is the purpose of using Activate option in the Type Into activity?
Choose one of the options below
Clicks a specified UI element before writing the text.
Y Brings a specified UI element to foreground.
Simulates the type action.
Erases previously existing content.
Match the input methods with the correct definitions:
Default - Clicks: the mouse cursor moves across the screen
Send window messages - Replays the window messages that the application receives when the mouse/keyboard are used
Simulate - Uses the technology of the target application (the API level) to send instructions
Which type of variable does the data scraping method use to store the extracted data?
Choose One:
Y DataTable
String
Array
UiElement
An automation process using UI Interaction activities set to the default input method is running on Michelle’s machine. Would you recommend that Michelle works on her machine while the process is running?
Choose one of the options below
Yes
Y No
Review Question: Which are the steps of RPA implementations?
Choose one of the options below
Prepare RPA / Solution Design / Build RPA / Implement RPA / Constant improvement
Y Prepare RPA / Solution Design / Build RPA / Test RPA / Stabilize RPA / Constant improvement
Prepare RPA / Design RPA / Develop RPA / Test RPA / Implement RPA
Prepare RPA / Opportunity Assessment / Solution Design / Build RPA / Test RPA / Stabilize RPA / Constant improvement
Review Question: Which of the following factors increase the complexity of a potential automation?
Choose all the options that apply
Y Legacy applications
Having clear rules for each step
Y Inputs that cannot be standardized
Y The number of decision points in the business logic
What happens if you use a Write Range activity and try to write data in an .xlsx file that does not exist?
Choose one of the options below
It will continue the execution without writing the data.
It will throw an error.
Y It will create that file for you and write the data in it.
It will create a new blank file.
What activity can you use to write a data table to a string variable?
Choose one of the options below
Generate Data Table
Merge Data Table
Y Output Data Table
Write Range
Which of the following activities can be used to read an entire sheet from an Excel file?
Choose one of the options below
Get Table Range
Y Read Range
Read Cell
Get Range
Which activity would be your first choice to loop through all the rows of a data table?
Choose one of the options below
Y For Each Row
While
For Each
Join Data Tables
Can activities which require an Use Excel Application container run on a machine that does not have the Excel application installed?
Choose one of the options below
Yes, but only for .xls files
Yes, for every Excel file type
Y No, these activities require Excel to be installed
Yes, but only for .xlsx files
What container do you need to add to be able to use Modern Excel activities?
Choose one of the options below
Y Use Excel File
Excel Application Scope
Use Application/Browser
No container is needed
Review Question: This project type is recommended for simple, linear workflows without multiple decision nodes.
Choose one of the options below
Y Sequence
Flowchart
State Machine
You have included a Sort Data Table activity in your workflow. The DataTable variable is called dt_Usernames. The Input DataTable field is set to the dt_Usernames variable and the Output DataTable field is also set to dt_Usernames.
Which activity will sort the Data Table values?
Choose one of the options below
store them a different variable
store them in an Excel file
store them in a .CSV file
Y store them in the same variable
display them in the Output panel
Choose two activities that you can use if you want to add data to an existing .xlsx document without overwriting existing data.
Choose all the options that apply
Y Excel Append Range
Y Workbook Append Range
Workbook Write Range
Excel Write Cell
Review Question: The body of a loop is executed at least once when this activity is used.
Choose one of the options below
For Each
Y Do While
Loop Sequence
While
String Method: String.Concat
Concatenates the string representations of two specified objects.
Expression: String.Concat (VarName1, VarName2)
Output datatype: String
String Method: Contains
Checks whether a specified substring occurs within a string. Returns true or false.
Expression: VarName.Contains (“text”)
Output datatype: Boolean
String Method: String.Format
Converts the value of objects to strings (and inserts them into another text).
Expression: String.Format(“{0} is {1}”, VarName1, VarName2)
Output datatype: String
String Method: IndexOf
Returns the zero-based index of the first occurrence of a specified Unicode character or string within this instance.
Expression: VarName1.IndexOf(“a”)
Output datatype: Int32
String Method: LastIndexOf
Reports the zero-based index position of the last occurrence of a specified Unicode character or string within this instance.
Expression: VarName1.LastIndexOf(“author”)
Output datatype: Int32
String Method: String.Join
Concatenates the elements in a collection and displays them as String.
Expression: String.Join(“|”, CollVarName1)
Output datatype: String
String Method: Replace
Replaces all the occurrences of a substring in a string.
Expression: VarName.Replace (“original”, “replaced”)
Output datatype: String
String Method: Split
Splits a string into substrings using a given separator.
Expression: VarName.Split(“|“c)(index)
Output datatype: Array of String
String Method: Substring
Extracts a substring from a string using the starting index and the length.
Expression: VarName1.Substring(startIndex, length)
Output datatype: String
The RegEx Builder
Regular Expression (REGEX, or regexp) is a specific search pattern that can be used to easily match, locate and manage text. However, creating RegEx expressions may be challenging.
UiPath Studio contains a RegEx builder that simplifies the creation of regular expressions.
Typical uses of RegEx include:
Input validation.
String parsing.
Data scraping.
String manipulation.
Regex Method: Matches
Searches an input string for all occurrences and returns all the successful matches.
Output datatype: System.Collections.Generic.IEnumerable
Regex Method: IsMatch
Indicates whether the specified regular expression finds a match in the specified input string.
Output datatype: Boolean
Regex Method: Replace
Replaces strings that match a regular expression pattern with a specified replacement string.
Output datatype: String
Which of the following four values will the following expression return?
String.Format(“{1} is {0}”, “home”, “John”, “far away”, 0, 1)
“John is home”
Consider the list of strings ListOfContinents = {“Africa”, “Antarctica”, “Asia”, “Australia”, “Europe”, “North America”, “South America”}.
What value will the expression ListOfContinents(2) return?
Asia
Consider the string variable Letters = “abcdefg”.
Which out of the four values would the expression Letters.Substring(1,2) return?
“bc”
Which out of the three activities can be used to process every item in a collection individually?
For Each