SSAS (SQL Server Analysis Services)1. What is Data warehouse ?
2. What is Business Intelligence ?
3. What are the tools in SQL Server which serves for Data warehouse and Business Intelligence ?
4. What are the Kinds of Data warehouse ?
5. How do you plan your data warehouse complete project ?
6. What are the benefits of DW and BI ?
7. Can you briefly explain the DW project on your working ?
8. What is OLTP and OLAP ?
9. What is Analysis Services ?
10. What is ODS ?
11. What is Data Mart ?
12. What is Dimension ?
13. What are differences between Dimensional Model and Relational Model of System ?
14. What are the Model of Data ware house ?
15. What are differences between snowflake and star model?
16. What is CUBE ?
17. What is FACT and Dimensions ?
18. What is Dimensions and Measures ?
19. How to Build and Deploy Cubes in SSAS ?
20. What is MDX and DMX ?
21. How to Backup and Restore CUBES in SSAS?
22. What is ROLAP and MOLAP ?
23. How to secure and Authorize cubes ?
24. What is SCD ?
25. What is LOOKUP Key ?
26. What is Surrogate Key ?
27. What is Lookup Tables ?
28. What are Aggregate Tables ?
29. Is OLTP Database design for optimal DW ?
30. What is Data mining ?
31. How do you Index fact tables in DW ?
32. What is Data Purging ?
SSIS (SQL Server Integration Services )
1. What is ETL ?
2. What are the tools in SQL Server which provides ETL Process ?
3. What is BCP and Bulk Insert ?
4. What is DTS and DTS Package ?
5. What is TASK, Container and Package ?
6. What is Control Flow ?
7. What is Data Flow ?
8. How to Create a simple package ?
9. How to process, build and deploy a package ?
10. How to schedule package ?
11. What are differences between SSIS package and DTS package ?
12. If I need SP inside a SQL DB to run a SSIS package, what is the way ?
13. Where does SSIS package store ?
14. What are differences between control flow and data flow ?
15. What are variables and scope of variables ?
16. What is container and precedence ?
17. What is Transformation ? How to do transformation in SSIS ?
18. What is Checkpoint and breakpoint ?
SSRS (SQL Server Reporting Services )
1. What is SQL Server Reporting Services?
2. Explain SSRS architecture?
3. What is the report server?
4. What are the different folders on report server?
5. What is report server project?
6. What is report subscription?
7. How to manage subscription?
8. How to handle security on report server?
9. What is report server configuration?
10.What is reporting service Engine?
11.What are different databases in SQL Server?
12.What is the use of different databases?
13.Where we can find metadata of Reporting service?
14.What is report server temp database?
15.What are the different ways to deploy the Report?
16.How to deploy multiple Reports on a report server?
17.What is RS.exe utility?
18.How to create report server project?
19.What are different types of project types available in bids?
20.What is the default location SSRS project in hard drive?
21.How to enable the project window if it’s not appearing by default?
22.How to add your first report in project?
23.What are the different parts of report file in design mode?
24.What is report designer?
25.Which language Report files made of?
26.What is Data Set in report?
27.What are the different types of data sources in SSRS?
28.What are the different types of possible reports?
29.What is the extension for report file?
30.What are the shared data sources in SSRS?
31.What is the RDL file?
32.What are the Matrix reports and what are their uses?
33.What is parameterized report?
34.How to implement cascaded parameters in report?
35.How to call textbox or any column value of report table in header or footer?
36.How to implement group by in report?
37.How to add a page break in a report?
38.How will I enable the column header should repeat on each page?
39.How to change a color ofcell in report?
40.How to add an expression on a report column?
41.What is the use of rectangle in tool box?
42.What is format function in SSRS?
43.What are the different kinds of SSRS Reports?
44.What are parameterized reports? What are cascading parameters in SSRS reports?
45.How would you go about developing a SSRS report?
46.What is a dataset and what are the different types of datasets?
47.Would you store your query in a SSRS report or a Database server? State the reason why.
48.How would you access SSRS reports deployed on report server?
49.How would you deploy SSRS Reports using out-of-box functionality and how can you automate SSRS report deployment?
50.What is Report Builder?
51.What is drill-down and drill-through in SSRS?
52.What is linked report?
53.What are sub reports and how to create them?
54.What is the chart in report?
55.What is Pagination?