Friday, January 21, 2011

14 important SQL Server interview questionson Data Warehousing/Data Mining - Part 1

14 important SQL Server interview questionson Data Warehousing/Data Mining - Part 1


This section is Part 1 and it will cover the most asked SQL Server interview questions by the
interviewer so have a look on the following and do revise it when ever you go for the SQL Server interview
Normally SQL Server interview starts with.....

What is “Data Warehousing”?
What are Data Marts?
What are Fact tables and Dimension Tables?
What is Snow Flake Schema design in database?
What is ETL process in Data warehousing?
How can we do ETL process in SQL Server?
What is “Data mining”?
Compare “Data mining” and “Data Warehousing”?
What is BCP?
How can we import and export using BCP utility?
During BCP we need to change the field position or eliminate some fields
how can we achieve this?

What is Bulk Insert?
What is DTS?
Can you brief about the Data warehouse project you worked on?

No comments: