Microsoft PL-300 Practice Test - Questions Answers, Page 16
List of questions
Question 151
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories. You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)
The related dimension tables are imported into the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Explanation:
Reference:
https://finance-bi.com/power-bi-basket-analysis/
Question 152
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
DRAG DROP
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.
Explanation:
User 1 = Member
User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
Question 153
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
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.
Explanation:
Box 1: cross-filter
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
Box 2: cross-highlight
Example:
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
1. Let's see what happens when we select Moderation.
2. Cross-filtering removes data that doesn't apply. Selecting Moderation in the doughnut chart crossfilters the line chart. The line chart now only displays data points for the Moderation segment.
3. Cross-highlighting retains all the original data points but dims the portion that does not apply to your selection. Selecting Moderation in the doughnut chart cross-highlights the column chart. The column chart dims all the data that applies to the Convenience segment and highlights all the data that applies to the Moderation segment.
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions
Question 154
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com. What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation:
Box 1: Append Queries as New.
There are two primary ways of combining queries: merging and appending.
When you have one or more columns that you’d like to add to another query, you merge the queries.
When you have additional rows of data that you’d like to add to an existing query, you append the query. Box 2: Disable loading the query to the data model
For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.
Reference:
https://docs.microsoft.com/en-us/power-query/append-queries
Question 155
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
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.
Explanation:
Box 1: Yes
The four columns used in the 2018 transactions are already displayed.
Box 2: Yes
The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected. Box 3: Yes
Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.
Question 156
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
DRAG DROP
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product. You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain. 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.
Explanation:
Step 1: Select Use Header as First Row.
Step 2: Select Department and Product and Unpivot Other Columns
Unpivot Other Columns: This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted. Step 3: Rename the Attribute column to Year and the Value column to Revenue.
You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.
When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:
Values (in blue on the left) are unpivoted into a new column (in blue on the right).
Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
Question 157
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
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.
Explanation:
Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.
https://pediaa.com/what-is-the-difference-between-unique-and-distinct-insql/#:~:text=Unique%20and%20Distinct%20are%20two%20SQL%20constraints.,the%20records%20from%20a%20table.
Question 158
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
DRAG DROP
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 dat a. 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.
Question 159
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
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
Question 160
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
DRAG DROP
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
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.
Explanation:
1- Convert list to table
2- Expand Column
3- Set Date type
Here is an example: https://youtu.be/B4kzyxnhQfI
The definition of the function which expand columns: https://docs.microsoft.com/enus/powerquery-m/table-expandrecordcolumn
Question