Incessant Technologies Interview Questions and Answers

Q1. What are the different sizes available for a virtual warehouse in Snowflake, and which sizes are currently being utilized in your current project?
Add your answer
Q2. What are stored procedures in Snowflake, and how did you utilize them?
Add your answer

Q1. How did you verify the data after transferring it from one database to another?
Add your answer
Q2. What are the different types of duplicate checks that can be performed using SQL queries?
Add your answer

Q1. Are you open to relocating to Hyderabad?
Add your answer
Q2. What information do you have about ValueLabs?
Add your answer

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
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) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

It's walkin, so they conducted 1 technical mcqs round.

Q1. Multi threading
Add your answer
Q2. Internal working of hashmap
Ans. 
HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on keys.
• HashMap uses an array of buckets to store key-value pairs.

• Keys are hashed to determine the index in the array where the key-value pair will be stored.

• In case of hash collisions, a linked list or a balanced tree is used to store multiple key-value pairs in the same bucket.

• HashMap allows null keys...read more
Answered by AI
Add your answer
Q3. Spring batch related
Add your answer
Q4. Non repeating characters in a array
Ans. 
Function to find and return all non-repeating characters in an array of strings.
• Iterate through the array and count the occurrences of each character using a HashMap.

• Then iterate through the array again and check if the count of each character is 1, if so add it to the result list.

• Return the list of non-repeating characters.
Answered by AI
Add your answer
Q5. 3rd highest salary
Ans. 
To find the 3rd highest salary in a database, we can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
• Use a SQL query with 'ORDER BY salary DESC' to sort the salaries in descending order.

• Use 'LIMIT 1 OFFSET 2' to skip the first two highest salaries and retrieve the third highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
Answered by AI
Add your answer
Q6. Qualifier vs primary
Ans. 
A qualifier in Java is used to specify additional information about a primary, which is the main data type or variable.
• A primary in Java is the main data type or variable, while a qualifier provides additional information about the primary.

• Qualifiers can be used to modify the behavior or characteristics of a primary.

• For example, in Java, 'final' is a qualifier that can be used to make a variable constant.
Answered by AI
Add your answer
Q7. Controller vs restcontroller
Ans. 
The main difference is that @RestController is a specialized version of @Controller that is used for RESTful web services.
• Both @Controller and @RestController are used in Spring MVC to handle HTTP requests, but @RestController is specifically used for RESTful web services.

• @Controller is used to create web pages, while @RestController is used to return data in JSON or XML format.

• @RestController is a convenience annotati...read more
Answered by AI
Add your answer
Q8. Spring boot annotataions
Add your answer
Q9. Oops concepts with examples
Ans. 
OOP concepts include inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class. Example: class Dog extends Animal.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables with public getter and setter methods.

• Polymorphism: Ability for objects to be treated as instances of their paren...read more
Answered by AI
Add your answer
Q10. Spring batch configuration
Add your answer
Q11. They covered all java, spring and Microservices
Add your answer

Q1. Microservices architecture
Add your answer
Q2. How do Microservices communicate
Ans. 
Microservices communicate with each other through various communication protocols like HTTP, messaging queues, and gRPC.
• Microservices can communicate over HTTP using RESTful APIs.

• Messaging queues like RabbitMQ or Kafka can be used for asynchronous communication between microservices.

• gRPC is a high-performance, open-source RPC framework that can be used for communication between microservices.

• Service discovery mechanism...read more
Answered by AI
Add your answer
Q3. How to access the Microservice end point
Ans. 
Microservice endpoints can be accessed using HTTP requests with the appropriate URL
• Use HTTP methods like GET, POST, PUT, DELETE to interact with the microservice

• Construct the URL with the base URL of the microservice and the specific endpoint path

• Include any necessary headers or parameters in the request for authentication or data filtering
Answered by AI
Add your answer
Q4. Why we use microservices
Ans. 
Microservices allow for modular, scalable, and flexible software development by breaking down applications into smaller, independent services.
• Microservices enable easier maintenance and updates as each service can be developed, deployed, and scaled independently.

• They improve fault isolation, as failures in one service do not necessarily affect the entire application.

• Microservices promote agility and faster time-to-mark...read more
Answered by AI
Add your answer

Q1. What is the potential of artificial intelligence (AI)?
Add your answer
Q2. What is advanced Excel?
Add your answer
Q3. What is the Hardwear Installation
Add your answer
Q4. What is the software installation process
Add your answer
Q5. Different between Software and Hardware
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What is derivative and its type
Add your answer
Q3. What is margin
Add your answer

English speaking test , one minute talk on particular topic , english grammar, typing test , reasoning and quants little

Q1. What is derivative and its type
Add your answer
Q2. What is reconciliation
Add your answer
Q3. Behavioral based questions
Add your answer

