Database design
Database Consultant Interview Questions
5,240 database consultant interview questions shared by candidates
All are moderate questions and questions regards work experience
1. Very specific database related problem in MongoDB. Given a collection, a set of indexes and a set of queries, would adding a particular index help and why? 2. Given a set of index servers in a data center that has 2 GBPS ethernet WAN capacity, describe a most efficient way to transfer the index files (100 M each) to a set of 10 web servers in a different data center with equivalent receiving ethernet speed at the same time without any data loss. 3. What are some of the Percona utilities that you have used for MySQL and the monitoring tools. Why do you like a certain tool better over the other? (mainly to describe the features of the tool used). 4. Describe the architectural strategy or options to design your data servers in such a way that for those candidates to access their resume data that is stored in a remote data center after they have moved to a different geographic region that is closer to another data center, is the most optimal.
1) What is my primary skillset? 2) The primary skills required and the upcoming projects were discussed. What is my experience with these?
The Offer I kick myself now for not using glass door to find out abut this company first.
They want to know what experience you have (of course) but aren't specifically looking for you to say you're a computer science guru. Mainly they want to get a sense of your character and work ethic. They might ask how you'd respond in some example situations regarding design or how you might interact with a client. They may show you a web site and ask for your opinion on usability or what alterations you might make, and why.
How do you update tables
How do you access your databases in Azure/Redshift whatever
Have you worked on databases?
(paraphrasing) The database design is relatively flat and makes use of Sharding. How would you tune such a setup?
Viewing 891 - 900 interview questions