Multiple Choice
Suppose you try to create a pivot table from multiple tables stored in a Data Model and,when you check a particular field to be placed in the pivot table,you get a warning about a missing relationship.Which of the following does this not imply?
A) You are trying to use fields from unrelatable tables,so no matter what you do,your pivot table results will be wrong.
B) You can open the Power Pivot window,create the missing relationships,and try building the pivot table again.
C) You can click the Auto-Detect button in the PivotTable Fields pane,and the chances are that Excel will correctly create the missing relationship.
D) You can click the CREATE button in the PivotTable Fields pane,which allows you to manually create the missing relationship.
Correct Answer:

Verified
Correct Answer:
Verified
Q8: Which of the following is not true
Q9: It is reasonable to assume that the
Q10: One way to create a unique identifier
Q11: Business intelligence refers to the insights gained
Q12: Primary and foreign keys relate information between
Q14: The flexibility of the measures created by
Q15: The pivot table functionality that has been
Q16: In terms of importing data from a
Q17: When there is a many-to-many relationship,it is
Q18: Which of the following most accurately explains