161- You have a Power BI report named ReportA. You have a Power BI tenant that allows users to export data. You need to ensure that consumers of ReportA cannot export any data from visuals. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point

A. From Power BI Desktop, modify the Report settings.

D. From the Power BI service, modify the Report settings

B. From Power BI Desktop, modify the Data Load settings.

C. From the Power BI service, modify the dataset permissions.

162- You have a Power BI report that will be rendered on a vertical display. You need to maximize the portion of the screen area used by the report. What should you do?

B. From the Canvas settings of Power BI Desktop, set a custom width and height.

A. From the Canvas background setting of Power BI Desktop, configure the Image fit setting.

C. From Power BI Desktop, select Personalize visuals.

D. From the Power BI service, enable the Pages pane.

164- You have a Power BI dataset named Finance that is hosted in a Power BI workspace. The finance team at your company is NOT currently a member of any Power BI workspace roles. You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset. What should you do?

A.Grant the finance team build permissions to the Finance dataset.

B.Provide an Excel workbook that is connected to the Finance dataset.

C.Create a row-level security (RLS) role and add the finance team to the role as members.

D.Grant the finance team write permissions to the Finance dataset.

165- You have a Power BI report that contains a visual. The visual contains a measure. You need to ensure that the report meets the following requirements: •All values must be set to two decimal places. •All negative values must be displayed in red font and parentheses. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

B. Configure the measure to use a custom format.

C. For the visual, apply conditional formatting to the font color.

A. For the visual, apply conditional formatting to the background color.

D. For the visual, set Value decimal places to 2.

168- 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?

C. Deploy an on-premises data gateway.

A. Upload the Excel file to a Power BI workspace.

B. Create a subscription to the report.

D. Edit the data source credentials.

169- 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.

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.

A. Enable query caching for the dataset.

B. Import the dataset to Microsoft Excel.

E. From PowerShell, run the get-powerbireport cmdlet

171- 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?

D. Modify the Data source settings.

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.

172- 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?

D. Add the user as a member of the workspace.

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.

E. Add the user as a Viewer of the workspace

174- 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?

D. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.

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.

175- 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?

D. From Power BI Desktop, configure the Report settings for the current file.

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.

176- You have a Power BI report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets, or dashboards. What should you do?

C. Instruct the Azure network security team to create security groups. Configure RLS to use the groups.

A. Grant the Read and Build permissions for the Power BI datasets to the Azure network security team.

B. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.

D. Add the Azure network security team as members of the RLS role.

177- You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant mail-enabled security group to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions. A sales manager changes to a different region. You need to ensure that the sales manager can see the correct sales data. What should you do?

D. Request that the sales manager be added to the correct Azure Active Directory group.

A. Change the Microsoft Power BI license type of the sales manager.

B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.

C. Manage the permissions of the underlying dataset.

178- You have more than 100 published datasets. Ten of the datasets were verified to meet your corporate quality standards. You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do?

C. Feature the dataset on the home page.

D. Publish the datasets in an app.

180- You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the Viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

C. Share the dashboard to the user.

181- You have a Power BI workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data in DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user. What should you do?

B. Grant the Build permission for DS1 to the user.

A. Add the user as a Viewer of Workspace1.

D. Add the user as a member of Workspace1.

185- From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

A. From powerbi.com, add users to the HR role for the dataset.

B. From powerbi.com, share the dataset to the HR team members.

C. From Power BI Desktop, change the Row-Level Security settings.

D. From Power BI Desktop, import a table that contains the HR team members.

187- You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network. You plan to publish the report to the Power BI Service. What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

D. a scheduled refresh of the dataset

188- 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 BI Desktop.

D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

189- You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use?

A. Microsoft Information Protection sensitivity labels

194- You have a Power BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset. You grant the users the Build permission for the dataset. What should you do next?

D. For the report, change the Export data setting to Summarized data, data with current layout and underlying data.

A. Certify the dataset used by the report.

B. Change the default visual interaction for the report.

C. For the report, change the Export data setting to None.

