Topic 4 - Question Set 4

Question #1 Topic 4: HOTSPOT - You have a Power BI tenant that hosts the datasets shown in the following table. You have the following requirements: The export of reports that contain Personally Identifiable Information (PII) must be prevented. Data used for financial decisions must be reviewed and approved before use. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. YES: tick NO: not tick Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-security-sensitivity-label-overview Hot Area:

• The Sales dataset requires a sensitivity label.
• The Operations dataset requires a sensitivity label and must be certified.
• The Finance dataset requires a sensitivity label and must be certified.

Question #2 Topic 4: You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement?

• A. Microsoft Intune policies
• B. row-level security (RLS)
• C. sensitivity labels
• D. dataset certifications

Question #3 Topic 4: You have a Microsoft Excel file on a file server. You create a Power BI report and import a table from the Excel file. You publish the report. You need to ensure that the data refreshes every four hours. What should you do first?

• A. Upload the Excel file to a Power BI workspace.
• B. Create a subscription to the report
• C. Deploy an on-premises data gateway.
• D. Edit the data source credentials.

Question #4 Topic 4: 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.

Question #5 Topic 4: You have a Power BI workspace that contains a dataset, a report, and a dashboard. The following groups have access: ✑ External users can access the dashboard. ✑ Managers can access the dashboard and a manager-specific report. ✑ Employees can access the dashboard and a row-level security (RLS) constrained report. You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised. What should you use?

• A. comments
• B. chat in Microsoft Teams
• C. alerts
• D. subscriptions

Question #6 Topic 4: You have a PBIX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do?

• A. From Power Query Editor, create new queries
• B. From Power Query Editor, modify the source of each query.
• C. Create a PBIT file, open the file, and change the data sources when prompted.
• D. Modify the Data source settings

Question #7 Topic 4: You have a Power BI workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?

• A. Create a row-level security (RLS) role and add the user to the role
• B. Share the reports with the user.
• C. Grant the Read permission for the datasets to the user.
• D. Add the user as a member of the workspace.
• E. Add the user as a Viewer of the workspace.

Question #8 Topic 4: You have a Power BI workspace that contains a single-page report named Sales. You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard. Which three 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.

• Pin the page
• Open powerbi.com
• Open the Sales report
• Open PowerBI desktop
• Pin each visual

Question #9 Topic 4: You have a report in Power BI named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report. The solution must prevent other reports from being affected. What should you do?

• A. Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.
• B. Apply row-level security (RLS) to the shared dataset.
• C. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.
• D. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.

Question #10 Topic 4: In Power BI Desktop, you are creating visualizations in a report based on an imported dataset. You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data. What should you do?

• A. From the Power BI service, configure the dataset permissions.
• B. From Power BI Desktop, configure the Data Load settings for the current file.
• C. From Power BI Desktop, modify the data source permissions.
• D. From Power BI Desktop, configure the Report settings for the current file.