You have the dashboard shown in the following exhibit. You need to modify the dashboard to display as shown in the following exhibit. What should you do?

Create and apply a custom dashboard theme.

Change the colors of the visuals in the report.

Apply the Dark dashboard theme.

Upload a snapshot image of the dashboard.

You build a Power Bi report that displays loT temperature data streaming from a refrigerator.You publish the report to the Power BI service.You need to be notified when the temperature rises above four degrees Celsius.What should you do?

Pin a report page to a dashboard and set an alert on the page.

Set an alert on a KPI visual in the report.

Pin a card visual to a dashboard and create a subscription.

Pin a card visual to a dashboard and set an alert on the tile.

Pin a report page to a dashboard and set an alert on the page.

You have a BI dataset and a connected report.You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset. You grant the users the Build permission for datasetWhat Should do next?

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

Change default visual interaction for the report

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

For the report, change the Export data setting to None

Certify the dataset used by the report.

You have a Power BI workspace named BI Data that contains a dataset named BI Finance.You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace, You need to connect to BI Finance and create a report. Which actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

From Power BI Desktop, connect to a Dataverse data source.

From the Power BI service, create a new report and select a published dataset

From the Power BI service, create a dataflow to the dataset by using DirectQuery.

From Power BI Desktop, connect to a Dataverse data source.

From the Power BI service, create a new report and select a published dataset

From Power Bl Desktop, connect to a shared dataset

You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals:Switch the measures used in the visuals.Change the visualization type.Add a legend.The solution must minimize development effort.What should you do?

Edit the interactions between the three visuals.

Enable personalization for each Visual.

Create a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart

Edit the interactions between the three visuals.

Enable personalization for the report

You have a Power BI report that contains four pages.All the pages contain a slicer for a field named Country,You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages, What should you do?

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.

Sync the Country slicer on page 1, page 2, and page 3.

Move the Country slicer from page 2 and page 3 to page 1.

You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?

From power Bl Desktop, use a built in report theme.

From Power Bl Desktop, customize the current theme,

From power Bl Desktop, use a built in report theme.

Create a theme as a JSON file and import the theme into Power Bl Desktop.

Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

You have a Power Bl 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 bar chart displays on Dashboard1.What should you do?

the Sales by month bar chart to Dashboard1

Edit the details for the dashboard tile of Dashboard1.

Select Refresh visuals for Dashboard1.

the Sales by month bar chart to Dashboard1

Refresh the dataset used by Report1 and Dashboard1.

You have a Power BI report named Report' and a dashboard named Dashboard'. 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 Dashboard',What should you do?

Refresh the dataset used by Report1 and Dashboard1.

Select Refresh visuals for Dashboard1.

Edit the details for the dashboard tile Of Dashboar1.

Pin the Sales by month bar chart to Dashboard1.

You use Power BI Desktop to load data from a Microsoft SQL Server database.While waiting for the data to load, you receive the following error. You need to resolve the error.What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Disable query folding on long running queries

Use Power Query to combine long running queries into one query.

Split long running queries into subsets Of columns and use power Query to the queries

Disable query folding on long running queries

Reduce number of rows and columns returned by each query.

Use Power Query to combine long running queries into one query.

You have a Power Bl report that contains five pages.Pages 1 to 4 are visible and page 5 is hidden.You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report. What should you do first?

Create a bookmark for each page.

Add a bookmark navigation button to page 1.

Create a bookmark for each page.

Add a page navigation button to page 1.

You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?

From Power Bl Desktop, customize the current theme.

Create a theme as a PBIVIZ file and import the theme into Power Bl Desktop.

Create a theme as a JSON file and import the theme into Power Bl Desktop.

From Power Bl Desktop, use a built-in report theme.

From Power Bl Desktop, customize the current theme.

You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.You publish the report to the Bl service.You need to be notified when the temperature rises above four degrees Celsius.What should you do?

Pin a report page to a dashboard and set an alert on the page.

Set an alert on a KPI visual in the report.

Pin a card visual to a dashboard and set an alert on the tile.

Pin a card visual to a dashboard and create a subscription.

A manager can represent only a single country.You need to use row-level security (RLS) to meet the following requirements:The managers must only see the data of their respective country.The number of RLS roles must be minimized.Which two actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

Create one role for each country.

For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

You are creating a report in Power BI Desktop.You load a data extract that includes a free text field named coll.You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do?

In the report, add a DAX calculated column that calculates the length of col1

In the report, add a DAX function that calculates the average length of col1

From Power Query Editor, add a column that calculates the length of col1

From Power Query Editor, change the distribution for the Column profile to group by length for col1

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format:2018-12-31 at 08:59.You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

Split the Logged column by using at as the delimiter.

Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

Change the data type of the Logged column to Date.

Split the Logged column by using at as the delimiter.

Apply a transformation to extract the first 11 characters of the Logged column.

What should you do to address the existing environment data concerns?

a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

a calculated column that uses the following formula: ABS(Sales[sales_amount])

a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

a measure that uses the following formula: SUM(Sales[sales_amount])

a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Microsoft PL-300 Practice Test 7 - Free Online Exam Prep & Questions

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report. What should you recommend?

Become a Premium Member for full access

Unlock Premium Member

Microsoft PL-300 Practice Test 7

Question

Microsoft PL-300 Practice Tests

Practice Tests