Q1. What are the reasons for using the Border Gateway Protocol (BGP)?
Ans. 
BGP is used for routing and exchanging routing information between different autonomous systems.
• BGP allows for dynamic routing between different autonomous systems

• It provides redundancy and load balancing by choosing the best path for data traffic

• BGP helps in preventing network loops and ensuring efficient data routing

• It is commonly used by Internet Service Providers (ISPs) to exchange routing information

• BGP is essenti...read more
Answered by AI
Add your answer
Q2. What is a switch stack?
Ans. 
A switch stack is a group of network switches that are interconnected and operate as a single unit.
• Switch stack simplifies network management by allowing multiple switches to be managed as one entity.

• It provides high availability and redundancy by allowing one switch to take over if another fails.

• Switch stack can also increase network performance by load balancing traffic across multiple switches.

• Examples of switch sta...read more
Answered by AI
Add your answer
Q3. What are the configurations required in wireless networking?
Ans. 
Configurations required in wireless networking include SSID, security settings, encryption type, and channel selection.
• Set up a unique SSID to identify the network

• Choose appropriate security settings such as WPA2-PSK

• Select encryption type like AES for secure data transmission

• Optimize channel selection to avoid interference
Answered by AI
Add your answer
Q4. What are the different types of VPNs?
Ans. 
Different types of VPNs include remote access VPN, site-to-site VPN, and client-to-site VPN.
• Remote access VPN allows individual users to connect to a private network remotely.

• Site-to-site VPN connects multiple networks together over the internet.

• Client-to-site VPN allows individual devices to connect to a private network remotely.

• Other types include MPLS VPN, SSL VPN, and IPsec VPN.
Answered by AI
Add your answer
Q5. What is the purpose of native VLAN?
Ans. 
The purpose of native VLAN is to carry untagged traffic across a trunk link.
• Native VLAN is used for untagged traffic on a trunk link

• It allows devices that do not support VLAN tagging to communicate over the trunk link

• Native VLAN should be the same on both ends of the trunk link to avoid VLAN hopping attacks
Answered by AI
Add your answer

10 min, simple question on programming skills

Q1. Which Microservice communication pattern you have used?
Ans. 
I have used the asynchronous messaging pattern for Microservice communication.
• Implemented messaging queues like RabbitMQ or Kafka for decoupled communication

• Used message brokers to enable communication between Microservices

• Leveraged event-driven architecture for real-time updates and scalability
Answered by AI
Add your answer
Q2. Which Application Insight tool you have used?
Ans. 
I have used Application Insights for monitoring and analyzing the performance of .NET applications.
• Used Application Insights to track application performance metrics

• Analyzed telemetry data to identify performance bottlenecks

• Set up alerts and notifications for critical issues

• Integrated Application Insights with Azure DevOps for continuous monitoring
Answered by AI
Add your answer
Q3. Caching Technique is used in your project
Ans. 
We use in-memory caching technique in our project to improve performance and reduce database load.
• In-memory caching is used to store frequently accessed data in memory for quick retrieval

• Helps reduce database load and improve application performance

• Examples: using MemoryCache in .NET, Redis caching, caching frequently accessed data like user profiles or product information
Answered by AI
Add your answer
Q4. Api Gateways is used in MicrosServices
Ans. 
Yes, API Gateways are used in Microservices to manage and secure communication between services.
• API Gateways act as a single entry point for clients to access multiple microservices

• They handle authentication, authorization, rate limiting, logging, and monitoring

• Examples of API Gateways include Kong, Apigee, and AWS API Gateway
Answered by AI
Add your answer
Q5. Which single sign on technology/Mechanism is used in project
Ans. 
We are using OAuth 2.0 for single sign on in the project.
• OAuth 2.0 is a widely used authorization framework that enables a third-party application to obtain limited access to an HTTP service.

• It allows users to log in once and access multiple applications without having to log in again.

• OAuth 2.0 provides secure delegated access to resources without sharing user credentials.
Answered by AI
Add your answer
Q6. What is JWT token,why we use it
Ans. 
JWT token is a JSON Web Token used for secure transmission of information between parties.
• JWT token is a compact and self-contained way to transmit information between parties.

• It is digitally signed to verify its authenticity and integrity.

• JWT tokens consist of three parts: header, payload, and signature.

• They are commonly used for authentication and information exchange in web applications.

• Example: JWT tokens are often
Answered by AI
Add your answer
Q7. How to implement exception handling and filters in .net core web api
Ans. 
Exception handling and filters in .NET Core Web API
• Use try-catch blocks to handle exceptions in the code

• Implement global exception handling middleware to catch unhandled exceptions

• Use filters like [Authorize] for authentication and [ValidateAntiForgeryToken] for CSRF protection

• Create custom exception filters by implementing IExceptionFilter interface
Answered by AI
Add your answer