Exercise 1

Run this code in the sqlcmd console:

  
use AdventureWorksDW2008R2
  go
  select count(1) from FactCurrencyRate
  go

The SQL Server returns: 14264

  
select count(1) from FactResellerSales
  go

The SQL Server returns: 60855

  
select count(1) from DimGeography
  go

The SQL Server returns: 655

  
select count(1) from DimDate
  go

The SQL Server returns: 1188

  
select count(1) from DimCurrency
  go

The SQL Server returns: 105