SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Data warehousing/BI interview questions
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jung1975
Aged Yak Warrior

USA
503 Posts

Posted - 04/22/2004 :  18:22:27  Show Profile  Reply with Quote
Does anyone have a list of datawarehousing /Business intelligence interview questions?
or can share the Data warehousing/BI interview experience with me?


Thanks







MichaelP
Jedi Yak

USA
2489 Posts

Posted - 04/22/2004 :  18:32:37  Show Profile  Visit MichaelP's Homepage  Reply with Quote
Explain the difference between Snowflake and Star Schema.

Why are OLTP database designs not generally a good idea for a Data Warehouse?

Why should you put your data warehouse on a different system than your OLTP system?

Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs? What setup for your data?

That should get things started.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

Joozh
Posting Yak Master

145 Posts

Posted - 04/23/2004 :  00:06:25  Show Profile  Reply with Quote
Hi Michael,

I know this will be a botheration but against each of these (these all are excellent questions), can you kindly provide a brief answer. I'm not preparing for an interview but your reply will really help me strengthen my concetps and I am sure that it will also give me new tips.

Many thanks in advance.

Thanks & Regards.

-J
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 04/23/2004 :  12:18:21  Show Profile  Reply with Quote
You can certainly google up some info...

See...

http://datawarehouse.dci.com/articles/1998/07/28star.htm

Damn...I've got to build a damn warehouse one of these days with the sql server tools...

We built before they were called that....now they got all of these buzz words...

I gotta be able to pass the buzz word interview...



Brett

8-)
Go to Top of Page

Joozh
Posting Yak Master

145 Posts

Posted - 04/26/2004 :  23:50:34  Show Profile  Reply with Quote
Thanks for the article. May I request if I can get answers to the following questions too. Sorry for the botheration and many thanks in advance:

1) Why are OLTP database designs not generally a good idea for a Data Warehouse?

2) Why should you put your data warehouse on a different system than your OLTP system?

3) * * Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs? What setup for your data?


Thanks & Regards.

-J
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 04/27/2004 :  00:20:54  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
1) Why are OLTP database designs not generally a good idea for a Data Warehouse?

OLTP databases are normalized structure designed to reduce data, increase performance of transactions, and decrease overall reads/writes.

When you are wanting to build summaries and cube analysis blocks of things, pulling this from a highly normalized transaction based structure creates huge amounts of overhead, is slow, and is inefficient.

2) Why should you put your data warehouse on a different system than your OLTP system?

There are a log of reasons. OLTP is designed to serve real-time transactional business needs. The idea is get in/get out quickly and efficiently. OLAP is designed to have large batch windows that aggregate and summarize data into reporting schemas. The two are dynamically opposed. The processing of the OLAP portion of the database kills the processing and memory utilization needed to keep the OLTP system active and "lively". The OLAP system also interferes with the data as it's locking and causing contention on data as it's creating the aggregate views that are needed.

The list for this goes on and on and on and on. They are two vastly different types of systems though. The resources will interefere with each other and end up choking your entire system to death.


3) * * Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs? What setup for your data?

Transaction logs write sequentially and don't need to be read at all. The ideal is to have each on RAID 1/0 because it has much better write performance than RAID 5.

RAID 1 is also better for TX logs and costs less than 1/0 to implement. It has a tad less reliability and performance is a little worse generally speaking.

RAID 5 is best for data generally because of cost and the fact it provides great read capability.

Check this site out. It's a great beginners tutorial on RAID:

http://www.acnc.com/04_00.html


MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

Joozh
Posting Yak Master

145 Posts

Posted - 04/27/2004 :  02:57:27  Show Profile  Reply with Quote
Many thanks derrickleggett. Appreciate your reply :-)


Thanks & Regards.

-J
Go to Top of Page

jerryvn01
Starting Member

3 Posts

Posted - 07/03/2010 :  13:08:20  Show Profile  Visit jerryvn01's Homepage  Reply with Quote
spam removed

Edited by - jerryvn01 on 07/26/2010 12:17:04
Go to Top of Page

anbetophillip
Starting Member

1 Posts

Posted - 07/15/2010 :  05:39:27  Show Profile  Reply with Quote
spam removed

Edited by - anbetophillip on 08/04/2010 21:30:47
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 08/05/2010 :  11:08:33  Show Profile  Reply with Quote
but what if you like Spam?

Spam..spam..spam...lovely spam...

Bloody vikings...



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

patricholier
Starting Member

3 Posts

Posted - 06/08/2011 :  21:49:02  Show Profile  Reply with Quote
quote:
Originally posted by X002548

but what if you like Spam?

Spam..spam..spam...lovely spam...

Bloody vikings...



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam







Very interesting
Go to Top of Page

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 06/09/2011 :  08:11:47  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
>> RAID 5 is best for data generally because of cost and the fact it provides great read capability.
Ummm what about write performance?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/09/2011 :  09:22:13  Show Profile  Reply with Quote
quote:
Originally posted by nigelrivett

>> RAID 5 is best for data generally because of cost and the fact it provides great read capability.
Ummm what about write performance?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.



Seven year old thread.

I don't think Derrick has posted on SQL Team for over four years.





CODO ERGO SUM
Go to Top of Page

hambim336
Starting Member

6 Posts

Posted - 08/30/2011 :  05:17:56  Show Profile  Reply with Quote
Hi

You can find this info by using search box in the top of website with some keywords related before posting questions.
Go to Top of Page

hambim336
Starting Member

6 Posts

Posted - 09/04/2011 :  03:26:38  Show Profile  Reply with Quote
If you want to get more materials that related to this topic, you can visit: http://freeinterviewquestions.net/free-interview-questions-for-warehouse-supervisor

Best regards.
Go to Top of Page

hambim336
Starting Member

6 Posts

Posted - 11/30/2011 :  03:09:30  Show Profile  Reply with Quote
Hi

This topic help me a lot in developing my project. I will contribute more when I finished it.
Go to Top of Page

hambim336
Starting Member

6 Posts

Posted - 12/07/2011 :  08:04:16  Show Profile  Reply with Quote
If you want to get more materials that related to this topic, you can visit: http://interviewquestionsandanswers.biz/architect-interview-questions-and-answers/

Best regards.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000