I am a hiring manager that has little to no knowledge of SQLserver, but i am hiring someone to properly store all my customer data/analytics. he needs to be able to do the following:
import my data( this could be a sample data) from access into sql server
sort and clean data, such that information is neat and easily extractable by fields and relational tables
query for simple use into excel spreadsheets/VBA/
cycle the import from external excel spreadsheets and schedule the task to run every hour.
Is there a way to setup a trial test for these skills? How do i go about doing it? This should be pretty basic, i am hoping to get the candidates to do this in an exam environment for an hour.
How do i test the competency of the candidates?