Which of the following is a type of recovery model supported in SQL Server in which all database changes are logged?
A) Bulk logged
B) Full
C) Simple
D) Complete
Question 2
Dimensional databases are used to track historical data, and therefore must have a(n) ________.
A) time dimension
B) customer dimension
C) sales dimension
D) order dimension