MockQuestions MockQuestions
Interviews Questions by Career
Interviews Questions by Company
Interviews Questions by Topic
Get Started
Interview Coach 1:1
Gain the confidence you need by asking our professionals any interview scenario, question, or answer you are unsure about.
Let Us Review Your Answers
Our interviewing professionals will gladly review and revise any answer you send us. Allowing you to craft perfect responses for your next job interview.
Interview Questions by Topic
Interview Questions by Career
Interview Questions by Company

Reddit.com

28 Interview Questions & Answers

1.
In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?
Click to View Answers
Reddit.com uses indexes to improve query performances within their software and for this question, your interviewer is looking to hear that you have a basic understanding of both clustered and non-clustered indexes. Explain the differences between the two types of indexes and be sure you can either speak to relevant times that you've used each or when would be the appropriate application to use each.

Interview Q&As
Explore expert tips and resources to be more confident in your next interview.
Behavioral
Common
Phone
Tough
Leadership
All Interview Topics
All Career Q&As
1.
In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?
Reddit.com uses indexes to improve query performances within their software and for this question, your interviewer is looking to hear that you have a basic understanding of both clustered and non-clustered indexes. Explain the differences between the two types of indexes and be sure you can either speak to relevant times that you've used each or when would be the appropriate application to use each.

Ryan's Answer #1
"In the simplest of terms, a clustered index order records in a table the way that they are physically stored. There can only be one clustered index per table. Non-clustered indexes do not store data to match the physical order that it is stored. Rather, it can hold up to 249 indexes per table. Both types come with their own benefits over the other. In my experience, clustered indexes are suited best for programs that use primary key as an identity integer column. On the other hand, non-clustered make the most sense for programs that need JOIN and WHERE clauses within them."
Ryan's Answer #2
"In my experience, clustered indexes are faster to read but very slow when it comes to update data within. Non-clustered indexes are just the opposite in that they are slower to read but much fast to insert new data into them. In my current role, I mostly use clustered indexes when large numbers of rows need to be retreived and when insert operations are important. Most other times, I will use non-clustered as the standard."
2.
What experience do you have in the different types of software maintenance?
As a reputable company, Reddit.com takes their software maintenance processes seriously and your interviewer is looking to hear that you are familiar with the four different types of software maintenance. Talk to your interviewer about any work you have done in the past with corrective, adaptive, perfective and/or preventative software maintenance. Use specific examples and make sure that your interviewer walks away from your conversation knowing that you understand the importance of proper system maintenance.

Ryan's Answer #1
"Being familiar with all four types of software maintenance, my most used method of maintenance in my current role is corrective. Based on bug reports from end users, I work through coding and logic issues to resolve issues in a timely and effective manner. In the maintenance I perform, I never hesitate to pick up the phone and contact customers to hear first hand about what they are experiencing. By doing this, they feel like they are an important part of the process and it reflects well on me and my organization."
Ryan's Answer #2
"In my current role, I'd definitely say that a majority of the maintenance work that I do is adaptive maintenance. Working in banking software that is used around the globe, I help perform system maintenance for changes in currency on a pretty regular basis. This work requires research and talking with end users to help adapt the programs for their use. If hired here at Reddit.com, I also have experience performing perfective, preventative and corrective maintenance on software as well."
3.
What unique values can you bring to Reddit.com in your user experience design skills?
While your interviewer has shown confidence in your technical abilities to succeed at Reddit.com as a UX designer, this question is helping them gain insight into your ability to see the big picture in the work that you do. As you think about the unique personal values that you would bring to the role, try and paint a picture of your work tying to the end user and how you can help make it more productive, enjoyable and satisfying for them.

Ryan's Answer #1
"I have really taken pride in my ability to add value to the business needs of the customers that I work with. During any design project, I take the time to work with end users to find their wants and needs out of the program. Then, as I create the UX design, I keep their needs at the forefront and do anything possible to exceed their expectations."
Ryan's Answer #2
"As you can see from my resume, I have formal training and experience in user experience research and I know that this would benefit the work that I would be doing here at Reddit.com if hired for this position. I pursued this additional training in my career because of my passion for the customer journey in the programs that I design."
4.
What do you feel is one of the top issues that is faced by data engineers today?
Being in the midst of the greatest technological revolution in the history of man, data engineers face many difficult issues in the work that they perform on a daily basis. While there are many directions that you can go with this question, be sure to focus your answer on something that you can speak passionately about. If you can research a common issue in the industry that Reddit.com works in, you may likely score some bonus points with your interviewer.

Ryan's Answer #1
"Over the past couple of years, I've come to realize that one of the largest issues we face as data engineers is the large amounts of data that are needed to store and then draw information from. Here at Reddit.com, I can only imagine how big of an issue that is in the healthcare industry. I have a lot of experience with cloud based data storage and also server based storage."
Ryan's Answer #2
"In my recent experiences, continuous, real-time integration is an issue that we will face each and every day moving forward. The need for fast paced information is certainly to blame for this. To stay on top of the continuous integration landscape, I am happy to hear that new and improved systems are being created to stay more real-time and up to the minute. Here at Reddit.com and working in the financial industry, how have you seen this need for real-time data impact your products?"
5.
What skills do you use to cope with the day to day stress and pressure on the job?
In modern technology industries, consumer demand has led to high volume of work and high pressure situations to work on tight deadlines. To prove that you are able to handle high stress, high pressure situations on the job, your interviewer is looking to hear first hand how you handle this type of environment in your own words. As you answer the question, try to turn potential perceived stress into a positive by highlighting your personal skills that enable you to perform well in those situations. If possible, try to use specific examples in your answer.

Ryan's Answer #1
"Where many others get overtaken by stress to the point that they can't function in this field, high pressure situations sharpen my focus and that helps me work through them with ease. Last year, I was assigned a high priority, short notice project for a high profile customer. My manager gave it to me because of my proven success in those situations. From the start, I created a timeline for completion and mapped out a plan to make it happen. While staying in communication with my leaders and the client, I was able to create a great system update in just a few short weeks."
Ryan's Answer #2
"I am confident in high stress work situations because of my ability to adapt, communicate and be organized in my work. These skills came in very useful a few weeks ago when our support staff were experiencing an extremely high volume of help desk calls. My adaptability helped me go with the flow and handle items on at a time. My communication skills enabled me to quickly and efficiently call on needed support. My organization skills helped me be prepared for anything on that day and enabled me to work through tickets in a quick and efficient manner."
View All 28 Reddit.com Questions and Answers
Sign up to access our library of 50,000+ Q&As,
plus coaches for one-on-one support, so you can interview more confidently.
More Interview Q&As
Explore expert tips and resources to be more confident in your next interview.
Behavioral
Common
Phone
Tough
Leadership
All Interview Topics
All Career Q&As
About Our Interview Q&As
Our interview questions and answers are created by experienced recruiters and interviewers. These questions and answers do not represent any organization, school, or company on our site. We do not claim they will be asked in any interview you may have. Our goal is to create interview questions and answers that will best prepare you for your interview, and that means we do not want you to memorize our answers. You must create your own answers, and be prepared for any interview question in any interview.