Database Architect Interview Questions
27
Database Architect interview questions shared by candidates
What is the first step you apply in setting up a new database system?
1 Answers↳
The first thing to do, which does not involve writing any code, is put on my hat as a systems analyst. An architect must have an understanding of each phase of the process ranging from first collecting information from the current system in place, talking to each person involved in that current system, sitting down and doing some of the work of some of those people (this provides very valuable information that was not submitted earlier, as it was not considered valuable), and basically learning to understand and appreciate the data. Knowing the data is the first and most crucial step, otherwise, the models and subsequent work based on it will be useless and can cost a company resources it cannot afford. Knowing the data well provides the architect with perspectives that the company may not be considering. That is, there may be better options available that have not been considered that could exceed their objectives. It is the objectives that are key in the entire process. A basic developer will resolve a specific issue concentrating on the key, but the architect must have an understanding of the entire forest, so to speak, and must concentrate on understanding the data and the company's current and future objectives. Less
Puzzle "Three Light Bulbs & Switches in a Room": A windowless room contains three identical light fixtures, each containing an identical light bulb or light globe. Each light is connected to one of three switches outside of the room. Each bulb is switched off at present. You are outside the room, and the door is closed. You have one, and only one, opportunity to flip any of the external switches. After this, you can go into the room and look at the lights, but you may not touch the switches again. How can you tell which switch goes to which light?"
1 Answers↳
I had no clue. Later I've found this Puzzle online. The right answer: "Switch on switches 1 & 2, wait a moment and switch off number 2. Enter the room. Whichever bulb is on is wired to switch 1, whichever is off and hot is wired to switch number 2, and the third is wired to switch 3." Less
How did you determine and test that your solution was going to solve the issue?
1 Answers↳
I answered honestly, that we looked at metrics, looked at processes running, and decided to adjust instance type. The problem did not recur. But he kept asking me over and over "How did you test this? How did you verify?" and I kept answering "We solved the problem, it did not happen, we watched the metrics and saw we were not hitting limits as before" Less
How are you going to help this manager meet his daily operational needs?