[Q76-Q91] 2023 Verified PL-300 dumps Q&As on your Microsoft Certified: Power BI Data Analyst Associate Exam Questions Certain Success!

Q76. You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q77. You plan to develop a Power BI report that has a bar chart to display the number of customers by location.
You have a table named Customer that has the following columns:
* Customer ID
* CustomerName
* Address
* City
* ProvState
* Country
You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

Q78. For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing data. The solution must minimize development effort. Which type ol data source should you use?

Q79. You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

Which type of visual should you use?

Q80. You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Q81. You have a report that includes a card visualization.
You need to apply the following conditional formatting to the card while minimizing design effort.
For values that are greater than or equal to 100, the font of the data label must be dark red.
For values that are less than 100, the font of the data label must be dark gray.
Which type of format should you use?

Q82. You attempt to connect Purer 81 Desktop to a Cassandra database.
From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database.
Which of connector should you choose?

Q83. You have a Power Bl report that contains a page. The page contains the following:
* A shape named Shape 1
* A card named Sales Summary
* A clustered bar chart named Sales by Region
You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

Q84. You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Q85. You have the Power BI data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Q86. You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.

Q87. You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

Q88. You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.

Q89. You have a dataset that has the permissions shown in the following exhibit.

Q90. You need to create a relationship in the dataset for RLS.
What should you do? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q91. You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

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.