Litmus7 Systems Consulting Senior Engineer Interview Questions and Answers

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
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

Leetcode easy level questions

Q1. Eliminate subsequent repetitions in a string
Ans. 
Remove subsequent repetitions in a string
• Iterate through the string and compare each character with the next one

• If they are the same, remove the repetition by shifting the characters to the left

• Repeat this process until all repetitions are eliminated
Answered by AI
Add your answer

Q1. Behavioral questions asked by Delivery Manager
Add your answer

Q1. Behavioral round and past experience
Add your answer

Q1. Design a URL shortener
Ans. 
A URL shortener is a tool that takes a long URL and generates a shorter, more manageable link.
• Generate a unique short code for each long URL

• Store the mapping between short code and long URL in a database

• Redirect users from short URL to original long URL when accessed
Answered by AI
Add your answer
Q2. Write unit test for a sevice class
Ans. 
Unit test for a service class
• Create a test class for the service class

• Mock any dependencies of the service class

• Write test methods to cover different scenarios

• Use assertions to verify the expected outcomes
Answered by AI
Add your answer

There was a coding round and out of 75 students 28 got selected for next round

Q1. Total on resume and basic coding questions like write code for different sorting algorithms.
Add your answer
Q2. Explain your project in detail and asking cross questions regarding project.
Add your answer

Q1. I was rejected in round 2.
Add your answer

Q1. Go Lang related questions
Add your answer
Q2. System architecture
Add your answer

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

30 mins Aptitude Question

30 mins - 3 Coding Question

Q1. Describe Rest API
Ans. 
Rest API is a set of rules and conventions for building and interacting with web services using HTTP methods.
• Rest API stands for Representational State Transfer Application Programming Interface.

• It uses standard HTTP methods like GET, POST, PUT, DELETE to perform CRUD operations.

• RESTful APIs use URLs to access resources, and return data in JSON or XML format.

• Stateless communication allows for scalability and flexibilit...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

60min of aptitude and coding test

2 questions on coding test