MasterCard Senior System Administrator Interview Questions and Answers

Implement thread safe load balancer.
focus on input validations and cover all corner cases in tests

Q1. Explain Concurrency
Ans. 
Concurrency is the ability of a system to execute multiple tasks simultaneously.
• Concurrency allows multiple tasks to run concurrently, improving performance and efficiency.

• Concurrency can be achieved through multithreading or multiprocessing.

• Example: A web server handling multiple requests simultaneously using multithreading.
Answered by AI
Add your answer
Q2. Explain Acid principles
Ans. 
ACID principles are a set of properties that guarantee database transactions are processed reliably.
• Atomicity: Transactions are all or nothing. If one part of the transaction fails, the entire transaction is rolled back.

• Consistency: Transactions bring the database from one valid state to another. All constraints are satisfied.

• Isolation: Transactions are isolated from each other until they are completed.

• Durability: Once...read more
Answered by AI
Add your answer

Q1. Current company architecture and what was your role
Add your answer

Online assessment and coding test

Q1. System Design related question to understand e2e picture of a working system in prod.
Add your answer
Q2. DS-Algo based question not remember now, but easy one
Add your answer

Q1. Prior project based System Design and questions around it
Add your answer
Q2. Design a custom data structure based on requirement
Ans. 
Custom data structure for array of strings
• Use a trie data structure to efficiently store and search for strings

• Implement methods for adding, removing, and searching for strings in the trie

• Consider optimizing the trie for memory usage and performance
Answered by AI
Add your answer
Q3. Internal working - of DB structures and indices etc
Ans. 
Understanding internal workings of DB structures and indices is crucial for optimizing database performance.
• DB structures refer to how data is organized within a database, such as tables, columns, and relationships.

• Indices are data structures that improve the speed of data retrieval operations by providing quick access to specific data values.

• Understanding how indices work can help in optimizing query performance by re...read more
Answered by AI
Add your answer

Q1. Past Experience based questions
Add your answer
Q2. Behavioral/Attitude observational Questions
Add your answer

DSA round on graph . String questions were asked

Q1. In memory sql db
Ans. 
In-memory SQL databases store data in memory for faster access and processing.
• In-memory databases keep all data in RAM for quicker retrieval compared to disk-based databases.

• Examples include SQLite in-memory database and Redis.

• They are commonly used for caching, real-time analytics, and temporary data storage.
Answered by AI
Add your answer