Click here to get free chapters (PDF) in the mailbox
It was a great pleasure to write latest series about Data Warehousing Interview Questions and Answers. Just like always again, I received lots of suggestion and follow up questions. I have tried to accommodate all of them in the last post in the series. I hope this series is helpful to all candidates who are seeking a job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer at convenience. Here is the questions and answers complete list, all in one place.
Complete Series of SQL Server Interview Questions and Answers
SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 2
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
Additional Series List Available to Download
SQL Server Interview Questions and Answers Complete List Download
SQL SERVER Database Coding Standards and Guidelines Complete List Download
How to Use This Questions and Answers Complete List
A PDF of answers is most useful when you do not just read it. Here is a simple way to study with it: read one question, close the file, and explain the answer out loud in your own words. If you cannot, read it again and try once more the next day.
Draw things as you study. A star schema with one fact table and three dimensions on a sheet of paper teaches more than a page of text. Then connect each answer to something real, like a sales report you have used, so you have an example ready when you are asked.
If you are the interviewer, use the questions as a starting point, not a script. Ask the candidate why a design choice makes sense, or what they would change if the data doubled. Those follow up questions show real understanding much better than a memorized definition does, and they give a nervous candidate room to show what they know.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
53 Comments. Leave new
Thanks alot!!!
It was useful.
good too good……… thank you boss……….
Thanks, good stuff!
hi,
Please give latest ssas,ssrs interview questions yar
Regards
mahesh
Hi Pinal
I am Ankur Singh,graduate student in SDSU(CA).
I am looking forward to make my career in Database field and preparing for interviews.
Your SQL server and Data Warehouse interview questions and answers helped me alot.
I would appreciate you if I can get SSIS and SSRS interview questions and answers as well so that I can prepare well for interviews.
With Regards
Thank you so much for this list!
Hi,
Can someone tell me two ways of writing query for create table??
Thanks!
create table(………)
select * into table from old_table
But the table created from second method will not have indices that old_table has
Hi,
Please give me ssis,ssrs interview quotions..
Hi Pinal,
I have few questions on Data Warehousing as am new to DWH.Following are my questions:
1. What is business key in DWH.
As per i under stood : A PK of a table from which dimension table is loaded. Am I right ? if wrong can u plz explain.
2. What is the relation between fact table and dimension table.
3. what is the relation between factless fact and dimension table.
4. Can you please send me one simple model where it inculdes fact table,factless fact and dimension table.
5. Is factless fact table a bridge table?
6. Why operational reports are generated at the ODS why not at the DWH. What happens if its operational reports are pulled from DWH.
It could be helpfull if you answer my question. Waiting for your reply as early as possible.
Hi, I need SSAS,SSRS related topics and FAQs, Please send me…
Thanks Pinal,
I am your fan. Every time I look up for any SQL related stuff, SQLAuthority comes up first.
Hey..could anyone tell what a double barelled join is?? Thank You