p351-370

Question 1

351. You have a Power BI report named Report1.

You plan to share Report1 with multiple users.

You need to add the users to a group.

Which two types of groups can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Accepted Answer

security group

Accepted Answer

Microsoft 365 group

Answer

distribution group

Answer

Microsoft Teams team

Question 2

352. You plan to create a Power BI report that will be connected to multiple data sources. One of the data sources contains tax records.

You need to ensure that other queries cannot access the tax record information.

To what should you set Privacy Level for the data source?

Accepted Answer

Private

Answer

None

Answer

Organizational

Answer

Public

Question 3

353. You need to create the dataset.

Which dataset mode should you use?

Accepted Answer

Import

Answer

DirectQuery

Answer

Composite

Answer

live connection

Question 4

354. You need to configure access for the sales department users. The solution must the meet the security requirements.

What should you do?

Accepted Answer

Add the sales department as a member of the reports workspace.

Answer

Share each report to the Azure Active Directory group of the sales department.

Answer

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

Answer

Distribute an app to the users in the Azure Active Directory group of the sales department.

Question 5

355. You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

dashboard
data alert

Answer

report 
data alert

Answer

dashboard
phone view

Question 6

356. You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.

What should you set as the relationship cardinality?

Accepted Answer

One to many

Answer

One to one

Answer

Many to many

Answer

Many to one

Question 7

357. You need to create a measure that returns the percent of revenue by product category.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Accepted Answer

CALCULATE
ALL
DIVIDE

Answer

CALCULATE
ALLEXCEPT
DIVIDE

Question 8

358. Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? 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:

Select and Place:

Accepted Answer

From Power BI Desktop, create four roles.
From Power BI Desktop, add a Table Filter DAX Expression to the roles.
From Power BI Desktop, publish the dataset to powerbi.com.
From powerbi.com, add role members to the roles.

Answer

From Power BI Desktop, create four roles.
From Power BI Desktop, add a Table Filter DAX Expression to the roles.
From powerbi.com, add role members to the roles.
From Power BI Desktop, publish the dataset to powerbi.com.

Question 9

359. Which DAX expression should you use to get the ending balances in the balance sheet reports?

Accepted Answer

CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), LASTDATE ( 'Date'[Date] ) )

Answer

CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), DATESQTD('Date'[Date]) )

Answer

FIRSTNONBLANK ('Date'[Date] SUM( BalanceSheet[BalanceAmount] ) )

Answer

CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE ('Date'[Date] ))

Question 10

360.You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

Accepted Answer

an additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_skip_date_id]

Answer

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

Answer

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]

Answer

an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]

Question 11

361. You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

Accepted Answer

Create a security role that has a table filter on the Sales Manager table where username = UserName().

Answer

Create a security role that has a table filter on the Sales Manager table where username = sales_manager_id.

Answer

Create a security role that has a table filter on the Region Manager table where sales_manager_id = UserPrincipalName().

Answer

Create a security role that has a table filter on the Sales_Manager table where name = UserName().

Question 12

362. You merge data from Sales_Region, Region_Manager, Sales_Manager, and Manager into a single table named Region.

What should you do next to meet the reporting requirements of the executives?

Accepted Answer

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Answer

Create a DAX calculated column that retrieves the region manager from the Weekly_Returns table based on the sales_region_id column.

Answer

Apply row-level security (RLS) to the Region table based on the sales manager username.

Answer

Configure a bi-directional relationship between Region and Sales_Region.

Question 13

363. What should you create to meet the reporting requirements of the sales department?

Accepted Answer

a measure that uses a formula of COUNTROWS(Sales)

Answer

a calculated column that use a formula of COUNTA(Sales[sales_id])

Answer

a calculated column that uses a formula of SUM(Sales[sales_id])

Answer

a measure that uses a formula of SUM(Sales[sales_id])

Question 14

364. What should you do to address the existing environment data concerns?

Accepted Answer

a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

Answer

a calculated column that uses the following formula: ABS(Sales[sales_amount])

Answer

a measure that uses the following formula: SUM(Sales[sales_amount])

Answer

a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Question 15

365. You need to create a calculated column to display the month based on the reporting requirements.

Which DAX expression should you use?

Accepted Answer

FORMAT('Date'[date],"MMM YYYY")

Answer

FORMAT('Date'[date_id],"MMM") & " " & FORMAT('Date'[year], "#")

Answer

FORMAT('Date'[date_id],"MMM YYYY")

Answer

FORMAT('Date'[date],"M YY")

Question 16

366. You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

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:

Accepted Answer

no yes no

Answer

no no yes

Answer

yes yes yes

Answer

no no no

Question 17

367. You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Accepted Answer

CALCULATE
FILTER
Orders[ShippedDate]>Orders[RequiredDate]

Answer

SUM
FILTER
Orders[ShippedDate]>Orders[RequiredDate]

Answer

CALCULATE
FILTER
Orders[ShippedDate]<Orders[RequiredDate]

Question 18

368. You need to minimize the size of the dataset. The solution must meet the report requirements.

What should you do?

Accepted Answer

Remove the QuantityPerUnit column from the Products table.

Answer

Group the Categories table by the CategoryID column.

Answer

Filter out discontinued products while importing the Products table.

Answer

Change the OrderID column in the Orders table to the Text data type.

Question 19

369. You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

Accepted Answer

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Answer

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

Answer

From Power BI Desktop, use the Auto date/time option when creating the reports.

Answer

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.