Microsoft Certified: Power BI Data Analyst Associate PL-300 Book

Microsoft Power BI Data Analyst Questions and Answers

Question 37

You need to create a visualization to meet the reporting requirements of the sales managers.

How should you create the visualization? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 38

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

Change the data type of Sales[region_id] to Whole Number.

In the Sales table, add a measure for sum(sales_amount).

Change the data type of sales[sales_id] to Text.

Change the data type of sales [region_id] to Decimal Number.

Question 39

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

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

Question 40

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

import that uses a Microsoft account

DirectQuery that uses the end-user s credentials

DirectQuery that uses a database credential

Import that uses a database credential