[Dec-2023] The Best Microsoft Certified: Power BI Data Analyst Associate PL-300 Professional Exam Questions [Q183-Q201]

[Dec-2023] The Best Microsoft Certified: Power BI Data Analyst Associate PL-300 Professional Exam Questions

Try 100% Updated PL-300 Exam Questions [2023]

Schedule exam

Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Russian, Chinese (Traditional), Italian

Retirement date: none

This exam measures your ability to accomplish the following technical tasks: prepare the data; model the data; visualize and analyze the data; and deploy and maintain assets.

NEW QUESTION # 183
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to edit the Product Category table query to match the desired Power BI model.
How should you complete the advanced query? To answer, drag the appropriate values to the correct targets.
Each value may be used once, more than once, or not at all.
You may need to frag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation
Graphical user interface, application Description automatically generated

References:
https://msdn.microsoft.com/en-us/library/mt260776.aspx
https://msdn.microsoft.com/en-us/library/mt260808.aspx

NEW QUESTION # 184
You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.
You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:
* Create reports that use the HR dataset.
* Publish the reports to WorkspaceB.
* Prevent the ability to modify the HR dataset.
* Prevent the ability to add users to WorkspaceB.

Answer:

Explanation:
Answer is as below.

NEW QUESTION # 185
You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

NEW QUESTION # 186
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

NEW QUESTION # 187
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 188
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/calculate-function-dax

NEW QUESTION # 189
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 190
You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Create a calculated measure that aggregates by using the COUNTROWS function.
B. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
C. Create one-to-many relationships between the tables.
D. Group the impressions by Ad_id, Site_name, and Impression_date.
Aggregate by using the CountRows function.

Answer: C,D

Explanation:
Explanation
Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size of the model.

NEW QUESTION # 191
You have a report page that contains the visuals shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions

NEW QUESTION # 192
You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.
You add the following fields to the Explain By field:
* Customer Country
* Product Category
* Supplier Country
* Sales Employee
* Supplier Name
* Product Name
* Customer City
The key influencers visual returns the results shown in the following exhibit.

What can you identify from the visual?

A. Product Category positively influences the quantity per order.
B. Customers in Cork order lower quantities than average.
C. Customers in Austria order 18.8 more units than the average order quantity.
D. Customers in Boise order 20.37 percent more than the average order quantity.

Answer: C

NEW QUESTION # 193
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 194
You are creating a line chart in a Power Bl report as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Answer:

Explanation:
Answer as selected

NEW QUESTION # 195
You need to create a Power Bl report. The first page or the report must contain the following two views:
* Sales By Postal Code
* Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.

Answer:

Explanation:

NEW QUESTION # 196
You plan to embed multiple visualization in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.

Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.

A. Visual4
B. Visual5
C. Visual1
D. Visual2
E. Visual3

Answer: A,D

NEW QUESTION # 197
You have a Power Bl report.
You have the following tables.

You have the following DAX measure.

Answer:

Explanation:

NEW QUESTION # 198
In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.
Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.
How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 199
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] - Sales[This Year].
You need to create the following visualization.

How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts

NEW QUESTION # 200
You are modifying a Power Bi model by using Power Bl Desktop.
You have a table named Sales that contains the following fields.

You have a table named Transaction Size that contains the following data.

You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.
How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.