Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Microsoft PL-300 - Microsoft Power BI Data Analyst

Page: 4 / 5
Total 434 questions

You are building a dataset from a JSON file that contains an array of documents.

You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.

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.

You have a Microsoft Excel file on a file server.

You create a Power BI report and import a table from the Excel file.

You publish the report.

You need to ensure that the data refreshes every four hours.

What should you do first?

A.

Upload the Excel file to a Power BI workspace.

B.

Create a subscription to the report.

C.

Deploy an on-premises data gateway.

D.

Edit the data source credentials.

You create a Power Bl dataset that contains the table shown in the following exhibit.

You need to make the table available as an organizational data type In Microsoft Excel.

How should you configure the properties of the table? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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

A.

Select Column distribution.

B.

Select the sales_amount column and apply a number filter.

C.

Select Column profile, and then select the sales_amount column.

D.

Transform the sales_amount column to replace negative values with 0.

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.

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

A.

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

B.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

C.

Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

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

What should you include in the solution?

A.

Create a security role that has a table filter on the Sales_Manager table where

username = UserName()

B.

Create a security role that has a table filter on the Region_Manager table where

sales_manager_id = UserPrincipalName().

C.

Create a security role that has a table filter on the Sales_Manager table where

name = UserName().

D.

Create a security role that has a table filter on the Sales_Manager table where

username = sales_manager_id.

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

A.

import that uses a Microsoft account

B.

DirectQuery that uses the end-user s credentials

C.

DirectQuery that uses a database credential

D.

Import that uses a database credential

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.

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

A.

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

B.

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

C.

a measure that uses a formula of COUNTROWS (Sales)

D.

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