Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps
https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection.
You need to ensure that users can use Q&A from the Power BI service for the dataset.
What should you do?

• A.From the Power Bi service, select Turn on Q& A for this dataset.
• B.From Power BI Desktop, add a Q&A visual to the report.
• C.From Power BI Desktop, add synonyms and suggested questions.
• D.From the Power BI service, add an enterprise gateway to the dataset.

Comment: *

Name: *

Email: *

Verification: *

You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

• A.1318
• B.1319
• C.21318 Lasalle Street
• D.21319 Lasalle Street

Correct Answer: D

Example:
Replace the text "ur" with the text "or" in the table.

Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

Comment: *

Name: *

Email: *

Verification: *

You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

• A.Add a measure to the visual that uses the following DAX expression. Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
• B.Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
• C.Create a horizontal line that has a fixed value of 24,000.
• D.Add a measure to the visual that uses the following DAX expression. Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],6.40)

Comment: *

Name: *

Email: *

Verification: *

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages .
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• A.Create a bookmark for each slicer value.
• B.Replace the slicers with visual-level filters.
• C.Replace the slicers with report-level filters.
• D.Replace the slicers with page-level filters.
• E.Sync the slicers across the pages.

Comment: *

Name: *

Email: *

Verification: *