September 14, 2010 at 1:58 am
Hi All,
Please provide me a link from where I can download the SSIS/SSAS/SSRS 2005 interview questions.
September 14, 2010 at 2:26 am
There's no fixed set of questions, different companies will ask different questions. Memorising questions is not the way to go about preparing for an interview. A good interviewer can tell the difference between someone who knows the area and someone who's memorised answers.
Don't exaggerate your skills.
Don't be afraid to say "I don't know", but always have a plan for finding out.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2010 at 2:37 am
Ashish I can give you 100 questions on each and I assure you that you will fail to answer any new technical query that arises in production or atleast at development.
This approach is not advisible.
Spend some time understanding the underlying architecture of BI-DW
Anyways, since you have taken time to post:
Please try to answer the following:
Can you enhance an existing aggregation design (custom or produced with the
Aggregation Design Wizard) with an aggregation design from the usage-Based
optimization Wizard?
Raunak J
January 12, 2011 at 10:24 pm
ashish.mehrotra (9/14/2010)
Hi All,Please provide me a link from where I can download the SSIS/SSAS/SSRS 2005 interview questions.
You can find link to list of interview questions on this page - MS SQL Interview Q&A.
==================
Visit my blog!
December 24, 2013 at 11:11 pm
Hi,
I tried to List SSIS/SSRS/TSQL and DWH real time questions those I learnt from different companies while interviewed or my students/Friends were asked.
Thank you
Aamir
December 26, 2013 at 4:57 pm
GilaMonster (9/14/2010)
There's no fixed set of questions, different companies will ask different questions. Memorising questions is not the way to go about preparing for an interview. A good interviewer can tell the difference between someone who knows the area and someone who's memorised answers.Don't exaggerate your skills.
Don't be afraid to say "I don't know", but always have a plan for finding out.
Believe it or not, that is how some interviews are cracked and after that, the person learns on the job. I have also seen cases where people get help from their "ssis/anything" expert friends, for thorny issues in development if forums and google cannot provide the answers. After they gain 2-3 years of experience themselves, they are set to sail (mostly) on their own.
I agree that one must not memorize questions. But, its still good to see some interview questions as if they exercises for you to solve. The more issues and problems you see, the more you learn.
November 26, 2014 at 12:25 am
Hi Grashopper,
You can find MS BI Interview questuions and answers here.
November 26, 2014 at 2:39 am
rahul.neekhra 81176 (11/26/2014)
You can find MS BI Interview questuions and answers here.
http://www.sqlserverpeoples.com/Faq.aspx%5B/quote%5D
Following on from Gail analysis of some of the information (see http://www.sqlservercentral.com/Forums/Topic482499-5-1.aspx) from that website Rahul, all I can say is caveat emptor (buyer beware)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply