Microsoft PL-300 dumps - 100% Pass Guarantee!

Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is

exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values.

End of repeated scenario.

You implement the Power BI model.

You need to add a measure to rank total sales by product. The results must appear as shown in the following table.

Which DAX formula should you use?

A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)

B. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Dense)

C. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Skip)

D. Product Ranking= RANKX (ALL (`Product'), [SalesAmount], , Asc, Dense

You have a PBiX file that imports several tables from an Azure SQL database.

The data will be migrated to another Azure SQL database.

You need to change the connections in the PBIX file. The solution must minimize administrative effort.

What should you do?

A. From Power Query Editor, modify the source of each query.

B. Create a PBiT file, open the file, and change the data sources when prompted

C. From Power Query Editor, create new queries.

D. Modify the Data source settings.

You have a QandA visual that displays information from a table named Carriers as shown in the following exhibit.

You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model. What should you do?

A. Add a duplicate query named Airline.

B. Add airline as a synonym of carrier.

C. Rename the carrier column as airline in the Carriers query.

D. Rename the query from Carriers to airlines.

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?

A. dataset certifications

B. row-level security (RLS)

C. sensitivity labels

D. Microsoft Intune policies

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 a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create an average line by using the Salary measure.

Does this meet the goal?

A. Yes

B. No