Axxela Advisory Services LLP Consultant Interview Questions and Answers

Q1. Questions on Tableau
Add your answer
Q2. Questions on SQL
Add your answer
Q3. Questions on Python
Add your answer

Q1. About the recent projects
Add your answer
Q2. Questions on Alteryx
Add your answer

Q1. Tell me about yourself.
Ans. 
I am a highly experienced consultant with a strong background in problem-solving and strategic planning.
• Over 10 years of experience in consulting roles

• Expertise in developing and implementing effective strategies

• Proven track record of delivering successful projects

• Strong analytical and problem-solving skills

• Excellent communication and interpersonal skills

• Ability to work well in cross-functional teams

• Experience in vario...read more
Answered by AI
Add your answer
Q2. Job description, daily routine,
Add your answer

Three sections (minimum two to be completed)-Aptitude, Case Solving and Machine Learning.

What do you know about Amex?

First case - you have data about the users of IRCTC app - login time, usage time, clicks, services, demographics etc.

IRCTC wants to launch air tickets booking service on the app and for this they will first show a pop up advertisement to inform their existing users about this service. Tell the parameters or criteria's to clean the data to come up with the target group to whom they will show this ad and are guaranteed to use this new service.

You have mentioned photography as your hobby. I know there is already a photography club in the campus but suppose you want to come up with a new but niche club only for select users who have high experience.

Suppose you have a genie, who can get you any database from any source which could be of help to you. With those data points overlapping over one another, you will eventually come up with a new data of users who are most likely to join your club. Tell me from what sort and type of data you will ask him to fetch and why? What information are you exactly searching for through those?

Q1. You're from Faridabad? So I want you to tell me the number of autorickshaws running in Faridabad in a day.
Add your answer
Q2. So now you have come up with the supply of autorickshaws. Now tell me what is the actual demand of these autorickshaws and see if the number is matching with supply or not. Had it been a different product,...read more
Ans. 
To determine if supply of autorickshaws matches demand, we need to conduct market research and analyze data. Approach for a different product would depend on the nature of the product.
• Conduct market research to determine the demand for autorickshaws

• Analyze data to compare demand with supply

• If demand is higher than supply, increase production or import more autorickshaws

• If demand is lower than supply, decrease productio...read more
Answered by AI
View 1 more answer

Q1. Tell me about you
Add your answer
Q2. Tell me about yourself
Add your answer

Q1. CompletableFuture VS Future
Ans. 
CompletableFuture is an enhanced version of Future in Java that provides more flexibility and functionality.
• CompletableFuture is part of the Java 8 concurrency framework.

• It allows chaining of multiple asynchronous operations.

• CompletableFuture can be explicitly completed or cancelled.

• It supports callbacks and combinators for handling completion.

• Future is a basic interface for representing the result of an asynchronous c...read more
Answered by AI
Add your answer
Q2. ConcurrentHashmap
Add your answer
Q3. Composition Vs inheritance
Ans. 
Composition is a design principle where objects are composed of other objects, while inheritance is a mechanism where objects inherit properties and behaviors from a parent object.
• Composition promotes code reusability and flexibility by allowing objects to be composed of other objects.

• Inheritance allows objects to inherit properties and behaviors from a parent object, promoting code reuse.

• Composition is more flexible t...read more
Answered by AI
Add your answer
Q4. Spring boot, microservices, Design patterns
Add your answer

Q1. Parallel Calls in java
Ans. 
Parallel calls in Java allow multiple tasks to be executed simultaneously, improving performance.
• Parallel calls can be achieved using threads or the Executor framework.

• Threads allow concurrent execution of tasks, but require manual management of synchronization and resource sharing.

• The Executor framework provides higher-level abstractions for managing parallel tasks, such as thread pools and task scheduling.

• Example: us...read more
Answered by AI
Add your answer
Q2. Lock Vs Sync Block
Ans. 
Lock and Sync Block are mechanisms used for thread synchronization in multi-threaded programming.
• Lock is a low-level synchronization mechanism that provides exclusive access to a shared resource.

• Sync Block is a higher-level synchronization mechanism that allows multiple threads to access a shared resource concurrently.

• Lock is more flexible and can be used in various scenarios, but it requires explicit acquisition and r...read more
Answered by AI
Add your answer
Q3. Hsshmap internal working , Checked Exception
Add your answer

Q1. Tell me something about yourself.
Add your answer
Q2. What is current job responsibilities ?
Add your answer
Q3. Can you help me all OSI layers ?
Ans. 
The OSI (Open Systems Interconnection) model consists of 7 layers that define the functions of a network.
• Physical layer - deals with physical connections and signals (e.g. Ethernet cables)

