Question 1

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality?

Options :

A : One to one

B : Many to one

C : One to many

D : Many to many

Answer: C

Question 2

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns: • Customer ID • CustomerName • Address • City • ProvState • Country You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

Options :

A : In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.

B : In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.

C : In the Axis field, add Country at the top, followed by ProvState, and then City.

D : In the Value field, add Country at the top, followed by ProvState, and then City.

Answer: C

Question 3

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do?

Options :

A : Create a new aggregation that summarizes by employee.

B : Create a new group on the state column and set the Group type to List.

C : Create a new group on the state column and set the Group type to Bin.

D : Create a new aggregation that summarizes by state.

Answer: B

Question 4

You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You change the semantic model mode. Does this meet the goal?

Options :

A : Yes

B : No

Answer: B

Question 5

Vou have a Microsoft Power Bl Desktop report named Report! that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data source as Report1. You need to simplify the connection to the data source for User1. Which type of file should you create?

Options :

A : PBIDS

B : PBIT

C : XLSX

D : PBIX

Answer: A

Higher Test Marks with Free Online PL-300 Exam Practice

Buying Options: