C#

How can you impose a restriction on the type of a parameter in a generic?

What does the RPS metric indicate and how does it affect system performance?

Have you had experience working with microservice architecture and its implementation?

What are the two approaches to database and code design?

Can you give examples of index structures in SQL and their features?

Junior — Middle

GoodforecastOZON

What is the purpose of data normalization in a database and what problems does it solve?

Can you explain what is meant by 'method' in programming?

Explain what the BULK INSERT operator in SQL is and what it is used for.

Can you explain the concept and mechanism of asynchronous functions using the async/await syntax?

Junior — Middle

AstonOZONФинГрад+2

How does data and structure transfer occur from one system or version to another?

For what purposes is the Ref object used in a program or framework?

Could you explain the principles and purpose of unit testing in software development?

How is message passing implemented in RabbitMQ system?

Should automatic tests be written for each element of the project?

How many bits are in a byte?

Can you give an example of a situation where an abstract class is used?

Explain the concept of denormalization in databases and what it entails.

Can you explain what the term idempotency means in the context of programming or APIs?

What is the maximum number of cluster indexes allowed for a single table in a database?

Junior — Middle

Aston

At what stage in the development process should error handling be implemented in a large project?