PL-300 exam

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . a line chart that shows balances by quarter filtered to account categories that are long-term...

DRAG DROP You receive revenue data that must be included in Microsoft Power Bl reports. You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit. You plan to create several visuals from the data, including a visual that shows revenue split...

You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?A . Create a horizontal line that has a fixed value of 24,000.B . Add a measure to the visual that...

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?A . Change lite OrderlD column in the Orders table to the text data type.B . Filter out discontinued products while importing the Product table.C . Remove the QuantityPerUnit column from...

You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?A . area chartB . donut chartC . scatter plotD . pie chartView AnswerAnswer: C Explanation: Outliers are those data points that lie outside...

HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario: The sales managers require a visual...

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City [State...

HOTSPOT You have an API that returns more than 100 columns. The following is a sample of column names. ✑ client_notified_timestamp ✑ client_notified_source ✑ client_notified_sourceid ✑ client_notified_value ✑ client_responded_timestamp ✑ client_responded_source ✑ client_responded_sourceid ✑ client_responded_value You plan to include only a subset of the returned columns. You need to remove...

You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: ✑ Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are...

Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?A . videoB . custom streaming dataC . text boxD . web contentView AnswerAnswer: D Explanation: https://docs.microsoft.com/en-us/stream/portal-embed-video https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content