10+ LSG Sky Chefs Interview Questions and Answers

I would first analyze the requirements and then design the database accordingly.

• Understand the data and its relationships

• Identify the entities and their attributes

• Normalize the data to reduce redundancy

• Choose appropriate data types and constraints

• Consider scalability and performance

• Ensure data integrity and security

Automation logs are kept in a centralized location with detailed information on test cases and results.

• Automation logs are stored in a centralized location for easy access and analysis.

• Logs include detailed information on test cases, such as test name, status, and duration.

• Logs also include information on the environment and system under test.

• Logs are organized by date and time for easy tracking of changes and issues.

• Logs are regularly reviewed and analyzed to identify areas ...read more

Pega Openspan supports database commands and connection string.

• Database commands can be executed using the OLEDB connector in Pega Openspan.

• Connection string can be defined in the configuration of the OLEDB connector.

• Examples of database commands include SELECT, INSERT, UPDATE, and DELETE.

• Connection string includes details such as server name, database name, and authentication mode.

Wait all waits for all tasks to complete while wait any waits for any one task to complete.

• Wait all is used when all tasks need to be completed before proceeding.

• Wait any is used when any one task can complete before proceeding.

• Wait all returns when all tasks complete while wait any returns when any one task completes.

• Wait all can cause longer wait times if one task takes longer while wait any can be faster if one task completes quickly.

Text adapters are used in Pega Robotics to interact with text-based applications.

• Text adapters can be used to read and write text from/to text-based applications.

• They can be configured to recognize specific text patterns and respond accordingly.

• Examples of text-based applications include command prompt, terminal, and text editors.

• Text adapters can also be used in conjunction with other adapters, such as web adapters, to automate end-to-end processes.

Code review involves examining code for errors, security vulnerabilities, and adherence to coding standards.

• Start by understanding the requirements and design of the code.

• Check for syntax errors, logic errors, and security vulnerabilities.

• Ensure the code adheres to coding standards and best practices.

• Provide constructive feedback to the developer.

• Use code review tools to automate the process and save time.

• Collaborate with the development team to ensure code quality.

• Perform co...read more

Pega Openspan supports Excel connectors for data manipulation.

• Excel connectors can be used to read, write, and manipulate data in Excel spreadsheets.

• Pega Openspan provides pre-built Excel connectors that can be easily integrated into automation projects.

• Excel connectors can be configured to perform various actions such as filtering data, sorting data, and formatting cells.

• Excel connectors can also be used to extract data from other sources such as databases and web services a...read more

Pega Openspan uses Log4Net for logging mechanism.

• Log4Net is a third-party logging framework used by Pega Openspan.

• It allows for logging at different levels of severity such as debug, info, warn, error, and fatal.

• Logs can be written to different outputs such as console, file, database, or email.

• Logging can be configured using the Log4Net configuration file.

• Example: log.Debug("Debug message");

Coding standard and project structure are crucial for efficient development and maintenance.

• Coding standard should be consistent and easy to understand for all team members.

• Project structure should be organized and modular to allow for scalability and easy maintenance.

• Use of version control and automated testing can help ensure adherence to coding standards and project structure.

• Examples of coding standards include naming conventions, commenting practices, and formatting guid...read more