195.1- HOTSPOT You have two Power BI workspaces named WorkspaceA and WorkspaceB. WorkspaceA contains two datasets named Sales and HR. You need to provide a user named User1 with access to the WorkspaceB. The solution must meet the following requirements: • Create reports that use the HR dataset. • Publish the reports to WorkspaceB. • Prevent the ability to modify the HR dataset. • Prevent the ability to add users to Workspaces. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 1- BOX 1

Grant User1 the Build permission for the HR dataset.

Assign User1 the Contributor role for WorkspaceA.

Grant User1 read permissions for the HR dataset.

Grant User1 share permissions for the HR dataset.

195.2- HOTSPOT You have two Power BI workspaces named WorkspaceA and WorkspaceB. WorkspaceA contains two datasets named Sales and HR. You need to provide a user named User1 with access to the WorkspaceB. The solution must meet the following requirements: • Create reports that use the HR dataset. • Publish the reports to WorkspaceB. • Prevent the ability to modify the HR dataset. • Prevent the ability to add users to Workspaces. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 2- BOX 2

Assign User1 the Contributor role for WorkspaceB.

Assign User1 the Admin role for Workspaces.

Assign User1 the Contributor role for WorkspaceA.

Assign User1 the Member role for Workspace B.

196- Overview - Litware, Inc. is an online retailer that uses Power BI. Litware plans to leverage data from an Azure SQL database that stores data for the company's live e-commerce website. Litware uses Azure Active Directory (Azure AD) to authenticate users. Existing Environment. Sales Data Litware has online sales data that has the SQL schema shown in the following table. The sales managers require a visual to analyze sales performance versus sales targets. The sales department requires reports that contain the number of sales transactions. Users must be able to see the month in each report as shown in the following example: Feb 2020. The customer service department requires a visual that can be filtered by both sales month and ship month independently. The maximum allowed latency to include transactions in reports is five minutes. Question You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

A. Change the data type of Sales[region_id] to Whole Number.

B. Change the data type of Sales[region_id] to Decimal Number.

C. In the Sales table, add a measure for Sum(sales_amount).

D. Change the data type of Sales[sales_id] to Text.

197- Overview - Litware, Inc. is an online retailer that uses Power BI. Litware plans to leverage data from an Azure SQL database that stores data for the company's live e-commerce website. Litware uses Azure Active Directory (Azure AD) to authenticate users. Existing Environment. Sales Data The sales managers require a visual to analyze sales performance versus sales targets. The sales department requires reports that contain the number of sales transactions. Users must be able to see the month in each report as shown in the following example: Feb 2020. The customer service department requires a visual that can be filtered by both sales month and ship month independently. The maximum allowed latency to include transactions in reports is five minutes. Question You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection?

C. DirectQuery that uses a database credential

A. Import that uses a Microsoft account

B. Import that uses a database credential

D. DirectQuery that uses the end-user's credentials

199- Users in the sales department must be able to access only the data of the sales region to which they are assigned in the Sales Employees table. Power BI has the following row-level security (RLS) Table filter DAX expression for the Sales Employees table. [EmailAddress] = USERNAME() RLS will be applied only to the sales department users. Users in all other departments must be able to view all the data. Question You need to configure access for the sales department users. The solution must the meet the security requirements. What should you do?

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

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

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

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

PART 3-PL-300-Power BI Data Analyst Associate (Intermediate LV1)

Quiz

•

others

•

Practice Problem

•

Medium

Ly Hung Lai

Used 1+ times

FREE Resource

84 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

155- You plan to use Power BI to create sales invoices for customers. The solution must meet the following requirements: •Sales invoices must be exported in a PDF format. •The PDF exports must show all columns and rows clearly. What should you create?

A.a paginated report that contains a tablix

B.a dashboard that contains a table

C.an interactive report that contains a table

D.an interactive report that contains a matrix

MULTIPLE CHOICE QUESTION

1 min • 1 pt

156.1-DRAG DROP You have a Power BI report that contains three pages. The pages are used to analyze sales across various countries. You add a slicer named Country to each page of the report. You need to configure the report to meet the following requirements: •When a user selects a country on the first page, the report must filter the other pages. •The second and third pages must display only the filtered results. Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point 1- BOX 1

Add the Country field to the filters on all the pages

