Software pros, listen up!

Labour day Offer ends tonight, you can get 25% off on enrolling in 2 or more courses at once. Use Code: SAVINGS25

Search for products... All Courses  Contact Us  MY ACCOUNT 

Your previous exam results will be recorded here.

Check Answer

BACK

Summary Leaderboard table View answers

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52

53 54 55 56 57 58 59 60 61 62 63 64 65

Correct Incorrect
Review Question Summary

1. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the server databases contain the same tables.
You create a new Power BI Desktop project based on 50 tables from SQLTest. Before publishing the report to Power BI Service, you need to
connect the project to tables in SQLlive.
What should you do in the Query Editor, with a low administrative effort, in order to meet the goal?

Edit the on-premises gateway settings.

Configure the Data source settings.

Change manually the data source for each table.

Copy the model into another PowerBI Project.

Unattempted
The correct answer is: Configure the Data source settings. This is the only option that makes sense: in fact, in the Power Query editor, by
going to Home> Data source settings, it is possible to update the origin of the data for the whole model you are working on.

2. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider the table shown in the picture:

All cells in the date column must contain a date. You want to replace null values with the date from the previous row.
Which command should you run in Power Query?

Fill, and then Down.

Replace Errors.

Remove errors.

Date, and then Earliest.

Unattempted
The right answer is: Fill, and then Down. You are not required to remove any values, but to use some of the existing ones to fill the null cells.
The Fill function filled the values by replacing the null values with the value above. Check how to achieve this task here:
- [Link]

3. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your colleague has shared with you a file containing a dataset about global market sales. After importing it inside your Power BI Desktop, you
want to get a quality profile of the dataset.
How can you achieve this task?

From Power Query, check the data profiling functionalities.

Create a table visual which contains all the dataset columns, then order columns by errors and blank values.

Create a DAX calculated column that uses the FILTER function.

From Power BI Desktop, set a Page Filter that includes only errors and blank rows.

Unattempted
The right answer is: From Power Query, check the data profiling functionalities. Check how can you get a Profiling Report in Power BI here: -
[Link]

4. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider two tables named Tab1 and Tab2 that retrieve data from an Oracle database. Both tables have the same data structure. You plan to
combine the data from Tab1 and Tab2.
Select the right command to use.

Append Queries.

Combine Files.

Merge Queries.
 Merge Rows.

Unattempted
The right answer is: Append Queries. In this case, as you have additional rows of data that you’d like to add to an existing query, you need to
append the query. Examine a deep explanation between merge and append here: - [Link]
power-query

5. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider the tables shown in the picture:

The tables come from a Microsoft SQL Server database.

The Enrollments table contains more than two million rows. You plan to import a sample of data from the Enrollments table in Power BI Desktop.
There are two ways to achieve the goal from the following options, select them.

From Query Editor, create a column by using Custom Column command

 From Query Editor, filter the table by Enrollment_date.

From Query Editor, add a SELECT statement that uses a WHERE clause.

In the Power BI Service, create a calculated table.

From Query Editor, create a custom column that SAMPLE Function.

Unattempted
The right answers are: 1. From Query Editor, add a SELECT statement that uses a WHERE clause. When you retrieve data from an SQL
Database, you can filter which range of data you want to work on by clicking Advanced Options
 Read more here:

- [Link] 2. From Query

Editor, filter the table by Enrollment_date. By applying a filter on the Enrollment[Enrollment date] column, you are selecting the range of data
row.
6. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider the table shown in picture 1:

You want to configure the table as shown in picture 2:

Which command should you use?

From the Split Column menu, click By Delimiter.

From the Extract menu, click Text After Delimiter.

From the Format menu, click Trim.

From the Extract menu, click Last Characters.

Unattempted
The right answer is: From the Extract menu, click Text After Delimiter. As you are required to reshape an existing column and not to create a

new one, the right menu to choose from is Extract: From here, by choosing the Text After Delimiter

option, you will able to specify the delimiter (-) and obtain the desired column configuration.

7. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have imported a data source in Power BI Desktop, now you plan to use Power Query to add some data transformations.
You notice that the data model presents a huge list of queries that make it difficult to organize the transformation steps.
Which best practice can you adopt in Power Query to solve this issue?

Append queries when it is possible.

Reduce the list of queries by importing small parts of the original dataset.

Create a group of queries to classify the data-transformations.

Re-name all the queries with a classification syntax.

Unattempted
The right answer is: Create a group of queries to classify the data-transformations. Check all the benefits of grouping queries here: -
[Link]

8. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider the table shown in the picture:
You want to replace the ”-” value in the DISCOUNT_CODE column with the text ”NO_DISCOUNT”.
Which M function completes the following formula?

[Link]

[Link]

[Link]

[Link]

Unattempted
The right answer is: [Link] [Link] replaces an existing value with a new value in the specified columns of a table.
Check the difference between this function and [Link] one here: - [Link]
- [Link]

9. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a Power BI Model containing the tables shown in the picture.

Course[CourseName] contains NULL values. You plan to add a new column to the Course table that uses the following formula:
=if [CourseName]=null then “NA” else [CourseName]
Select the option available in the Query Editor to meet the goal.

Index Column.

Column From Examples.

Conditional Column.

Pivot Column.

Unattempted
The right answer is: Conditional Column. A conditional column is a column based on a condition imposed on an existing column. Examine in-
depth its potentials here: - [Link] Check the difference
with a Column from Examples here: - [Link]

10. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You are working on the Contoso Sales report in Power BI. It relies on a large dataset.
The Sales[DateKey] column is in the Date/time format as shown:

What can you do to improve performance when you are getting data in Power BI?

