Online Questions – Valid Practice To your PL-300 Exam (Updated 375 Questions) [Q214-Q232]

QUESTION 214
You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 215
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

QUESTION 216
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?

QUESTION 217
You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?

QUESTION 218
What should you create to meet the reporting requirements of the sales department?

QUESTION 219
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 any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 220
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 any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 221
You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.
The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

You need to modify the dashboard mobile layout to meet the following requirements:
* Only show single-value visuals.
* Minimize scrolling.
What should you do?

QUESTION 222
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?

QUESTION 223
You have the Azure SQL databases shown in the following table.

You plan to build a single PBIX file to meet the following requirements:
* Data must be consumed from the database that corresponds to each stage of the development lifecycle.
* Power Bl deployment pipelines must NOT be used.
* The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.

QUESTION 224
You are profiling data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

QUESTION 225
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.
From Power Query Editor, you profile the data shown in the following exhibit.

The IOT ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?

QUESTION 226
You plan to create a report that will display sales data from the last year for multiple regions You need to restrict access to individual rows of the data on a per region-basis by using roles.
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.

QUESTION 227
You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.
A user wants to create a report by using the data In DS1 and publish the report to another workspace.
You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.
What should you do?

QUESTION 228
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.

QUESTION 229
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 230
You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.
You have a Power Bl dashboard named DashboardA that has Q&A enabled.
You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to Dashboard Which three 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.

QUESTION 231
You have a column named UnitslnStock as shown in the following exhibit

QUESTION 232
You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.