Questions

1. Why do we need to transform data?
   We need to make data consistent and prepared for our analytical purposes. Data can come from a range of data sources with very volatile quality.
2. Is it always good approach to consume source data directly?
   Sometimes, yes, but not always. One of the reasons why we should stage data aside is to avoid conflicts with common data contention coming to a source data.
3. Why is the OPENQUERY function preferred when writing distributed queries?
   The first reason is that security when using the OPENROWSET function is compromised. The second reason is to do with performance. Distributed queries written using the OPENQUERY function often perform better than those written using an ad hoc approach.
4. Can we modify data using views?
   No. The view definition is defined by the SELECT statement only. The modular object intended mainly for data manipulation...