MICROSOFT POWER BI Exam Questions Total Questions: 453 – 7 Mock Exams
Practice Set 1
Time limit: 0
0 of 37 questions completed
Questions:
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
Information
Click on Start Test.
You have already completed the Test before. Hence you can not start it again.
Test is loading...
You must sign in or sign up to start the Test.
You have to finish following quiz, to start this Test:
Your results are here!! for" PL-300 Practice Test 6 "
0 of 37 questions answered correctly
Your time:
Time has elapsed
Your Final Score is : 0
You have attempted : 0
Number of Correct Questions : 0 and scored 0
Number of Incorrect Questions : 0 and Negative marks 0
Average score
Your score
PL-300
You have attempted: 0
Number of Correct Questions: 0 and scored 0
Number of Incorrect Questions: 0 and Negative marks 0
You can review your answers by clicking view questions. Important Note : Open Reference Documentation Links in New Tab (Right Click and Open in New Tab).
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
Answered
Review
Question 1 of 37
1. Question
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?
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.
Correct
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:
– https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Incorrect
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:
– https://radacad.com/append-vs-merge-in-power-bi-and-power-query
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:
– https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Question 3 of 37
3. Question
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.
Correct
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:
– https://community.powerbi.com/t5/Desktop/How-to-create-Select-query-with-where-clause-with-AND-condition/td-p/593509
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.
Incorrect
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:
– https://community.powerbi.com/t5/Desktop/How-to-create-Select-query-with-where-clause-with-AND-condition/td-p/593509
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.
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:
– https://community.powerbi.com/t5/Desktop/How-to-create-Select-query-with-where-clause-with-AND-condition/td-p/593509
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.
Question 4 of 37
4. Question
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?
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.
Correct
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:
– https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything
Check the difference with a Column from Examples here:
– https://www.youtube.com/watch?v=GUwtPIKtqO0
Incorrect
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:
– https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything
Check the difference with a Column from Examples here:
– https://www.youtube.com/watch?v=GUwtPIKtqO0
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:
– https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything
Check the difference with a Column from Examples here:
– https://www.youtube.com/watch?v=GUwtPIKtqO0
Question 6 of 37
6. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/learn/modules/get-data/8-performance-issues
Incorrect
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:
– https://docs.microsoft.com/en-us/learn/modules/get-data/8-performance-issues
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:
– https://docs.microsoft.com/en-us/learn/modules/get-data/8-performance-issues
Question 7 of 37
7. Question
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?
Correct
The right answer is:
Add a folder data source and use the Combine Files command.
Discover more here:
– https://support.microsoft.com/en-ie/office/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4
Incorrect
The right answer is:
Add a folder data source and use the Combine Files command.
Discover more here:
– https://support.microsoft.com/en-ie/office/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4
Unattempted
The right answer is:
Add a folder data source and use the Combine Files command.
Discover more here:
– https://support.microsoft.com/en-ie/office/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4
Question 8 of 37
8. Question
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:
Correct
The right answer is:
Text.Replace -Text.Start
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 Text.Replace: it returns the result of replacing all occurrences of an existing text value (111-21-) into a new text value (xxx-xx-).
The Text.Start function is necessary to give to the Text.Replace function the position of the replaced new values (7, in this case).
Analyze them here:
– https://docs.microsoft.com/en-us/powerquery-m/text-replace
– https://docs.microsoft.com/en-us/powerquery-m/text-start
What is the difference with Text.Insert? Follow the link to discover more:
– https://docs.microsoft.com/en-us/powerquery-m/text-insert
Incorrect
The right answer is:
Text.Replace -Text.Start
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 Text.Replace: it returns the result of replacing all occurrences of an existing text value (111-21-) into a new text value (xxx-xx-).
The Text.Start function is necessary to give to the Text.Replace function the position of the replaced new values (7, in this case).
Analyze them here:
– https://docs.microsoft.com/en-us/powerquery-m/text-replace
– https://docs.microsoft.com/en-us/powerquery-m/text-start
What is the difference with Text.Insert? Follow the link to discover more:
– https://docs.microsoft.com/en-us/powerquery-m/text-insert
Unattempted
The right answer is:
Text.Replace -Text.Start
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 Text.Replace: it returns the result of replacing all occurrences of an existing text value (111-21-) into a new text value (xxx-xx-).
The Text.Start function is necessary to give to the Text.Replace function the position of the replaced new values (7, in this case).
Analyze them here:
– https://docs.microsoft.com/en-us/powerquery-m/text-replace
– https://docs.microsoft.com/en-us/powerquery-m/text-start
What is the difference with Text.Insert? Follow the link to discover more:
– https://docs.microsoft.com/en-us/powerquery-m/text-insert
Question 9 of 37
9. Question
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?
Correct
The right answer is:
Delete the Remove Duplicates steps.
Check how it works here:
– https://support.microsoft.com/en-us/office/remove-duplicates-power-query-d9cffc69-dc5d-4d94-8b66-72779688874d
Incorrect
The right answer is:
Delete the Remove Duplicates steps.
Check how it works here:
– https://support.microsoft.com/en-us/office/remove-duplicates-power-query-d9cffc69-dc5d-4d94-8b66-72779688874d
Unattempted
The right answer is:
Delete the Remove Duplicates steps.
Check how it works here:
– https://support.microsoft.com/en-us/office/remove-duplicates-power-query-d9cffc69-dc5d-4d94-8b66-72779688874d
Question 10 of 37
10. Question
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?
Correct
The right answer is:
In the Courses table query, use the Table.TrasformColumnTypes function.
In order to realize the relationship, the two columns must be set with the same data type: the Table.TrasformColumnTypes serves this purpose.
Check the difference with the Table.TrasformRows here:
– https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumntypes
– https://docs.microsoft.com/en-us/powerquery-m/table-transformrows
Incorrect
The right answer is:
In the Courses table query, use the Table.TrasformColumnTypes function.
In order to realize the relationship, the two columns must be set with the same data type: the Table.TrasformColumnTypes serves this purpose.
Check the difference with the Table.TrasformRows here:
– https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumntypes
– https://docs.microsoft.com/en-us/powerquery-m/table-transformrows
Unattempted
The right answer is:
In the Courses table query, use the Table.TrasformColumnTypes function.
In order to realize the relationship, the two columns must be set with the same data type: the Table.TrasformColumnTypes serves this purpose.
Check the difference with the Table.TrasformRows here:
– https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumntypes
– https://docs.microsoft.com/en-us/powerquery-m/table-transformrows
Question 11 of 37
11. Question
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?
Correct
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.
Incorrect
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.
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.
Question 12 of 37
12. Question
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?
Correct
The right answer is:
Table.Distinct
The Course table has some duplicates: thanks to the table function Table.Distinct, you can remove duplicated rows from the selected table.
Check the difference between Table.Distint and Table.IsDistinct here:
– https://docs.microsoft.com/en-us/powerquery-m/table-distinct
– https://docs.microsoft.com/en-us/powerquery-m/table-isdistinct
Incorrect
The right answer is:
Table.Distinct
The Course table has some duplicates: thanks to the table function Table.Distinct, you can remove duplicated rows from the selected table.
Check the difference between Table.Distint and Table.IsDistinct here:
– https://docs.microsoft.com/en-us/powerquery-m/table-distinct
– https://docs.microsoft.com/en-us/powerquery-m/table-isdistinct
Unattempted
The right answer is:
Table.Distinct
The Course table has some duplicates: thanks to the table function Table.Distinct, you can remove duplicated rows from the selected table.
Check the difference between Table.Distint and Table.IsDistinct here:
– https://docs.microsoft.com/en-us/powerquery-m/table-distinct
– https://docs.microsoft.com/en-us/powerquery-m/table-isdistinct
Question 13 of 37
13. Question
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:
Correct
The right answer is:
AFTERDELIMITER – RELATIVEPOSITION
Your goal is to transform the value ”7271-1123×998” into ”998”.
Text.AfterDelimiter returns the portion of a text after the specified delimiter: in this case, our delimiter is ”x”.
The RelativePosition.FromEnd 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:
– https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter
Incorrect
The right answer is:
AFTERDELIMITER – RELATIVEPOSITION
Your goal is to transform the value ”7271-1123×998” into ”998”.
Text.AfterDelimiter returns the portion of a text after the specified delimiter: in this case, our delimiter is ”x”.
The RelativePosition.FromEnd 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:
– https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter
Unattempted
The right answer is:
AFTERDELIMITER – RELATIVEPOSITION
Your goal is to transform the value ”7271-1123×998” into ”998”.
Text.AfterDelimiter returns the portion of a text after the specified delimiter: in this case, our delimiter is ”x”.
The RelativePosition.FromEnd 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:
– https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter
Question 14 of 37
14. Question
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?
Correct
The right answer is:
Edit the interactions from the Format menu.
Check here how to control visuals interactions:
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Incorrect
The right answer is:
Edit the interactions from the Format menu.
Check here how to control visuals interactions:
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Unattempted
The right answer is:
Edit the interactions from the Format menu.
Check here how to control visuals interactions:
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Question 15 of 37
15. Question
You are configuring a Gauge Chart. Where do you set the Goal?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
Question 16 of 37
16. Question
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?
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/consumer/end-user-bookmarks
– https://www.youtube.com/watch?v=_Afcj8mT5_Q
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/consumer/end-user-bookmarks
– https://www.youtube.com/watch?v=_Afcj8mT5_Q
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:
– https://docs.microsoft.com/en-us/power-bi/consumer/end-user-bookmarks
– https://www.youtube.com/watch?v=_Afcj8mT5_Q
Question 18 of 37
18. Question
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?
Correct
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:
Incorrect
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:
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:
Question 19 of 37
19. Question
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 = pyplot.gca();
dataset.plot.line(x = ‘Courses’, y = ‘Total Enrollments’, color = ‘green’, ax = ax)
Power BI Desktop returns the following error message:
How can you fix the issue?
Correct
The right answer is:
You should add the following command to the script: pyplot.show();
Without this command, the script is not complete.
Check how Python and Power BI interact here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
Incorrect
The right answer is:
You should add the following command to the script: pyplot.show();
Without this command, the script is not complete.
Check how Python and Power BI interact here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
Unattempted
The right answer is:
You should add the following command to the script: pyplot.show();
Without this command, the script is not complete.
Check how Python and Power BI interact here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
Question 20 of 37
20. Question
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?
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
Question 22 of 37
22. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices#:~:text=To%20add%20synonyms%2C%20in%20Power,column%20or%20table%20introduces%20ambiguity.
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices#:~:text=To%20add%20synonyms%2C%20in%20Power,column%20or%20table%20introduces%20ambiguity.
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:
– https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices#:~:text=To%20add%20synonyms%2C%20in%20Power,column%20or%20table%20introduces%20ambiguity.
Question 23 of 37
23. Question
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.
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
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:
– https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Question 24 of 37
24. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools
Question 25 of 37
25. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-data-categorization
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-data-categorization
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-data-categorization
Question 26 of 37
26. Question
You have a Microsoft Excel file named Enrollments.csv 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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates#:~:text=Types%20of%20data&text=The%20service%20can%20even%20aggregate,distinct%20occurrences%20of%20each%20category.
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates#:~:text=Types%20of%20data&text=The%20service%20can%20even%20aggregate,distinct%20occurrences%20of%20each%20category.
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates#:~:text=Types%20of%20data&text=The%20service%20can%20even%20aggregate,distinct%20occurrences%20of%20each%20category.
Question 27 of 37
27. Question
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:
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?
Correct
The right answer is:
Create a Paginated Report.
When you print a report as pdf.file 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: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi
Incorrect
The right answer is:
Create a Paginated Report.
When you print a report as pdf.file 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: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi
Unattempted
The right answer is:
Create a Paginated Report.
When you print a report as pdf.file 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: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi
Question 29 of 37
29. Question
You plan to create a custom visualization for Power BI. What do you install first?
Correct
The right answer is;
Node.js
Check how to install the developer environment here:
– https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial
Incorrect
The right answer is;
Node.js
Check how to install the developer environment here:
– https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial
Unattempted
The right answer is;
Node.js
Check how to install the developer environment here:
– https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial
Question 30 of 37
30. Question
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?
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.
Correct
There are two true statements in this scenario:
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.
Here’s a breakdown of why:
Row-level security restrictions on the dataset are in effect: When a user builds new content based on an existing dataset, any row-level security (RLS) restrictions applied to the original dataset are still enforced. This ensures that users can only see data they have access to, regardless of whether they are working with the original report or a new report based on the same dataset.
You haven’t made a copy of the dataset. The dataset remains in its original location: Enabling “Allow users to build new content using the underlying dataset” doesn’t create a copy of the dataset. Users can still access and use the original dataset to build new reports.
Incorrect statement:
You have made a copy of the dataset. The dataset is duplicated in your workspace. This statement is incorrect. Enabling the “Allow users to build new content” option doesn’t automatically create a copy.
In conclusion, when users build new content based on an existing dataset with RLS restrictions, those restrictions are still in effect. Additionally, no copy of the dataset is created; users work with the original dataset in its original location.
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.
Here’s a breakdown of why:
Row-level security restrictions on the dataset are in effect: When a user builds new content based on an existing dataset, any row-level security (RLS) restrictions applied to the original dataset are still enforced. This ensures that users can only see data they have access to, regardless of whether they are working with the original report or a new report based on the same dataset.
You haven’t made a copy of the dataset. The dataset remains in its original location: Enabling “Allow users to build new content using the underlying dataset” doesn’t create a copy of the dataset. Users can still access and use the original dataset to build new reports.
Incorrect statement:
You have made a copy of the dataset. The dataset is duplicated in your workspace. This statement is incorrect. Enabling the “Allow users to build new content” option doesn’t automatically create a copy.
In conclusion, when users build new content based on an existing dataset with RLS restrictions, those restrictions are still in effect. Additionally, no copy of the dataset is created; users work with the original dataset in its original location.
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.
Here’s a breakdown of why:
Row-level security restrictions on the dataset are in effect: When a user builds new content based on an existing dataset, any row-level security (RLS) restrictions applied to the original dataset are still enforced. This ensures that users can only see data they have access to, regardless of whether they are working with the original report or a new report based on the same dataset.
You haven’t made a copy of the dataset. The dataset remains in its original location: Enabling “Allow users to build new content using the underlying dataset” doesn’t create a copy of the dataset. Users can still access and use the original dataset to build new reports.
Incorrect statement:
You have made a copy of the dataset. The dataset is duplicated in your workspace. This statement is incorrect. Enabling the “Allow users to build new content” option doesn’t automatically create a copy.
In conclusion, when users build new content based on an existing dataset with RLS restrictions, those restrictions are still in effect. Additionally, no copy of the dataset is created; users work with the original dataset in its original location.
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?
Correct
The best option to identify reports with critical usage in your Power BI app workspace is:
D. You can use the Power BI Premium Capacity Metrics App.
Here’s why the other options are incorrect:
Check the activity log by using the Power BI Management cmdlets for PowerShell: This might show some information about report access, but it wouldn’t provide detailed usage metrics like view count or refresh frequency.
Request to the Power BI admin enabling usage metrics for content creators: This feature doesn’t exist in Power BI. Usage metrics are generally viewed from the perspective of administrators, not content creators.
Go to the Health tab in the Capacity settings area in the Admin portal: This section focuses on the overall health of your Power BI capacity and wouldn’t provide report-specific usage metrics.
The Power BI Premium Capacity Metrics App is specifically designed to offer insights into report usage within a workspace. It provides details such as:
Number of times a report has been viewed
Refresh frequency
Average execution time
By analyzing this data, you can identify reports with critical usage, meaning reports that are frequently accessed and relied upon by a significant number of users. This information is valuable for prioritizing your reports maintenance program and focusing your efforts on the reports that have the biggest impact on your organization.
The best option to identify reports with critical usage in your Power BI app workspace is:
D. You can use the Power BI Premium Capacity Metrics App.
Here’s why the other options are incorrect:
Check the activity log by using the Power BI Management cmdlets for PowerShell: This might show some information about report access, but it wouldn’t provide detailed usage metrics like view count or refresh frequency.
Request to the Power BI admin enabling usage metrics for content creators: This feature doesn’t exist in Power BI. Usage metrics are generally viewed from the perspective of administrators, not content creators.
Go to the Health tab in the Capacity settings area in the Admin portal: This section focuses on the overall health of your Power BI capacity and wouldn’t provide report-specific usage metrics.
The Power BI Premium Capacity Metrics App is specifically designed to offer insights into report usage within a workspace. It provides details such as:
Number of times a report has been viewed
Refresh frequency
Average execution time
By analyzing this data, you can identify reports with critical usage, meaning reports that are frequently accessed and relied upon by a significant number of users. This information is valuable for prioritizing your reports maintenance program and focusing your efforts on the reports that have the biggest impact on your organization.
The best option to identify reports with critical usage in your Power BI app workspace is:
D. You can use the Power BI Premium Capacity Metrics App.
Here’s why the other options are incorrect:
Check the activity log by using the Power BI Management cmdlets for PowerShell: This might show some information about report access, but it wouldn’t provide detailed usage metrics like view count or refresh frequency.
Request to the Power BI admin enabling usage metrics for content creators: This feature doesn’t exist in Power BI. Usage metrics are generally viewed from the perspective of administrators, not content creators.
Go to the Health tab in the Capacity settings area in the Admin portal: This section focuses on the overall health of your Power BI capacity and wouldn’t provide report-specific usage metrics.
The Power BI Premium Capacity Metrics App is specifically designed to offer insights into report usage within a workspace. It provides details such as:
Number of times a report has been viewed
Refresh frequency
Average execution time
By analyzing this data, you can identify reports with critical usage, meaning reports that are frequently accessed and relied upon by a significant number of users. This information is valuable for prioritizing your reports maintenance program and focusing your efforts on the reports that have the biggest impact on your organization.
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?
Correct
The right answer is:
From the Power BI Admin portal, disable the Publish to web setting.
Check how Publish to Web settings work here:
– https://powerbi.microsoft.com/en-us/blog/heads-up-the-publish-to-web-default-is-changing-and-it-affects-who-can-create-public-embed-codes/
Incorrect
The right answer is:
From the Power BI Admin portal, disable the Publish to web setting.
Check how Publish to Web settings work here:
– https://powerbi.microsoft.com/en-us/blog/heads-up-the-publish-to-web-default-is-changing-and-it-affects-who-can-create-public-embed-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:
– https://powerbi.microsoft.com/en-us/blog/heads-up-the-publish-to-web-default-is-changing-and-it-affects-who-can-create-public-embed-codes/
Question 34 of 37
34. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview
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:
– https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview
Question 35 of 37
35. Question
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?
Correct
The right answer is:
Go to dev.powerbi.com/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:
– https://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app#register-with-the-power-bi-application-registration-tool
Incorrect
The right answer is:
Go to dev.powerbi.com/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:
– https://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app#register-with-the-power-bi-application-registration-tool
Unattempted
The right answer is:
Go to dev.powerbi.com/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:
– https://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app#register-with-the-power-bi-application-registration-tool
Question 36 of 37
36. Question
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?
Correct
The right answer is:
Actual Size.
Check all the page display settings in a Power BI report here:
– https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-display-settings
Incorrect
The right answer is:
Actual Size.
Check all the page display settings in a Power BI report here:
– https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-display-settings
Unattempted
The right answer is:
Actual Size.
Check all the page display settings in a Power BI report here:
– https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-display-settings
Question 37 of 37
37. Question
How do you connect to Excel files that contain target figures? The solution should involve minimum manual work when new Excel files are created.
Correct
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.
Incorrect
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.
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.
X
Use Page numbers below to navigate to other practice tests