30+ Purview Interview Questions and Answers

Answering questions related to Consultant Business Analyst role.

• BRD stands for Business Requirements Document and FRD stands for Functional Requirements Document.

• BRD focuses on business requirements while FRD focuses on functional requirements.

• BRD is created by the business analyst while FRD is created by the functional analyst.

• Scrum is an agile framework used for project management.

• In my last project, I worked as a BA and contributed by gathering requirements, creating user ...read more

A secure sign-in option can be designed by implementing multi-factor authentication and using encryption techniques.

• Implement multi-factor authentication such as using a password and a one-time code sent to the user's phone or email.

• Use encryption techniques such as hashing and salting to protect user passwords.

• Implement rate limiting to prevent brute force attacks.

• Use HTTPS protocol to encrypt data in transit.

• Regularly update and patch the sign-in system to address any secur...read more

End to end project architecture involves designing and implementing a data pipeline to process and analyze data from various sources.

• Define project requirements and goals

• Design data architecture including data sources, storage, processing, and analytics tools

• Implement data pipeline to extract, transform, and load data

• Ensure data quality and consistency throughout the pipeline

• Monitor and optimize performance of the data pipeline

• Examples: Using Apache Kafka for real-time data s...read more

I implemented concepts of OOP in my projects by creating classes, objects, inheritance, encapsulation, and polymorphism.

• Used classes to represent real-world entities

• Implemented inheritance to reuse code and create a hierarchy of classes

• Utilized encapsulation to hide data and restrict access to it

• Applied polymorphism to allow objects of different classes to be treated as objects of a common superclass

Code to check if a string is a palindrome or not

• Create a function that takes a string as input

• Remove all non-alphanumeric characters and convert to lowercase

• Compare the string with its reverse to check if it's a palindrome

Using Common Table Expressions (CTEs) to delete duplicates in SQL query

• Use a CTE to identify duplicates by ranking rows based on a unique identifier

• Delete rows with duplicate ranks in the main query

SQL joins combine data from two or more tables based on a related column between them.

• Different types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• The number of records in the result of a join depends on the type of join and the data in the tables.

• For example, an INNER JOIN will only return records that have matching values in both tables, while a LEFT JOIN will return all records from the left table and matching records from the right table.

Taking CSE from a tier 3 college is a better option for a career in software development.

• CSE from a tier 3 college will provide a strong foundation in computer science and programming skills.

• Employers in the software industry often prioritize skills and experience over the college's tier.

• Metallurgy may not be directly relevant to a career in software development.

• Internships, projects, and self-learning can help bridge any perceived gap between tier 3 and tier 1 colleges.

Duplicate entries in the database can be handled by using unique constraints, deduplication scripts, or merging duplicate records.

• Use unique constraints in the database schema to prevent duplicate entries.

• Implement deduplication scripts to regularly scan and remove duplicate records.

• Merge duplicate records by updating one record with the information from the other duplicate record.

Implemented query optimization techniques to improve performance in data processing.

• Utilized indexing to speed up data retrieval

• Optimized SQL queries by rewriting them for better performance

• Implemented caching mechanisms to reduce redundant data processing

Reverse a list without using inbuilt functions

• Create two pointers, one at the start and one at the end of the array

• Swap the elements at the two pointers and move them towards the center until they meet

• Repeat the process until the entire list is reversed

End to end project implementation involves taking a project from conception to completion, including planning, development, testing, and deployment.

• Define project goals and requirements

• Design data pipelines and architecture

• Develop and implement data processing algorithms

• Test and validate data quality and accuracy

• Deploy and monitor the project in production

• Iterate and improve based on feedback

UiPath Assistant is a desktop application that allows users to manage and run automation processes, while UiPath Robot is the execution agent that runs the automation processes.

• UiPath Assistant is a user-friendly interface for managing automation tasks, while UiPath Robot is the actual execution engine.

• UiPath Assistant allows users to trigger automation processes, monitor their progress, and interact with them, while UiPath Robot performs the tasks as instructed.

• Orchestrator ...read more

Bots can access the same Excel file simultaneously by using file locking mechanisms and ensuring data integrity.

• Implement file locking mechanisms to prevent multiple bots from writing to the file at the same time

• Use shared access to the file with read-only permissions for bots that only need to read data

• Utilize version control systems to track changes made by different bots and resolve conflicts

• Consider using cloud-based storage solutions that support concurrent access and co...read more

Test cases are detailed steps to test a specific functionality or feature, while STLC (Software Testing Life Cycle) is the process of testing software from planning to closure.

• Test cases are written to verify if a specific functionality works as expected.

• STLC includes phases like requirement analysis, test planning, test design, test execution, and closure.

• Example: Test case for login functionality - Enter valid username and password, click login button, verify successful log...read more

Spring is a framework for building Java applications, while Spring Boot is an extension that simplifies the setup and development process.

