Free Microsoft PL-300 Exam Questions

Question 1

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?

A : PBIDS

B : PBIT

C : XLSX

D : PBIX

Answer: A

Question 2

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?

A : Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.

B : Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.

C : Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.

D : Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

Answer: D

Question 3

You attempt to connect Power BI Desktop to a Cassandra database. From the Get Data connector list, you discover that there is no specific connector for the Cassandra database. You need to select an alternate data connector that will connect to the database. Which type of connector should you choose?

A : Microsoft SQL Server database

B : ODBC

C : OLE DB

D : OData

Answer: C

Question 4

You attempt to connect Power BI Desktop to a Cassandra database. From the Get Data connector list, you discover that there is no specific connector for the Cassandra database. You need to select an alternate data connector that will connect to the database. Which type of connector should you choose?

A : Microsoft SQL Server database

B : ODBC

C : OLE DB

D : OData

Answer: C

Question 5

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?

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