Pass Microsoft PL-300 PDF Dumps | Recently Updated 515 Questions
Updated Test Engine to Practice PL-300 Dumps & Practice Exam
NEW QUESTION # 37
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.
NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Answer:
Explanation:
1 - From Power BI Desktop. select Get Data, and then select Folder.
2 - From Power Query Editor, expand the Attributes column.
3 - From Power Query Editor, combine the Content column.
NEW QUESTION # 38
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?
- A. highlight
- B. no impact
- C. filter
Answer: A
NEW QUESTION # 39
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 # 40
You have a Power B1 semantic model that contains a table
You need to create a Power B1 report page that contains two visuals that meet the following requirements:
* Visual 1: Display* the distribution of hierarchical data
* Visual 2: Search arid then filler by values
Which type should you choose for each visual? To answer, drag the appropriate visual types to the correct visuals. Each visual 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:
Explanation:
NEW QUESTION # 41
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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 # 42
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 # 43
You have a Power BI model that has the following tables:
* Product (Product_id, Product_Name)
* Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
* Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
* Sales to Product
* Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
NEW QUESTION # 44
You build a report about warehouse inventory data. The dataset has more than 10 million product records from
200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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.
Answer:
Explanation:
Explanation
NEW QUESTION # 45
You have a Power Bl semantic model that contains the data sources shown in the following table.
You need to configure the privacy levels of the data sources.
What should you configure (01 each data source? To answer, select (he appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Answer:
Explanation:
Explanation:
NEW QUESTION # 46
You have a Power B1 model that contains a table named Date. The table has the following columns.
Answer:
Explanation:
see the expalanation for the answer below.
Explanation:
Answer is below.
NEW QUESTION # 47
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.
Answer:
Explanation:
1 - From Power BI Desktop, publish the dataset to powerbi.com
2 - From Power BI Desktop, create four roles.
3 - From Power BI Desktop, add a Table Filter DAX Expression to the roles.
4 - From powerbi.com, add role members to the roles.
NEW QUESTION # 48
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.
Answer:
Explanation:
NEW QUESTION # 49
You have a report in Power BI Desktop 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:
NEW QUESTION # 50
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.
Answer:
Explanation:
Explanation:
Box 1: Table.RemoveColumns
When you do "Remove Columns" Power Query uses the Table.RemoveColumns function Box 2: List.Select Get a list of columns.
Box 3: Text.EndsWith
NEW QUESTION # 51
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.
Sheet2 contains the following table named Table2.
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
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.
Answer:
Explanation:
1 - From Power BI Desktop, import the date from Excel, and select Table1 and Table2.
2 - From Power Query Editor, append Table2 to Table1.
3 - From Power Query Editor, select Table1, and then select Remove duplicates.
NEW QUESTION # 52
You have a report that contains four pages. Each page contains slicers for the same four fields.
Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages.
You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A. Create a bookmark for each slicer value.
- B. Replace the slicers with page-level filters.
- C. Sync the slicers across the pages.
- D. Replace the slicers with visual-level filters.
- E. Replace the slicers with report-level filters.
Answer: C,E
Explanation:
E: Add a report-level filter to filter an entire report.
The visuals on the active page, and on all pages in the report, change to reflect the new filter.
A: You can sync a slicer and use it on any or all pages in a report.
1. On the Power BI Desktop View menu, select Sync slicers.
The Sync slicers pane appears between the Filters and Visualizations panes.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
NEW QUESTION # 53
You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four 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
Answer:
Explanation:
1 - Configure an on-premises data gateway.
2 - Configure a scheduled refresh.
3 - Add a data source.
4 - Add the dataset owner to the data source.
NEW QUESTION # 54
......
Microsoft PL-300 Dumps Cover Real Exam Questions: https://examsboost.actualpdf.com/PL-300-real-questions.html
