IT Assistant - written exercise for an European Agency (Brussels)

60 minutes to tackle the following points:

1. RUP

• what are the principles?
• detail the most important documents/artefacts.

2. Migrating an old application server

• an existing framework contract exists and 2 alternatives are available; you are working inside the company for 3 years and you need to help the management to take a decision. How are you going to do it?

3. SQL

• how is an n-n relationship modeled;
• how to tackle a query with performance issues.

4. User requirements: a new corporate HR information system is being developed. You are part of the working group involving 5 multiple services, and you represent the interests of your organisation.

• why should the requirements be prioritized?
• how to assure that the requirements of the 5 services remain stable?

piece of cake ;)