⟩ Explain what are the different index configurations a table can have?
No indexes
A clustered index
A clustered index and many nonclustered indexes
A nonclustered index
Many nonclustered indexes
No indexes
A clustered index
A clustered index and many nonclustered indexes
A nonclustered index
Many nonclustered indexes
Explain MS SQL Server Reporting Services vs Crystal Reports?
Do you know what are the Reporting Services components?
What is MS SQL Server Reporting Services?
What is the architecture of MS SQL Reporting service?
Do you know the storage models of OLAP?
What is Data purging?
Explain what are the different problems that “Data mining” can solve?
Tell me what are CUBES?
What is Rollup and cube?
Do you know what are OLAP and OLTP?