Skip to main content

Data Ware House & Business Intelligence

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?

Popular posts from this blog

mongoDB error : aborting after fassert() failure

What to do when facing errors on mongoDB “aborting after fassert() failure”

I like errors, in mongoDB this is the first error I faced and luckily many times. This error i faced during restoring name-space on local and restarting db system. I am still searching the exact root cause of this issue but i am able to resolve the current problem through below steps.

Remove all relevant namespace files from data-file route path..Now repair mongo instance using mongod process.mongod --repair ////////// execute command from bin folder path Then start server using mongd process, if started server successfully then ..mongod  ////////// execute command from bin folder path Restore last backups as normal process.Now check database by connecting mongo shell. Thanks for reading, 
Please comment your experience if you faced and also share knowledge if you have better steps to resolve...


https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

SQL71562: external references are not supported when creating a package from this platform

Last week I got this error from one of developer who was trying to deploy his project from Testing server to SQL Azure QA server. He was using “Deploy Database to SQL Azure” option from SSMS Tool-Task option.

After connecting to SQL Azure portal when operation started to deployment below errors occurs.

Validation of the schema model for data package failed. Error SQL71562: Error validating element xx.xxx.xx:function .dbo.xxx has an unresolved refrence to object xx.dbo.xxxx external refrences are not supported when creating a package from this platform.



Reason: The reason of the this error was; some functions of project was dependent on master database and only single database was being deploy to SQL Azure. DACFx must block Export when object definitions (views, procedures, etc.) contain external references, as Azure SQL Database does not allow cross-database external references So, this error was coming.

Solution : I suggested him to create those function to locally on local database what…

How to add an article in Transactional Replication

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process.
To add an article In Transaction replication with PUSH Subscription