70-778

70-778 practice questions, page 5 of 6, with answer review and explanations.

Question 21

You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.) The model has the following relationships: ✑ Store to District based on DistrictID Sales to Store based on LocationID ✑ Sales to Date based on PeriodID ✑ Sales to Item based on ItemID You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage. When the district managers view the Store by Items report, they see items for all the stores. You need to ensure that the district managers can see items for the stores they manage only. How should you configure the relationship from Sales to Item?

  1. Select Assume Referential Integrity.
  2. Change the Cardinality to One to Many (1:*).
  3. Change the Cross filter direction to Both.
  4. Change the Cardinality to One to one (1:1).

Question 22

You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source. You need to ensure that you can use R visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  1. Download and install Microsoft R Server.
  2. Download and install RStudio Server on the computer that has Power BI Desktop installed.
  3. Install SQL Server R Services on the server that runs SQL Server.
  4. Enable R Scripting on the computer that has Power BI Desktop installed.
  5. Download and install Microsoft R on the computer that has Power BI Desktop installed.

Question 23

You have a Power BI model that contains the following two tables: ✑ Sales(Sales_ID, sales_date, sales_amount, CustomerID) ✑ Customer(CustomerID, First_name, Last_name) There is a relationship between Sales and Customer. You need to create a measure to rank the customers based on their total sales amount. Which DAX formula should you use?

  1. RANKX(ALL(Sales), SUMX(RELATEDTABLE(Customer), [Sales_amount]))
  2. TOPN(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
  3. RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
  4. RANK.EQ(Sales[sales_amount], Customer[CustomerID])

Question 24

You have a Microsoft SharePoint Online site named Sales. Your company has 1,000 sales users. All the sales users can access Sales. You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part. You need to ensure that all the sales users can view the report from the Sales site. What should you do?

  1. Configure the Portal Site Connection for the Sales site.
  2. Enable anonymous access for the Sales site.
  3. Configure the app workspace for Premium capacity.
  4. Disable the Embed content in apps setting from the Tenant settings in Power BI.

Question 25

You plan to deploy a Power BI app workspace that will be viewed by 10,000 users. You need to ensure that dashboard data can be updated every 30 minutes. What should you do?

  1. Assign each user a Power BI Pro license.
  2. Store the dataset in Microsoft Azure Storage that uses the Premium storage tier.
  3. Create the app workspace by using an account that is assigned a Power BI Pro license.
  4. Configure the app workspace for Premium capacity.