Download the Latest PL-300 Dumps – 2024 PL-300 Exam Questions [Q209-Q229]

QUESTION 209
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.

QUESTION 210
You have a Power BI imported dataset that contains the data model 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.

QUESTION 211
You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?

QUESTION 212
The data model must support the following analysis:
Total sales by product by month in which the order was placed
Quantities sold by product by day on which the order was placed
Number Of sales transactions by quarter in Which the order was placed
For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.

QUESTION 213
You have a Power Bl report that contains five pages.
Pages 1 to 4 are visible and page 5 is hidden.
You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.
What should you do first?

QUESTION 214
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

What should you do?

QUESTION 215
You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements:
* Customer must be refreshed daily.
* Date must be refreshed once every three years.
* Sales must be refreshed in near real time.
* SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following requirements:

QUESTION 216
You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? 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.

QUESTION 217
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.

QUESTION 218
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.

QUESTION 219
You need to create a measure that will return the percentage of late orders.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 220
HOTSPOT
You have an API that returns more than 100 columns.
The following is a sample of column names.
* client_notified_timestamp
* client_notified_source
* client_notified_sourceid
* client_notified_value
* client_responded_timestamp
* client_responded_source
* client_responded_sourceid
* client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

QUESTION 221
You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?

QUESTION 222
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?

QUESTION 223
You open powerbi.com 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.

QUESTION 224
You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

QUESTION 225
What is the minimum number of datasets and storage modes required to support the reports?

QUESTION 226
You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power Bi dataset
You need to ensure that the dataset can be refreshed in powefbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

QUESTION 227
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

QUESTION 228
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

QUESTION 229
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?