Microsoft DP-500 Full Practice Sets Total Questions: 474 – 6 Mock Exams& 1 Master Cheat Sheet
Practice Set 1
Time limit: 0
0 of 90 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
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
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" DP-500 Practice Test 1 "
0 of 90 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
MICROSOFT POWER BI DA-100
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 on “View Answers” option. 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
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
Answered
Review
Question 1 of 90
1. Question
You are the admin of an app workspace where you collaborate with the other 5 members.
Select the action that the members of the app workspace can’t perform.
Correct
The right answer is:
Remove other users as members.
Check the app workspace roles features here:
– https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
Incorrect
The right answer is:
Remove other users as members.
Check the app workspace roles features here:
– https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
Unattempted
The right answer is:
Remove other users as members.
Check the app workspace roles features here:
– https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
Question 2 of 90
2. Question
You have the following tables in your Power BI model:
There is a many-to-one relationship between Sales[ProductKey] and Product[ProductKey], and between Sales[StoreKey] and Stores[StoreKey].
To resctrict data acces, you create two different Role-level security (RLS), with the following filters:
– Store[State] = ”USA”
– Product[ProductName] = ”T-shirts”
What a user will be able to see if he is a member of both the two RLS?
Correct
The right answer is:
The member will see all the data that have ”USA” as Store[State] or ”T-shirts” as Product[ProductName].
The addition of two different RLS filters allows the member of both of them to see data for the RLS_1 as well as for the RLS_2, not just their intersection.
Check the link to discover how to create roles:
– https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance#create-roles
Incorrect
The right answer is:
The member will see all the data that have ”USA” as Store[State] or ”T-shirts” as Product[ProductName].
The addition of two different RLS filters allows the member of both of them to see data for the RLS_1 as well as for the RLS_2, not just their intersection.
Check the link to discover how to create roles:
– https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance#create-roles
Unattempted
The right answer is:
The member will see all the data that have ”USA” as Store[State] or ”T-shirts” as Product[ProductName].
The addition of two different RLS filters allows the member of both of them to see data for the RLS_1 as well as for the RLS_2, not just their intersection.
Check the link to discover how to create roles:
– https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance#create-roles
Question 3 of 90
3. Question
You create a Power BI Desktop project that retrieves data from a Microsoft SQL Server by using DirectQuery Connection mode.
Your queries generate two tables named Enrollments and Teacher. A sample data of tables is shown in the picture.
You want to get more efficient queries, so you plan to enable the Assume Referential Integrity option.
Is it a good solution in this case?
Correct
The right answer is:
NO.
A requirement to assume Referential Integrity is that data in the From column in the relationship is never Null or blank.
Check how Referential Integrity works here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-assume-referential-integrity
Incorrect
The right answer is:
NO.
A requirement to assume Referential Integrity is that data in the From column in the relationship is never Null or blank.
Check how Referential Integrity works here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-assume-referential-integrity
Unattempted
The right answer is:
NO.
A requirement to assume Referential Integrity is that data in the From column in the relationship is never Null or blank.
Check how Referential Integrity works here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-assume-referential-integrity
Question 4 of 90
4. Question
Consider two tables named Document and Users. You can check the structure of the tables in the following picture:
The columns Checked_by, Approved_by and Not_Approved_by present a Many-to-One relationship on the column User_ID in the Users table.
N.B. Only the relationship between Checked_by and User_ID is marked as Active Relationship.
You need to count the number of documents edited by each User, filtered by ‘Checked_by’, ‘Approved_by’ and ‘Not_Approved_by’.
Solution: Before setting visualizations, create a DAX formula using CALCULATE, COUNT and USERELATIONSHIP functions.
Does this solution meet the goal?
Correct
The right answer is:
YES.
Before setting visualizations, you need to create two calculated measures that enable the ‘Approved_by’ and ‘Not_Approved_by’ filters by using the USERELATIONSHIP function.
Incorrect
The right answer is:
YES.
Before setting visualizations, you need to create two calculated measures that enable the ‘Approved_by’ and ‘Not_Approved_by’ filters by using the USERELATIONSHIP function.
Unattempted
The right answer is:
YES.
Before setting visualizations, you need to create two calculated measures that enable the ‘Approved_by’ and ‘Not_Approved_by’ filters by using the USERELATIONSHIP function.
Question 5 of 90
5. Question
Your database contains the tables shown in the picture.
Check the information stored in the following columns:
– Date[Month] in the mmyyyy format
– Date[Date_ID] in the ddmmyyyy format
– Date[Date_name] in the mm/dd/yyyy format
– Monthly Drop out[Month_ID] in the mmyyyy format
The only relationship is between the Course table and the Monthly Drop Out table by the CourseID Column.
You plan to create a visualization that displays a sum of Enrollments[Total Paid] by month for the Enrollment date column and the Starting date column.
How do you model the data?
Correct
The right answer is:
Add a second Date table named Starting date to the model. Create a one-to-many relationship from Date[Date_ID] to Enrollments[Enrollment date] and a one-to-many relationship from Starting Date[Date_ID] to Enrollments[Starting date].
This solution is not recommended when you manage large datasets; but in this case, it properly works.
Incorrect
The right answer is:
Add a second Date table named Starting date to the model. Create a one-to-many relationship from Date[Date_ID] to Enrollments[Enrollment date] and a one-to-many relationship from Starting Date[Date_ID] to Enrollments[Starting date].
This solution is not recommended when you manage large datasets; but in this case, it properly works.
Unattempted
The right answer is:
Add a second Date table named Starting date to the model. Create a one-to-many relationship from Date[Date_ID] to Enrollments[Enrollment date] and a one-to-many relationship from Starting Date[Date_ID] to Enrollments[Starting date].
This solution is not recommended when you manage large datasets; but in this case, it properly works.
Question 6 of 90
6. Question
You have set a parameter named ExcelDataSet which contains the location-path of a Microsoft Excel data source.
Now, you want to update the query to get dynamic use of the parameter instead of set-up copies of the location-path within each query.
Solution: Modify the source step of the queries and use ExcelDataSet as the file path.
Does this solution meet the goal?
Correct
The right answer is:
Yes.
You can use parameters in Power BI to dynamically reference different Data Sources.
Check how parameters work here:
– https://powerbi.microsoft.com/it-it/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Incorrect
The right answer is:
Yes.
You can use parameters in Power BI to dynamically reference different Data Sources.
Check how parameters work here:
– https://powerbi.microsoft.com/it-it/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Unattempted
The right answer is:
Yes.
You can use parameters in Power BI to dynamically reference different Data Sources.
Check how parameters work here:
– https://powerbi.microsoft.com/it-it/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Question 7 of 90
7. Question
Consider a Power BI model with the following tables:
– Course (Columns: CourseID, CourseName)
– Enrollments (Columns: EnrollmentsID, EnrollmentsDate, CourseID, TeacherID, TotalPaid)
– Teacher (Columns: TeacherID, TeacherName)
You want to create the following measure: SoldCourse = DISTINCTCOUNT(Enrollments[CourseID])
You must create the following relationships:
– Enrollments to Course
– Enrollments to Teacher
N.B. The measures must display the number of courses sold and the teacher who is responsible for it.
Select the right configuration of relationships.
Correct
The right answer is:
Relationship: Many-to-One and Cross Filer Direction: Single
This is a typical Star Schema, where the Enrollments table works as the fact table (the many side of the relationship), and the Course and Teacher ones work ad the dimension tables (the one side of the relationship).
Discover more about the Star Schema here:
– https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Incorrect
The right answer is:
Relationship: Many-to-One and Cross Filer Direction: Single
This is a typical Star Schema, where the Enrollments table works as the fact table (the many side of the relationship), and the Course and Teacher ones work ad the dimension tables (the one side of the relationship).
Discover more about the Star Schema here:
– https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Unattempted
The right answer is:
Relationship: Many-to-One and Cross Filer Direction: Single
This is a typical Star Schema, where the Enrollments table works as the fact table (the many side of the relationship), and the Course and Teacher ones work ad the dimension tables (the one side of the relationship).
Discover more about the Star Schema here:
– https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Question 8 of 90
8. Question
Your colleague passes you a Power BI report named “DeltaCompanySales” requesting support to optimize the report loading performances.
DeltaCompanySales retrieves data from an imported dataset that contains one table with 15 million rows. The report is a single page with 12 PowerBI default visuals. The customer complains about the report performances when loading data and interacting with visuals.
What do you suggest to increase report performances?
Correct
The right answer is:
Remove unused columns from tables in the data model.
The first operation you can do in order to optimize the data loading performances is removing unnecessary columns and rows.
Check the other best practices here:
– https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Incorrect
The right answer is:
Remove unused columns from tables in the data model.
The first operation you can do in order to optimize the data loading performances is removing unnecessary columns and rows.
Check the other best practices here:
– https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Unattempted
The right answer is:
Remove unused columns from tables in the data model.
The first operation you can do in order to optimize the data loading performances is removing unnecessary columns and rows.
Check the other best practices here:
– https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Question 9 of 90
9. Question
You have a CSV file that contains employees’ badging. This file contains a column named “Starting Time”.
The data in “Starting Time” is in the following format: 2021-01-10 at 09:00.
You want to analyze the Badging trend by the Starting Time column and use a built-in date hierarchy. What should you do?
Correct
The right answer is:
Create a column by example that starts with 2021-01-10, then set the data type of the new column to Date.
After creating a column from example, you should set that column as Date Column in order to properly use the built-in date hierarchy.
Incorrect
The right answer is:
Create a column by example that starts with 2021-01-10, then set the data type of the new column to Date.
After creating a column from example, you should set that column as Date Column in order to properly use the built-in date hierarchy.
Unattempted
The right answer is:
Create a column by example that starts with 2021-01-10, then set the data type of the new column to Date.
After creating a column from example, you should set that column as Date Column in order to properly use the built-in date hierarchy.
Question 10 of 90
10. Question
Consider a Microsoft Excel 2016 workbook based on a Power Pivot model.
The model contains the following tables:
– Item(columns: Item_id, Item_Name)
– Sales (columns: Order_id, Order_Date, Item_id, Store_id, Total_Paid)
– Stores (columns: Store_id, Store_address)
The model has the following relationships:
– Sales to Item
– Sales to Stores
After you have imported the Power Pivot model in PowerBI you need to generate a report that displays the count of Items sold by each Store.
Which task you should perform before creating the report?
Correct
The right answer is:
For each relationship, change the Cross filter direction to Both.
By setting the bi-directional filter you will able to cross filter Item and Store tables.
Check how the cross filter direction works here:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
Incorrect
The right answer is:
For each relationship, change the Cross filter direction to Both.
By setting the bi-directional filter you will able to cross filter Item and Store tables.
Check how the cross filter direction works here:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
Unattempted
The right answer is:
For each relationship, change the Cross filter direction to Both.
By setting the bi-directional filter you will able to cross filter Item and Store tables.
Check how the cross filter direction works here:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
Question 11 of 90
11. Question
You plan to import in Power BI Desktop a set of tables from a Microsoft SQL Server.
The Database Engineer created a single view in Microsoft SQL Server that joined the fact and dimension tables in the underlying query as you need to reduce your effort in Power BI modeling data.
Does this solution work?
Correct
The right answer is:
NO.
You need to model data in Power BI Desktop when using the import data connection mode. In this case, the Developer doesn’t reduce your effort.
Learn how to model data in Power BI here:
– https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/1-overview-power-bi
Incorrect
The right answer is:
NO.
You need to model data in Power BI Desktop when using the import data connection mode. In this case, the Developer doesn’t reduce your effort.
Learn how to model data in Power BI here:
– https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/1-overview-power-bi
Unattempted
The right answer is:
NO.
You need to model data in Power BI Desktop when using the import data connection mode. In this case, the Developer doesn’t reduce your effort.
Learn how to model data in Power BI here:
– https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/1-overview-power-bi
Question 12 of 90
12. Question
Check the tables shown in the picture.
Consider a many-to-one relationship from Order table to Date table that uses Order[Purchase_date] and Date[Date]. The Cross filter direction of the relationship is set to Single. You want to create a visualization that displays the following two measures:
– Count of OrderID by Month based on the Purchase_date
– Count of OrderID by Month based on the Shipping_date
Which task you should perform before creating the measure?
Correct
The right answer is:
Create an inactive many-to-one relationship from Order[Shipping_date] to Date[Date].
By setting an inactive relationship between Order and Date table you will able to use also the Shipping_date filter in the measure.
Check how active and inactive relationship work here:
– https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
Incorrect
The right answer is:
Create an inactive many-to-one relationship from Order[Shipping_date] to Date[Date].
By setting an inactive relationship between Order and Date table you will able to use also the Shipping_date filter in the measure.
Check how active and inactive relationship work here:
– https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
Unattempted
The right answer is:
Create an inactive many-to-one relationship from Order[Shipping_date] to Date[Date].
By setting an inactive relationship between Order and Date table you will able to use also the Shipping_date filter in the measure.
Check how active and inactive relationship work here:
– https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
Question 13 of 90
13. Question
Consider a Power BI model with two tables named Enrollments and Date. Enrollments contains five columns named StudentID, TotalPaid, EnrollmentDate, AttendanceDate, and StartingDate. The Date table contains only one column named Date. The tables have the following relationships:
– Enrollments[EnrollmentDate] and Date[Date]
– Enrollments[AttendanceDate] and Date[Date]
– Enrollments[StartingDate] and Date[Date]
The active relationship is on Enrollments[EnrollmentDate]. You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
NOTE: You can’t meet the goal by duplicating data or loading additional data.
Solution: You should create two copies of the Date table named AttendanceDate and StartingDate, then you create a measure that uses the new tables.
Does this solution resolve the issue?
Correct
The right answer is:
NO.
This option requires duplicating data.
Incorrect
The right answer is:
NO.
This option requires duplicating data.
Unattempted
The right answer is:
NO.
This option requires duplicating data.
Question 14 of 90
14. Question
Consider a Power BI model with two tables named Enrollments and Date. Enrollments table contains five columns named StudentID, TotalPaid, EnrollmentDate, AttendanceDate, and StartingDate.
The Date Table contains only one column named Date. The tables have the following relationships:
Enrollments [EnrollmentDate] to Date[Date]
Enrollments [AttendanceDate] to Date[Date]
Enrollments [StartingDate] to Date[Date]
The active relationship is on Enrollments[EnrollmentDate]. You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
N.B. You can’t meet the goal by duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
Does this solution resolve the issue?
Correct
The right answer is:
YES.
By using USERELATIONSHIP function you specify the relationship to be used in a measure.
Check the following pattern: CALCULATE(COUNT(Enrollments[StartingDate]), USERELATIONSHIP(Enrollments[StartingDate], ‘Date'[Date])).
Check how USERELATIONSHIP function works here:
– https://docs.microsoft.com/en-us/dax/userelationship-function-dax.
Incorrect
The right answer is:
YES.
By using USERELATIONSHIP function you specify the relationship to be used in a measure.
Check the following pattern: CALCULATE(COUNT(Enrollments[StartingDate]), USERELATIONSHIP(Enrollments[StartingDate], ‘Date'[Date])).
Check how USERELATIONSHIP function works here:
– https://docs.microsoft.com/en-us/dax/userelationship-function-dax.
Unattempted
The right answer is:
YES.
By using USERELATIONSHIP function you specify the relationship to be used in a measure.
Check the following pattern: CALCULATE(COUNT(Enrollments[StartingDate]), USERELATIONSHIP(Enrollments[StartingDate], ‘Date'[Date])).
Check how USERELATIONSHIP function works here:
– https://docs.microsoft.com/en-us/dax/userelationship-function-dax.
Question 15 of 90
15. Question
Your company has a Microsoft Sharepoint Online portal that contains different document libraries. One of these libraries holds a list of sales reports saved as Microsoft Excel files which have all the same structure. You need to use Power BI Desktop to only download the sales reports library from Sharepoint.
How can you meet the goal?
Correct
The right answer is:
Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the sales reports library.
By getting data from the SharePoint Online folder, you are able to see all of the files from all of the folders of the site. This might be a pretty long list, thus you can filter on the “Folder Path” column and select the folder where your data is being stored.
Check this link to get more insights:
– https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Incorrect
The right answer is:
Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the sales reports library.
By getting data from the SharePoint Online folder, you are able to see all of the files from all of the folders of the site. This might be a pretty long list, thus you can filter on the “Folder Path” column and select the folder where your data is being stored.
Check this link to get more insights:
– https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Unattempted
The right answer is:
Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the sales reports library.
By getting data from the SharePoint Online folder, you are able to see all of the files from all of the folders of the site. This might be a pretty long list, thus you can filter on the “Folder Path” column and select the folder where your data is being stored.
Check this link to get more insights:
– https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Question 16 of 90
16. Question
Consider a Power BI model with two tables named Enrollments and Date. Enrollments contains five columns named StudentID, TotalPaid, EnrollmentDate, AttendanceDate, and StartingDate. The Date table contains only one column named Date. The tables have the following relationships:
– Enrollments[EnrollmentDate] and Date[Date]
– Enrollments[AttendanceDate] and Date[Date]
– Enrollments[StartingDate] and Date[Date]
The active relationship is on Enrollments[EnrollmentDate]. You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
N.B. You can’t meet the goal by duplicating data or loading additional data.
Solution: You create measures that use the following functions: CALCULATE, COUNT, and FILTER DAX function.
Does this solution resolve the issue?
Correct
The right answer is:
YES.
You can simply create a measure using the FILTER function since all columns you need are in the same table.
Check the following pattern CALCULATE(COUNT(Table[Column]), FILTER(Table, NOT(ISBLANK(Table[Column)))).
Incorrect
The right answer is:
YES.
You can simply create a measure using the FILTER function since all columns you need are in the same table.
Check the following pattern CALCULATE(COUNT(Table[Column]), FILTER(Table, NOT(ISBLANK(Table[Column)))).
Unattempted
The right answer is:
YES.
You can simply create a measure using the FILTER function since all columns you need are in the same table.
Check the following pattern CALCULATE(COUNT(Table[Column]), FILTER(Table, NOT(ISBLANK(Table[Column)))).
Question 17 of 90
17. Question
Consider the following tables:
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 PowerBI report following these requirements:
– Region Managers need a visual to analyze weekly enrollments and returns.
– You must create a relationship between the Weekly_Returns table and the Date table to meet the Region Managers goal.
What should you do?
Correct
The right answer is:
First, create a new calculated column named date_id in a format of yyyymmdd inside the Weekly_Returns table, then use the calculated column to make a relationship to the Date table.
Your goal is to let Region Managers use a PowerBI visual to analyze weekly enrollments and returns. We are talking about two different aggregations, one on Enrollments Table and one on Weekly Returns Table. The Date table works as a Dimension table. You can easily create a relationship between “Enrollments” and “Date”, but the process comes with complications about the Weekly Return Table. You need to create a calculated column in date format or integer in order to create a relationship between the Return Table and the Date one.
Incorrect
The right answer is:
First, create a new calculated column named date_id in a format of yyyymmdd inside the Weekly_Returns table, then use the calculated column to make a relationship to the Date table.
Your goal is to let Region Managers use a PowerBI visual to analyze weekly enrollments and returns. We are talking about two different aggregations, one on Enrollments Table and one on Weekly Returns Table. The Date table works as a Dimension table. You can easily create a relationship between “Enrollments” and “Date”, but the process comes with complications about the Weekly Return Table. You need to create a calculated column in date format or integer in order to create a relationship between the Return Table and the Date one.
Unattempted
The right answer is:
First, create a new calculated column named date_id in a format of yyyymmdd inside the Weekly_Returns table, then use the calculated column to make a relationship to the Date table.
Your goal is to let Region Managers use a PowerBI visual to analyze weekly enrollments and returns. We are talking about two different aggregations, one on Enrollments Table and one on Weekly Returns Table. The Date table works as a Dimension table. You can easily create a relationship between “Enrollments” and “Date”, but the process comes with complications about the Weekly Return Table. You need to create a calculated column in date format or integer in order to create a relationship between the Return Table and the Date one.
Question 18 of 90
18. Question
Consider a Power BI Desktop project named InsuranceBI that retrieves data from a Microsoft SQL Server by using DirectQuery connection. You are working on three tables named Insurance, Account and Customer.
Check the sample data for the tables shown in the picture.
You need to model a relationship from the Account Table to the Insurance Table and from the Account Table to the Customer Table by joining the ID_Acc column.
How should you meet the goal?
Correct
The right answer is:
Add a new column that combines the Ins.ID and Ins.Account columns in the Insurance and Customer tables.
You need to join the text strings inside Ins.ID column and Ins.Account column into one text string by using the CONCATENATE function.
Check how to use CONCATENATE function here:
– https://docs.microsoft.com/en-us/dax/concatenate-function-dax
Incorrect
The right answer is:
Add a new column that combines the Ins.ID and Ins.Account columns in the Insurance and Customer tables.
You need to join the text strings inside Ins.ID column and Ins.Account column into one text string by using the CONCATENATE function.
Check how to use CONCATENATE function here:
– https://docs.microsoft.com/en-us/dax/concatenate-function-dax
Unattempted
The right answer is:
Add a new column that combines the Ins.ID and Ins.Account columns in the Insurance and Customer tables.
You need to join the text strings inside Ins.ID column and Ins.Account column into one text string by using the CONCATENATE function.
Check how to use CONCATENATE function here:
– https://docs.microsoft.com/en-us/dax/concatenate-function-dax
Question 19 of 90
19. Question
Consider the tables named ‘Orders’ and ‘Date’ shown in the picture. You want to create a calculated column that shows the day’s difference between the order reception and the order shipping.
N.B. Both Order_date and Order_Shipping are connected to the Date table. But Order_date is an active relationship, while Order_shipping is inactive.
Which function should you include in the DAX formula to create the calculated column?
Correct
The right answer is:
DATEDIFF
In this case, Order_date and Shipping_date columns are in the same table. You can simply use the DATEDIFF function to create the calculated column.
Check how DATEDIFF function works here:
– https://docs.microsoft.com/en-us/dax/datediff-function-dax
Incorrect
The right answer is:
DATEDIFF
In this case, Order_date and Shipping_date columns are in the same table. You can simply use the DATEDIFF function to create the calculated column.
Check how DATEDIFF function works here:
– https://docs.microsoft.com/en-us/dax/datediff-function-dax
Unattempted
The right answer is:
DATEDIFF
In this case, Order_date and Shipping_date columns are in the same table. You can simply use the DATEDIFF function to create the calculated column.
Check how DATEDIFF function works here:
– https://docs.microsoft.com/en-us/dax/datediff-function-dax
Question 20 of 90
20. Question
Consider the Power BI model shown in the picture.
The Product Table has a relationship to the Product Category Table on the SKU column.
Here, you can check a sample of data inside the tables:
Product Table:
SKU: HD-001, Product: GymSmartwatch, Color: Blue
SKU: HD-002, Product: XSound Headphones, Color: Black
SKU: HD-003, Product: Laptop Pro 2000, Color: Green
Product Category Table:
SKU: HD-001, Category: Smartwatch
SKU: HD-002, Category: Headphone
SKU: HD-003, Category: Computer
You need to use in your Power BI report a Hierarchy that shows two levels: product and category.
Solution: From Power Query, merge the tables and then create the hierarchy.
Does this solution meet the goal?
Correct
The right solution is:
YES.
In order to create a Hierarchy in Power BI, all the involved columns need to be in the same table.
Check how the Power Query Merge function works here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-queries
Incorrect
The right solution is:
YES.
In order to create a Hierarchy in Power BI, all the involved columns need to be in the same table.
Check how the Power Query Merge function works here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-queries
Unattempted
The right solution is:
YES.
In order to create a Hierarchy in Power BI, all the involved columns need to be in the same table.
Check how the Power Query Merge function works here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-queries
Question 21 of 90
21. Question
Consider two tables named Document and Users. You can check the structure of the tables in the following picture:
The columns Checked_by, Approved_by and Not_Approved_by present a Many-to-One relationship on the column User_ID in the Users table.
N.B. Only the relationship between Checked_by and User_ID is marked as Active Relationship.
You need to count the number of documents edited by each User, filtered by ‘Checked_by’, ‘Approved_by’ and ‘Not_Approved_by’.
Solution: Create a table visualization in Power BI Report tab and add User_ID, Checked_by, Approved_by and Not_Approved_by to the Values field.
Does this solution meet the goal?
Correct
The right answer is:
NO.
This solution does not allow seeing the ‘Approved_by’ and ‘Not_Approved_by’ filters. It also does not specify how to get the Count of documents edited by each user.
Incorrect
The right answer is:
NO.
This solution does not allow seeing the ‘Approved_by’ and ‘Not_Approved_by’ filters. It also does not specify how to get the Count of documents edited by each user.
Unattempted
The right answer is:
NO.
This solution does not allow seeing the ‘Approved_by’ and ‘Not_Approved_by’ filters. It also does not specify how to get the Count of documents edited by each user.
Question 22 of 90
22. Question
You are modeling data in Microsoft Power BI. Your data model is made of a Microsoft SQL Server table named Enrollments that has 20 million records. You need to import a sample of the data from the Enrollments table.
Solution: Add a WHERE clause to the SQL statement.
Does this meet the goal?
Correct
The right answer is:
Yes.
You need to apply the filter before the data is imported. Thus you need to add a WHERE clause to the SQL statement.
Incorrect
The right answer is:
Yes.
You need to apply the filter before the data is imported. Thus you need to add a WHERE clause to the SQL statement.
Unattempted
The right answer is:
Yes.
You need to apply the filter before the data is imported. Thus you need to add a WHERE clause to the SQL statement.
Question 23 of 90
23. Question
Consider a Power BI model with two tables named Enrollments and Date. Enrollments contains five columns named StudentID, TotalPaid, EnrollmentDate, AttendanceDate, and StartingDate. The Date table contains only one column named Date. The tables have the following relationships:
– Enrollments[EnrollmentDate] and Date[Date]
– Enrollments[AttendanceDate] and Date[Date]
– Enrollments[StartingDate] and Date[Date]
The active relationship is on Enrollments[EnrollmentDate]. You plan to create measures to count both the number of Enrollments by [AttendanceDate] and the Enrollments by [StartingDate].
N.B. You can’t meet the goal by duplicating data or loading additional data.
Solution: You should create a calculated table, then you create a measure that uses the new table. Does this solution resolve the issue?
Correct
The right answer is:
NO.
By creating a calculated table you are duplicating data or loading additional data.
Incorrect
The right answer is:
NO.
By creating a calculated table you are duplicating data or loading additional data.
Unattempted
The right answer is:
NO.
By creating a calculated table you are duplicating data or loading additional data.
Question 24 of 90
24. Question
Consider two tables named Courses and Teachers. Check a sample of data tables in the following picture:
You want to set a many-to-one cardinality between tables, but it appears as not available in the relationship settings as shown in the picture.
What should you do before creating the Many-to-One relationship?
Correct
The right answer is:
From Query Editor, filter out Blank Values from Teacher Table.
Teacher ID in Teacher Table contains blank values and this is not allowed for columns on the one side of the many-to-one relationship for columns that are used as the primary key of a table.
Incorrect
The right answer is:
From Query Editor, filter out Blank Values from Teacher Table.
Teacher ID in Teacher Table contains blank values and this is not allowed for columns on the one side of the many-to-one relationship for columns that are used as the primary key of a table.
Unattempted
The right answer is:
From Query Editor, filter out Blank Values from Teacher Table.
Teacher ID in Teacher Table contains blank values and this is not allowed for columns on the one side of the many-to-one relationship for columns that are used as the primary key of a table.
Question 25 of 90
25. Question
You have a Power BI report that retrieves data from an SQL database named CompanyBI_01.
Your company wants to build a second SQL database that works as a development database.
The data structure available in the new development database is the same as the CompanyBI_01 one.
Now, you need to easily switch the data source in your Power BI Desktop environment between the development database and the CompanyBI_01 one.
Which is the simplest action that ensures you do that?
Correct
The right answer is:
In Power Query Editor, create a new parameter based on the data source and set it as the report source.
“Parameters in Power Query are a useful way to change values dynamically in your Get Data and Transform process. Parameters can be used to change values without opening the Power Query (Transform Data) window in the Power BI Desktop, and they are helpful even in the Power BI Service in a way that you can change values manually without the need to open PBIX file in the Desktop and re-publish it.”
Click here to read more:
– https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
Incorrect
The right answer is:
In Power Query Editor, create a new parameter based on the data source and set it as the report source.
“Parameters in Power Query are a useful way to change values dynamically in your Get Data and Transform process. Parameters can be used to change values without opening the Power Query (Transform Data) window in the Power BI Desktop, and they are helpful even in the Power BI Service in a way that you can change values manually without the need to open PBIX file in the Desktop and re-publish it.”
Click here to read more:
– https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
Unattempted
The right answer is:
In Power Query Editor, create a new parameter based on the data source and set it as the report source.
“Parameters in Power Query are a useful way to change values dynamically in your Get Data and Transform process. Parameters can be used to change values without opening the Power Query (Transform Data) window in the Power BI Desktop, and they are helpful even in the Power BI Service in a way that you can change values manually without the need to open PBIX file in the Desktop and re-publish it.”
Click here to read more:
– https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
Question 26 of 90
26. Question
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?
Correct
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.
Check the Append applications here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Incorrect
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.
Check the Append applications here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
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.
Check the Append applications here:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Question 27 of 90
27. Question
Consider the table shown in the picture:
After you pivot columns, the table appears as shown in the following picture:
How can you resolve the error in row 3?
Correct
The correct answer is:
Modify the Aggregate Value Function of the pivot.
When you use the Pivot feature, you have to take care of the Aggregate Value Functions displayed in the Advanced options; if you want to preserve duplicated values, you do not have to select the Sum option:
Read more here:
– https://databear.com/power-bi-pivot-and-unpivot-columns/#:~:text=To%20do%20this%20go%20into,following%20pivoted%20result%20will%20appear.
Incorrect
The correct answer is:
Modify the Aggregate Value Function of the pivot.
When you use the Pivot feature, you have to take care of the Aggregate Value Functions displayed in the Advanced options; if you want to preserve duplicated values, you do not have to select the Sum option:
Read more here:
– https://databear.com/power-bi-pivot-and-unpivot-columns/#:~:text=To%20do%20this%20go%20into,following%20pivoted%20result%20will%20appear.
Unattempted
The correct answer is:
Modify the Aggregate Value Function of the pivot.
When you use the Pivot feature, you have to take care of the Aggregate Value Functions displayed in the Advanced options; if you want to preserve duplicated values, you do not have to select the Sum option:
Read more here:
– https://databear.com/power-bi-pivot-and-unpivot-columns/#:~:text=To%20do%20this%20go%20into,following%20pivoted%20result%20will%20appear.
Question 28 of 90
28. Question
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?
Correct
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.
Incorrect
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.
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.
Question 29 of 90
29. Question
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?
Correct
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:
– https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/
Incorrect
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:
– https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/
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:
– https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/
Question 30 of 90
30. 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 32 of 90
32. 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 33 of 90
33. Question
Consider the table shown in picture 1:
You want to configure the table as shown in picture 2:
Which command should you use?
Correct
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.
Incorrect
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.
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.
Question 34 of 90
34. 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?
You want to replace the ”-” value in the DISCOUNT_CODE column with the text ”NO_DISCOUNT”.
Which M function completes the following formula?
Correct
The right answer is:
Table.ReplaceValue
Table.ReplaceValue replaces an existing value with a new value in the specified columns of a table.
Check the difference between this function and Text.Replace one here:
– https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
– https://docs.microsoft.com/en-us/powerquery-m/text-replace
Incorrect
The right answer is:
Table.ReplaceValue
Table.ReplaceValue replaces an existing value with a new value in the specified columns of a table.
Check the difference between this function and Text.Replace one here:
– https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
– https://docs.microsoft.com/en-us/powerquery-m/text-replace
Unattempted
The right answer is:
Table.ReplaceValue
Table.ReplaceValue replaces an existing value with a new value in the specified columns of a table.
Check the difference between this function and Text.Replace one here:
– https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
– https://docs.microsoft.com/en-us/powerquery-m/text-replace
Question 36 of 90
36. Question
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 37 of 90
37. 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 38 of 90
38. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-common-query-tasks#group-rowshttps://docs.microsoft.com/en-us/power-query/group-by
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-common-query-tasks#group-rowshttps://docs.microsoft.com/en-us/power-query/group-by
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:
– https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-common-query-tasks#group-rowshttps://docs.microsoft.com/en-us/power-query/group-by
Question 39 of 90
39. 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 40 of 90
40. 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 41 of 90
41. 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 42 of 90
42. Question
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?
Correct
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:
– https://yodalearning.com/tutorials/learn-how-create-index-columns-using-power-query/
Incorrect
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:
– https://yodalearning.com/tutorials/learn-how-create-index-columns-using-power-query/
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:
– https://yodalearning.com/tutorials/learn-how-create-index-columns-using-power-query/
Question 43 of 90
43. 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 44 of 90
44. Question
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.
Correct
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.
Incorrect
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.
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.
Question 45 of 90
45. Question
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?
Correct
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:
– https://www.tutorialgateway.org/joins-in-power-bi/
Incorrect
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:
– https://www.tutorialgateway.org/joins-in-power-bi/
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:
– https://www.tutorialgateway.org/joins-in-power-bi/
Question 46 of 90
46. 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.
Check the following link to see an application:
– https://gcomsolutions.co.uk/blog/power-bi/power-query-trim-and-clean/
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.
Check the following link to see an application:
– https://gcomsolutions.co.uk/blog/power-bi/power-query-trim-and-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.
Check the following link to see an application:
– https://gcomsolutions.co.uk/blog/power-bi/power-query-trim-and-clean/
Question 47 of 90
47. 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 48 of 90
48. 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
– https://docs.microsoft.com/en-us/powerquery-m/relativeposition-fromend
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
– https://docs.microsoft.com/en-us/powerquery-m/relativeposition-fromend
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
– https://docs.microsoft.com/en-us/powerquery-m/relativeposition-fromend
Question 49 of 90
49. Question
How do you know that the TotalCost column has 0% of empty rows?
Correct
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:
– https://docs.microsoft.com/en-us/power-query/data-profiling-tools
Incorrect
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:
– https://docs.microsoft.com/en-us/power-query/data-profiling-tools
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:
– https://docs.microsoft.com/en-us/power-query/data-profiling-tools
Question 50 of 90
50. Question
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?
Correct
The right answer is:
From Query Editor, select the StudentID column. Click Replace Errors and set a value of 0.
Incorrect
The right answer is:
From Query Editor, select the StudentID column. Click Replace Errors and set a value of 0.
Unattempted
The right answer is:
From Query Editor, select the StudentID column. Click Replace Errors and set a value of 0.
Question 51 of 90
51. 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 52 of 90
52. 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 53 of 90
53. 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?
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals
Question 55 of 90
55. Question
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 56 of 90
56. 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 57 of 90
57. Question
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?
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 59 of 90
59. 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?
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?
Correct
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.
Incorrect
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.
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.
Question 61 of 90
61. Question
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?
Correct
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:
– https://www.tutorialgateway.org/line-and-clustered-column-chart-in-power-bi/
Incorrect
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:
– https://www.tutorialgateway.org/line-and-clustered-column-chart-in-power-bi/
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:
– https://www.tutorialgateway.org/line-and-clustered-column-chart-in-power-bi/
Question 62 of 90
62. Question
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?
Correct
The right answer is:
Datasets.
Check how to enable and use Q&A and Cortana from Power BI Service and Power BI Desktop here:
– https://docs.microsoft.com/en-us/windows/configuration/cortana-at-work/cortana-at-work-powerbi
Incorrect
The right answer is:
Datasets.
Check how to enable and use Q&A and Cortana from Power BI Service and Power BI Desktop here:
– https://docs.microsoft.com/en-us/windows/configuration/cortana-at-work/cortana-at-work-powerbi
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:
– https://docs.microsoft.com/en-us/windows/configuration/cortana-at-work/cortana-at-work-powerbi
Question 63 of 90
63. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes
Question 64 of 90
64. Question
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 65 of 90
65. 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 66 of 90
66. 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 67 of 90
67. 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 68 of 90
68. 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 69 of 90
69. 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 70 of 90
70. Question
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?
Correct
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.
Incorrect
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.
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.
Question 71 of 90
71. 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 73 of 90
73. Question
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?
Correct
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.
Incorrect
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.
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.
Question 74 of 90
74. 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 75 of 90
75. Question
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.
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
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:
– https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
Question 76 of 90
76. Question
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?
Correct
The right answer is:
Because of Default Summarization on Enrollments.
Discover more about the Default Summarization here:
– https://www.youtube.com/watch?v=vJNjLTc8NF0
Incorrect
The right answer is:
Because of Default Summarization on Enrollments.
Discover more about the Default Summarization here:
– https://www.youtube.com/watch?v=vJNjLTc8NF0
Unattempted
The right answer is:
Because of Default Summarization on Enrollments.
Discover more about the Default Summarization here:
– https://www.youtube.com/watch?v=vJNjLTc8NF0
Question 77 of 90
77. 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?
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.
Correct
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:
– https://powerbi.microsoft.com/it-it/blog/automatically-install-apps/
Incorrect
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:
– https://powerbi.microsoft.com/it-it/blog/automatically-install-apps/
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:
– https://powerbi.microsoft.com/it-it/blog/automatically-install-apps/
Question 79 of 90
79. Question
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 powerbi.com.
Select the right order of the actions to achieve the goal.
Correct
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.
Incorrect
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.
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.
Question 80 of 90
80. Question
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
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-discover-across-workspaces
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-discover-across-workspaces
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-discover-across-workspaces
Question 81 of 90
81. Question
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?
Correct
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.
Incorrect
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.
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.
Question 82 of 90
82. Question
Your company asks you for finding methods to standardize the creation and the sharing of Power BI content among the company units.
NB. Your company owns a Premium Capacity.
Which solutions should you advise?
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 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:
– https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics
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:
– https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics
Question 84 of 90
84. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-tile-from-excel
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-tile-from-excel
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:
– https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-tile-from-excel
Question 85 of 90
85. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#publish-to-the-power-bi-service
Incorrect
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#publish-to-the-power-bi-service
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:
– https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#publish-to-the-power-bi-service
Question 86 of 90
86. Question
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 87 of 90
87. 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 88 of 90
88. 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 89 of 90
89. 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 90 of 90
90. Question
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?
Correct
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:
– https://docs.microsoft.com/en-us/power-query/data-profiling-tools
Incorrect
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:
– https://docs.microsoft.com/en-us/power-query/data-profiling-tools
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:
– https://docs.microsoft.com/en-us/power-query/data-profiling-tools
Use Page numbers below to navigate to other practice tests