Questions d'entretiens - Database architect


Questions d'entretien pour Database Architect partagées par les candidats

Principales questions d'entretien

Trier: Pertinence|Populaires|Date
Mode Media
On a demandé à un Senior Database Architect...12 avril 2011

how to handle the corrupted record scenario?

2 réponses

the answer is export & import the particular table

Collect Corrupted records, do the special API to handle it. ie. Regain from Database, Retry and Finally Analyse why it corrupted. Moins


did not given interview there?

1 réponses


TSYS|Total System Services

What is the first step you apply in setting up a new database system?

1 réponses

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. Moins

Arizona Department of Corrections, Rehabilitation & Reentry

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 réponses

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." Moins

Jama Software

Can you read a data model and talk to it?

1 réponses

Yes I can and I did.


How did you determine and test that your solution was going to solve the issue?

1 réponses

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" Moins


How are you going to help this manager meet his daily operational needs?


What is one thing you have accomplished that added value to an organization you've worked with/for?

1 - 10 sur 24 questions d'entretien d'embauche

Consultez les questions posées en entretiens pour des emplois similaires