Power BI Flashcards
What does this button on the formula bar do?
Check mark
What does this button on the formula bar do?
Validates and enters the measure into the model.
What always surrounds a column name in a DAX formula?
What does this button on the formula bar do?
Brackets [].
Previous Quarter Sales = CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSQUARTER(Calendar[DateKey]))
In a Power BI Desktop model design, which type of object do you create to enforce row-level security?
Table
Column
Measure
Role
In a Power BI Desktop model design, which type of object do you create to enforce row-level security?
Table
Column
Measure
*Role
A role consists of one or more rules, which are DAX formulas that are used to filter table rows. Roles define row-level security.
Which of the following statements is correct regarding a star schema design?
Fact tables store accumulations of business events.
Fact tables store accumulations of business entities.
Fact tables must have a unique column.
Which of the following statements is correct regarding a star schema design?
*Fact tables store accumulations of business events.
Fact tables store accumulations of business events, like sales orders or currency exchange rates.
Fact tables store accumulations of business entities.
Fact tables must have a unique column.
In what order does an analytic query implement its phases?
Filter, Group, Summarize
Group, Filter, Summarize
Summarize, Filter, Group
In what order does an analytic query implement its phases?
*Filter, Group, Summarize
Filter is used to first restrict the data to query. Group then divides the query result into groups. Summarize then produces single value aggregations for each group.
Group, Filter, Summarize
Summarize, Filter, Group
You’re using Power BI Desktop to develop a model. It has a table named Sales, which includes a column named CustomerKey. In reports, you need a calculation to show the number of different customers who have placed orders. What type of DAX calculation will you add to the model?
Calculated table
Calculated column
Computed column
Measure
You’re using Power BI Desktop to develop a model. It has a table named Sales, which includes a column named CustomerKey. In reports, you need a calculation to show the number of different customers who have placed orders. What type of DAX calculation will you add to the model?
Calculated table
Calculated column
Computed column
*Measure
You can add a measure to the Sales table by using the DISTINCTCOUNT DAX function.
You’re using Power BI Desktop to develop a model. It has a table named Customer, which includes a column named DateOfBirth. In reports, you need to group customers by current age. What type of DAX calculation will you add to the Customer table?
Calculated table
Calculated column
Computed column
Measure
You’re using Power BI Desktop to develop a model. It has a table named Customer, which includes a column named DateOfBirth. In reports, you need to group customers by current age. What type of DAX calculation will you add to the Customer table?
Calculated table
*Calculated column
A calculated column can store the current age for each customer. This column could then be used in reports to group customers by age.
Computed column
Measure
You’re using Power BI Desktop to develop a model. It has a table named Geography, which has two relationships to the Sales table. One relationship filters by customer region and the other filters by sales region. You need to create a role-playing dimension so that both filters are possible. What type of DAX calculation will you add to the model?
Calculated table
Calculated column
Computed column
Measure
You’re using Power BI Desktop to develop a model. It has a table named Geography, which has two relationships to the Sales table. One relationship filters by customer region and the other filters by sales region. You need to create a role-playing dimension so that both filters are possible. What type of DAX calculation will you add to the model?
*Calculated table
A calculated table could create a table that duplicates the Geography table data. It could then have an active relationship to the Sales table. Both geography tables would have active relationships to allow report users to filter by customer region or sales region.
Calculated column
Computed column
Measure
You write a DAX formula that adds BLANK to the number 20. What will be the result?
The result will be zero (0).
The result will be 20.
The result will be BLANK.
The result will be NULL.
You write a DAX formula that adds BLANK to the number 20. What will be the result?
The result will be zero (0).
*The result will be 20.
BLANK is converted to zero when added to a number.
The result will be BLANK.
The result will be NULL.
