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)- B11% (4)
- C3% (1)
- E80% (28)
- F6% (2)
Community Discussion
No community discussion yet for this question.