Configure the Country slicer to sync across all the pages

Configure the Country slicer to sync only on the second and third pages

Hide the Country slicer on the second and third pages

MULTIPLE CHOICE QUESTION

1 min • 1 pt

156.2-DRAG DROP You have a Power BI report that contains three pages. The pages are used to analyze sales across various countries. You add a slicer named Country to each page of the report. You need to configure the report to meet the following requirements: •When a user selects a country on the first page, the report must filter the other pages. •The second and third pages must display only the filtered results. Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point 2- BOX 2

Add the Country field to the filters on all the pages

Configure the Country slicer to sync across all the pages

Configure the Country slicer to sync only on the second and third pages

Hide the Country slicer on the second and third pages

MULTIPLE CHOICE QUESTION

1 min • 1 pt

157- You have a Power BI report that contains a page. The page contains the following: •A shape named Shape1 •A card named Sales Summary •A clustered bar chart named Sales by Region You need to ensure that Sales Summary renders on top of Shape1. What should you modify?

A.Tab order in the Selection pane

B.Layer order in the Selection pane

C.Maintain layer order in the General visual settings

D.Vertical alignment in the Canvas settings

MULTIPLE CHOICE QUESTION

1 min • 1 pt

158- You have a Power BI report named Report1 and a dashboard named Dashboard1. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard1. What should you do?

A.Refresh the dataset used by Report1 and Dashboard1.

B.Pin the Sales by month bar chart to Dashboard1.

C.Select Refresh visuals for Dashboard1.

D.Edit the details for the dashboard tile of Dashboard1

MULTIPLE SELECT QUESTION

1 min • 1 pt

159- In Power BI Desktop, you are creating a report that will contain three pages. You need to create a custom tooltip page and prepare the page for use. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. For the tooltip page, set Allow use as tooltip to On.

B. For the target page, set Allow use as tooltip to On.

C. Configure filters on the target visual.

D. For the tooltip page, configure filters.

E. Add and configure visuals on the tooltip page.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

160.1- DRAG DROP You need to use AI insights to add a column of enhanced data based on the customer feedback. The solution must identify the following: • What the customers most often provide feedback about • Whether the customers like your company’s product • The language of the feedback Which AI insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. 1- BOX 1

Image Tagging

Key Phrase Extraction

Language Detection

Sentiment Analysis

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

79 questions

World War 2 Review

Quiz

•

86 questions

Yr 8 Versus Computer Studies!

Quiz

•

8th Grade

81 questions

TSFA Level 1 Practice Test

Quiz

•

KG - University

86 questions

K11-15P SỐ 7-TV U5 (Getting started & Reading)

Quiz

•

KG - University

82 questions

LICH SU 12

Quiz

•

KG - University

86 questions

Semester 1 Stems/Vocabulary Review

Quiz

•

KG - University

81 questions

Review _Objectives: Pt1

Quiz

•

KG - University

80 questions

Final

Quiz

•

12th Grade

Popular Resources on Wayground

10 questions

Honoring the Significance of Veterans Day

Interactive video

•

6th - 10th Grade

9 questions

FOREST Community of Caring

Lesson

•

1st - 5th Grade

10 questions

Exploring Veterans Day: Facts and Celebrations for Kids

Interactive video

•

6th - 10th Grade

19 questions

Veterans Day

Quiz

•

5th Grade

14 questions

General Technology Use Quiz

Quiz

•

8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Circuits, Light Energy, and Forces

Quiz

•

5th Grade

19 questions

Thanksgiving Trivia

Quiz

•

6th Grade

Discover more resources for others

10 questions

Honoring the Significance of Veterans Day

Interactive video

•

6th - 10th Grade

9 questions

FOREST Community of Caring

Lesson

•

1st - 5th Grade

10 questions

Exploring Veterans Day: Facts and Celebrations for Kids

Interactive video

•

6th - 10th Grade

19 questions

Veterans Day

Quiz

•

5th Grade

14 questions

General Technology Use Quiz

Quiz

•

8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Circuits, Light Energy, and Forces

Quiz

•

5th Grade

19 questions

Thanksgiving Trivia

Quiz

•

6th Grade