3F Advanced Techno Labs RPA Developer Interview Questions and Answers

Yes, vbscript is a scripting language used for automating tasks in Windows environments.

• VBScript stands for Visual Basic Scripting Edition.

• It is commonly used for automating tasks in Windows environments.

• VBScript is often used in conjunction with RPA tools like UiPath for automation.

• Example: Set objShell = CreateObject("WScript.Shell")

Yes, I have experience with SharePoint.

• I have worked with SharePoint to create and manage document libraries.

• I have experience with SharePoint workflows and automation.

• I have integrated SharePoint with other systems using APIs.

• I have customized SharePoint sites using web parts and templates.

PDF extraction involves using software tools to extract text, images, and data from PDF files.

• Use RPA tools like UiPath, Automation Anywhere, or Blue Prism to automate the process of extracting data from PDF files.

• Utilize OCR (Optical Character Recognition) technology to extract text from scanned PDFs.

• Extract structured data from PDF forms using data extraction techniques.

• Consider using regex patterns to extract specif...read more

IQ Bot is a cognitive automation solution that can learn from human behavior to handle unstructured data.

• IQ Bot uses machine learning algorithms to understand and extract data from unstructured documents.

• It can be trained to recognize patterns and extract relevant information from various types of documents.

• IQ Bot can be integrated with RPA tools like UiPath to automate end-to-end processes.

• It can handle documents like...read more

SQL queries are used to retrieve, manipulate, and manage data stored in a database.

• Write SQL queries using SELECT, INSERT, UPDATE, DELETE statements.

• Use WHERE clause to filter data based on specific conditions.

• Join tables using INNER JOIN, LEFT JOIN, RIGHT JOIN.

• Aggregate data using functions like COUNT, SUM, AVG.

• Group data using GROUP BY clause.

• Order data using ORDER BY clause.

Truncating removes all records from a table, while deleting removes specific records.

• Truncating is faster than deleting as it does not log individual row deletions.

• Truncating resets identity columns, while deleting does not.

• Truncating cannot be rolled back, while deleting can be.

• Truncating is a DDL operation, while deleting is a DML operation.

There are three types of selectors in UiPath: UiElement, aaname, and idx.

• UiElement selector is the default selector used by UiPath, based on the attributes of the UI element.

• aaname selector is based on the 'aaname' attribute of the UI element.

• idx selector is based on the position of the UI element in the application window.

Credentials in UiPath can be stored in Orchestrator Assets, Windows Credential Manager, Config file, and Constants file.

• Orchestrator Assets: Securely store credentials in Orchestrator and retrieve them during automation.

• Windows Credential Manager: Store credentials in Windows Credential Manager and access them in UiPath.

• Config file: Store credentials in a separate configuration file and read them during automation.

• Cons...read more

Use Power Automate to modify rows in Excel.

• Create a new flow in Power Automate.

• Add a trigger for when a new row is added or modified in the Excel file.

• Use the 'Get rows' action to retrieve the rows from the Excel file.

• Apply the necessary modifications to the rows using actions like 'Apply to each' and 'Update row'.

• Save the changes back to the Excel file using the 'Update a row' action.