Automation Anywhere Advanced Mock Questions/Prep

7. The procurement team needs to feed all the temporaily logged purchace information from one large CSV file into the correct finance database. What loop types can the bot developer use to meet this request? (choose two

'Iterator Excel Advanced ' / 'for each row in worksheet' 'iterator CSV/TXT' / 'for each row in CSV/TXT'

What Will be the result if the following parameters are specified in the String: substring action? Source String: Today 1 US Dollar is equal to 70.162249 INR Start from: 31 Length: 5

70.16

A developer needs to prepare an automation to handle unforeseen events but still execute some code if those events happen Which two does the developer need to consider in the solution? (choose two)

A finally action placed after a try action Will always be executed A finally action after an empty catch action

When switching screens in an Application, a bot periodically hangs. This seems to happen most when the remote System is busy and slow. What should the bot developer do to make the bot more tolarant of remote system pacing issues?

Add a delay action for the maximum expected wait time

A developer is writing a bot to be scheduled to Download the previous days reports from SAP. After running the report, the developer finds that the bot downloaded all reports from the past month. How can this issue be resolved?

Add the if: date is after, conditional statement

A bot developer deploys a bot which keeps failing between two actions. The failing action depends on the completion of the previous task bot, run action. The previous task bot is creating a file for use in the current bot. how should the bot developer modify the bot to prevent failure?

Add the wait for condition action and select the proper condition

A manager wants to set up automatic file archiving for files in a Specific location that have not been updated in a week. How would a bot developer meet this Request while looping through each file in the folder?

Assign filename and extension from the dictionary type variable. To move the files, use package copy action and delete action

The inventory managemente bot reads data from an excel workbook (inventory .xlsx) that stores stock data for various materials. When the stock fallas below a pre-defined level, it updates another Excel workbook (orderform.xlsx) that maintains re-order Information. However, when the bot runs, the inventory .xlsx workbook is getting updated instead of the orderForm.xlsx workbook. What is the cause of the problema?

Both worksheets are open in the same session

A user would like to extract table data from a web page and save it in a CSV file, what Procedure should be used after using the browser package : launch website action?

Capture the table recorder and set action to 'get table' assign the output to table tupe variable and use the data table package to write to file action to write the data in the table variable to a CSV file

After reading data from several CSV files using a loop through files in a folder, a bot developer discoverts the first line of data repeats for every CSV file in the folder. How can they eliminate the duplicated data?

Change add another loop inside the table loop to loop through each value in a record and add a condition to eliminate the duplicate data

A bot developer has developed an automation and needs assitance from colleagues to ensure the bot production ready. They need to share this bot with their colleagues to review the logic. How can they best achieve this?

Check in the bot to the public folder

A developer has been asked to build a bot to record a process within an application. The process involves entering data into multiple fields within different sections. How would the developer accomplish this request?

Clic record, select de application, and clic through each of the fields

. A developer is attemping to run a bot locally but receives the following message: "unexpected error setting up a new user session". What three steps would reveal root cause of this error? (choose three)

Confirm that local device is connected to the control room Verify the device username is correct in the user Profile Review the Audit log for more detailled Information

A company has strict policies to ensure data security and strictly enfocres password security. A bot developer is developing a bot that requieres connecting to a MySQL database to retrive data. The database administrator is not able to share the database adminsitrator to ensure that the bot can succesfully connect to the MySQL database without violating the security policies of the organization?

Create a credential vault to store the password in an encrypted format

A bot developer is looking to leverage the credential vault to store user data for an ERP Application. They would like to store their URL, username, password, and API key in the vault. How can this best be accomplished?

Create a single credential to hold this data

A bot developer has captured Information from a website and stored it in a "table" variable. They are trying to use the data table: write to file action to write the stored information to a CSV file. When they run the bot, they get this error: "folder is not available" what should the bot developer enable to ensure the file and folder are present

Create files/folders if it does not exist

A bot developer is running a loop through each row in a table but needs to keep track of how many iterations occur. There does not seem to be any System variable that keedps track of iterations. Which two actions can be used in the bot's code to address this issue?

Create number variable to store the count convert the Number variable to a string to record in a log to file

A bot developer has logged into a control room with a bot creator account to build a bot. When trying to record a process from the workbench, the following error is gererated: "device is disconnected". Where should the Administrator go to check the device status?

Devices>my devices

While capturing a series of steps in a process to fill out a web-based form, the resultant recorder: capture actions have errors in the captured text, on playback the bot fills out the form with varying speeds where some letters are typed individually and other cells are populated completely. How can the bot developer change the code to have consistent playback?

Edit the recorder:capture lines and clear the delay parameter to remove the keystrokes delays

A bot sends an email to the lead at the end of a procees using microsoft Outlook when it is run on the developer's device. When the same bot is run on a bot runner, the bot fails to send the email and displays an error for the send email line number. what should be done to fix this error?

Ensure the bot runner device user has Profile created for Microsoft Outlook

A business analyst Request that an automation provides Specific, dynamic information at defined points of the execution of the bot. What two actions should the bot developer utilize to achieve this? (choose two)

Enter a comment: comment action and add the matching variables Insert a log to file: log to file action and write relevant Information to a dedicated file

A bot developer needs to provide a mechanism to log issues within a bot in a production environment while providing an inline resolution for known fault scenarios. Which tool allows this result

Error handler package

A bot developer is writing up the requirements document for a use case where data from an Excel worbook is moved to new worksheets within the workbook. What packages should be specified in the requirements document?

Excel advance package

During the automation of an Excel spreadsheet, a macro must be called from the spreadsheet itself. Which package should be used to archieve that result?

Excel advanced

While verifying a bot using the debug feature in the bot, a bot developer identifies an error in the bor steps. The bot developer is unable to edit the step. What should the bot developer do to fix this?

Exit de debug mode

. A developer is creating a bot to generate a report and wants to ensure the bot Will create a new report every time it runs, which if condition would verify that we are not overwriting an existing file?

File exists

0. A colleague told a bot developer they created a re-usable bot for logging into their CRM System. The bot developer would like to test the colleagues bot. What two steps should the bot developer take to use the CRM login bot at the front-end of their automation? (choose two)

Have the colleague check out the bot to their private folder Use the run task action to call the CRM login bot

A bot developer builds a bot and is a planning to schedule the bot for execution on bot runnerns. While trying to schedule this to run at 11:00 am every Monday, the bot developer does not see their bot populating in the list of available bots. How can the bot developer resolver the issue?

Import the task bot

A bot developer is tasked to create a modular bot that Will be made available to all citizen developers. The modular bot Will be able to communicate back with the calling bot. What should the bot developer's action be to accomplish this?

In the modular bot, assign the return value(s) to the 'promt-assigment' variable that Will automatically be picked up by the calling bot

A bot built a long time ago uses old versions of packages, yet continues to work properly. Why should the package references not be updated to the lates versions

It may change the parameters for some actions

A bot developer built a bot connected to the company's call center mail server to get email from customers. All emails subject recipients, senders, message and received date and time Will be stored in a dictionary variable. To ensure that the above properties exist which if action condition should the bot developer select for this situation?

List variable

For security reasons, Organization A has collected citizenship cards of all 15000 employes which need to be uploaded to an HR Portal. All employees have submitted the citizenship card in PDF format. The HR portal allows only JPG image files to be uploaded. How should the bot developer automate this process?

Loop through each PDF file saved in a folder. Use the extract image action from the pdf package to convert PDF to image format and upload the image to the HR Portal using Recorder

Organization a wants to send salary splips in pdf format to its 15000 employees. They also want to password-protect the sañary slip with a random password. what is the best approach that the bot developer should follow?

Loop through each PDF file seved in a folder. Use the Encrypt Document Action from the PDF package to set the password

A developer is creating three bots and wants to pass the variables among them. The second bot must accept the values from the First and pass them to the third, how can this be configured?

Make sure all the variable names match in each bot

. A bot is scheduled to run weekly to Download pdf files from an FTP server and then process them through IQ bot. Last night's run failed with an error "unable to connect to the FTP server 192.168.21.21. Use valid connection parameters and try again." What is the best way to make this bot work properly

Make the connection to the FTP server prior to running the bot

A bot developer is developing a bot on an erp system that helps with the creation of a support ticket, what are the two benefits of creating a bot using the modular concept rather than putting everything in one bot

Makes the bot easier to read and Update Enables reusability

A bot developer is developing a bot on an ERP system that helps with the creation of a support ticket. what are the two benefits of creating a bot using the modular concept rather than putting everything in one bot?

Makes the bot easier to read and Update Enables reusability

A bot developer wants to check if a Specific push button exists on a webpage in the Internet Explorer browser. What is the best loop condition to meet the Request?

Object

A bot debeloper creates a bot that loops through an office 365 excel spreadsheet. when they run the bot, they receive an error: cannot find any open spreadsheet action using session name "default". What action is likely missing?

Office 365 excel: open

They is a CSV file which a user needs to Update daily with the daily sales numbers from ERP (one data set per day). A bot creator would like to automate this operation. After getting the data from ERP, which proceduce is used next?

Open an existing CSV file using Excel advancer: open action and add data using Excel Advanced: get cell action

1. A project manager wants to make changes to a bot stored in private tab. They have asked the bot developer to move the bot to public tab, but the Project manager is not able to edit the bot. What is the likely reason for this?

Public bots and files can be viewed, run and checked out by other people, based on permission set by the administrator

A bot been created to run a Python script using inline scripting. When the bot runs. It fails to execute the phyton script. What is the problem?

Python runtime is not Installed on the device

A bot developer wants to take a CSV file and write the rows into an XLSX file. What process can they follow to do this using the fewest lines of code? (choose two0

Read from the CSV and loop though each row loop through each value in a record. Write one line to the Excel file in the loop, then change to the next row in the outer loop Read form the CSV file, assign each value in the record variable to the appropriate variable, then write a line of variables to the Excel file using a single line

A bot developer Installed a bot agent with Administrator rights successfully for the first time but cannot create a bot with the universal recorder. What would be the first time but cannot create a bot with the universal recorder. What would be the fist step to resolve the issue?

Restart the bot agent service

A developer needs to automate the following process 1 Receives daily reports in an e-mail with a specific subject 2 Downloads the report 3 Formats the report in Excel (i.e. shorts columns, removes unnecessary colummns, filters required rows.) 4 Saves the report with a date-time stamp 5 Logs in to SAP 6 Uploads the report into SAP What action would be used in the bot for step 6

SAP: set text

A developer is building a bot to run daily reports. If any errors occur in web app while the report is running a Window titled "error" with important Information is displayed. The developer would like to capture this Window when errors occur and sabe it to a local file on the desktop. What action package should be used to capture the desired data

Screen> capture Window

A bot developer wants to organize a task bot that is easy to read and troubleshoot for other developers, which action Will Help achieve this goal?

Step: step

A bot developer is int the process of a building 10 bots that all Access a website and log in with same Administrator credentials. The Company policy is to change the password for the administratot accouunt every 30 days. What should the bot developer do to handle theses password changes without compromising on security?

Store the credentials in a locker in the credential vault

A bot developer is building a bot for a highly secure website. Due to security concerns, login Information cannot be stored in an insecure place. How can the developer best maintain security in this scenario?

Store the credentials in the credentials vault

A bot A is required to execute different actions base on the status of a parameter from bot B. the developer wants to ensure portability and maintainability of the bots. How would the bot developer accomplish this?

Store the status of bot in a database and read it from bot a

A bot captures a data table and stores it into a table variable. A bot developer needs to loop through the table variable and filter based on data value from one of the columns. Which two variable types are needed to complete the filter? (choose two)

String Boolean

A bot developer creates an automation that validates the content of a data table on a record-by-record basis. Which two options Allow the developer to access the Information inside each record when iterating through the data table? (choose two)

Switch over to the variable pane and create a variable of the required variable type Click the wand icon to create a variable of chosen type any on the fly

. A developer has created a String called vCounter with a default value of 1. The developer added the "increment" action at the end of a loop to add 1 to the variable each time the loop repeats. When the bot reaches the "increment" action it receives an error. What is the cause of this issue?

The String> number acction must be used to first convert the String variable to a numbe

. A bot developer is creating an automation that needs to consist of multiple bots. What are two ways they can ensure that Information from the main bot is available in all sub bots? (choose two)

The bot developer creates variables in the sub-bots and tags them as input and output The bot developer creates variables in the sub-bots and tags them as constant

A bot developer has created a bot to extract data from a CSV file and load it into the Excel format. The bot is running successfully but the Excel file at the destination is not opening during execution, resulting in the inability to monitor the data being loaded in the Excel file. What is the reason for this issue?

The bot developer selected the read action instead of the open action for the Excel file

A bot developer found an older version of the email package set as default and would like to use the latest one for an existing bot. How Will the version of email package be called by the bot?

The bot developer should open the packages page and select the version of the package to be used

A citizen developer is analyzing a business process for wich a task bot with no artificial intelligence neddes to be created. Which two conditions need to be considered? (choose two)

The business process needs to be based on structured data The business process needs to be rule-based

. A bot developer has a CSV file, which contains five columns separatesd by commas. They create a bot to extract data from the first columna of the CSV using the Open and Read actions of the CSV/TXT package. However, the bot extracts five ítems in a row, not only the firts item. Why is this ocurring?

The delimiter of the Open action in the CSV/TXT package was set to new line

A bot developer is designing a bot to perform automation on an SQL server database. There are multiple conditional queries affecting multiple records of dependent tables in different databases. The developer must ensure that if the bot fails Midway during the query execution process, the changes in the tables will be successfully complete or rolled back to ther original state. How would the developer accomplish this?

The developer should use the Begin/End database transaction action in the database package

A bot developer is responsable for processing expense reports submitted by employees in the organization. The developer wanta to create a bot that reads a set of expenses submitted and then sends them for approval to the appropiate approvers. If the expense value of a line item in the report is under $15, the bot should ignore the record and process the next record. If the total value of all expenses in the expense report exceeds $1500, the bot should stop processing and send an email to the submiting employee that the value excedes policy limits. Which approach Will the bot developer use in the bot

The loop action, specify loop: Continue when the line item value is under $15 and specify Loop: Break when the total expense report value exceeds $1500

. Due to modulatization, multiple bots were created. All the bots are called in sequence from a parent bot. variables are declared as input/output variables in a child bot. By using the taskbot: run action a String variable was selected as an output variable in the parent bor. On executing the bot, it throws an error related to the output variable. What is the likely reason for this error?

The variable in the assign variable to output selection in the parent bot must be of datatype list

To read Price data from a CSV file, a bot creator creates a number variable and uses the loop package iterator 'for each row in CSV/TXT' to build a bot. But, while setting the loop iterator's 'assign the current row to this variable' action, the bot creator could not find the number variable from the drop-down list. What is the likely cause of this issue?

The variable type should be "string"

A bot is supposed to open Google Chrome. It Works correctly on user A's system but instead opens Internet Explorer on user B's System. What is the posible reason for this phenomenon?

This bot calls the browse package: Launch website action which set the browser to blank. On user A's system the default web browser was Google Chrome and on user B's system, it was Internet Explorer

A bot developer wants to sort rows of invoice line ítems based on a numerical quantily columna. They have captured the data for the row into a a variable but are unable to select the variable in the if condition. Which two processes can they use an if conditioon for, base on numerical value? (choose two)

Use String to number to convert the record index value into a number type variable Use number assign to assign a record index value to the number type variable

A developer is actively building a bot to login a company's CRM system, run daily reports and send those reports to management. Depending on the amount of data, these reports can take between 10 and 55 minutes to run. Once the report has completed, as CSV file is created and placed in the local downloads folder without changing the GUI on the CRM. How can the developer best account for the inconsostencies in the time it takes to run the reports?

Use the "wait for Windows" action

A bot manipulates various Excel files is desploye don a virtual machine. During execution, the bot fails to manipulate the Excel files. The virtual machine Administrator informs the bot developer that microsoft office is not installed. How can they develop the bot to run without microsoft office?

Use the Excel basic package actions

A bot that manipulates various Excel files is deployed on a virtual machine. During execution, the bot fails to manipulate the Excel files. The virtual machine Administrator informs the bot developer that microsoft office is not Installed. How can they develop the bot to run without microsofr office?

Use the Excel basic package actions

A bot developer would like to know how many cells that contain email address are in a specificic Excel sheet. They will create a bot to search the cells for "@" for email address which two procedures are suitable for this bot (choose two)

Use the Excel basic package: find action to assign the result to a "list" type variable. Inside the loop "for each item in the list", use the number package increment action to increment action to increase the "number" type variable by 1. After looping, you Will see the "number" variable contains the number of email addresses Use the Excel basic package: find action to assign the result to a "dictionary" type variable, inside the loop "for each key in the dictionary", use number package increment action to increase the "number" type variable by 1. After looping, you Will see the "number" variable contains the number of email addresses

The finance team needs to automatically email dozens of reports to different manages in the Company. What two methods can the bot developer use to achieve this? (choose two)

Use the email: send email action specifying the local windows messaging Service with its relevant Access Information to send the email Use the email: send email action specifying and email server with irs relevant contact and Access Information to send the email

A bot is not executing expected actions within an if statement, what should the bot developer do to present a visual indicator that the bot Flow is performing actions within the if statement?

Use the message box action inside the if statemente

A bot developer has completed an end-to-end automation and is looKing to incorporate user inputs into the bot. The intent is to run this in an attended fashion in production. What actions they use to achieve this?

Use the prompt action packages to prompt for input

A bot developer is assigned a process to automate. One of the steps in the process involves logging in to an application. When building the bot, the bot developer does not wat to expose the login information. What are the ways the bot developer can accomplish this Request? (choose two

Use the recorder tool with credentials Use the simulate keystrokes action with credentials

A bot developer is assigned to automate an end-to-end process. Their Project manager has asked to design the bot keeping in mind the ease of review during testing. Which action should the bot developer use to modularize the actions within the bot?

Use the step action

. A bot developer is creating an automation in Excel and is running a large marcho to collect data from different systems. The macro varies in how long it takes to run but once complete, it highlights A1 red if any errors are found. If no error exist, the macro highliths A1 to green. Depending on the color, the bot developer has different workflows to automate. They are no table to get the bot to pick up the correct color because the bot attempts to get this color before the macro changes it. How can the bot developer best prevent this issue?

Use the wait conditicion to test if the macro is completed

While developing a bot, a bot developer notices that the bot continues the automation before the target Excel file is opened, causing the bot error out. This file contains 700,000 lines of data and takes between 30-90 seconds to open. While the file is opening, a small loading Window appears and then closes just before the file is opened. How can the bot developer make the bot most resilent and prevent the error at this stage

Use wait for window action to wait for the loading window to open

. A business user wants to extract table data from a web page, the Window title of the web page is similar but always changing. What two wait actions would address the Request? (choose two

Using wait for Window action, use the wildcard character to match the Window file Using wait for condition action's wait till Window exists

. A bot developer created a bot using the Excel basic package (version 2.0.0-20200215) on the fisrt of the month. On the fifth of the month, an Administrator in the organization uploaded the new version of Excel basic package (version 2.0.0- 20200305) to control room and set it as default. What Will occur when a bot created on the First of the month is executed on the fifth of the month and beyond?

When executing a bot, the version of Excel basic package needs to be selected

After entering the purchase order record into the order System, the system Will display a pop-up Window whether the data was successsfully entered or not. To confirm the data entry status, what is the best if condition for this situation?

Windows exists

A bot developer is given the requeriments to create a bot that repeats 10 steps. If the First five steps are true, the bot should stop processing. how should the developer meet this requirment?

Write a loop using the loop: break action

A bot is created to extract data from a CSV file and input the data into a web-based form. When executed, the bot fails to write the data to the form. How can the developer modify the bot correct the failure?

add the CSV/TXT: Open Read action with a table variable

A bot developer has a large bot which completes the following automation 1 bot logs into ERP System 2 bot navigates to the invoicing page 3 bot clicks actions > Search 4 bot searches for Specific invoice 5 bot emails invoice to Accounts payable team The not developer is interested in modularizing this bot to make it useful for upcoming automation projects. What is the most logical way to make the bot modular and reusable?

create one bot for logging into the ERP, another for searching invoices and a third for sending emails

. A developer has created an automation that gets the current system date and time. in the next step of the bot, the developer needs to add one week to this date. What type of variable should be used to meete this requiremente?

datatime variable

A bot developer needes to leverage a modular bot (botA) that was created by a citizen developer. What should be the chosen action to achieve this?

execute the "task bot run" action and select botA

The bot runner wants to run a bot with a different device, which is not registered in the control room, to activate the local device, the bot runner installs the bot agent to the local device. What should the bot runner do next?

set the local device login credentials to device>my devices in the control room

A bot developer installs a bot agent on a local device. When the bot is run from the workbench, an error to input device credentials is received. Which credentials should be used to resolve this error?

single sign-on credential

A bot developer has created a bot to read data from a microsoft Excel file and store in in a database. The bota y encounter an error if the required Excel file is not available or while updating a table in the database. What is the best way the bot developer can address this issue?

use another file that contains the same data in a catch block

4. A bot developer is looKing to create an automation where their bot connects to a SQL isntance and runs a few queries. What action should be used as first step in their instance and runs a few queries. What action should be used as a first step in their Workflow?

use the begin database transaction action

3. Due to modularization, multiple bots are created. All the bots need to be called in a sequence from parent bot. Values need to be transfered between all childs bots. What is the best approach the developer should follow?

while declaring variables, select the options use as input and use as output in the child bots