Compress the databes into a zip file.

 Use the CALENDARAUTO function in DAX.

Separate date and time into two distinct columns before importing them into Power BI.

Delete the Sales[DateKey] column.

Unattempted
The right answer is: Separate date and time into two distinct columns before importing them into Power BI. In order to improve our Power BI
model performances, it is really important to work at the data source level. Among the different techniques available to optimize the modeling
experience, there is the split between the date and time if they come from a single combined column. Check the following link to discover more
options: - [Link]

11. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You want to import 50 Microsoft Excel files to Power BI Desktop. All the files share the same structure and are they stored in a unique desktop
local folder. You plan to import all Excel files into one table.
How can you achieve the goal?

Add a Microsoft Excel data source and select all the files in the folder

Add every single file to the model and then use the Merge Queries command.

Add a folder data source and use the Combine Files command.

Add a folder data source and use the Append Queries command.

Unattempted
The right answer is: Add a folder data source and use the Combine Files command. Discover more here: - [Link]
ie/office/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4

12. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider the table shown in the picture:

You want to create a custom column that hides the first seven digits of the NationalCode. The values in the new column should be displayed in
the following format: xxx-xx-0000
Select the proper order of targets to complete the formula:

[Link] - [Link]

[Link] - [Link]

[Link] -[Link]

[Link] - [Link]
Unattempted
The right answer is: [Link] -[Link] If you focus on the first row, the question is asking you to convert the cell value 111-21-8932 into
xxx-xx-8932. In the M language, the text function that meets this purpose is [Link]: it returns the result of replacing all occurrences of
an existing text value (111-21-) into a new text value (xxx-xx-). The [Link] function is necessary to give to the [Link] function the
position of the replaced new values (7, in this case). Analyze them here: - [Link]
- [Link] What is the difference with [Link]? Follow the link to discover more:
- [Link]

13. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have connected a Microsoft SQL Server Analysis Services (SSAS) cube to Power BI Desktop, generating the following query:

The query retrieves 10,200 records. After checking the data source, you discover that there are 21,300 records.
How can you ensure that the query retrieves all 21,300 records?

Delete the Remove Duplicates steps.

 Change the query to use Direct Query mode.

Change the query to use Import connection mode.

From Power Query, select Unpivot Columns command.

Unattempted
The right answer is: Delete the Remove Duplicates steps. Check how it works here: - [Link]
duplicates-power-query-d9cffc69-dc5d-4d94-8b66-72779688874d

14. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have created a query to append the rows of three different tables that contains product data into one table named Products.
Now you need to set-up a new ID Column to be sure that every row in the Products table contains a unique value.
How can you meet the goal?

Add an Index Column to Products Table.

Select a Product Table Column and click Remove Duplicates.

Add a Column from Examples to Products Table.

Add a counter column to Products Table.

Unattempted
The right answer is: - Add an Index Column to Products Table. - Select a Product Table Column and click Remove Duplicates. Power Query
allows users to index rows in a table thanks to the "Add index column" tool. In order to get rid of the duplicated values it is necessary to
remove them by right clicking on selcted column in the Power Query Editor. Check how to create an Index Column from the scratch here:
- [Link]

15. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider the following tables:

You plan to create a relationship between the Enrollments table and the Courses table on the Course_ID column.
What task do you need to perform before creating the relationship?

In the Courses table query, use the [Link] function.

 In the Course table query, use the [Link] function.

In the Enrollments table query, use the [Link] function.

In the Enrollments table query, use the [Link] function.

Unattempted
The right answer is: In the Courses table query, use the [Link] function. In order to realize the relationship, the two
columns must be set with the same data type: the [Link] serves this purpose. Check the difference with the
[Link] here: - [Link] - [Link]
us/powerquery-m/table-transformrows

16. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have the tables shown in the picture:

There is a relationship between tables, you want to create a report in Power BI Service that shows TotalPaid by EnrollmentDate and by
CourseName.
N.B. Only the required columns must be shown in the report.
Select the right configuration of EnrollmentID column and TeacherID column.
 From Query Editor, click on "Choose Columns" and remove the TeacherID column, then in the report view hide the EnrollmentID
column.

From Query Editor, select EnrollmentID and click Remove other Columns then select TeacherID and click Hide.

From Query Editor, select EnrollmentID and click Remove Columns then select TeacherID and click Hide.

From Query Editor, select EnrollmentID and click Hide then select TeacherID and click Remove Duplicates.

Unattempted
The right answer is: From Query Editor, click on "Choose Columns" and hide the EnrollmentID column, then select TeacherID and click
Remove. You can remove columns in Power Query by clicking "Choose Column" from the Home Tab. EnrollmentID in necessary to realize the
relationship between the tables, so you can simply hiding it in the report view; while TeacherID is not useful for the described purpose, so you
can get rid of it.

17. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider two tables named Course and Teacher.
In the picture, you can find a sample of data for the tables. You want to know which Teacher is responsible for which course.
Which kind of Join should you use?

Left Join.

Right Join.

Outer Join.

Inner Join.

Unattempted
The right answer is: Inner Join. This is the merging join type that returns only the rows existing in both the left and right table.

Check how the different join types work here: - [Link]

18. Question Report Question

Question time : 00:00:00 1 points
Category: PL-300
Consider the table named Courses shown in the picture:

You plan to create a relationship between the Courses table and another table called Enrollments.
Which function let you optimize the query for Courses before creating the relationship?

[Link]

[Link]

[Link]

[Link]

Unattempted
The right answer is: [Link] The Course table has some duplicates: thanks to the table function [Link], you can remove
duplicated rows from the selected table. Check the difference between [Link] and [Link] here: - [Link]
us/powerquery-m/table-distinct - [Link]

19. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
How do you know that the TotalCost column has 0% of empty rows?

Thank to the DAX PERCENTAGES formula.

Thanks to the column quality tool in Power Query.

Thanks to the column distribution tool in Power Query.

Thanks to the column profile tool in Power Query.

Unattempted
The right answer is: Thanks to the column quality tool in Power Query. Data profiling is a Data Preview option in the Power Query Editor useful
to better understand the data inside your tables. Column quality, Column distribution and Column profile are all available tools. You can
discover how to activate them by following these guidelines: - [Link]

20. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a table named Enrollments that contains a column named StudentID. The Data Type of StudentID is ”whole number”. After you have
imported tables in Power BI Desktop, you discover that the StudentID column contains several non-numeric values. You want the non-numeric
values in the StudentID column set to 0.
How can you achieve the goal?

The solution must request a low transformation effort.

From Query Editor, open Advanced Editor and use [Link] function.

From Query Editor, select the StudentID column and click Remove Errors.

From Query Editor, select the StudentID column. Click Replace Errors and set a value of 0.

From Query Editor, open Advanced Editor and use [Link] function.

Unattempted
The right answer is: From Query Editor, select the StudentID column. Click Replace Errors and set a value of 0.

21. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a Power BI report that contains a Pie chart and a Line chart on the same page. The Line chart displays the total Enrollments by Year,
while the Pie chart displays the total Enrollments by course.
You want to ensure that when you select a year on the Line chart, the Pie chart remains unchanged.
How can you perform this task?

Edit the interactions from the Format menu.

Delete the relationship between the Enrollments table and the Date table.
 Set a visual level filter on the report page.

Set a visual level filter on the Pie chart.

Unattempted
The right answer is: Edit the interactions from the Format menu. Check here how to control visuals interactions:
- [Link]

22. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a table that contains the last two years of sales data. You want to identify the outliers.
Which type of visual best fits your needs?

Key Influencers.

Bar chart.

Scatter plot.

Area chart.

Unattempted
The right answer is: Scatter plot. The Scatter Plot visual allows identifying the outliers. They are an observation of data that does not fit the rest
of the data. Check how to set up the Scatter plot here: - [Link]

23. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You plan to use R Scripting in Power BI Desktop to create several visualizations.
Which actions should you perform to use R scripting in Power BI Desktop?

You don't need to perform any action: R scripting is available in Power BI Desktop by default.

Download and install RStudio on the computer that has Power BI Desktop installed.

Download and install R plug-in for Power BI Desktop.

Download and install Microsoft R on the computer that has Power BI Desktop installed.

Unattempted
The right answer is: Download and install Microsoft R on the computer that has Power BI Desktop installed. Discover how to create your R
visuals here: - [Link] - [Link]
reports/desktop-r-visuals

24. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a report in Power BI Desktop that contains several donut charts and a date slicer.
You plan to create a slide show that displays the donut charts filtered by different years. You want that the slide show can be used from Power BI
Service.
What should you do before publishing the report?

Filter the donut charts by using the slicer, then create bookmarks.

Configure page level filters, and then create groups that use the Bin group type.
 Configure drillthrough filters for each bar chart, and then select Selection Pane.

Configure report level filters, and then create groups that use the List group type.

Unattempted
The right answer is: Filter the bar charts by using the slicer, then create bookmarks. Check how to configure bookmarks, and how to play with
slicers here: - [Link] - [Link]

25. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider the following table scheme:
Note that in the Date table, the date_id column has a format of yyyymmdd and the month column has a format of yyyymm.
The week column in the Date table and the week_id column in the Weekly_Returns table have a format of yyyyww.
You are in charge of building a Power BI report following these requirements:
The Enrollments managers ask for a visual to analyze enrollment performance versus enrollment targets. You must include in the visualization a
time trend across months.
Which visualization object should you select?

Multi row card.

KPI.

Gauge.

Key Influencers.

Unattempted
The right answer is: KPI. In order to meet the Enrollments Manager requirements, you have to set up the "Trend Axis" available in the KPI
visual. Check how KPI visual works here: - [Link]

26. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You want to use Python Scripting in Power BI Desktop in order to create several visualizations. After you have installed and configured Python
for Power BI Desktop, you try to run the following code:
from matplotlib import pyplot;
ax = [Link]();
[Link](x = ‘Courses’, y = ‘Total Enrollments’, color = ‘green’, ax = ax)
Power BI Desktop returns the following error message:

How can you fix the issue?

You should add the following command to the script: [Link]();

You must enable the Pyhton Visuals before running code.

You need to refresh the IDE settings.

You must refresh the dataset origin connection.

Unattempted
The right answer is: You should add the following command to the script: [Link](); Without this command, the script is not complete.
Check how Python and Power BI interact here: - [Link]
- [Link]

27. Question Report Question

Question time : 00:00:00 1 points
Category: PL-300
You have a table named Enrollments with the following columns:
– StudentID;
– CourseID;
– Date;
– CourseName;
– FeePaid.
You create a report that contains a Stacked Column Chart that shows the count of Students by CourseName, then you want to customize the
information placed in the visualization tooltip for the chart.
What should you do first?

Create a new report page and set it as Tooltip.

Disable the tooltip option from the Format pane of the Stacked Column Chart.

Set the CourseName column as Tooltip field.

Set the StudentID column as Tooltip Field.

Unattempted
The right answer is: Create a new report page and set it as Tooltip. Check how to customize tooltips in Power BI here:
- [Link] - [Link]
reports/desktop-tooltips

28. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You create a Power BI Desktop project named Enrollments_BI that contains a table with the following columns:
– StudentID;
– StudentName;
– City;
– ProvState;
– Country.
You configure a bar chart to display the number of students by Country, and drill down to ProvState, and in the end to City.
You publish the Enrollments_BI project to Power BI Service and plan to share it with your colleagues: how could you share it?
N.B. Your colleagues must be able to use the Drill Down feature.
Solution: You create a dashboard and pin the Bar Chart visualization to it, then share the dashboard with your team.
Does this solution meet the goal?

No

Yes

Unattempted
The right answer is: No. This solution doesn't work because the Drill Down feature is not currently available for dashboards experience. You
have to share the data as a report with your colleagues.

29. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a table containing the following columns.
– Date;
– Funds;
– Expenses.
You configure a Line and Clustered Column Chart as the following:
– Date Column as Shared Axis
– Funds Column as Line Values
– Expenses Column as Column Values
You notice that the Line Values doesn’t’ match the correspondent Y-axis Values and it is set on the top of the chart by default as shown in the
picture:

How can you fix the visualization?

Set to Auto the Y-axis 'start' and 'end' settings.

Remove the Default Summarization from the Funds column.

Remove the Default Summarization from the Expenses column.

Edit the data type of Funds column as a Whole Number.

Unattempted
The right answer is: Set to Auto the Y-axis 'start' and 'end' settings. By changing this setting, you create consistency between the two scale
values. Explore how to create a Line and Clustered Column Chart here: - [Link]
power-bi/

30. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have created a Power BI dashboard that contains visualizations of sales data.
You want to enable sample questions that users can ask when using the Q&A option.
What do you need to modify in the Power BI Settings?

Reports.

Dashboards.

Datasets.

Workbooks.

Unattempted
The right answer is: Datasets. Check how to enable and use Q&A and Cortana from Power BI Service and Power BI Desktop here:
- [Link]

31. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You plan to create a Corporate Power BI Desktop Project that will be shared with the entire organization.
You need to customize the report with both the corporate colors of your organization and a set of custom icons.
How can you meet the goal?

The solution must request the lowest administrative effort.

Select the visualization you want to add to the report, then edit their color properties from the Format Pane.

Configure an XML file and then import it in Power BI Desktop as Custom Theme.

Configure a JSON file and then import it in Power BI Desktop as Custom Theme.

Access to Power BI Theme Gallery and import a blank theme, then customize it.

Unattempted
The right answer is: Configure a JSON file and then import it in Power BI Desktop as Custom Theme. Check how to use report themes here:
- [Link]

32. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have a dashboard named Sales_01. Q&A is enabled on the dashboard. When users try to get the count of clients, the query fails. Instead,
when users ask for the count of subscribers, they receive the expected results. You want to ensure that both queries will return the same results.
Which action should you perform?

Edit Synonyms from Power BI Desktop.

Edit tables from Power Query in Power BI Desktop.

 Edit Relationships from Power BI Desktop.

Edit Synonyms from Power BI Service.

Unattempted
The right answer is: Edit Synonyms from Power BI Desktop. A good practice to improve the Q&A experience is adding synonyms from the
Power BI Desktop Model view. Check how to do it here: - [Link]
practices#:~:text=To%20add%20synonyms%2C%20in%20Power,column%20or%20table%20introduces%20ambiguity.

33. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a table named Students with the following columns:
– StudentID;
– StudentName;
– City;
– ProvState;
– Country.
You are creating a Power BI report that includes a bar chart to display the number of students by location. You want that the report will show the
number of students by Country, and drill down to ProvState, and in the end to City.
Select the right configuration of the drill down in the bar chart.

In the Legend field, add ProvState. In the Axis field, add Country and City.

In the Value field add all the columns in the following order: Country, ProvState, City.

In the Value field, add Country. In the Axis field, add ProvState and City.

In the Axis field, add all the columns in the following order: Country at the top, followed by ProvState and City.
Unattempted
The right answer is: In the Axis field, add all the columns in the following order: Country at the top, followed by ProvState and City. Check the
full procedure to configure a drill experience in a visual here: - [Link]

34. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You are building a complex report in Power BI, full of visuals.
You want to be sure that the user will read it in a logical way when he/she uses the keyboard.
On what should you have to work on?

Filters hierarchy.

Tab order.

Page order.

Layer order.

Unattempted
The right answer is: Tab order. Tab order is the order in which users interact with the items on a page using the keyboard. In order to change
the default order, from the View tab it is possible to open the Selection pane and select Tab order. Check here the interaction between the
keyboard navigation and your reports: - [Link]

35. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a table named Enrollments that contains enrollments data for Europe. Check the sample dataset in the picture:

You try to create a map to show Enrollments by Area, but you find out that the map doesn’t work.
What can you do to fix the map visualization?

Add a column that contains latitude and longitude.

Create a table named Country and create a relationship with the Enrollments table.

Select the Area field. From the Modeling tab, change the Data Category.

Select the Area field. From the Modeling tab, change the Data Type.

Unattempted
The right answer is: Select the Area field. From the Modeling tab, change the Data Category. In the Report View or Data View, you can specify
the data category for a column so that Power BI Desktop knows how to treat its values when in a visualization. Check how to specify data
categories here: - [Link]

36. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have a Microsoft Excel file named [Link] that contains data about Student Enrollments by Region.
After you have imported the Excel file to Power BI Desktop, you create a bar chart showing the Enrollments amount by region.
Unfortunately, the Enrollments amount value appears as the count of Enrollments amount instead of the sum of Enrollments amount for each
region.
You need to modify the query to ensure that the data appears correctly.
How can you fix the issue?

