Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

Free Microsoft Power BI Data Analyst Practice Questions

Question # 51

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

Options:

A.  

Change lite OrderlD column in the Orders table to the text data type.

B.  

Filter out discontinued products while importing the Product table.

C.  

Remove the QuantityPerUnit column from the Products table

D.  

Group the Categories table by the CategorylD column.

Discussion 0
Question # 52

You need to create a relationship in the data model for RLS.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 52

Options:

Discussion 0
Question # 53

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

Options:

A.  

bar chart

B.  

scatterplot

C.  

pie chart

Discussion 0
Question # 54

You need to create the dataset. Which dataset mode should you use?

Options:

A.  

DirectQuery

B.  

Import

C.  

Live connection

D.  

Composite

Discussion 0
Question # 55

You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct select is worth one point:

Question # 55

Options:

Discussion 0
Question # 56

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

Options:

A.  

Add the sales department as a member of the reports workspace

B.  

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

C.  

Distribute an app to the users in the Azure Active Directory group of the sales department.

D.  

Share each report to the Azure Active Directory group of the sales department.

Discussion 0
Question # 57

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 57

Options:

Discussion 0
Question # 58

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 # 58

Options:

Discussion 0
Question # 59

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

Options:

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

Discussion 0
Question # 60

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

Options:

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])

Discussion 0

PL-300 PDF

PL-300 PDF (Printable)
$54.25
$154.99

PL-300 Testing Engine

PL-300 PDF (Printable)
$59.5
$169.99

PL-300 PDF + Testing Engine

PL-300 PDF (Printable)
$74.55
$212.99

Free Exams Sample Questions