PL-300 Certification – Valid Exam Dumps Questions Study Guide! (Updated 467 Questions) [Q103-Q125]

Q103. 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.

Q104. You have a column named UnitslnStock as shown in the following exhibit

UnitsInStock has 75 non-null values, of which 51 are unique.
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.

Q105. You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?

Q106. You have the CSV file shown in the following table.

You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
* The first column must contain the month.
* The second column must contain the year.
* The third column must contain the order amount for the month and year.
Which transformation should you use first?

Q107. You have the Power Bl model shown in the following exhibit.

There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only.
What should you do?

Q108. You are creating a Power 81 model to analyze inventory.
You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships.
Inventor)’ data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.
How should you complete the measure? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point

Q109. 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.

Q110. You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Q111. You use Power 81 Desktop to load data from a Microsoft SQL Server database.
While waiting for the data to load, you receive the following error.

You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Q112. ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?

Q113. You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.
You need to create a calculated table that v/ill contain the following:

Q114. You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q115. You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.
You add a sheer named Country to each page of the report.
You need to configure the report to meet the following requirements:
* When a user selects a country on the first page, the report must filter the other pages.
* The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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.Ther NOTE Each correct selection is worth one point.

Q116. You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q117. You have a Power Bl report.
You have the following tables.

You have the following DAX measure.

Q118. You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q119. You create a Power BI workspace named Workspace1.
You publish a semantic model and a report to Workspace1.
You need to configure Workspace1 to meet the following requirements:
– Provide access to a group named Sales.
– Ensure that Sales can invite other users to Workspace1.
– Follow the principle of least privilege.
Which role should you assign to Sales?

Q120. 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.

Q121. You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Q122. You have a Power B1 report that contains the fields 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.

Q123. You have the Power Bl data model shown in the following exhibit.
You need to create a measure to count the number of product categories that had products sold during a selected period. 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.

Q124. You have a Power Bl workspace that contains a single-page report named Sales.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Q125. You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.
Which type of visualization should you use?