Change the Data Type of Enrollments amount column to Whole Number.

Create a calculated column that use the SUM function.

Delete the query, import the data into Microsoft One Drive for Business, and then from Power BI Service connect to the [Link] by
clicking import.

Create a calculated measure that uses the SUMX function.

Unattempted
The right answer is: Change the Data Type of Enrollments amount column to Whole Number. Data Types and Data Categories are often automatically
attributed by the Power BI intelligence when data sources are imported into the model. Sometimes, it happens that those software engine
assumptions need to be manually changed in order to make our report work: that's the case. Here, the Enrollment values had been probably
transposed as a text type. Check how many Data Types you have, and how you can aggregate them here: - [Link]
bi/connect-data/desktop-data-types - [Link]
aggregates#:~:text=Types%20of%20data&text=The%20service%20can%20even%20aggregate,distinct%20occurrences%20of%20each%20category.

37. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your Power BI model contains two tables named StoreVisits and Date. After you have created a measure to calculate the number of Store Visits,
you use it in a report visualization as shown in the picture.
You found that the total number of customer visits was 60,000 and that there were only 5,000 customer visits in August. You check that the total
number of visits was 90,000 and that there were only 10,000 visits in October.
How can you fix the report visualization?

Disable the default Summarization to the Number of visits column.

Modify the measure to use the sum DAX function.

Create a relationship between the StoreVisits and the Date table.

Modify the measure to use the Count function.

Unattempted
The right answer is: Create a relationship between the StoreVisits and the Date table. A lot of visual problems often come from issues in
relationships between the data they are intended to show. Without a relationship, in fact, a visual that combines data from two different tables
will not work properly.
38. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your principal asks you to print some Power BI reports in order to physically share them with the other colleagues during the next meeting.
When you start to print the reports, you notice that some tables show less rows than they really have.
How can you solve this issue?

Change the table visual to a matrix visual.

Group the rows of the table to reduce its size.

Extend table visual to the whole page.

Create a Paginated Report.

Unattempted
The right answer is: Create a Paginated Report. When you print a report as [Link] in Power BI, only the current view will be printed: therefore,
if you stop scrolling a table visual with multiple rows, the only rows that will be printed are the ones you saw on the page. To solve this
limitation you can use the Paginated Reports: [Link]
power-bi

39. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a table named Enrollments containing the sample data shown in the picture.

After you have created a stacked bar chart to display CourseName by StartingDate, you notice that the axis shows all the individual dates. You
want to set the drill down in the chart to display CourseName by year, by week, and day.
What is the first task to do?

From the Format Pane of the Chart set the type of the Y-Axis to Categorical.

Create a new table that has columns for the date, year, week, and day.

From the Format Pane of the Chart set the type of the X-Axis to Categorical.

Unattempted
The right answer is: Create a new table that has columns for the date, year, week, and day. When a column is formatted as a date, Power BI
will display a drillable hierarchy of year, quarter, month and days, but not of week. You have to create a column that includes it.

40. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You plan to create a custom visualization for Power BI. What do you install first?
 Microsoft Azure PowerShell

[Link]

Power BI Service

JavaScript

Unattempted
The right answer is; [Link] Check how to install the developer environment here: - [Link]
bi/developer/visuals/custom-visual-develop-tutorial

41. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a table named Enrollments that contains the following three measures:
– A measure named Total Enrollments Last Year shows the Enrollments from the previous calendar year. The current value is 52,000.
– A measure named Total Enrollments This Year shows the Enrollments from the current calendar year. The current value is16,000.
– A measure named Total Sales Difference based on the following DAX formula: Enrollments[Last Year] – Enrollments[This Year].
You need to create the following visualization.
You plan to create a Gauge visualization by using the measures above. Select the right configuration for the visualization.

Value: Total Enrollments this Year - Maximum Value: Total Enrollments this Year - Target Value: Total Enrollments Last Year

Value: Total Enrollments this Year - Maximum Value: Total Enrollments last Year - Target Value: Total Enrollments Last Year

Value: Total Enrollments last Year - Maximum Value: Total Enrollments last Year - Target Value: Total Enrollments this Year

Value: Total Enrollments last Year - Maximum Value: Total Enrollments this Year - Target Value: Total Enrollments Last Year

Unattempted
The right answer is: Value: Total Enrollments this Year - Maximum Value: Total Enrollments last Year - Target Value: Total Enrollments Last
Year Check how to set a Gauge diagram here: - [Link]

42. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider the table shown in the picture:
You add Country and Enrollments columns to a table visualization in Power BI Desktop and the result appears as in the following picture:

Why does it show three rows of data instead of six?

Data Category of Country is set to Country.

The Enrollments column data type is set to text.

Because of Default Summarization on Country.

Because of Default Summarization on Enrollments.

Unattempted
The right answer is: Because of Default Summarization on Enrollments. Discover more about the Default Summarization here:
- [Link]

43. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You are analyzing the Customer Sales monthly report and you notice that the Churn Rate metric is strangely increased.
You want to understand which variables may affect this result.
Which solutions can help you to explore the possible causes in Power BI Desktop?

Decomposition tree visual.

Enable the Auto ML.

 Use the Gauge visual.

Use the Key Influencer visual.

Unattempted
The right answers are: - Decomposition tree visuals. - Use the Key Influencer visual. Check how these visuals work here: -
[Link] - [Link]
bi/visuals/power-bi-visualization-influencers

44. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your Organization plan to create a Power BI App which would include Power BI dashboards and other custom content.
The App will be available to all Organization users. You need to be sure that all the PowerBI users will have access to the App.

NB The solution must request the lowest administrative effort.

