Deloitte SQL Server Database Administrator Interview Questions and Answers for Experienced

This is a case study round, you would be given 3 question out of which you will need to solve any 2.
Two question are algoritm based around designing datastructure and matrix problem
One question will be based om designing Database for a given requirement.

Q1. This is a follow up round after case study,where the interviewer will ask you about perfomance and scalability of questions is case study round. There might be few addition question on improving the soluti...read more
Add your answer

Q1. This is a behaviour round where interviewer will see your fitiness for team. It basically has scenario based question . This is also elimination round
Add your answer

Q1. Interview was for .NET Full Stack Developer 1. What is the difference between .Use and .Run in Configure method in startup class in .NET core applications. 2. What are SOLID principles? 3. What are AWS ...read more
Add your answer

Q1. SSRS reports - Why temp tables are used and not regular tables?
Ans. 
Temp tables are used in SSRS reports for performance optimization and to reduce resource consumption.
• Temp tables are used to store intermediate results during report generation, reducing the need to repeatedly query the database.

• Regular tables can lead to locking and contention issues in multi-user environments, while temp tables are session-specific and do not cause conflicts.

• Temp tables can be indexed and optimized f...read more
Answered by AI
Add your answer
Q2. Table group and cache look-up
Add your answer

Q1. Infra architechture
Add your answer
Q2. Form patterns - D365FO
Add your answer

Q1. Why are you looking for job change?
Add your answer

Multiple choice questions on language of your choice

Solve any 2 case studies out of 3.
2 classes design LLD.
1 SQL db design

Q1. Oop, DSA basic and medium level questions.
Add your answer

This round is purely based on DS /Algo and System Design and their real-life applications implications and a few case studies.

Q1. How memory is managed in python?
Ans. 
Python uses automatic memory management through garbage collection.
• Python uses reference counting to keep track of memory usage.

• When an object's reference count reaches zero, it is deleted.

• Python also uses a garbage collector to clean up circular references.

• Memory allocation is handled by the Python memory manager.

• Python provides tools like sys.getsizeof() to monitor memory usage.
Answered by AI
Add your answer
Q2. Three-tier architecture, Flask, Docker, Redis,Microservice,Design Patterns
Add your answer

Q1. Aptitude-based and technical situation questions with senior members of the team.
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. Where do you see yourself in 5 years?
Add your answer

Q1. Life cycle around Static Constructor
Ans. 
Static constructor is called only once during the lifetime of a class.
• Static constructor is used to initialize static fields of a class.

• It is called automatically before the first instance of the class is created.

• It cannot be called directly and cannot have any access modifiers.

• It can be used to perform one-time initialization tasks such as setting up a database connection.

• If an exception is thrown during static constr
Answered by AI
Add your answer
Q2. SOLID principle deep dive
Add your answer

Q1. Technical stuff about previous company.
Add your answer

Q1. Previous company work, experience about topics
Add your answer
Q2. Technical stuff qna about previous company work and tools n technology
Add your answer

Q1. Manager round technical stuff
Add your answer

Basic coding questions and SQL queries

Q1. Technology used
Ans. 
Various technologies including Java, Python, SQL, AWS, Docker, Kubernetes, etc.
• Java

• Python

• SQL

• AWS

• Docker

• Kubernetes
Answered by AI
Add your answer