UiPath

Question 1

What are the 4 ways to create DataTables?

Answer 1

• Build Data Table
• Read Range - gets content of worksheet and store data in data table
• Read CSV
• Data Scraping

BRRD (Big bird picking up data table and flying away)

Question 2

What does the Lookup Data Table function do?

Answer 2

1. Search for value -> returns row index
2. Give coordinates of cell -> returns value

SerGeant Lookup

Question 3

What does Output DataTable function do?

Answer 3

Writes data table to string using csv format

Question 4

List 3 business scenarios where Join Data function is useful?

Answer 4

1. Combine 2 databases of employees extracted from 2 applications
2. Check which clients (DB1) have been contacted in a marketing campaign (DB2)
3. Check which of the suppliers of a company (internal DB) have applied for public aid (public DB).

Question 5

What are the differences between the two input methods: “Send Windows Messages” and “Simulate”?

Answer 5

Both work in the background (default does not)

Send Windows Messages: Replays the window messages that the target application receives when the mouse/keyboard is used. Slower, but less compatability issues.

Simulate: Uses the technology of the target application (API level). Faster, but some compatability issues.

Question 6

What is the default input method when interacting with User Interfaces? Strengths/weaknesses?

Answer 6

Actually clicks the mouse and uses the keyboard to enter input.

Can’t touch computer while it’s working.

Slower, but has 100% compatability.

Question 7

What is an input action as it relates to User Interfaces and what are the 4 types?

Answer 7

It’s any time we insert data into an application, or we send a command to a system to produce a change (or a continuation)

Types: Click, Type Into, Send Hotkey, Hover

Question 8

What is IMAP?

Answer 8

Internet Message Access Protocol

Used to receive e-mail from mail server

Question 9

Name 3 characteristics that make a process more suitable for RPA automation?

Answer 9

1. Repetitive
2. Rule-based
3. Stable

Question 10

Name 3 factors that increase the complexity of a potential automation?

Answer 10

1. Number of decision points in business logic
2. Legacy Applications
3. Inputs that cannot be standardized

Question 11

What value will the following expression return?

String.Format(“{1} is {0}”, “home”, “John”, “far away”, 0, 1)

Answer 11

“John is home”

Question 12

What are the 6 steps of RPA implementations?

Answer 12

Prepare RPA, Solution Design, Build RPA, Test RPA, Stailized RPA, Constant improvement

Question 13

Consider a dictionary variable (birthDates), of type String, String, that contains name and birth date pairs. They key values are the names. You want to add a new key / value pair using an Assign Activity (John Doe, Apr/20/1980).

What expressions would you enter in the To and Value fields of the Assign activity?

Answer 13

To: birthDates(“John Doe”) Value:”Apr/20/1980”

Question 14

What activity can you use to create a data table from unstructured data?

Answer 14

Generate Data Table. This allows you to use files that may be separated by pipes, spaces, etc…

Question 15

Can Excel related activities run on a machine that does not have the Excel application installed?

Answer 15

Yes, but only for XLSX files

The last X (xlsX for xls) means that it follows the XML standards

XLSX files is smaller than XLS

Question 16

What 2 activities can you use if you want to add data to an existing XLSX document without overwriting existing data?

Answer 16

1. Excel Append Range

2. Workbook Append Range

Question 17

What happens if you use a Write Range activity and try to write data in an XLSX file that does not exist?

Answer 17

It will create that file and write the data to it.

Question 18

What happens when a Find Element activity does not find the desired element within the set Timeout property?

Answer 18

The activity throws an exception and stops the execution.

Question 19

List 4 uses of RegEx?

Answer 19

Data Scraping
Input Validation
String Manipulation
String Parsing

Question 20

What are the 4 types of workflows in UiPath

Answer 20

Sequence - best for simple linear work
Flowcharts - better for decisions, workarounds, etc…
State Machine
Global Exception Handler

Question 21

What are output methods used for in UiPath? What are the 3 types?

Answer 21

They are used to extract data from UI elements.

FullText
Native
OCR

Question 22

Describe the FULLTEXT Output method

Answer 22

• Fastest of the three
• Extracts hidden text (options in dropdown list)
• Doesn’t support virtual env
• Doesn’t capture text position and formatting

Question 23

Describe the NATIVE Output method

Answer 23

• Compatible with apps that support Graphics Design Interface
• Extracts text position and formatting
• Can’t extract hidden text or work in the background
• Doesn’t support virtual env

Question 24

What is GDI

Answer 24

Graphics Design Interface: the Microsoft API used for representing graphical objects.

Question 25

Describe the OCR Output Method

Answer 25

Optical Character Recognition - Works with virtual env and reading text from images - Captures Text position - Cannot work in the background - Slowest of the 3

Question 26

How does data scraping work?

Answer 26

- Indicate multiple elements of the same thing (i.e. titles from a search result). - This creates a pattern that UiPath recognizes and generalizes to the entire page[s]. - Can do this for multiple elements (i.e. title, publish date, etc...) - This is then stored in a data table and can be written to a file).

Question 27

How do you get the number of files in a given directory (as well as other info about the files)

Answer 27

FileInfo = Directory.GetFiles("FilePathInStringFormat") -You would then do: FileInfo.Count.ToString (if you wanted it to be a string that is).

Question 28

How do you get e-mails in UiPath

Answer 28

- Assign the e-mail address to a variable - Use get password to store password variable - Use Get IMAP Mail Messages activity (specify folder, port #, server (imap.gmail.com), email and password) - In the Output section of IMAP activity properties, use the variable (GetMailMessages) to store the Messages.

Question 29

How would you get a specific e-mail subject line?

Answer 29

- Store the messages in an email object (variable could be GetMailMessages for example). - Use GetMailMessages.MessageInstance.Subject

Question 30

Outilne a workflow to fill an online form from data in a csv file.

Answer 30

- Read CSV into a data table - Open browser to the form url - Loop through CSV File - Use a Type Into activity specifying the selector (i.e. name, address, etc...), and the Record from the CSV/DataTable (Datatable.SpecificRecord.FullName)

Question 31

What are the steps to publish a library and how would you import to use?

Answer 31

-From studio click publish tab at the top. -Publish to orchestrator or a custom file location -Click "publish" to finish to import... -Click Manage Packages tab -Go to Settings -Locate Source File and click "Add" -You can now install the package

Question 32

Describe how to do a google search if you're interacting on a VM

Answer 32

- Use If Image exists to check for the google search button. - If true then: - Use Native Citrix recorder to detect and click where you need to.

Question 33

When should you use a full selector vs a partial selector?

Answer 33

- Full selectors are best when switching between windows. | - Partial selectors are best for multiple actions in the same window

Question 34

How do you use wildcards in selectors?

Answer 34

* replaces multiple characters | ? replaces a single character.

Question 35

What is a business rule exception?

Answer 35

An exception caused by the data and a business rule handled by REFramework. Ex: if a value is too high or low, then skip the next step.

Question 36

What is an application exception?

Answer 36

An exception caused by an application that is handled by REFramework. Example: An application fails to start, so the framework closes that application and retries.

Question 37

In REFramework, what is the main advantage of using a dispatcher pattern?

Answer 37

You can split the processing of items between multiple robots

Question 38

How do the performer and dispatcher work in REFramework?

Answer 38

Dispatcher gets data and puts it in the orchestrator queue. The performer than takes from that queue and performs the necessary actions.