Avertra Corp SAP Abap Technical Consultant Interview Questions and Answers

Q1. Explain roles and responsinbilities?
Ans. 
Consultants provide expert advice, analysis, and solutions to help organizations improve performance and achieve goals.
• Conduct thorough research and analysis to understand client needs and challenges.

• Develop strategic plans and recommendations based on findings; for example, a marketing consultant may suggest new branding strategies.

• Facilitate workshops and meetings to gather insights and foster collaboration among sta...read more
Answered by AI
Add your answer
Q2. On which technologies u have worked?
Ans. 
I have worked with various technologies including cloud computing, data analytics, and machine learning to drive business solutions.
• Cloud Computing: Experience with AWS and Azure for deploying scalable applications.

• Data Analytics: Utilized tools like Tableau and Power BI for data visualization and reporting.

• Machine Learning: Developed predictive models using Python and libraries like scikit-learn.

• Web Development: Worke...read more
Answered by AI
Add your answer

It was given some job descriptions and asked to write boolean search for it.

Q1. Salary discussion and hr discussion
Add your answer

Q1. Some basic SQL based questions and PySpark questions
Add your answer
Q2. Coalesce and partition in PySpark
Ans. 
Coalesce reduces the number of partitions in a DataFrame, while repartition increases the number of partitions.
• Coalesce is used to reduce the number of partitions in a DataFrame without shuffling the data

• Repartition is used to increase the number of partitions in a DataFrame and can involve shuffling the data

• Coalesce is more efficient than repartition when reducing partitions as it avoids shuffling
Answered by AI
Add your answer
Q3. Puzzles of get 4 litter of water using 3 litter and 5 litter flask. Famous online puzzle
Add your answer

Q1. Was an good interview which happened around one and half an hour
Add your answer

Q1. Why do you think you would be a good fit at our company
Add your answer
Q2. Lets say your boss is asking you to lie for the benefit of the company will you do it
Add your answer

Q1. Difference between functions and stored procedure in SQL.
Ans. 
Functions return a single value while stored procedures can perform multiple operations and return multiple values.
• Functions return a single value while stored procedures can return multiple values.

• Functions are used for computations and return values, while stored procedures are used for executing a series of statements.

• Functions can be called from within SQL statements, while stored procedures are called using the EX...read more
Answered by AI
Add your answer
Q2. Difference between abstract class and Interface in C#
Ans. 
Abstract class can have implementation details, while interface only contains method signatures.
• Abstract class can have constructors, fields, and methods with implementation details, while interface can only have method signatures.

• A class can inherit from only one abstract class, but can implement multiple interfaces.

• Abstract classes are used when some common functionality needs to be shared among multiple classes, whi...read more
Answered by AI
Add your answer