Crest Data Systems Senior Software Engineer Interview Questions and Answers

Q1. What is sql server agent why can't we create objects of abstract class write extension method for abstract class SQL: SP vs Function, which one is faster, why? can I call SP from Function Microservice orch...read more
Ans. 
SQL Server Agent is a job scheduling tool in SQL Server. Abstract classes cannot be instantiated. SPs are faster than functions. Microservice concepts. IEnumerable vs IQueryable.
• SQL Server Agent is a job scheduling tool in SQL Server for automating tasks like backups, database maintenance, etc.

• Abstract classes cannot be instantiated because they are incomplete and meant to be extended by subclasses.

• Extension methods ca...read more
Answered by AI
Add your answer

Q1. What is record in c# write generic method to perform summation of 2 numeric type variable (int, double, float..) write test cases for Sum method which design pattern you used
Ans. 
A record in C# is a data structure that stores a fixed number of fields of different data types.
• A record in C# is similar to a struct in C++, containing fields to store data.

• Example: 'public record Person { public string Name; public int Age; }'

• Generic method for summation: 'public T Sum(T a, T b) where T : struct, IConvertible { return Convert.ToDouble(a) + Convert.ToDouble(b); }'

• Test cases can include checking the su...read more
Answered by AI
Add your answer
Q2. This was the worst interview I have ever given. Interview got rescheduled 3 times. The panelist behaved so rudely, Why people wouldn't even care to show his face, it's literally very frustrating.
Add your answer

Q1. There were multiple questions on azure cloud and projects i worked on
Add your answer
Q2. Sql queries and scenario based azure questions
Add your answer

Q1. Machine coding -- design and implement splitwise -- duration 1.5hr
Add your answer
Q2. Basic implemetation of split-wise
Ans. 
Split-wise is a basic implementation to divide expenses among a group of people.
• Create a function that takes in an array of expenses and participants

• Calculate the total expense and divide it equally among participants

• Return a list of strings showing who owes how much to whom
Answered by AI
Add your answer

Q1. Low and high level design of BookMyShow
Ans. 
BookMyShow is a platform for booking movie tickets, event tickets, and other entertainment activities.
• Low level design: Database schema for storing user information, ticket details, show timings, etc.

• High level design: System architecture including front-end, back-end, and database components.

• Example: Use of microservices for scalability and fault tolerance.

• Example: Integration with payment gateways for seamless transa
Answered by AI
Add your answer

Q1. Functional Interface,java 8 features,predicate functions
Add your answer

Q1. General question & scenario based questions
Add your answer

Q1. Mostly on OOP's basic and some tricky questions related SOLID concepts
Add your answer

Q1. .net core middleware
Add your answer

Q1. Manament discusion about your last project and responsibility
Add your answer

Q1. Salary discusion and designation and preferred loaction
Add your answer

Q1. Mostly asked java springboot questions
Add your answer
Q2. What is interceptor
Ans. 
An interceptor is a middleware component that intercepts incoming and outgoing HTTP requests in an application.
• Interceptors can be used for logging, authentication, error handling, and modifying requests/responses.

• In Angular, interceptors can be used to add headers to HTTP requests or handle errors globally.

• In Spring framework, interceptors can be used for pre-processing and post-processing of requests.

• Interceptors are...read more
Answered by AI
Add your answer
Q3. What are all functional interfaces available in java
Ans. 
Functional interfaces in Java are interfaces with a single abstract method, used for lambda expressions and method references.
• Functional interfaces can be found in the java.util.function package.

• Examples of functional interfaces include Consumer, Supplier, Predicate, and Function.

• Functional interfaces can be identified by the @FunctionalInterface annotation.
Answered by AI
Add your answer
Q4. Gatway implementation in spring boot
Ans. 
Gateway implementation in Spring Boot allows for routing and filtering of incoming requests to different microservices.
• Use Spring Cloud Gateway for implementing gateway in Spring Boot

• Define routes and filters in application.properties or application.yml

• Example: routes: - id: my_route uri: http://localhost:8080 predicates: - Path=/my_route/**

• Example: filters: - AddRequestHeader=X-Request-Foo, Bar
Answered by AI
Add your answer
Q5. Java 8 coding questions
Add your answer

Q1. Frontend angular and javascript questions
Add your answer
Q2. Life cycle hook Components Model Lazy loading Pipe Observable Promise
Add your answer

Basic programming questions, like find the occurrence of the characters in a string

Q1. Salary discussion and some project related questions
Add your answer