NaviSite Consultant Interview Questions and Answers

2 hour test and it was easy

Topic The best day in your life

Q1. Synthetic events in react
Ans. 
Synthetic events in React are custom events created by developers to handle specific interactions.
• Synthetic events are created using the SyntheticEvent object provided by React.

• Developers can use synthetic events to handle user interactions like clicks, key presses, etc.

• Synthetic events have the same interface as native browser events but are normalized across different browsers.
Answered by AI
Add your answer
Q2. How do you create forms in react?
Ans. 
Forms in React can be created using controlled components, state management, and event handling.
• Use controlled components to manage form data through state

• Handle form submission using event handlers like onSubmit

• Utilize form elements like input, textarea, and select to collect user input
Answered by AI
Add your answer

Create a simple react web app using npm

Q1. Why do you want to work with us?
Ans. 
I am drawn to your company's reputation for innovative solutions and collaborative work environment.
• Impressed by company's track record of successful projects

• Excited about the opportunity to work with a talented team

• Interested in contributing to cutting-edge solutions

• Appreciate the focus on collaboration and teamwork
Answered by AI
Add your answer
Q2. Where do you see yourselves in next 5 years
Ans. 
In the next 5 years, I see myself advancing in my career as a consultant, taking on more challenging projects and expanding my expertise.
• Continuing to build strong relationships with clients and colleagues

• Seeking opportunities for professional development and training

• Exploring new industries and sectors to broaden my experience

• Working towards leadership roles within the consulting firm
Answered by AI
Add your answer

Basic aptitude which is based on computer science skills

Q1. Basic coding questions
Add your answer

Asked to write Selenium code to launch flipkart and handle the popup that shows up and asked to write code to reverse an entire string later asked reverse each word in that string without reversing the relative order of that string

Q1. What is bapi, and all bapis are rfcs?
Ans. 
BAPI stands for Business Application Programming Interface. All BAPIs are RFCs.
• BAPIs are standard interfaces provided by SAP to access business processes and data.

• They are used to integrate SAP with other systems.

• BAPIs are RFC-enabled function modules.

• They are used to create, read, update, and delete data in SAP.

• Examples of BAPIs include BAPI_MATERIAL_GET_DETAIL, BAPI_SALESORDER_CREATEFROMDAT2, etc.
Answered by AI
Add your answer
Q2. What is rfc, and all rfcc are bapis?
Ans. 
RFC is a remote function call protocol used to communicate between SAP systems. Not all RFCs are BAPIs.
• RFC stands for Remote Function Call and is a protocol used to enable communication between SAP systems.

• BAPI stands for Business Application Programming Interface and is a set of standard interfaces provided by SAP for accessing its business objects.

• Not all RFCs are BAPIs, but all BAPIs are RFCs.

• RFCs can be used to cal...read more
Answered by AI
Add your answer

It was a 30 minutes round questions on Python, SQL, Pyspark - scenario based question to write the code.

Q1. Here you will be asked few theoretical question like defination, where to use, what is the advantage etc. - Focused on Azure (ADF,ADLS,Synapse), SQL, Pyspark,python
Add your answer
Q2. SQL Optimization
Add your answer
Q3. Dynamic file ingestion in ADF
Ans. 
Dynamic file ingestion in ADF involves using parameters to dynamically load files into Azure Data Factory.
• Use parameters to specify the file path and name dynamically

• Utilize expressions to dynamically generate file paths

• Implement dynamic mapping data flows to handle different file structures
Answered by AI
Add your answer
Q4. Agregation in databricks
Ans. 
Aggregation in Databricks refers to the process of combining and summarizing data in a Spark environment.
• Aggregation functions like sum, count, avg, min, max can be used in Databricks to summarize data.

• Grouping data based on certain columns and then applying aggregation functions is a common practice.

• Aggregation can be performed on large datasets efficiently using Databricks' distributed computing capabilities.
Answered by AI
Add your answer

Q1. It would be basic HR round to understand your expectation and expertise.
Add your answer

A VM was provided with an already applied project with bugs, incorrect implementation of requirement, partial unit test.

They take people in parallel. This works as initial screening round.

Q1. Basic C#, .Net, .Net Core questions
Add your answer
Q2. Architecture questions on how to proceed with an app design.
Add your answer
Q3. SQL procedure function transactions indexes
Add your answer

Q1. Similar from the tech round 1. But more in-depth and including front end technology stack and azure
Add your answer

Q1. Technical Manager review and discussion. Adaptability, handling questions, over view discussions
Add your answer