• Spring is a comprehensive framework for building Java applications, providing features like dependency injection, aspect-oriented programming, and more.

• Spring Boot is an extension of the Spring framework that simplifies the setup and development process by providing defaults for configuration and dependencies.

• Spring Boot includes embedded s...read more

The accounting entry for rent forgiveness involves recording the forgiven amount as an expense and reducing the liability for rent payable.

• Record the forgiven rent amount as an expense in the income statement.

• Reduce the liability for rent payable in the balance sheet.

• Debit the rent expense account and credit the rent payable account.

• Ensure proper documentation and approval for the rent forgiveness.

• Consider any tax implications or reporting requirements related to the forgiven...read more

Selenium is a popular open-source automation testing tool used for web application testing.

• Selenium supports multiple programming languages like Java, Python, C#, etc.

• It can automate web browsers and simulate user interactions.

• Selenium WebDriver is the most commonly used component for writing test scripts.

• Selenium Grid allows for parallel test execution on different machines and browsers.

• Example: Selenium can be used to automate login functionality on a website.

Passion for problem-solving and interest in technology led me to choose Computer Science Engineering.

• Passion for problem-solving

• Interest in technology

• Opportunities for innovation and creativity

• High demand and job prospects in the field

Insurance is a financial product that provides protection against specific risks in exchange for payment of a premium.

• Insurance is a contract between the insurer (insurance company) and the insured (policyholder).

• Types of insurance include life insurance, health insurance, auto insurance, home insurance, and more.

• Insurance helps individuals and businesses manage risk by transferring it to the insurance company.

• Premiums are paid by the insured to the insurer in exchange for co...read more

Regression testing is the process of retesting a software application to ensure that new code changes have not adversely affected existing functionality.

• Regression testing is performed after code changes to verify that the existing features still work correctly.

• It helps in identifying any defects introduced by new code changes.

• Automated testing tools are often used for regression testing to save time and effort.

• Examples of regression testing include running test cases that co...read more

Sanity testing is a subset of regression testing that focuses on testing specific functionalities to ensure they still work after changes.

• Sanity testing is a quick and focused testing of specific functionalities to ensure they are still working after changes.

• It is usually performed after major code changes or bug fixes to ensure the core functionalities are not affected.

• Sanity testing is not exhaustive and does not cover all functionalities, but rather focuses on critical are...read more

Different terminologies of testing include unit testing, integration testing, system testing, regression testing, and acceptance testing.

• Unit testing: Testing individual components or modules of a software.

• Integration testing: Testing the interaction between different components or modules.

• System testing: Testing the entire system as a whole.

• Regression testing: Testing to ensure that new code changes do not adversely affect existing functionality.

• Acceptance testing: Testing t...read more

OOPs concepts refer to Object-Oriented Programming concepts which include inheritance, encapsulation, polymorphism, and abstraction.

• Inheritance allows a class to inherit properties and behavior from another class.

• Encapsulation refers to the bundling of data and methods that operate on the data into a single unit.

• Polymorphism allows objects to be treated as instances of their parent class.

• Abstraction hides the complex implementation details and only shows the necessary feature...read more

Triggers can be set in RPA software by defining specific conditions that will initiate an automated process.

• Identify the event or condition that will trigger the automation

• Set up the trigger in the RPA software by configuring the necessary parameters

• Test the trigger to ensure it functions correctly

• Examples: Triggering a process when a specific email is received, or when a file is uploaded to a certain folder

Insurance is a contract between an individual and an insurance company where the individual pays premiums in exchange for financial protection against potential losses.

• Insurance is a form of risk management to protect against financial loss.

• Types of insurance include health, life, auto, home, and travel insurance.

• Premiums are paid by the insured to the insurance company in exchange for coverage.

• Insurance policies outline the terms and conditions of coverage, including what is...read more

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• VLOOKUP stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the range B2:D10 and retur...read more

Design pattern is a reusable solution to a commonly occurring problem in software design.

• Design patterns help in creating efficient, scalable, and maintainable software.

• They provide a common language for developers to communicate and understand each other's code.

• Examples include Singleton, Factory, Observer, and Strategy patterns.

My next 5 years plan is to grow professionally and contribute to the success of the company.

• Acquire new skills and knowledge through training and development programs

• Take on more responsibilities and lead projects

• Collaborate with colleagues to achieve common goals

• Contribute to the growth and profitability of the company

• Build a strong network of professional contacts

Spring is a lightweight framework for building Java applications.

• Provides comprehensive infrastructure support for developing Java applications

• Promotes good design practices such as dependency injection and aspect-oriented programming

• Facilitates easier integration with other frameworks and libraries

• Includes modules like Spring Core, Spring MVC, Spring Security, etc.

• Example: Inversion of Control (IoC) container in Spring manages the creation and configuration of objects