Add each user to the app workspace and give him "member" permissions.

Create an Office 365 Group named "all organization users" and give it app workspace "member" permissions.

Create an Office 365 group named "all organization users" and share the link to get the App.

Ask the PowerBI admin for enabling permission to install the app automatically to all users.

Unattempted
The right answer is: Ask the Power BI admin for enabling permission to install the app automatically to all users. Check how to automatically
install apps here: - [Link]
45. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have an app workspace. You collaborate in the app workspace with a user named User_01. User_01 is a member of the workspace. You
plan to create a report that retrieves data from a Microsoft SQL Server database. You want that User_01 can edit the report both from Power BI
Desktop and from [Link].
Select the right order of the actions to achieve the goal.

From Power BI Service, create a report - From Power BI Service share the report in the App Workspace - From the App Workspace
settings, allow User_01 to export data from the report.

From Power BI Service, create a report - From Power BI Service share the report with User_01.

From Power BI Desktop, add a data source - From Power BI Desktop, create a report - From Power BI Desktop, publish the report
to the Power BI Service.

From Power BI Desktop, create a report - From Power BI Desktop, publish the report to the Power BI Service - Deploy an On-Premises
Data Gateway (personal mode).

Unattempted
The right answer is: From Power BI Desktop, add a data source - From Power BI Desktop, create a report - From Power BI Desktop, publish
the report to the Power BI Service. User_01 is already a member of the workspace. You don't need extra-steps after you publish the report to
the shared workspace.

46. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have a report named Sales in an app workspace named Sales_BI. User_01 is a member of the Sales_BI.
You have enabled the option ”Allow users to build new content using the underlying dataset” from the report settings.
What will happen to the underlying dataset? Select the true statements.

Row-level security restrictions on the dataset are in effect.

You haven't made a copy of the dataset. The dataset still resides in its original location.

You have made a copy of the dataset. The dataset is duplicated in your workspace.

Unattempted
The right answers are: - You haven't made a copy of the dataset. The dataset still resides in its original location. - Row-level security
restrictions on the dataset are in effect. Check how to create reports based on datasets from different workspaces here:
- [Link]

47. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You manage a list of reports for the sales team of your company. The company operates across different regional markets and every region has
its sales manager.
You need that the sales managers can interact with the data from their region. In addition, you want that sales managers can’t modify the
report’s layout.
Note that the datasets use row-level security (RLS).
How can you meet the goal?

Disable Row Level Security.

Create a Power BI app that contains all the reports and give access permissions to the sales managers.
 Create a new workspace, duplicate the datasets and reports, add the sales managers as owners of the workspace.

Publish the reports to a workspace and store the datasets in another one.

Unattempted
The right answer is: Create a Power BI app that contains all the reports and give access permissions to the sales managers. RLS can't restrict
access to the layout of the report. With Apps, users can interact with the app content but can't modify it.

48. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have a Power BI app workspace that contains 30 reports shared with 55 users of your organization.
You plan to start a reports maintenance program. You need to know which reports present a critical usage.
How can you achieve this task?

Check the activity log by using the Power BI Management cmdlets for PowerShell.

Request to the Power BI admin enabling usage metrics for content creators.

Go to the Health tab in the Capacity settings area in the Admin portal.

You can use the Power BI Premium Capacity Metrics App.

Unattempted
The right answer is: Request to the Power BI admin enabling usage metrics for content creators. Check how to Monitor usage metrics for
Power BI dashboards and reports here: - [Link]

49. Question Report Question

Question time : 00:00:00 1 points
Category: PL-300
You have a table named ‘Enrollments’ stored on a Microsoft Excel spreadsheet.
You want to add the Enrollments table to a Power BI dashboard as a tile.
What is the tile configuration?

From Excel, import the workbook to PowerBI Desktop, then publish it to PowerBI Service.

From the Power BI service, upload the Excel workbook.

From the Power BI service, import the data from the Excel workbook.

From the Power BI tab in Excel, pin the table.

Unattempted
The right answer is: From the Power BI tab in Excel, pin the table. Check how Pin a tile to a Power BI dashboard from Excel here:
- [Link]

50. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You plan to publish a report from Power BI Desktop to Power BI Service.
The report retrieves data from an Azure SQL Database. How can you ensure that users of your organization will see the current data when they
access the report on the Power BI Service?

In the Power BI service's Settings page, select the Datasets tab, choose the dataset that uses DirectQuery, and select Edit
credentials.
 Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode.

Deploy an on-premises data gateway (personal mode). Connect to the data by using the Live Connectivity mode.

Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Connectivity mode.

Unattempted
The right answer is: In the Power BI service's Settings page, select the Datasets tab, choose the dataset that uses DirectQuery, and select
Edit credentials. The Azure SQL Database can work in DirectQuery Mode without using an on-premises data gateway. Check more details
here: - [Link]

51. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
A Power BI user in your organization has published a report to the Web. The report contained sensitive data.
What can you do to prevent the reports from being published on the Web?

From Azure AD remove the PowerBI Pro license from the user.

From the app workspace settings remove the user as a member.

From the Power BI Admin portal, disable the Publish to web setting.

From the Power BI Pro, delete the embedded codes.

Unattempted
The right answer is: From the Power BI Admin portal, disable the Publish to web setting. Check how Publish to Web settings work here:
- [Link]
codes/
52. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your organization owns a consistent number of dashboards on Power BI. Your goal is to ensure that when users browse the list of the available
dashboard, they can see the ones that contain Personal Identifiable Information.
Which function best fit your needs?

Row Level Security.

Tiles.

KPIs.

Microsoft Information Protection sensitivity labels.