• Data link layer - responsible for node-to-node communication (e.g. MAC addresses)

• Network layer - handles routing and forwarding of data packets (e.g. IP addresses)

• Transport layer - ensures end-to-end communication (e.g. TCP/UDP)

• Sessio...read more
Answered by AI
Add your answer
Q4. What are the private IP address ranges ?
Ans. 
Private IP address ranges are reserved for use within private networks and are not routable on the public internet.
• Private IP address ranges include 10.0.0.0 to 10.255.255.255, 172.16.0.0 to 172.31.255.255, and 192.168.0.0 to 192.168.255.255

• These addresses are commonly used in home, office, and corporate networks to allow devices to communicate with each other within the same network

• Private IP addresses are not unique ...read more
Answered by AI
Add your answer
Q5. What is RFC 1918 ?
Ans. 
RFC 1918 refers to a set of IP address ranges reserved for private networks.
• RFC 1918 defines three blocks of IP addresses that are reserved for private networks: 10.0.0.0 - 10.255.255.255, 172.16.0.0 - 172.31.255.255, and 192.168.0.0 - 192.168.255.255

• These private IP addresses are not routable on the public internet and are commonly used within organizations for internal networks

• Using RFC 1918 addresses helps prevent c...read more
Answered by AI
Add your answer
Q6. What is OSPF and how it is differ from EIGRP ?
Ans. 
OSPF is a link-state routing protocol while EIGRP is a distance-vector routing protocol.
• OSPF uses Dijkstra algorithm to calculate the shortest path while EIGRP uses Diffusing Update Algorithm (DUAL)

• OSPF supports VLSM and CIDR while EIGRP does not

• OSPF is an open standard protocol while EIGRP is Cisco proprietary

• OSPF has a lower administrative distance (110) compared to EIGRP (90)
Answered by AI
Add your answer
Q7. What are the types of BGP protocol ?
Ans. 
The types of BGP protocol include eBGP and iBGP.
• eBGP (External BGP) is used between different AS (Autonomous Systems)

• iBGP (Internal BGP) is used within the same AS

• eBGP is typically used for connecting to external networks, while iBGP is used for internal routing within the same network
Answered by AI
Add your answer
Q8. What is Ipsec ? What is IKE ?
Ans. 
IPsec is a protocol suite for securing Internet Protocol (IP) communications. IKE is a key management protocol used with IPsec.
• IPsec stands for Internet Protocol Security and is used to secure IP communications.

• It provides authentication, encryption, and key management for network traffic.

• IKE (Internet Key Exchange) is a key management protocol used with IPsec to establish security associations and negotiate cryptograp...read more
Answered by AI
Add your answer
Q9. What is main mode and aggressive mode ?
Ans. 
Main mode and aggressive mode are two different negotiation strategies used in business and consulting.
• Main mode is a collaborative negotiation approach where parties work together to find mutually beneficial solutions.

• Aggressive mode is a competitive negotiation approach where one party seeks to maximize their own gains at the expense of the other party.

• Main mode focuses on building relationships and trust, while aggr...read more
Answered by AI
Add your answer
Q10. What is IPSec Parameters ?
Ans. 
IPSec Parameters are settings used to configure and control the IPSec protocol for secure communication over a network.
• IPSec parameters include encryption algorithms such as AES, DES, and 3DES.

• Authentication methods like HMAC-SHA1, HMAC-MD5, and digital certificates are also part of IPSec parameters.

• Key exchange protocols such as IKEv1 and IKEv2 are used to establish secure communication channels.

• IPSec parameters also ...read more
Answered by AI
Add your answer
Q11. What is next Generation Firewall ?
Ans. 
Next Generation Firewall (NGFW) is a network security system that integrates intrusion prevention, application awareness, and other advanced features.
• NGFW combines traditional firewall capabilities with advanced security features like application control, intrusion prevention, and SSL inspection.

• It provides deeper visibility into network traffic and more granular control over applications and users.

• NGFWs can identify a...read more
Answered by AI
Add your answer
Q12. What is NAT ?
Ans. 
NAT stands for Network Address Translation, a process used to modify network address information in packet headers while in transit.
• NAT allows multiple devices on a local network to share a single public IP address.

• There are different types of NAT such as Static NAT, Dynamic NAT, and PAT (Port Address Translation).

• NAT helps improve security by hiding internal IP addresses from external networks.

• Example: A home router u...read more
Answered by AI
Add your answer
Q13. General questions about firewall.
Add your answer