ExamGecko
Login
Home / Microsoft / PL-300 / List of questions
Ask Question

Microsoft PL-300 Practice Test - Questions Answers, Page 16

List of questions

Question 151

Report
Export
Collapse

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

Microsoft PL-300 image Question 118 106375 10052024010716000000

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.


Microsoft PL-300 image Question 151 106375 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 151 106375 10052024010716000

Explanation:

Reference:

https://finance-bi.com/power-bi-basket-analysis/

asked 05/10/2024
Ray Hato
38 questions

Question 152

Report
Export
Collapse

DRAG DROP

You have a Microsoft Power Bl workspace.

You need to grant the user capabilities shown in the following table.

Microsoft PL-300 image Question 119 106376 10052024010716000000

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.


Microsoft PL-300 image Question 152 106376 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 152 106376 10052024010716000

Explanation:

User 1 = Member

User 2 = Contributor

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces

asked 05/10/2024
takasuka masahide
39 questions

Question 153

Report
Export
Collapse

HOTSPOT

You have a report page that contains the visuals shown in the following exhibit.

Microsoft PL-300 image Question 120 106377 10052024010716000000

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.


Microsoft PL-300 image Question 153 106377 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 153 106377 10052024010716000

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.

Microsoft PL-300 image Question 120 explanation 106377 10052024010716000000

1. Let's see what happens when we select Moderation.

Microsoft PL-300 image Question 120 explanation 106377 10052024010716000000

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

asked 05/10/2024
Ciaran Cullimore
41 questions

Question 154

Report
Export
Collapse

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.


Microsoft PL-300 image Question 154 106378 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 154 106378 10052024010716000

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

asked 05/10/2024
Hassene SAADI
30 questions

Question 155

Report
Export
Collapse

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

Microsoft PL-300 image Question 122 106379 10052024010716000000

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 155 106379 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 155 106379 10052024010716000

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.

asked 05/10/2024
mohammed zakir
38 questions

Question 156

Report
Export
Collapse

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.

Microsoft PL-300 image Question 123 106380 10052024010716000000

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.


Microsoft PL-300 image Question 156 106380 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 156 106380 10052024010716000

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.

Microsoft PL-300 image Question 123 explanation 106380 10052024010716000000

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

asked 05/10/2024
Exam Prepping
29 questions

Question 157

Report
Export
Collapse

HOTSPOT

You view a query named Transactions as shown in the following exhibit.

Microsoft PL-300 image Question 124 106381 10052024010716000000

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.


Microsoft PL-300 image Question 157 106381 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 157 106381 10052024010716000

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.

asked 05/10/2024
Avinash Kumar
32 questions

Question 158

Report
Export
Collapse

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.


Microsoft PL-300 image Question 158 106382 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 158 106382 10052024010716000
asked 05/10/2024
Saikhantsetseg Donnelly
38 questions

Question 159

Report
Export
Collapse

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.


Microsoft PL-300 image Question 159 106383 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 159 106383 10052024010716000

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

asked 05/10/2024
max artusa
39 questions

Question 160

Report
Export
Collapse

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.


Microsoft PL-300 image Question 160 106384 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 160 106384 10052024010716000

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

asked 05/10/2024
Calvin Bolico
30 questions
Total 370 questions
Go to page: of 37
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure. Does this meet the goal?
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns: * Order Line ID * Product ID * Unit Price * Order ID * Quantity Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID. You need to write a DAX measure that counts the number of orders. Which formula should you use?
HOTSPOT 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.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the loT DateTime column into a column named Date and a column named Time. Does this meet the goal?
You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?
You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?
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.
DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. 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 order.
DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent. How should you complete the calculation? 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.