In a scenario having multiple facts (FACT A & FACT B)and conformed dimensions (CONF D), what is the best way to fire queries involving both?

technology enterprise content management

  1. Having a single SQL query with FACT A, FACT B and Conf D.

  2. Have a individual query between FACT A & Conf D, and a individual query between FACT B & Conf D.

  3. Have three individual queries, one for each table.

  4. A and B

  5. All of the above

Show answer
Correct Option: B

Find more quizzes: