Relationships and Edit Relationships windows

QUESTION 1

1. The Create Relationships and Edit Relationships windows are the same, except the Create Relationships window has all the fields pre-populated.
   True
   False
   0.9 points
   QUESTION 2
2. Within the Relationship View, the number (1) denotes the table on the One side of the relationship.
   True
   False
   0.9 points
   QUESTION 3
3. Which of the following options for data load is off by default?
   Import relationships from data sources
   Update relationships when refreshing queries
   Autodetect relationships after data is loaded
   Allow data preview to download in the background
   1.4 points
   QUESTION 4
4. Many-to-One cardinality specifies that there is a single record in one table for many records that map in the table that is joined.
   True
   False
   0.9 points
   QUESTION 5
5. Which is an example of a Parent-Child relationship?
   “A list of transactions, each of which takes place at a specific time and place”
   “A company with multiple offices, which in turn have multiple branches”
   “A list of raw materials, each of which are used to assemble various goods”
   “A list of services, each of which are available from various companies”
   0.9 points
   QUESTION 6
6. Which of the following are most likely to require a many to many relationship?
   A list of parents and a list of their children
   A list of dates and a list of historical events
   A list of cities and a list of GPS coordinates
   A list of companies and a list of brands they produce
   1.4 points
   QUESTION 7
7. Edits can be made in Reading View.
   True
   False
   0.9 points
   QUESTION 8
8. Which of the options can NOT be changed in the Visualizations toolbar?
   Axis Title
   Calculated Column
   Graph Color
   Data Labels
   0.9 points
   QUESTION 9
9. To show a line graph and a bar chart what kind of visualization should you create?
   Scatter Chart
   Matrix Visualization
   Combination Chart
   Slicer

Sample Solution