Microsoft PL-300 Real Exam Questions Guaranteed Updated Dump from TestInsides [Q150-Q166]

Microsoft PL-300 Real Exam Questions Guaranteed Updated Dump from TestInsides

Verified Pass PL-300 Exam in First Attempt Guaranteed

NEW QUESTION # 150
You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.

You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model.
What should you do?

A. Add a duplicate query named Airline.
B. Add airline as a synonym of carrier.
C. Rename the query from Carriers to airlines.
D. Rename the carrier column as airline in the Carriers query.

Answer: B

Explanation:
Add synonyms to tables and columns: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step can be important. Even with straightforward table and column names, users of Q&A ask questions using the vocabulary that first comes to them. They're not choosing from a predefined list of columns. The more sensible synonyms you add, the better your users' experience is with your report.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

NEW QUESTION # 151
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.

A. Delete the City column.
B. Remove duplicates from the Country column.
C. |Remove duplicates from the table.
D. Delete the Country column.
E. Remove duplicates from the City column.

Answer: A,B

Explanation:
To create a dimension table for Country from your source data, you need to perform these two actions34:
* Delete the City column. You don't need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.
* Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.

NEW QUESTION # 152
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.
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?

A. No
B. Yes

Answer: A

Explanation:
Instead modify the source step of the queries to use DataSourceExcelas the file path.= Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

NEW QUESTION # 153
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

The visualization appears as shown in the Chart exhibit. (Click the Chart 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.

Answer:

Explanation:

NEW QUESTION # 154
You have a Power BI data model that contains a table named Employees. The table has the following columns:
* Employee Name
* Email Address
* Start Date
* Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
* Users must see only their own employee data
* The DAX expression must work in both Power 81 Desktop and the Power BI service.
Which expression should you use?

A. Option B
B. Option D
C. Option C
D. Option A

Answer: A

NEW QUESTION # 155
You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions.
The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

A. Q&A
B. smart narrative
C. decomposition tree
D. key influences

Answer: B

NEW QUESTION # 156
A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
The managers must only see the data of their respective country.
The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Create one role for each country.
B. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
C. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
D. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.
E. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

Answer: B,E

Explanation:
Explanation
In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service. See
https://community.powerbi.com/t5/Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-P for more information.

NEW QUESTION # 157
You have the visual shown in the exhibit.

You need to show the relationship between Total Cost and Total Sales over time.
What should you do?

A. Add a slicer for the year.
B. Add a play axis.
C. Create a DAX measure that calculates year-over-year growth.
D. From the Analytics pane, add an Average line.

Answer: A

Explanation:
When to use a slicer
Slicers are a great choice when you want to:
Display commonly used or important filters on the report canvas for easier access.
Make it easier to see the current filtered state without having to open a drop-down list.
Filter by columns that are unneeded and hidden in the data tables.
Create more focused reports by putting slicers next to important visuals.
Note: Suppose you want your report readers to be able to look at overall sales metrics, but also highlight performance for individual district managers and different time frames. You could create separate reports or comparative charts. You could add filters in the Filters pane. Or you could use slicers. Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

NEW QUESTION # 158
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 ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.
Solution: You change the IOT DateTime column to the Date data type.
Does this meet the goal?

A. No
B. Yes

Answer: B

NEW QUESTION # 159
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.

Answer:

Explanation:

NEW QUESTION # 160
Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.
You need to shape the query to display the following three columns:

* Month
* Sales
* Year
'What should you select in Power Query Editor?

A. Unpivot columns.
B. Pivot column
C. Transpose
D. Merge columns

Answer: A

Explanation:
Explanation
This will convert your column headers (Jan-20, Feb-20,...) into row values under a new column called Attribute. You can then rename this column as Month and change its data type to Date. You will also have a new column called Value that contains the sales amounts for each month. You can rename this column as Sales and change its data type to Decimal Number.

NEW QUESTION # 161
You have a table that contains the following three columns:
* City
* Total Sales
* Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation:

Box 1: Total Sales
Box 2: Occupation
Box 3: City
You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

NEW QUESTION # 162
You have the following table named Location.

The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations.
What should you do?

A. Change the name of the GeoCode column to Country.
B. Change the Default Summarization of the GeoCode column.
C. Change the name of the Location table to Country.
D. Add a Geoportal column to the Location table.
E. Change the Data Type of the GeoCode column.
F. Replace the values in the GeoCode column with postal codes or zip codes.

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

NEW QUESTION # 163
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:
* Visualizations that include all measures in the data over time
* Year-over-year calculations for all the measures
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.

Answer:

Explanation:
Explanation

Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c70

NEW QUESTION # 164
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

NEW QUESTION # 165
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

The visualization appears as shown in the Chart exhibit. (Click the Chart 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.