PL-300 Demo Exam | Skill Course

Question 1

Power BI Service allows sharing reports with external users using RLS.

FALSE TRUE

Question 2

Scenario: Fill nulls from below in a column.

Fill Up Fill Down Replace Values Remove Rows

Question 3

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

Change lite OrderlD column in the Orders table to the text data type. Filter out discontinued products while importing the Product table. Remove the QuantityPerUnit column from the Products table Group the Categories table by the CategorylD column.

Question 4

In which layer is “Manage Relationships”?

Power Query Model view Report view Service

Question 5

What is the purpose of Deployment Pipelines?

User security Move content across Dev–Test–Prod Data modeling Mobile layout

Question 6

You have an on-premises Power BI Report Server. You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?

Microsoft Azure SQL Database A Microsoft SQL Server database A Microsoft SQL Server Analysis Services (SSAS) database Microsoft Excel

Question 7

Scenario: You want to combine two tables vertically.

Append Merge Pivot Unpivot

Question 8

What does “Remove Blank Rows” do?

Remove all nulls Remove rows with no values Delete columns Trim spaces

Question 9

You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column. From Power Bl Desktop, use the Auto date/time option when creating the reports. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Question 10

A Matrix visual is a combination of what?

Table + Pivot Chart + Table Card + KPI Map + Table