Unattempted
The right answer is: Microsoft Information Protection sensitivity labels. Microsoft Information Protection sensitivity labels provide a simple way
for your users to classify critical content in Power BI without compromising the access to the content. Check here how IPSL work:
- [Link]

53. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your organization plan to use the Power BI Service to get several visualizations from data stored in a custom application.
The developers ask for pushing data into the Power BI Service from the custom app.
How can you ensure this task?
 Go to Office 365 Admin portal and register a web app.

Go to Tenant Setting from PowerBI admin portal and set the API permissions.

Go to [Link] and create an empty report.

Go to [Link]/apps and register an application.

Unattempted
The right answer is: Go to [Link]/apps and register an application. The first step you should do is to register a new app and select
the Power BI APIs that your application needs. This task is achievable in two ways: from the Power BI Application Registration Tool and from
the Azure Portal. Check the complete procedure here: - [Link]
with-the-power-bi-application-registration-tool

54. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have a report named Sales_01. You plan to publish Sales_01 to a Blog, but you need to be sure that the report will preserve its size as a set
on the report page.
Which View Mode should you set for the Sales_01 report?

Fit to Width.

Custom size.

16:09

Actual Size.

Unattempted
The right answer is: Actual Size. Check all the page display settings in a Power BI report here: - [Link]
bi/create-reports/power-bi-report-display-settings

55. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your company stores sales data on a Microsoft SQL Server. You are responsible for creating a Power BI report, ensuring the quality and
completeness of the sales data. In particular, you must be sure that the report doesn’t show negative amounts for sales data.
How can you review data in Power Query before creating the data model?

Create a column from examples and fill it with positive values only from the total_sales column.

Select Column profile, and then select the total_sales column.

Select the total_sales column and filter out negative values.

Select the total_sales column and delete all the negative values.

Unattempted
The right answer is: Select Column profile, and then select the total_sales column. The data profiling tools provide effective ways to clean,
transform, and understand data in Power Query Editor. Check all the features here: - [Link]
profiling-tools

56. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
In your Power BI report, you have the Sales table that has the following column:

The Sales table contains one million records per month. You want to minimize the data model size. Plus, you want to count sales by Date and
Store. How can you meet the two goals?

Create a calculated measures with the COUNTROWS function.

Create a calculated table with the SalesAmount column.

Use the Group by function in Power Query, aggregating sales by DateKey and StoreKey using Sum as operation.

Use the Group by function in Power Query, aggregating sales by DateKey and StoreKey using Count Rows as operation.

Unattempted
The right answer is: Use the Group by function in Power Query, aggregating sales by DateKey and StoreKey using Count Rows as operation.
Power Query offers a useful tool to summarize rows and count a certain number of records. It is possible to group by one or more columns: the
result is a table with a fewer number of rows. Here is what happens with our Sales table:
 Check the following

link for more: - [Link]

rows[Link]

57. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You have imported a dataset in Power BI Desktop from an Excel File. During the tables profiling, you discover two columns that need to be fixed:
– ColumnA presents several values starting with space;
– ColumnB contains several non-printable characters.
Which couple of commands should you use to fix the above column errors?

ColumnA: TRIM - ColumnB: CLEAN

ColumnA: LENGHT - ColumnB: TRIM

ColumnA: CLEAN WHITE SPACES - ColumnB: TRIM

ColumnA: CAPITALIZE EACH WORD - ColumnB: CLEAN

Unattempted
The right answer is: ColumnA: TRIM - ColumnB: CLEAN In the Power Querry editor, select the text column you want to shape and the right

click on them. This menu will appear: Trim is used to getting rid of white spaces,

while Clean is the good choice to remove the non-printable characters.

58. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Consider a column named Product_SKU. The values in the column have the following format:
• 7271-1123×998
• 7271-1123×945
• 7271-1123×924
The values after x in the Product_SKU column indicate the SKU extension. You plan to create a custom column in Query Editor that contains
only the SKU extensions.
Select the right order of functions to complete the following formula:

AFTERDELIMITER - REMOVERANGE

POSITIONOF - REMOVERANGE

POSITIONOF - TRIMEND

AFTERDELIMITER - RELATIVEPOSITION

Unattempted
The right answer is: AFTERDELIMITER - RELATIVEPOSITION Your goal is to transform the value ''7271-1123x998'' into ''998''.
[Link] returns the portion of a text after the specified delimiter: in this case, our delimiter is ''x''. The [Link] in
the formula is a piece of optional information: it is working as an index, to specify which occurrence of the delimiter should be considered and
that the indexing needs to be done from the end of the input. Check their syntax here: - [Link]
afterdelimiter

59. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You are configuring a Gauge Chart. Where do you set the Goal?

Power Query.

Calculated column.

Format settings.

DAX Formula.

Unattempted
The right answer is: Format settings. It is possible to manually set Minimum, Maximum, and Target values from the Format pane:
 Check how to set a Gauge diagram here:

- [Link]

60. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your Power BI report contains a clustered bar chart that has Sales[ReturnAmount] as the value and Product[ProductKey] as the axis.
You want to improve the visual by adding a horizontal line that shows which products have a return amount above the median amount.
How could you reach the goal?

In the Analitycs pane for the clustered bar chart, add a Percentile line set to 50%.

In the Format pane for the clustered bar chart, add a Constant line and set it to 0.5.
 In the Analitycs pane for the clustered bar chart, add a Constant line and set it to 0.5.

In the Analitycs pane for the clustered bar chart, add a Trend line.

Unattempted
The right answer is: In the Analitycs pane for the clustered bar chart, add a Percentile line set to 50%. The Analytics pane is a subsection of
the Visualizations pane in Power BI. It is a great feature that gives the opportunity to add dynamic reference lines to some visuals. Here is
what happens in our question's context:
Check the link to discover more options for the Analytics pane: - [Link]
pane

