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

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

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

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

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

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

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.

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

160.2- 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. 2- BOX 2

• Image Tagging
• Key Phrase Extraction
• Language Detection
• Sentiment Analysis

160.3- 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. 3- BOX 3

• Image Tagging
• Key Phrase Extraction
• Language Detection
• Sentiment Analysis

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.
• B. From Power BI Desktop, modify the Data Load settings.
• C. From the Power BI service, modify the dataset permissions.
• D. From the Power BI service, modify the Report settings