QUESTION 20

Many to One is the _____ type relationship, for example a sales table with multiple rows per product being matched up with a table listing products in their own unique row.

fact to dimension

dimension to cell

snowflake

cube

QUESTION 21

_____ is used often for linking single entries in reference tables.

One to One

Null value to One

Many to Many

Many to One

QUESTION 23

A _____ column is a new column that you create by defining a calculation that transforms or combines two or more elements of existing data.

user-defined

virtual

faux

calculated

QUESTION 24

One useful reason for creating a calculated column is to establish a relationship between tables, when no ____ fields exist that can be used to establish a relationship.

similar

non-keyed

indexed

unique

QUESTION 26

Note that your hidden columns are not deleted; if you've used that field in existing visualizations, the data is still in that visual, and you can still use that data in other visualizations too, the hidden field just isn't displayed in the pane.

Fields

Rows

Columns

Attributes

Calculated _____ are a function within DAX that allows you to express a whole range of new modeling capabilities.

procedures

views

tables

queries

QUESTION 32

If you want to do different types of merge joins or create new tables on the fly based on the results of a functional formula, calculated views are the way to accomplish that.

True

False

QUESTION 34

Select the _____ icon on the Visualizations pane to make cosmetic changes to your visual, such as background alignment, title text, and data colors.

		coloring
		visualization
		paintbrush
		graph