61. Question Report Question

Question time : 00:00:00 1 points
Category: PL-300
An area chart shows the discount quantity over years. Therefore, when you hover the mouse over a data point, you will see the discount quantity
at a certain year:
How could you provide additional information about the discount amount, on the black label?
The result should be as the following picture:

Add the DiscountAmount column on the secondary values.

 Add the DiscountAmount column on the tooltip.

Set a drillthrough option for the visual.

By right-clicking on the visual, select Analyze.

Unattempted
The right answer is: Add the DiscountAmount column on the tooltip. Check how to customize tooltips in Power BI here: -
[Link] - [Link]
reports/desktop-tooltips

62. Question Report Question

Question time : 00:00:02 1 points

Category: PL-300
You have a Power BI model that contains the following tables:

Consider a new table named SchoolYearDate which has the same columns schema as the Date table. You want to create a report that shows
the total Enrollments by SchoolYearDate and Calendar Month.
How can you achieve the task?
 Add SchoolYearDate to the model and create a one-to-many relationship with the Enrollments Table.

Append SchoolYearDate into the Date table.

Union SchoolYearDate and Date as one table.

Delete Date Table and use SchoolYearDate as the main Date table.

Unattempted
The right answer is: Append SchoolYearDate into the Date table. The Date table and the SchoolYearDate one have the same structure:
since you want to filter the Enrollment report by SchoolYearDate as well as by Calendar Month, you can append them into one query. To
create a report that shows the total enrollments by both SchoolYearDate and Calendar Month, follow these steps:

1. Create a Common Date Table:

First, create a common date table that includes all relevant date values (such as DateKey, MonthNumber, and Year). This table will
serve as the basis for time-related calculations in your Power BI model.
2. Add SchoolYearDate to the Model:
Next, add the SchoolYearDate table to your Power BI model. Ensure that it has the same columns schema as the Date table
(DateKey, MonthNumber, and Year).
3. Create Relationships:
Establish relationships between the Enrollments table and both the Date table and the SchoolYearDate table.
Specifically:
Create a relationship between the Enrollments table and the Date table based on the common date column (e.g., EnrollmentDate
and DateKey).
Create another relationship between the Enrollments table and the SchoolYearDate table using the same common date column
(e.g., EnrollmentDate and DateKey).
4. Use the Date Table for Time Intelligence:
Set the Date table as the main date table in your model. This ensures that time intelligence functions (such as TOTALYTD,
SAMEPERIODLASTYEAR, etc.) work correctly.
 You can do this by going to the “Model” view in Power BI Desktop, right-clicking on the Date table, and selecting “Mark as Date
Table.”
5. Create Visuals:
Now you can create visuals (charts, tables, etc.) in your report.
Use the SchoolYearDate table for grouping by school years (if applicable) and the Date table for grouping by calendar months.
Aggregate the enrollment data (e.g., using SUM or COUNT) to show the total enrollments.

Based on these steps, the correct answer is B. Append SchoolYearDate into the Date table. Sources: [Link]
us/credentials/certifications/resources/study-guides/pl-300 [Link] Check the Append
applications here: [Link]

63. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
You create a Power Bl dataset from your organization’s data warehouse using DirectQuery with the tables shown in the below schema exhibit.
You create a calculated table named Country from the dataset for unique values of country in the table named Customer.
You generate visualizations for the sales data including showing sales by product manager. The product manager data is not in the data
warehouse. The product manager data is in an Excel workbook on your local computer as shown in the Workbook exhibit below.

You do not have the Power BI On-Premises Gateway installed. You need to explain to the user when the data in the visualizations was last
refreshed.
Visuals referring to the Product Managers table show the values from..

when the user pressed F5

when the workbook was last loaded

when the dataset was last refreshed

when the user selected Refresh dashboard tiles

the latest values in the data warehouse

Unattempted
Visuals referring to the Product Managers table show the values from when the workbook was last loaded. Refresh is not supported for Excel
workbooks imported from a local drive. If you need Excel data to be updated when the dataset is refreshed, you should move the worksheet to
OneDrive for Business or install the Power BI On-Premises Gateway.

64. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
How do you connect to Excel files that contain target figures? The solution should involve minimum manual work when new Excel files are
created.

Connect to the files with Folder connector and use the Combine Binaries functionality

Connect to a new file each month, perform transformations, and use Append function in Power Query Editor to combine all targets in the
same table

Unattempted
Connecting to files separately will take time if there are a lot of files in the folder. It's always better to connect to the folder if files have the same
structure. If you copy new files in that folder with the same structure, that file will be loaded automatically without doing any change to data
sources.

65. Question Report Question

Question time : 00:00:00 1 points

Category: PL-300
Your workspace contains 10 dashboards. You want to allow users to find data by using natural language queries.
What should you do to meet the goal?

From the properties of the dashboard, modify the Q&A settings.

From the Power BI Desktop disallow Q&A option to the reports.

From the properties of the datasets, modify the Q&A settings.

Pin a Q&A tile into the dashboards.

Unattempted
The answer is: From the properties of the datasets, modify the Q&A settings. Check how to enable and use Q&A from Power BI Service with
the following screenshot:
 Quick Links Important
Links
ABOUT US
Skillcertpro REFUND POLICY
FAQ
REFUND REQUEST
BROWSE ALL PRACTICE
TESTS TERMS & CONDITIONS

CONTACT FORM PRIVACY POLICY

Copyright © 2024 SkillCertPro | Credits

Privacy Policy