QUESTION 20 Many to One is the _____ type relationship, for example a sales tabl
ID: 3746492 • Letter: Q
Question
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
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
Explanation / Answer
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. - snowflake
QUESTION 21) _____ is used often for linking single entries in reference tables - 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 - 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. - non-keyed
QUESTION 26) Calculated _____ are a function within DAX that allows you to express a whole range of new modeling capabilities. - Procedures
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.
Please let me know in case of any clarifications required. Thanks!