PL-300 Free Practice Test

- (Topic 4)
You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:
• The count of orders and the sum of total sales by Order Date
• The count of customers who placed an order
• The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

1. A. Fillet the data to only the NorthWest region sales territory.
2. B. Remove the CustomerKey and ProductKey columns.
3. C. Remove the TaxAmt and Freight columns.
4. D. Set the data type for SatesOrderNumber to Decimal Number

Correct Answer: AC

- (Topic 4)
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?

1. A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.
2. B. Deploy an on-premises data gatewa
3. C. Import the data by using the Import Data Connectivity mode.
4. D. Deploy an on-premises data gatewa
5. E. Import the data by using the DirectQuery Data Connectivity mode.
6. F. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-bi-connectivity-modes

- (Topic 4)
You have a Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution. NOTL Each correct selection is worth one pant.

1. A. Remove the rows in which sales [status] has a value of Canceled.
2. B. Change the data type of sale [Delivery_Time] to Integer
3. C. Removes (Canceled Date).
4. D. Split Sales [Sale_Date] into separate date and time columns.
5. E. Remove sales [Sales_Date].

Correct Answer: AD

- (Topic 4)
You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A. Which settings should you modify from the Power BI Settings?

1. A. Subscriptions
2. B. Dashboards
3. C. Datasets
4. D. Workbooks

Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured- questions

- (Topic 4)
For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing data. The solution must minimize development effort. Which type ol data source should you use?

1. A. a SharePoint folder
2. B. Power Bl dataflows
3. C. an Excel workbook
4. D. Power Bl dataset

Correct Answer: A
case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.