Conformed dimensions allow users to do the following: A) share ...

[tfester]

Conformed dimensions allow users to do the following:
 
  A) share nonkey dimension data.
  B) query across fact tables with consistency.
  C) work on facts and business subjects for which all users have the same meaning.
  D) all of the above.

Question 2

How are missing values generally handled in database management systems?
 
  What will be an ideal response?

[yahahah24021]

Answer to Question 1

D

Answer to Question 2

When dealing with missing data, there are many options. Two integrity controls (default value and null control) will handle this problem. One also could substitute an estimate for the missing value which would then be stored in place of the missing value (and marked as an estimate). Another possible method is to use triggers to track missing values and create a log which can be viewed later. One other method is to perform sensitivity testing, which will tell us whether having missing data greatly impacts results. If results are not impacted, then the missing values are ignored.