Get 2022 Most Reliable Microsoft PL-300 Training Materials [Q26-Q46]

NEW QUESTION 26
You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?

Round the hour of the Date column to startOfHour.

Change the data type of the Date column to Text.

Trim the Date column.

Split the Date column into two columns, one that contains only the time and another that contains only the date.

NEW QUESTION 27
ion have a Power B1 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.

Disable the Power Query toad.

Round the Longitude column two decimal places.

Change the data type of the TempCelsius column to Integer

NEW QUESTION 28
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant 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?

Change the data type of the Logged column to Date.

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

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

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

NEW QUESTION 29
You have the Power BI data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

NEW QUESTION 30
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

NEW QUESTION 31
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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?

Yes

No

NEW QUESTION 32
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source.
The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

A user pressed F5

A new transaction was added to the data source.

A user added a comment to a tile.

The dashboard tile cache refreshed.

NEW QUESTION 33
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] – Sales[This Year].
You need to create the following visualization.

How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

NEW QUESTION 34
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.

Disable the Power Query load.

Round the Longitude column two decimal places.

Change the data type of the TempCelsius column to Integer

NEW QUESTION 35
You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?

Subscriptions

Dashboards

Datasets

Workbooks

NEW QUESTION 36
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Add the same slicer to each page and configure Sync slicers.

Edit the interactions of the KPI visualization.

Configure a page-level filter.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

Configure a report-level filter.

NEW QUESTION 37
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?

Create a horizontal line that has a fixed value of 24,000.

Add a measure to the visual that uses the following DAX expression.Heasurel – PERCENTUEX.EXC (Sales,Sales[Total Sales],6.40)

Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

NEW QUESTION 38
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?

video

custom streaming data

text box

web content

NEW QUESTION 39
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 create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group.
Does this meet the goal?

Yes

No

NEW QUESTION 40
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE; Each correct selection is worth one point.

NEW QUESTION 41
You have a Power BI tenant.
You have reports that use financial datasets and are exported as PDF files.
You need to ensure that the reports are encrypted.
What should you implement?

dataset certifications

row-level security (RLS)

sensitivity labels

Microsoft Intune policies

NEW QUESTION 42
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 a query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerlD column are set to 0.
Solution: From Query Editor, select the CustomerlD column and click Remove Errors.
Does this meet the goal?

Yes

No

NEW QUESTION 43
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

NEW QUESTION 44
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.

NEW QUESTION 45
You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= “United States” && [ProductCategory]= “Clothing”

Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing

From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= “United States”

Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

NEW QUESTION 46
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 a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.
The tables have the following relationships:
Sales[DueDate] and Date[Date]
Sales[ShipDate] and Date[Date]
Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
Does this meet the goal?

Yes

No