Microsoft PL-300 Exam Questions Free Practice Test

Viewing page 4 out of 7 pages

Viewing questions 31-40 out of questions

Questions # 31:

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

Options:

a measure that uses a formula of SUM (Sales [sales_id])

a calculated column that use a formula of COUNTA(sales [sales_id])

a measure that uses a formula of COUNTROWS (Sales)

a calculated column that uses a formula of SUM (Sales [sales_id])

Expert Solution

Questions # 32:

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

Options:

Select Column distribution.

Select the sales_amount column and apply a number filter.

Select Column profile, and then select the sales_amount column.

Transform the sales_amount column to replace negative values with 0.

Expert Solution

Questions # 33:

You publish the semantic model 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 # 33

Expert Solution

Questions # 34:

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

Options:

Create a security role that has a table filter on the Sales_Manager table whereusername = UserName()

Create a security role that has a table filter on the Region_Manager table wheresales_manager_id = UserPrincipalName().

Create a security role that has a table filter on the Sales_Manager table wherename = UserName().

Create a security role that has a table filter on the Sales_Manager table whereusername = sales_manager_id.

Expert Solution

Questions # 35:

You have a Power 81 report. The report contains a single report page that uses the detault theme.

You need to configure the report page to match the formatting shown in the following exhibit.

Question # 35

What should you change on the report page?

Options:

the wallpaper color only

the canvas background color only

the wallpaper color and the canvas background color

the canvas background image only

Expert Solution

Questions # 36:

You have a Microsoft 365 subscription that contains the resources shown in the following table.

Question # 36

You create a new dashboard that uses row-level security (RIS) filters You define a new role named Consultants.

To which resource can you assign the Consultants role?

Options:

Group2

Team1

Sales reports

Group 1

Expert Solution

Questions # 37:

You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter. Model 1 contains a DAX measure that sums the Sales column.

You need to create a report that will contain the visual shown in the following exhibit.

Question # 37

The solution must NOT require additional DAX measures.

Which type of visual should you use?

Options:

ribbon chart

line chart

100% stacked area chart

area chart

Expert Solution

Questions # 38:

You have a Fabric tenant that hosts the semantic models shown in the following table.

Question # 38

The auto date/time option or the model is enabled.

You need to reduce the size of the model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one pent.

Options:

Create a Rate table and select Mark as Date Table.

Disable the auto date/time option.

Remove the relationship between the Product table and the Sales table.

Disable the load on the Date table.

Create a relationship between the Date table and the Sales table.

Expert Solution

Questions # 39:

You have a semantic model named Model1 that contains sales data.

You need to ensure that Modell is refreshed on the first day of each month to include last month's sales data. What should you configure?

Options:

an on-premises data gateway

a Microsoft Rower Automate flow

an incremental refresh

a scheduled refresh

Expert Solution

Questions # 40:

You have a Microsoft Excel file in a Microsoft OneDrive folder.

The file must be imported to a Power Bi dataset

You need to ensure that the dataset can be refreshed in powefbi.com.

Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Options:

Text/CSV

Folder

Excel Workbook

SharePoint folder

Web

Expert Solution

Viewing page 4 out of 7 pages

Viewing questions 31-40 out of questions

Pass the Microsoft Microsoft Certified: Power BI Data Analyst Associate PL-300 Questions and answers with CertsForce