Power Bi 5

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and
Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter.

Date[Calendar Year] = 2020
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

• The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.

• The user will receive an error and will not be able to see the data in the report.

• The user will only see data for which the State Province value is Kentucky.

• The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?

• Yes

• No

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?

• Yes

• No

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?

• Yes

• No

You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:
✑ Visualizations that include all measures in the data over time
✑ Year-over-year calculations for all the measures
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

• use headers as first row, rename the attribute column as Year, Change the data type of the Year column to Date

• Transpose Table, Use first rows as headers, Unpivot all the columns other than Measure, Rename the Measure column as Year

• Transpose Table, Use first rows as headers, Unpivot all the columns other than Measure, Change the data type of the Year column to Date

You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.
There are no reporting requirements on employee_id and employee_photo.
You need to optimize the data model.
What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

• Hide, Sort

• Delete, Hide

• Hide, Delete

• Delete, Change Type

You have the Power BI model shown in the following exhibit.

There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only.
What should you do?

• Create a slicer that filters Departments based on DepartmentID.

• Create a row-level security (RLS) role for each department, and then define the membership of the role.

• Create a DepartmentID parameter to filter the Departments table.

• Use filters to limit data visibility by date.To the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function.

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?

• • Create an inactive relationship between the tables and select Apply security filter in both directions.

• • Create an active relationship between the tables and select Apply security filter in both directions.

• • Create an inactive relationship between the tables and select Assume referential integrity.

• • Create an active relationship between the tables and select Assume referential integrity.

You have a column named UnitsInStock as shown in the following exhibit.

UnitsInStock has 75 non-null values, of which 51 are unique.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

• 75, reduce

• 51, reduce

• 51. 51, increase

• 75, maintain

You have a Power BI report.
You have the following tables.

You have the following DAX measure.
Accounts :=
CALCULATE (
DISTINCTCOUNT (Balances[AccountID]),
LASTDATE ('Date'[Date])
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

• Yes, Yes, No

• No, No, No

• Yes, Yes, Yes

• No, No, Yes