You have a query that contains customer data in Power Query Editor as shown in the following exhibit.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?

• A.Use the Test as role option to view data as the salesperson's user account.
• B.Use the Test as role option to view data as the Sales role.
• C.Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
• D.Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Correct Answer: A

Validate the roles within Power BI Desktop
* After you've created your roles, test the results of the roles within Power BI Desktop.From the Modeling tab, select View as.
A picture containing application Description automatically generatedThe View as roles window appears, where you see the roles you've created.Graphical user interface, text, application Description automatically generated


* Select a role you created, and then select OK to apply that role.The report renders the data relevant for that role.
* You can also select Other user and supply a given user.Graphical user interface, application Description automatically generated
* Select OK.The report renders based on what that user can see.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
You have the Azure SQL databases shown in the following table.

You plan to build a single PBIX file to meet the following requirements:
- Data must be consumed from the database that corresponds to each
stage of the development lifecycle.
- Power BI deployment pipelines must NOT be used.
- The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
To meet the requirements specified, we can use a single parameter in the PBIX file that controls which database is used for data consumption based on the stage of the development lifecycle.
We can use a Text parameter type in Power BI to achieve this. The parameter can be used to switch between the different database connections when a user interacts with the report. The text parameter could include values such as "Development", "Staging", and "Production", which correspond to the different databases shown in the table.
The parameter can then be used in the queries to dynamically filter the data based on the selected stage of the development lifecycle. By using a single parameter, we can minimize administrative effort and ensure that the report works with each stage of the development lifecycle.

Comment: *

Name: *

Email: *

Verification: *

You need to create a Power BI report. The first page of the report must contain the following two views:
*Sales By Postal Code
*Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.

The Sales By Month view must display a column chart visual as shown in the following exhibit.

Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views.
What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a dataset that is used infrequently and refreshes every hour.
You receive a notification that the refresh was disabled due to inactivity.
Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.Enable query caching for the dataset.
• B.Import the dataset to Microsoft Excel.
• C.From the Power BI service, open a dashboard that uses the dataset.
• D.From the Power BI service, open a report that uses the dataset.
• E.From PowerShell, run the get-powerbireport cmdlet.

Comment: *

Name: *

Email: *

Verification: *