Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS 2005 Interview Questions


SSIS 2005 Interview Questions

Author
Message
ashish.mehrotra
ashish.mehrotra
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 27
Hi All,

Please provide me a link from where I can download the SSIS/SSAS/SSRS 2005 interview questions.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47198 Visits: 44367
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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Raunak Jhawar
Raunak Jhawar
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1095 Visits: 1944
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?

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
humanier
humanier
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 2
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!
aamir.nmhu
aamir.nmhu
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 349
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.

http://sqlage.blogspot.com/

Thank you
Aamir
blasto_max
blasto_max
SSC-Enthusiastic
SSC-Enthusiastic (185 reputation)SSC-Enthusiastic (185 reputation)SSC-Enthusiastic (185 reputation)SSC-Enthusiastic (185 reputation)SSC-Enthusiastic (185 reputation)SSC-Enthusiastic (185 reputation)SSC-Enthusiastic (185 reputation)SSC-Enthusiastic (185 reputation)

Group: General Forum Members
Points: 185 Visits: 480
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.
rahul.neekhra 81176
rahul.neekhra 81176
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 0
Hi Grashopper,

You can find MS BI Interview questuions and answers here.

http://www.sqlserverpeoples.com/Faq.aspx
Stuart Davies
Stuart Davies
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4471 Visits: 4545
rahul.neekhra 81176 (11/26/2014)
Hi Grashopper,

You can find MS BI Interview questuions and answers here.

http://www.sqlserverpeoples.com/Faq.aspx

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
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search