RakeshKushwaha82: September 2023

R1 RCM Interview Question

-----------------------------------

1-short Introduction

2-Roles and responsibility

3-Education completed year

4-AA 360 Development question

5-Datetime command in AA360

6-how we can get date difference in AA

7-without another script or language?

8-Knowledge of Database

9 Can we use Excel as DB

10-how we can Excel as DB

11-can we perform select Insert update delete in Excel using SQL query

12-how we can call script

13-you have knowledge of script language

14- Which script language you have used?

15. How many variables we can use to call the script

16-how to retrieve variables from the script

17-In Databse what is consistency?

18-where you use? consistency

19-how you can define an input-output variable in AA

20-what is the public and private mode in AA

21-can we see changes in Public mode

22-what is a credential vault?

23-how many variable type in credential

24-consumed* who are credential consumer

Here’s a structured answer guide for your interview questions related to Automation Anywhere A360, scripting, Excel as a DB, variables, and database concepts:

1. Short Introduction

I’m Rakesh Kumar, an RPA professional with over 9 years of experience, specializing in Automation Anywhere A360. I have delivered automation solutions in healthcare, BFSI, and life sciences domains, working with both Indian and international clients.

2. Roles and Responsibilities

Requirement gathering and feasibility analysis
Design and development of bots using AA360
Handling exception management and reusable components
Integration with APIs, databases, and Excel
Deployment and maintenance
Mentoring junior developers and ensuring best practices

3. Education Completed Year

B.Tech in 2009
MCA in 2012

🔹 Automation Anywhere A360 Technical Questions

4. AA360 Development Question

Q: How do you handle error logging in bots?
A: I use Try-Catch blocks, custom error handler sub-bots, and capture screenshots. Errors are logged with metadata like timestamp, bot name, line number, and exception message.

5. DateTime Command in AA360

The DateTime package provides actions like:

Get current date/time
Format date/time
Add/Subtract time
Calculate difference between two dates
Convert date strings to DateTime object

6. How to Get Date Difference in AA?

Use the “Calculate Date/Time Difference” action in the DateTime package.
Input: Start Date, End Date, Unit (Days, Hours, etc.)
Output: Stores difference in a variable.

7. Without Another Script or Language?

Yes, this is natively supported using DateTime commands — no external scripting is needed.

🔹 Database and Excel Knowledge

8. Knowledge of Database

Yes, I have hands-on experience with SQL Server, MySQL, and using Excel as a data source in AA360. I write queries for CRUD operations and use stored procedures as well.

9. Can We Use Excel as a DB?

Yes, using Database package with OLEDB/ODBC connection, Excel can be treated as a database.

10. How We Can Use Excel as DB?

Use ODBC DSN or OLEDB connection string
Connect via Database: Connect
Use SQL queries like SELECT * FROM [Sheet1$]

11. Can We Perform SELECT, INSERT, UPDATE, DELETE in Excel Using SQL Query?

Yes, but:

SELECT and INSERT work well
UPDATE and DELETE have limited support depending on driver and Excel version
All operations must refer to the sheet name with $

🔹 Scripting and Variables

12. How We Can Call Script

Use Run Script command in Script package, or call a Python, VBScript, or JavaScript via the Execute Script command.

13. Knowledge of Script Language?

Yes, I’ve used JavaScript, Python, and VBScript inside AA bots.

14. Which Script Language You Have Used?

Primarily JavaScript and Python to handle string manipulation, file operations, or complex logic.

15. How Many Variables We Can Use to Call the Script?

You can pass multiple input variables using the "Input Parameters" section. No fixed limit but practical usage depends on script and memory.

16. How to Retrieve Variables from the Script

You can return values using the “Output variable” option in script execution. The return value of the script is captured into a bot variable.

🔹 Database Theory

17. What is Consistency in Database?

Consistency means data integrity is maintained after any transaction. It ensures that all rules (constraints, relations) are preserved.

18. Where You Use Consistency?

Consistency is crucial in transaction management, for example when inserting records across multiple related tables. Also used in bot data validations before performing DB insert/update.

🔹 AA360 Variables & Security

19. How You Can Define an Input-Output Variable in AA?

In sub-bots, define input/output variables in “Bot Variables” section
Mark the variable as Input or Output based on data flow

20. What is the Public and Private Mode in AA?

Public: Variables are visible in the recorder and logs
Private: Values are masked (like passwords), useful for secure data handling

21. Can We See Changes in Public Mode?

Yes, public variables’ values can be logged and seen in debug output and log files.

22. What is a Credential Vault?

A secure repository in AA360 used to store and manage sensitive data like usernames and passwords. Access controlled via Roles and Policies.

23. How Many Variable Types in Credential?

Credential vault supports:

Username
Password
Key-value pairs

24. Consumed Who Are Credential Consumers?*

Credential consumers are bots or bot runners/users who use credentials stored in the vault. Permissions are controlled by the credential locker policy.

RakeshKushwaha82

Tuesday, 12 September 2023

AA Test Challenge AA360 RPA Challenge | XPATH Manipulation for Dynamic Web Page - Automation Anywhere A2019

AA Assessment Preparation

Novatiosolutions AA Assessment

Friday, 8 September 2023

Interview R1RCM -AA360