Solutions Architect Interview Questions |

Solutions Architect Interview Questions


Solutions architect interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

What does ORM mean? What are the advantages of using an ORM? What are some commercially available ORMs?

1 Answer

Object-Relational Mapping. Advantages: Lets the devloper deal with objects in the business domain instead of database tables (relations). Manages connection and possibly transactions. Some ORMs can abstract from the relational model and span several different data sources, including files or XML, or connect to different DB servers, abstracting from the particular query language used. If working with an IDE, having the relational model as an object model can provide syntax help (like Visual Studio's IntelliSense). Unfortunately, I have seen in several projects how at the end of the project, when deployment is on its way and real-world performance becomes an issue, that developers start to circumvent the ORM and write native SQL. Recently I heard the opinion "ORMs considered harmful", so I'm not a totally convinced proponent of ORMs. Example ORMs (from the .Net world): nHibernate, LinQ to SQL, Entity Framework. And of course everything here:

How would I approach a legacy system?

1 Answer

What is unit testing? How do I go about writing a unit test? Do I focus a unit test on a class or a method? Would I write one or more tests per method? What are some unit testing frameworks?

1 Answer

What is Dependency Injection? How would I go about using it in "day to day programming"?

1 Answer

When I have a legacy method and need to change it, how would I do that? How do I make sure that I don't break anything?

1 Answer

Would I make a recommendation that could cause the termination of an employee?

1 Answer

Explain how to scale from a single 5 user database to a 50 user, 500 user, 5000 user and then 5 million user database and explain how to overcome each hurdle. Explain the difference between raid0, 1, 5, 6, 10, 50 and 60 Explain the differences between C, C++ and C# Write a piece of code to turn a recursive operation into a non recursive one

Tell us of a difficult situation with customers and how you handled it.

110 of 53 Interview Questions