Microsense Desktop Support Engineer Interview Questions and Answers

Q1. Details about your working projects and technology
Add your answer
Q2. Routing and switching realted scenario Q&A
Add your answer
Q3. BGP attributes,States and loop mechanism
Add your answer
Q4. What exactly do you mean by a route reflector in the context of Border Gateway Protocol? Why is it necessary?
Ans. 
A route reflector in BGP is a device that helps reduce the number of BGP peerings required in a network by reflecting routes to other routers.
• Route reflectors help reduce the number of BGP peerings required in a network by allowing a router to reflect routes to other routers without the need for a full mesh of peerings.

• They are necessary in large networks with many routers to reduce the complexity and resource usage of...read more
Answered by AI
Add your answer

Q1. Based upon profile which you got selected
Add your answer

Q1. 30min technical round
Add your answer
Q2. Project manager round
Add your answer
Q3. HR round for salary discussion
Add your answer

Round duration - 135 minutes
Round difficulty - Medium

The test window was open from 2:00 p.m. to 05:30 PM IST on 28th of August 2020.We were also given a chance to take a practice test to know about working of the platform .It was a Proctored Assessment .The test platform was HackerEarth and there were around 28 MCQs, 1 programming question, and 2 SQL queries. MCQs majorly focused on OS, DBMS, C++, OOPS concepts.

Q1. 
Find All Pairs Adding Up to Target
Given an array of integers ARR of length N and an integer Target, your task is to return all pairs of elements such that they add up to the Target.
Input:
The first line ...read more
Ans. 
Find all pairs of elements in an array that add up to a given target.
• Iterate through the array and use a hashmap to store the difference between the target and current element.

• Check if the current element exists in the hashmap, if so, print the pair.

• If no pair is found, print (-1, -1).
Answered by AI
Add your answer

Round duration - 50 minutes
Round difficulty - Medium

It was basically a technical interview. It was conducted around 11:00 a.m. on 31st august 2020. There was only 1 person who was interviewing me though I expected a panel. It started off by the question regarding our college and infrastructure of it and what do I like the most about it etc. Later continued by few technical subjective questions and a code along with a basic query. Technical questions regarding data structures like linked list, Array List , HashMap were asked along with concepts like backtracking were also covered. More about technologies related to projects that I have done were asked which is machine learning. the ratings i earned in online judges were also asked about.

Q1. 
Sudoku Solver
Given a 9x9 Sudoku board, your task is to fill the empty slots and return the completed Sudoku solution.
A Sudoku is a grid composed of nine 3x3 smaller grids. The challenge is to fill in the...read more
Ans. 
Implement a Sudoku solver to fill empty slots in a 9x9 grid with numbers 1-9 satisfying constraints.
• Create a recursive function to solve the Sudoku puzzle by trying out different numbers in empty slots.

• Use backtracking to backtrack and try a different number if a conflict is encountered.

• Ensure each number appears only once per row, column, and 3x3 grid.

• Return the completed Sudoku grid as the output.
Answered by AI
Add your answer
Q2. 
Cycle Detection in a Singly Linked List
Determine if a given singly linked list of integers forms a cycle or not.
A cycle in a linked list occurs when a node's next points back to a previous node in the ...read more
Ans. 
Detect if a singly linked list forms a cycle by checking if a node's next points back to a previous node.
• Traverse the linked list using two pointers, one moving one step at a time and the other moving two steps at a time.

• If the two pointers meet at any point, it indicates the presence of a cycle in the linked list.

• If one of the pointers reaches the end of the list (null), it means there is no cycle in the linked list.
Answered by AI
Add your answer

Round duration - 40 minutes
Round difficulty - Medium

It is more of a Managerial round. This was not confined to any topic or a subject .It took place around 4:15 p.m. on 31st of August ,2020. 
 

Q1. Asked questions about past experience and skills
Add your answer

Build small project on site

Q1. Behavioral questions
Add your answer

Q1. How to tune synapse tables
Ans. 
Synapse tables can be tuned by optimizing query performance and adjusting table properties.
• Identify frequently used queries and optimize them for better performance

• Adjust table properties such as partitioning, indexing, and compression

• Regularly monitor and analyze table performance to identify areas for improvement

• Consider using caching mechanisms to reduce query times

• Collaborate with database administrators and other ...read more
Answered by AI
Add your answer
Q2. How to tune slow reports
Ans. 
Slow reports can be tuned by optimizing queries, indexing tables, and reducing data retrieval.
• Identify the slowest queries and optimize them

• Index the tables to improve query performance

• Reduce the amount of data retrieved by filtering or aggregating

• Consider caching frequently accessed data

• Use query profiling tools to identify bottlenecks

• Upgrade hardware or database software if necessary
Answered by AI
Add your answer

Q1. Languages attended
Add your answer

30 mins Aptitude Question

30 mins - 3 Coding Question

Q1. Describe Rest API
Ans. 
REST API is an architectural style for designing networked applications using HTTP requests to access and manipulate data.
• REST stands for Representational State Transfer.

• It uses standard HTTP methods: GET (retrieve), POST (create), PUT (update), DELETE (remove).

• Resources are identified by URIs (Uniform Resource Identifiers).

• Data is typically exchanged in JSON or XML format.

• Example: A GET request to '/users' retrieves a...read more
Answered by AI
Add your answer
Q2. What is various Response code. Diffenrence b/w 200 & 201, 400 & 403
Ans. 
Response codes indicate the status of a HTTP request. 200 & 201 are success codes, while 400 & 403 are client error codes.
• 200 - OK: Request was successful

• 201 - Created: Request was successful and a new resource was created

• 400 - Bad Request: The server cannot process the request due to a client error

• 403 - Forbidden: The server understood the request, but refuses to authorize it
Answered by AI
Add your answer

Coding test are just basic Array and linkedList question

Q1. Explain 4 pillar of oops
Add your answer
Q2. Internal working of Hashmap
Add your answer
Q3. Crud operation implementation
Add your answer

Q1. Why are you chaning the organisation?
Add your answer