Practice Free PL-300 Exam Online Questions
You plan to generate a line chart to visualize and compare the last six You need to Increase the accessibility of the visual.
What should you do?
- A . Configure a unique marker for each series
- B . Configure a distinct color for each series.
- C . Replace long text with abbreviation and acronyms.
- D . Move important Information to a tooltip.
DRAG DROP
You use Power Query Editor to load two queries named Query 1 and Query2 Query1 results in the following error.
You need to create a visual that compares profit across 10 product categories for a selected quarter.
What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select the BEST answer.
- A . an area chart
- B . a clustered bar chart
- C . a line chart
- D . a funnel chart
DRAG DROP
You have a Power B1 data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content. NOTE: Each correct selection is worth one point
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 several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You enable included in app for all assets.
Does this meet the goal?
- A . Yes
- B . No
You embed a Power BI report in a Microsoft SharePoint Online page.
A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: “This content isn’t available”.
User1 is unable to view the report.
You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.
You need to ensure that User1 can view the report form SharePoint Online.
What should you do?
- A . Publish the app workspace.
- B . Edit the settings of the Power BI web part.
- C . Modify the members of the app workplace.
- D . Share the dashboards in the app workspace.
C
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo
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?
- A . Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
- B . Change the data type of the Logged column to Date.
- C . Split the Logged column by using at as the delimiter.
- D . Apply a transformation to extract the first 11 characters of the Logged column.
C
Explanation:
Simply create a custom table in Power Query, enter the date shown in the question into a column called Date, and then Split it by a delimiter. No need for spaces on either side of "at" Power BI takes care of the rest:
= Table.SplitColumn(#"Changed Type", "Date", Splitter.SplitTextByDelimiter("at", QuoteStyle.Csv), {"Date.1", "Date.2"})
It will even automatically change the type to Date:
= Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type date}, {"Date.2", type time}})
Vow have a Power 81 semantic model named Modell that runs in Import storage mode. Vou need to reduce the size of Model 1. The solution must NOT increase report query response times.
What should you do?
- A . Unpivot unnecessary columns.
- B . Rename unnecessary columns.
- C . Change Model1 to DirectQuery storage mode.
- D . Remove unnecessary columns.
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.
Solution: You create aggregations to summarize results.
Does this meet the goal?
- A . Yes
- B . No
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 dataset
What Should do next?
- A . Change default visual interaction for the report
- B . For the report change the Export data setting to Summarized data, data with current layout and underlying data
- C . For the report, change the Export data setting to None
- D . Certify the dataset used by the report.