Microsoft PL-300 Practice Exam Questions

Microsoft PL-300 Sample Question Answers

Question # 1

You are creating a Power BI report to analyze consumer purchasing patterns from a tablenamed Transactions. The Transactions table contains a numeric field named Spend. Youneed to include a visual that identifies which fields have the greatest impact on Spend.Which type of visual should you use?

A. decomposition tree
B. Q&A
C. smart narrative
D. key influences

Show Answer

Question # 2

You are creating a dashboard by using the Power Bl service.You have an existing report page that contains three charts.You need to add the charts to the dashboard while maintaining the interactivity between thecharts.What should you do?

A. Pin each chart as a tile.
B. Edit interactions in the report and set all interactions to Filter
C. Edit the dashboard theme and pin each chart as a file.
D. Pin the report page as a live tile.

Show Answer

Question # 3

You have a Rawer Bl report That imports a dace table and a sales table from an AzureSQL database data source. The sales table has the following date foreign keys:• Due Date• Order Date• Delivery DateYou need to support the analysis of sales over time based on all three dates at the sametime.Solution: From the Fields pane, you rename the date table as Due Date. You use a DAXexpression to create Order Date and Delivery Date as calculated tables. You create activerelationships between the sales table and each date table.Does this meet the goal?

A. Yes
B. No

Show Answer

Question # 4

You have a dataset that is used infrequently and refreshes every hour.You receive a notification that the refresh was disabled due to inactivity.Which two actions will cause the scheduled refresh schedule to resume? Each correctanswer presents a complete solution.NOTE: Each correct selection is worth one point.

A. Enable query caching for the dataset.
B. Import the dataset to Microsoft Excel.
C. From the Power BI service, open a dashboard that uses the dataset.
D. From the Power BI service, open a report that uses the dataset.
E. From PowerShell, run the get-powerbireport cmdlet.

Show Answer

Question # 5

You have two Power Bl reports named ReportA and ReportB that each uses a distinct colorpalette.You are creating a Power Bl dashboard that will include two visuals from each reportYou need to use a consistent dark theme for the dashboard. The solution must preservethe original colors of the reports.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. Upload a snapshot.
B. Select the dark dashboard theme.
C. Turn on tile flow.
D. When pinning visuals to the dashboard, select Use destination theme.
E. For the browser, set the color preference to dark mode.

Show Answer

Question # 6

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

A. From Power Bl Desktop, customize the current theme,
B. From power Bl Desktop, use a built in report theme.
C. Create a theme as a JSON file and import the theme into Power Bl Desktop.
D. Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

Show Answer

Question # 7

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

A. Create a theme as a PBIVIZ file and import the theme into Power Bl Desktop.
B. Create a theme as a JSON file and import the theme into Power Bl Desktop.
C. From Power Bl Desktop, use a built-in report theme.
D. From Power Bl Desktop, customize the current theme.

Show Answer

Question # 8

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

A. Create a column by example that starts with 2018-12-31.
B. Apply a transformation to extract the last 11 characters of the Logged column and setthe data type of the new column to Date.
C. Apply a transformation to extract the first 11 characters of the Logged column.
D. split the Logged column by using at as the delimiter.

Show Answer

Question # 9

You are building a Power Bl report.Users will view the report by using their mobile device.You need to configure the report to display data based on each user s location.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. For the relevant columns, set synonyms to match common geographical terms.
B. From Power Query Editor, detect the data types of the relevant columns.
C. Use the columns of the geography data type in all visuals.
D. Create a hierarchy for columns of the geography data type.
E. In Data Category, set the geographic data category for the relevant columns.

Show Answer

Question # 10

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 havepermissions 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.

A. From the Power BI service, create a dataflow to the dataset by using DirectQuery.
B. From Power BI Desktop, connect to a Dataverse data source.
C. From the Power BI service, create a new report and select a published dataset
D. From Power Bl Desktop, connect to a shared dataset

Show Answer