nerdexam
Oracle

1Z0-591 · Question #45

You run the Consistency Check and receive the warning: [39003] Missing functional dependency association for column: DIM_Offer_End_Date.CREATE_DT. What would you check?

The correct answer is E. Whether there is a physical column mapped to the logical column. See the full explanation below for the reasoning.

Question

You run the Consistency Check and receive the warning:

[39003] Missing functional dependency association for column:

DIM_Offer_End_Date.CREATE_DT. What would you check?

Options

  • AWhether the logical table source for this column has been disabled
  • BWhether the columns creating CREATE_DT have been deleted
  • CWhether there is a logical join between the DIM and FACT tables
  • DWhether there is a physical join between the DIM and FACT tables
  • EWhether there is a physical column mapped to the logical column
  • FDIM_Offer_End_Date.CREATE_DT

How the community answered

(35 responses)
  • B
    11% (4)
  • C
    3% (1)
  • E
    80% (28)
  • F
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice