Thesqua.re Assistant Manager Finance Interview Questions and Answers

Dot net is a framework for building Windows applications while Dot net core is a cross-platform framework.

• Dot net is Windows-only while Dot net core is cross-platform

• Dot net core is open-source while Dot net is not

• Dot net core is modular while Dot net is monolithic

• Dot net core has better performance and scalability

• Dot net core supports microservices architecture

ORM stands for Object-Relational Mapping. It is a technique to map database tables to classes in object-oriented programming.

• ORM allows developers to work with databases using object-oriented programming concepts.

• ORM models I have worked on include Hibernate, Entity Framework, and Sequelize.

• ORM helps to reduce the amount of boilerplate code required to interact with databases.

• ORM provides a layer of abstraction between...read more

Migration scripts help in updating the database schema when changes are made to the code first model.

• Migration scripts are used to update the database schema to match the code first model

• They help in keeping the database schema in sync with the code first model

• They are executed automatically when the application starts or manually using the Package Manager Console

• They can be used to add, modify or delete database objec...read more

Mapping in code first is done using attributes or fluent API to map classes to database tables.

• Mapping can be done using attributes like [Table], [Column], [Key], etc.

• Fluent API can be used to configure mapping in OnModelCreating method of DbContext.

• Navigation properties can be mapped using [ForeignKey] attribute or fluent API.

• Mapping can also be done for complex types and inheritance hierarchies.

• Mapping can be customi...read more

I have used multiple IOC containers including Unity, Autofac, and Ninject.

• I have used Unity for dependency injection in a .NET MVC project.

• I have used Autofac for dependency injection in a .NET Core project.

• I have used Ninject for dependency injection in a Xamarin.Forms project.

• I have also worked with Simple Injector and Castle Windsor.

Microservices architecture is a software development approach where a single application is broken down into smaller, independent services.

• Each service is responsible for a specific task or function

• Services communicate with each other through APIs

• Allows for greater flexibility, scalability, and easier maintenance

• Examples include Netflix, Amazon, and Uber

We use a continuous integration and deployment pipeline to automatically deploy code changes to our production environment.

• We use Git for version control and have a separate branch for production-ready code.

• Our CI/CD pipeline is set up using Jenkins and Docker.

• Tests are run automatically before deployment to ensure code quality.

• Deployment is triggered automatically when changes are pushed to the production branch.

• We us...read more

Pipelines are created by defining a series of steps to be executed in a specific order to process data or perform tasks.

• Define the steps to be executed in a pipeline configuration file

• Use a pipeline orchestration tool to execute the steps in the defined order

• Each step in the pipeline can be a separate program or script

• Data is passed between steps in the pipeline

• Pipelines can be used for data processing, continuous inte

One to many relationship in SQL Server

• Create a foreign key in the child table referencing the primary key in the parent table

• Use JOIN to retrieve data from both tables

• Use GROUP BY to group data by the parent table's primary key

• Use COUNT to get the number of child records for each parent record

C# 9.0 introduces new features like records, init-only setters, and top-level programs.

• Records provide a concise syntax for defining immutable types.

• Init-only setters allow for setting properties only during initialization.

• Top-level programs allow for writing simple console applications without a class or Main method.

• Improved pattern matching with logical patterns and relational patterns.

• Function pointers and improved ...read more

To make an application scalable, consider factors like load balancing, caching, database optimization, and horizontal scaling.

• Use load balancers to distribute traffic evenly across multiple servers

• Implement caching to reduce the number of requests to the server

• Optimize database queries and indexes to improve performance

• Use horizontal scaling to add more servers as needed

• Design for fault tolerance and high availability

An agreement for sale is a preliminary agreement to sell a property, while a sale deed is the final document that transfers ownership.

• An agreement for sale is a contract between the buyer and seller, outlining the terms and conditions of the sale.

• It is usually executed before the sale deed.

• The agreement for sale does not transfer ownership of the property, but it creates an obligation to sell and purchase.

• A sale deed, ...read more

Hollandaise sauce is made by emulsifying egg yolks, butter, lemon juice, and vinegar, while demi glaze is a rich brown sauce made by simmering beef bones, vegetables, and herbs.

• Hollandaise sauce is a classic French sauce made by whisking egg yolks, butter, lemon juice, and vinegar over a double boiler until thick and creamy.

• Demi glaze is a rich brown sauce made by simmering beef bones, vegetables, and herbs for several...read more