You are developing a sales report that will have multiple pages. Each page will answer a different business question. You plan to have a menu page that will show all the business questions.You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.What should you include on the menu page?

Create a button for each business question and set the action type to Bookmark.

Create a text box for each business question and insert a link.

Create a button for each business question and set the action type to Bookmark.

Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique. In powerbi.com, when users load the visual, they only see some of the customers.What is the cause of the issue?

Too many records were sent to the visual.

The visual was built by using a different version of R.

The data comes from a Microsoft SQL Server source.

Too many records were sent to the visual.

You have a line chart that shows the number of employees in a department over time.You need to see the total salary costs of the employees when you hover over a data point.What is possible way to achieve this goal?

Add a salary to the visual filters.

Add salary to the drillthrough fields.

You have the dataset shown in the following exhibit. You need to ensure that the visual shows only the 10 cities that have the highest sales profit.What should you do?

Add a Top N filter to the visual.

Configure the Sales Profit measure to use the RANKX function.

Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.

Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column. D18912E1457D5D1DDCBD40AB3BF70D5D

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an onpremises Oracle database and an Azure SQL database by using one query. You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured. You need to ensure that the data is updated every morning. The solution must minimize configuration effort. Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Configure the dataset to use the existing On-premises data gateway.

Set the refresh frequency to Daily.

Configure the dataset to use the existing On-premises data gateway.

Deploy an On-premises data gateway in personal mode.

Set the refresh frequency to Daily.

Configure the dataset to use the personal gateway.

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity. You discover that the dataset refresh fails after the refresh runs out of resources.What is a possible cause of the issue?

Query folding is not occurring.

You selected Only refresh complete periods.

The data type of the column used to partition the data changed.

A filter is missing on the report.

You have a Microsoft Power BI 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 AppSource 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?

Remove unused columns from tables in the data model.

Change any DAX measures to use iterator functions.

Replace the default visuals with AppSource visuals.

Change the imported dataset to DirectQuery.

Remove unused columns from tables in the data model.

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?

Microsoft Information Protection sensitivity labels

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI. You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets. What should you recommend?

Create a workspace for development and a workspace for production. From the production workspace, publish an app.

Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.

Create one workspace for development. From the new workspace, publish an app for production.

Create a workspace for development and a workspace for production. From the production workspace, publish an app.

In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

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 ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

a scheduled refresh of the dataset

You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit. You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model. What should you do?

Add airline as a synonym of carrier.

Add a duplicate query named Airline.

Add airline as a synonym of carrier.

Rename the carrier column as airline in the Carriers query.

Rename the query from Carriers to airlines.

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

From Power Bi Desktop, use the Auto date/time option when creating the reports.

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

From Power Bi Desktop, use the Auto date/time option when creating the reports.

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column

ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table. The table has 12 million rows. All the columns are needed for analysis.You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data. What should you do?

Split the DateTime column into separate date and time columns.

Round the Longitude column two decimal places.

Change the data type of the TempCelsius column to Integer

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?

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

From Power BI Desktop, configure the Data Load settings for the current file.

From the Power BI service, configure the dataset permissions.

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

From Power BI Desktop, modify the data source permissions.

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

Performance Analyzer in Power BI Desktop

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?

Import the Date table twice in Power Query and create active relationships between Sales and both Date tables in the modeling view.

Use the Auto Date/Time functionality in Microsoft Power Bl and do NOT import the Date table.

Duplicate the Date query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

Import the Date table twice in Power Query and create active relationships between Sales and both Date tables in the modeling view.

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have rowQuestions & Answers PDF P-145 level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings. What should you do?

Create an active relationship between the tables and select Apply security filter in both directions.

Create an active relationship between the tables and select Assume referential integrity.

Create an inactive relationship between the tables and select Assume referential integrity.

Create an inactive relationship between the tables and select Apply security filter in both directions.

Create an active relationship between the tables and select Apply security filter in both directions.

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

Question 1 / 40

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary.

Solution: You create a constant line and set the value to .5.

Does this meet the goal?

Become a Premium Member for full access

Unlock Premium Member

Microsoft PL-300 Practice Test 3

Question

Microsoft PL-300 Practice Tests

Practice Tests