You have already completed the Test before. Hence you can not start it again.
Test is loading...
You must sign in or sign up to start the Test.
You have to finish following quiz, to start this Test:
Your results are here!! for" PL-300 Practice Test 10 "
0 of 63 questions answered correctly
Your time:
Time has elapsed
Your Final Score is : 0
You have attempted : 0
Number of Correct Questions : 0 and scored 0
Number of Incorrect Questions : 0 and Negative marks 0
Average score
Your score
PL-300
You have attempted: 0
Number of Correct Questions: 0 and scored 0
Number of Incorrect Questions: 0 and Negative marks 0
You can review your answers by clicking on “View Answers” option. Important Note : Open Reference Documentation Links in New Tab (Right Click and Open in New Tab).
Your result has been entered into leaderboard
Loading
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
Answered
Review
Question 1 of 63
1. Question
You work for a Bike company and create a report of Sales and Category. You build a measure for the Sales % of Categories and want to add conditional formatting such that the colors for low values are red, center values are orange and high values are green.
How would you achieve this goal?
Correct
Use conditional formatting and under Format by select ‘Color scale’. Next, select the ‘diverging’ setting and you will now have three color options: Minimum, Center and Maximum. Set the Minimum color to red, the Center color to orange and the Maximum to green.
Do not use a Color scale with default settings. This setting will give only two color settings, one color for Minimum and one color for Maximum.
Do not use the Format by ‘Rules’. For rules-based conditional formatting, you will need a specific numeric range for each color and you will not be able to see a diverging color scheme as per the exhibit.
Do not use conditional formatting with field values. This conditional formatting setting relies on a column with color names or color codes.
Incorrect
Use conditional formatting and under Format by select ‘Color scale’. Next, select the ‘diverging’ setting and you will now have three color options: Minimum, Center and Maximum. Set the Minimum color to red, the Center color to orange and the Maximum to green.
Do not use a Color scale with default settings. This setting will give only two color settings, one color for Minimum and one color for Maximum.
Do not use the Format by ‘Rules’. For rules-based conditional formatting, you will need a specific numeric range for each color and you will not be able to see a diverging color scheme as per the exhibit.
Do not use conditional formatting with field values. This conditional formatting setting relies on a column with color names or color codes.
Unattempted
Use conditional formatting and under Format by select ‘Color scale’. Next, select the ‘diverging’ setting and you will now have three color options: Minimum, Center and Maximum. Set the Minimum color to red, the Center color to orange and the Maximum to green.
Do not use a Color scale with default settings. This setting will give only two color settings, one color for Minimum and one color for Maximum.
Do not use the Format by ‘Rules’. For rules-based conditional formatting, you will need a specific numeric range for each color and you will not be able to see a diverging color scheme as per the exhibit.
Do not use conditional formatting with field values. This conditional formatting setting relies on a column with color names or color codes.
Question 2 of 63
2. Question
You are working on a fast moving R&D project for an autonomous vehicle company. You create a dashboard but find that management wants you to make quick changes to both content and layout that they can see immediately on the dashboard. Management is only comfortable using a dashboard. What should you do to achieve this goal?
Correct
When you pin an entire page, the tiles are live. You can interact with the visuals directly on the dashboard. Changes you make to any of the visualizations back in the report editor, like adding a filter or changing the fields used in the chart, are reflected in the dashboard tile. Do not create an app. Any layout changes will not be reflected in the app. Do not add management to the workspace. This will not help them see an up to date dashboard. Note that they are only interested in accessing a dashboard and do not want to access the underlying workspace. Do not add a refresh schedule as management wants to see updates immediately in the dashboard.
Incorrect
When you pin an entire page, the tiles are live. You can interact with the visuals directly on the dashboard. Changes you make to any of the visualizations back in the report editor, like adding a filter or changing the fields used in the chart, are reflected in the dashboard tile. Do not create an app. Any layout changes will not be reflected in the app. Do not add management to the workspace. This will not help them see an up to date dashboard. Note that they are only interested in accessing a dashboard and do not want to access the underlying workspace. Do not add a refresh schedule as management wants to see updates immediately in the dashboard.
Unattempted
When you pin an entire page, the tiles are live. You can interact with the visuals directly on the dashboard. Changes you make to any of the visualizations back in the report editor, like adding a filter or changing the fields used in the chart, are reflected in the dashboard tile. Do not create an app. Any layout changes will not be reflected in the app. Do not add management to the workspace. This will not help them see an up to date dashboard. Note that they are only interested in accessing a dashboard and do not want to access the underlying workspace. Do not add a refresh schedule as management wants to see updates immediately in the dashboard.
Question 3 of 63
3. Question
You have worked hard to create a clean dataset of all your companyÂ’s customer details, including address and geocode. The Senior Director in your division has asked that all people within your company are aware of the high-quality, authoritative customer dataset that meets all the companyÂ’s standards. How can you achieve this goal?
Correct
Certification means that the content meets the companyÂ’s quality standards and is regarded as reliable, authoritative, and ready for use across the organization. Only authorized reviewers (defined by the Power BI administrator) can certify content. Do not select promote content. Promotion is a way to highlight content you think is valuable and worthwhile for others to use. It encourages the collaborative use and spread of content within an organization. Promotion is not used for authorative, reliable data sources. Do not select Feature content on home. When you feature dashboards, reports, and apps they appear in the Featured section of your colleagues‘ Power BI Home page. Do not create a new workspace and add every person as a member. This will give your entire company the ability to edit your dataset and reports within the workspace.
Incorrect
Certification means that the content meets the companyÂ’s quality standards and is regarded as reliable, authoritative, and ready for use across the organization. Only authorized reviewers (defined by the Power BI administrator) can certify content. Do not select promote content. Promotion is a way to highlight content you think is valuable and worthwhile for others to use. It encourages the collaborative use and spread of content within an organization. Promotion is not used for authorative, reliable data sources. Do not select Feature content on home. When you feature dashboards, reports, and apps they appear in the Featured section of your colleagues‘ Power BI Home page. Do not create a new workspace and add every person as a member. This will give your entire company the ability to edit your dataset and reports within the workspace.
Unattempted
Certification means that the content meets the companyÂ’s quality standards and is regarded as reliable, authoritative, and ready for use across the organization. Only authorized reviewers (defined by the Power BI administrator) can certify content. Do not select promote content. Promotion is a way to highlight content you think is valuable and worthwhile for others to use. It encourages the collaborative use and spread of content within an organization. Promotion is not used for authorative, reliable data sources. Do not select Feature content on home. When you feature dashboards, reports, and apps they appear in the Featured section of your colleagues‘ Power BI Home page. Do not create a new workspace and add every person as a member. This will give your entire company the ability to edit your dataset and reports within the workspace.
Question 4 of 63
4. Question
You have a time series chart for your sales and you need to display a line to show the direction the data has moved over your selected period.
How would you add this black dotted line? See the exhibit below.
Correct
Power BI provides options to draw a trend line for visualizations using scatter plot charts and line charts. To add a Trend line, go to the Analytics pane and add a Trend line.
Do not add an average line as this will give a horizontal line that averages the data values.
Do not add a forecast line. A forecast line takes the historical data and estimates future values using a triple exponential smoothing algorithm.
Do not add a PlayAxis to the visual. A Play Axis is used to create an animation of a scatter chart across time.
Incorrect
Power BI provides options to draw a trend line for visualizations using scatter plot charts and line charts. To add a Trend line, go to the Analytics pane and add a Trend line.
Do not add an average line as this will give a horizontal line that averages the data values.
Do not add a forecast line. A forecast line takes the historical data and estimates future values using a triple exponential smoothing algorithm.
Do not add a PlayAxis to the visual. A Play Axis is used to create an animation of a scatter chart across time.
Unattempted
Power BI provides options to draw a trend line for visualizations using scatter plot charts and line charts. To add a Trend line, go to the Analytics pane and add a Trend line.
Do not add an average line as this will give a horizontal line that averages the data values.
Do not add a forecast line. A forecast line takes the historical data and estimates future values using a triple exponential smoothing algorithm.
Do not add a PlayAxis to the visual. A Play Axis is used to create an animation of a scatter chart across time.
Question 5 of 63
5. Question
Your company is considering Power BI Report Server and you are asked if certain features are available. Which of the following three features are NOT available in Power BI Report Server?
You work at a bike company and have two tables that use DirectQuery – Product and Category (see the below exhibit.) These two tables are joined with a relationship from Product to Category using the CategoryID column. To increase the efficiency in your join you decide to check ‘Assume referential integrity‘ in the relationship.
Will this help the join between your tables?
Correct
Assume Referential Integrity enables running more efficient queries against your DirectQuery data source. However, for referential integrity to work, data in the From column in the relationship can never be null or blank.
Incorrect
Assume Referential Integrity enables running more efficient queries against your DirectQuery data source. However, for referential integrity to work, data in the From column in the relationship can never be null or blank.
Unattempted
Assume Referential Integrity enables running more efficient queries against your DirectQuery data source. However, for referential integrity to work, data in the From column in the relationship can never be null or blank.
Question 7 of 63
7. Question
You are designing a data model and have a Date table and a Sales table as per the below exhibit. You create an active relationship between Date[Date] and Sales[Delivery Date]. You also create an inactive relationship between Date[Date] and Sales[Order Date].
How would you create a measure with the inactive Order Date by filling in the correct DAX function in [VALUE]?
CALCULATE (
[Sales Amount],
[VALUE] ( Sales[Delivery Date], ‘Date‘[Date] )
)
Correct
The USERELATIONSHIPÂ function specifies an existing relationship to be used in the evaluation of a DAX expression. The relationship is defined by naming, as arguments, the two columns that serve as endpoints. As long as an active or inactive relationship exists, you can use USERELATIONSHIP in your calculation.
Do not use VALUES. The VALUES function returns a single column table of unique values.
Do not use SELECTCOLUMNS. The SELECTCOLUMNS function returns a table with selected columns.
Do not use RELATED. The RELATED function returns a related value from another table.
Incorrect
The USERELATIONSHIPÂ function specifies an existing relationship to be used in the evaluation of a DAX expression. The relationship is defined by naming, as arguments, the two columns that serve as endpoints. As long as an active or inactive relationship exists, you can use USERELATIONSHIP in your calculation.
Do not use VALUES. The VALUES function returns a single column table of unique values.
Do not use SELECTCOLUMNS. The SELECTCOLUMNS function returns a table with selected columns.
Do not use RELATED. The RELATED function returns a related value from another table.
Unattempted
The USERELATIONSHIPÂ function specifies an existing relationship to be used in the evaluation of a DAX expression. The relationship is defined by naming, as arguments, the two columns that serve as endpoints. As long as an active or inactive relationship exists, you can use USERELATIONSHIP in your calculation.
Do not use VALUES. The VALUES function returns a single column table of unique values.
Do not use SELECTCOLUMNS. The SELECTCOLUMNS function returns a table with selected columns.
Do not use RELATED. The RELATED function returns a related value from another table.
Question 8 of 63
8. Question
You are a Power BI consultant and you are doing some remote work for a mining company in Western Australia. You need to build a date table that starts from November 2010 and ends in December 2025. You decide you will use DAX to create a table. How should you create the DAX expression?
Correct
Use the CALENDAR function with a start and end date. For each date, use the DATE function and add in the three parameters for year, month and day. In A, the DATE function is used to generate a single date and not a calendar. In B, do not use CALCULATE and do not use strings within the CALENDAR function. Dates require the DATE function. In D, do not use CALENDAR without the DATE function. The DATE function is required to convert the specified date in datetime format.
Incorrect
Use the CALENDAR function with a start and end date. For each date, use the DATE function and add in the three parameters for year, month and day. In A, the DATE function is used to generate a single date and not a calendar. In B, do not use CALCULATE and do not use strings within the CALENDAR function. Dates require the DATE function. In D, do not use CALENDAR without the DATE function. The DATE function is required to convert the specified date in datetime format.
Unattempted
Use the CALENDAR function with a start and end date. For each date, use the DATE function and add in the three parameters for year, month and day. In A, the DATE function is used to generate a single date and not a calendar. In B, do not use CALCULATE and do not use strings within the CALENDAR function. Dates require the DATE function. In D, do not use CALENDAR without the DATE function. The DATE function is required to convert the specified date in datetime format.
Question 9 of 63
9. Question
You import a TXT file that contains package delivery times. The format in the DeliveryDate column is in datetime format. For example, the first row is 2022-03-20 0831 EST. You want to analyze the dates, but you are not interested in the time stamp. How could you easily extract the date into a new column?
Correct
In Power Query Editor, go to Add Column > Column from Examples. Next, and type in the date component of the first row you see e.g. 2022-03-20. After Power BI applies to all rows, set the data type of the column to Date. Do not use the TRIM function. TRIM is used to remove whitespaces in strings. Do not use the VALUE function. VALUE converts a string to a number. Do not use the CONCATENATE function. CONCATENATE joins two strings together.
Incorrect
In Power Query Editor, go to Add Column > Column from Examples. Next, and type in the date component of the first row you see e.g. 2022-03-20. After Power BI applies to all rows, set the data type of the column to Date. Do not use the TRIM function. TRIM is used to remove whitespaces in strings. Do not use the VALUE function. VALUE converts a string to a number. Do not use the CONCATENATE function. CONCATENATE joins two strings together.
Unattempted
In Power Query Editor, go to Add Column > Column from Examples. Next, and type in the date component of the first row you see e.g. 2022-03-20. After Power BI applies to all rows, set the data type of the column to Date. Do not use the TRIM function. TRIM is used to remove whitespaces in strings. Do not use the VALUE function. VALUE converts a string to a number. Do not use the CONCATENATE function. CONCATENATE joins two strings together.
Question 10 of 63
10. Question
You work for an established mobile App game company, and you have a large dataset for in-app purchases. The dataset contains over 300k rows. What visual should you use to identify outliers in the data?
Correct
You should use a scatter cart to identify outliers in your data. Scatter charts are useful at displaying patterns in large datasets when displayed with two numeric values. You should not use a key influencers visual. The key influencers visual allows you to discover factors that affect a metric. You should not use a decomposition tree. A decomposition tree allows you to drill into multiple dimension and conduct root cause analysis. You should not use an Area chart. An area chart (also known as layered area chart) is based on the line chart. The area between axis and line is filled with colors to indicate volume.
Incorrect
You should use a scatter cart to identify outliers in your data. Scatter charts are useful at displaying patterns in large datasets when displayed with two numeric values. You should not use a key influencers visual. The key influencers visual allows you to discover factors that affect a metric. You should not use a decomposition tree. A decomposition tree allows you to drill into multiple dimension and conduct root cause analysis. You should not use an Area chart. An area chart (also known as layered area chart) is based on the line chart. The area between axis and line is filled with colors to indicate volume.
Unattempted
You should use a scatter cart to identify outliers in your data. Scatter charts are useful at displaying patterns in large datasets when displayed with two numeric values. You should not use a key influencers visual. The key influencers visual allows you to discover factors that affect a metric. You should not use a decomposition tree. A decomposition tree allows you to drill into multiple dimension and conduct root cause analysis. You should not use an Area chart. An area chart (also known as layered area chart) is based on the line chart. The area between axis and line is filled with colors to indicate volume.
Question 11 of 63
11. Question
One of your queries in Power Query Editor seems to be taking a lot longer to refresh than you expect. You need to understand what Power Query is doing at authoring and at refresh time. How would you go about this?
Correct
The Query Diagnostics tells you what Power Query is doing at authoring and refresh time in Power BI Desktop. Performance analyzer is used to identify performance issues of visuals and is not used in Power Query Editor. Q&A is a natural language tool to help you interrogate your data and cannot be used to analyze queries. The ALM toolkit is a tool to manage Microsoft Power BI dataset and cannot be used to analyze queries.
Incorrect
The Query Diagnostics tells you what Power Query is doing at authoring and refresh time in Power BI Desktop. Performance analyzer is used to identify performance issues of visuals and is not used in Power Query Editor. Q&A is a natural language tool to help you interrogate your data and cannot be used to analyze queries. The ALM toolkit is a tool to manage Microsoft Power BI dataset and cannot be used to analyze queries.
Unattempted
The Query Diagnostics tells you what Power Query is doing at authoring and refresh time in Power BI Desktop. Performance analyzer is used to identify performance issues of visuals and is not used in Power Query Editor. Q&A is a natural language tool to help you interrogate your data and cannot be used to analyze queries. The ALM toolkit is a tool to manage Microsoft Power BI dataset and cannot be used to analyze queries.
Question 12 of 63
12. Question
You have created a supplier quality report and are asked to add row-level security to your data model. You decide to add dynamic row-level security that uses a userÂ’s email address. You have a column for a userÂ’s email address called UserEmail. What DAX function would you use to create a new role using the UserEmail field?
Correct
Use the USERPRINCIPALNAME function. Within Power BI Desktop userprincipalname() will return a user in the format of [email protected]. In answer A, USEROBJECTID returns the current userÂ’s Object ID from Azure AD for Azure Analysis Server. This function does not return an email address. In answer C, PATH returns a string that contains a delimited list of IDs, starting with the top/root of a hierarchy and ending with the specified ID. PATH is often used for employee hierarchies. In answer D, there is no DAX function USERDOMAIN.
Incorrect
Use the USERPRINCIPALNAME function. Within Power BI Desktop userprincipalname() will return a user in the format of [email protected]. In answer A, USEROBJECTID returns the current userÂ’s Object ID from Azure AD for Azure Analysis Server. This function does not return an email address. In answer C, PATH returns a string that contains a delimited list of IDs, starting with the top/root of a hierarchy and ending with the specified ID. PATH is often used for employee hierarchies. In answer D, there is no DAX function USERDOMAIN.
Unattempted
Use the USERPRINCIPALNAME function. Within Power BI Desktop userprincipalname() will return a user in the format of [email protected]. In answer A, USEROBJECTID returns the current userÂ’s Object ID from Azure AD for Azure Analysis Server. This function does not return an email address. In answer C, PATH returns a string that contains a delimited list of IDs, starting with the top/root of a hierarchy and ending with the specified ID. PATH is often used for employee hierarchies. In answer D, there is no DAX function USERDOMAIN.
Question 13 of 63
13. Question
You work for a bank and have a large dataset for credit card transactions for a city. The data is in a Microsoft SQL Server database and has over 15 million rows. Before you use the dataset, you want to import a sample of the credit card data. How could you achieve this goal?
Correct
When connecting to a SQL Server Database, expand the advanced options. Within the advanced options, you can add a SQL statement. Write a filter using the WHERE clause to import a sample of the data. In answer A, if you import all the data, you will not have a small sample to work with. As there are 15 million rows, you may end up with a huge model that is difficult to use. In answer C, there is no TOPN functionality. TOPN is a DAX filter used to create measures once the data has already been imported. In answer D, there is no option HEAD in the advanced settings to automatically sample the data. HEAD is a function used in R scripts.
Incorrect
When connecting to a SQL Server Database, expand the advanced options. Within the advanced options, you can add a SQL statement. Write a filter using the WHERE clause to import a sample of the data. In answer A, if you import all the data, you will not have a small sample to work with. As there are 15 million rows, you may end up with a huge model that is difficult to use. In answer C, there is no TOPN functionality. TOPN is a DAX filter used to create measures once the data has already been imported. In answer D, there is no option HEAD in the advanced settings to automatically sample the data. HEAD is a function used in R scripts.
Unattempted
When connecting to a SQL Server Database, expand the advanced options. Within the advanced options, you can add a SQL statement. Write a filter using the WHERE clause to import a sample of the data. In answer A, if you import all the data, you will not have a small sample to work with. As there are 15 million rows, you may end up with a huge model that is difficult to use. In answer C, there is no TOPN functionality. TOPN is a DAX filter used to create measures once the data has already been imported. In answer D, there is no option HEAD in the advanced settings to automatically sample the data. HEAD is a function used in R scripts.
Question 14 of 63
14. Question
You have a slicer for categories in a vertical list. How can you get the same slicer into a horizontal list of buttons that automatically adapts to size changes, as per the below exhibit?
Correct
Under the Format pane select the General dropdown. Under Orientation change the setting to Horizontal. Lastly, to ensure the visual will adapt to size changes, toggle the Responsive switch on.
In answers A and B, using buttons and images you cannot automatically adapt the size changes. These solutions also do not use a slicer.
In answer D, changing the background color does not assist with automatically adapting to size changes.
Incorrect
Under the Format pane select the General dropdown. Under Orientation change the setting to Horizontal. Lastly, to ensure the visual will adapt to size changes, toggle the Responsive switch on.
In answers A and B, using buttons and images you cannot automatically adapt the size changes. These solutions also do not use a slicer.
In answer D, changing the background color does not assist with automatically adapting to size changes.
Unattempted
Under the Format pane select the General dropdown. Under Orientation change the setting to Horizontal. Lastly, to ensure the visual will adapt to size changes, toggle the Responsive switch on.
In answers A and B, using buttons and images you cannot automatically adapt the size changes. These solutions also do not use a slicer.
In answer D, changing the background color does not assist with automatically adapting to size changes.
Question 15 of 63
15. Question
You have a customer service database that has a feedback score from 1 to 5. You create a dashboard with a card visual for the daily feedback score average. The CEO wants to receive an alert if the average score falls below 3.5. How can he achieve this?
Correct
Alerts notify you when data in your dashboards changes beyond the limits you set. The limit can be above or below a threshold and can be set on cards, gauges and KPI visuals. Answer A is incorrect. You do not write a custom R script for data alerts. Answer B is incorrect. A subscription is a recurring snapshot of your dashboard sent to your email. A subscription is not used for data alerts. Answer C is incorrect. You add emails for service notifications for admins in case of service disruptions.
Incorrect
Alerts notify you when data in your dashboards changes beyond the limits you set. The limit can be above or below a threshold and can be set on cards, gauges and KPI visuals. Answer A is incorrect. You do not write a custom R script for data alerts. Answer B is incorrect. A subscription is a recurring snapshot of your dashboard sent to your email. A subscription is not used for data alerts. Answer C is incorrect. You add emails for service notifications for admins in case of service disruptions.
Unattempted
Alerts notify you when data in your dashboards changes beyond the limits you set. The limit can be above or below a threshold and can be set on cards, gauges and KPI visuals. Answer A is incorrect. You do not write a custom R script for data alerts. Answer B is incorrect. A subscription is a recurring snapshot of your dashboard sent to your email. A subscription is not used for data alerts. Answer C is incorrect. You add emails for service notifications for admins in case of service disruptions.
Question 16 of 63
16. Question
CASE 1 You have built a report with many pages for a manufacturing company. Your client’s feedback is that it is hard to navigate to the important pages of the report. You suggest creating a homepage with links to help guide users to important pages on the report. How would you go about building the homepage? Solution: · Add pictures that describe the report page · Set the image action type to ‘Q&A.’ Can this technique be used for the homepage?
Correct
To use a picture as a link to a report page, the action type needs to be ‘Page navigation’. If you select ‘Q&A’, the Q&A screen will pop-up to integrate your data.
Incorrect
To use a picture as a link to a report page, the action type needs to be ‘Page navigation’. If you select ‘Q&A’, the Q&A screen will pop-up to integrate your data.
Unattempted
To use a picture as a link to a report page, the action type needs to be ‘Page navigation’. If you select ‘Q&A’, the Q&A screen will pop-up to integrate your data.
Question 17 of 63
17. Question
CASE 1 You have built a report with many pages for a manufacturing company. Your client’s feedback is that it is hard to navigate to the important pages of the report. You suggest creating a homepage with links to help guide users to important pages on the report. How would you go about building the homepage? Solution: · Create a bookmark for each page · On the homepage, create buttons to link to those pages · On the button, change the action type to bookmark for the corresponding page Can this technique be used for the homepage?
Correct
This technique will work. A bookmark keeps a page in a configured format with filters applied. When you click on the home page buttons, you are taken to the report page with the bookmarkÂ’s settings applied.
Incorrect
This technique will work. A bookmark keeps a page in a configured format with filters applied. When you click on the home page buttons, you are taken to the report page with the bookmarkÂ’s settings applied.
Unattempted
This technique will work. A bookmark keeps a page in a configured format with filters applied. When you click on the home page buttons, you are taken to the report page with the bookmarkÂ’s settings applied.
Question 18 of 63
18. Question
CASE 1 You have built a report with many pages for a manufacturing company. Your client’s feedback is that it is hard to navigate to the important pages of the report. You suggest creating a homepage with links to help guide users to important pages on the report. How would you go about building the homepage? Solution: · Create shapes e.g. square, circle · Assign the shape’s action to page navigation Can this technique be used for the homepage?
Correct
This technique will work. Page navigation is supported for buttons, images and shapes. When you click on the shape, you will navigate to the report page assigned to the shape.
Incorrect
This technique will work. Page navigation is supported for buttons, images and shapes. When you click on the shape, you will navigate to the report page assigned to the shape.
Unattempted
This technique will work. Page navigation is supported for buttons, images and shapes. When you click on the shape, you will navigate to the report page assigned to the shape.
Question 19 of 63
19. Question
CASE 2
You have a dataset for a market basket analysis as per the below exhibit. Each row represents a transaction, and each column contains an item purchased. For instance, in TransactionID 8 there are 3 products: Product1 = ‘peanut butter‘, Product2 = frozen pizza‘ and Product3 =‘ ice cream‘.
\
You need to transform your data into the below exhibit. The first column is TransactionID, the second is Attribute and the third column is Value.
How would you transform the data into these 3 columns?
Correct
To analyze the data you need as a minimum, a column for the TransactionID and a Value column for the item purchased. To do this, select the TransactionID column and then go to the transform ribbon and select Unpivot other columns.
Do not Pivot columns as per Answers A and B. Pivoting turns data into columns, whereas unpivoting turns data into rows. Since the exhibit shows data in rows, we want to use unpivot.
Do not unpivot all columns as you will get two columns, attribute and value. The value column will mix both the TransactionID with the product purchased.
Incorrect
To analyze the data you need as a minimum, a column for the TransactionID and a Value column for the item purchased. To do this, select the TransactionID column and then go to the transform ribbon and select Unpivot other columns.
Do not Pivot columns as per Answers A and B. Pivoting turns data into columns, whereas unpivoting turns data into rows. Since the exhibit shows data in rows, we want to use unpivot.
Do not unpivot all columns as you will get two columns, attribute and value. The value column will mix both the TransactionID with the product purchased.
Unattempted
To analyze the data you need as a minimum, a column for the TransactionID and a Value column for the item purchased. To do this, select the TransactionID column and then go to the transform ribbon and select Unpivot other columns.
Do not Pivot columns as per Answers A and B. Pivoting turns data into columns, whereas unpivoting turns data into rows. Since the exhibit shows data in rows, we want to use unpivot.
Do not unpivot all columns as you will get two columns, attribute and value. The value column will mix both the TransactionID with the product purchased.
Question 20 of 63
20. Question
CASE 2
For your Market Basket Analysis, you now need to create a new table with all possible combinations of products as per the below exhibit.
What DAX function would you use in the [VALUE] position in the expression?
Basket Analysis =
FILTER(
[VALUE]Â (
VALUES(‘MarketBasket‘[Value]),
SELECTCOLUMNS(VALUES(MarketBasket[Value]),“Value2“, [Value])
),
[Value]>[Value2] )
Correct
You use a CROSSJOIN() function to combines each row from the first table with each row from the second table. For example, for every citrus fruit, there is a corresponding product. The filter function is used to remove duplicate rows.
Do not use INTERSECT(). The INTERSECT() function is used to the rows that exist in two tables.
Do not use EXCEPT(). The EXCEPT() function returns the rows of the left-side table which do not appear in the right-side table.
Do not use SUMMARIZE(), this function returns a summary of the input table grouped by specified columns.
Incorrect
You use a CROSSJOIN() function to combines each row from the first table with each row from the second table. For example, for every citrus fruit, there is a corresponding product. The filter function is used to remove duplicate rows.
Do not use INTERSECT(). The INTERSECT() function is used to the rows that exist in two tables.
Do not use EXCEPT(). The EXCEPT() function returns the rows of the left-side table which do not appear in the right-side table.
Do not use SUMMARIZE(), this function returns a summary of the input table grouped by specified columns.
Unattempted
You use a CROSSJOIN() function to combines each row from the first table with each row from the second table. For example, for every citrus fruit, there is a corresponding product. The filter function is used to remove duplicate rows.
Do not use INTERSECT(). The INTERSECT() function is used to the rows that exist in two tables.
Do not use EXCEPT(). The EXCEPT() function returns the rows of the left-side table which do not appear in the right-side table.
Do not use SUMMARIZE(), this function returns a summary of the input table grouped by specified columns.
Question 21 of 63
21. Question
CASE 2 You want to use a custom network chart to display your market basket analysis called ‘Network and add the Advanced Network Visual.’ However, your company policy is to not allow custom visuals as a default. How could you enable this specific custom visual?
Correct
You can add custom visuals to your organizational visuals. Go to the admin portal in Power Bi Service and add the Network and add the Advanced Network Visual to your organizational visuals list. Now anyone in your company can use the custom visual. Temporarily allowing all visuals would violate your companyÂ’s policy. Reproducing a visual is time-consuming and may not yield the same results as the custom visual. A request to Microsoft will unlikely add the custom visual to the standard charts.
Incorrect
You can add custom visuals to your organizational visuals. Go to the admin portal in Power Bi Service and add the Network and add the Advanced Network Visual to your organizational visuals list. Now anyone in your company can use the custom visual. Temporarily allowing all visuals would violate your companyÂ’s policy. Reproducing a visual is time-consuming and may not yield the same results as the custom visual. A request to Microsoft will unlikely add the custom visual to the standard charts.
Unattempted
You can add custom visuals to your organizational visuals. Go to the admin portal in Power Bi Service and add the Network and add the Advanced Network Visual to your organizational visuals list. Now anyone in your company can use the custom visual. Temporarily allowing all visuals would violate your companyÂ’s policy. Reproducing a visual is time-consuming and may not yield the same results as the custom visual. A request to Microsoft will unlikely add the custom visual to the standard charts.
Question 22 of 63
22. Question
CASE 3
You are a Supply Chain analytics manager and have data on customer fill rates. A fill rate is a KPI of the fraction of customer demand that is met through immediate stock availability. See the below exhibit for a sample of the ‘FillRate’ table.
You need to restrict a visual to show the bottom 5 customers with the lowest fill rates.
Solution: Create a measure of the bottom five customers using the TOPN function.
Does this solution meet your goal?
Correct
You can use the TOPN DAX function to give the top or bottom values in a table. For instance, you could create a table of the bottom 5 values using TOPN and ASC such as the below.
Fill Rate Bottom 5 = TOPN (5, ‘FillRate’, ‘FillRate’[Fill Rate], ASC)
If you wanted the same function to give you the top 5, you would change to DESC.
Fill Rate Top 5 = TOPN (5, ‘FillRate’, ‘FillRate’[Fill Rate], DESC)
One thing to note is the TOPN function does not guarantee the order of the results. When you create your new table, you need to sort the Fill Rate column ascending or descending.
Incorrect
You can use the TOPN DAX function to give the top or bottom values in a table. For instance, you could create a table of the bottom 5 values using TOPN and ASC such as the below.
Fill Rate Bottom 5 = TOPN (5, ‘FillRate’, ‘FillRate’[Fill Rate], ASC)
If you wanted the same function to give you the top 5, you would change to DESC.
Fill Rate Top 5 = TOPN (5, ‘FillRate’, ‘FillRate’[Fill Rate], DESC)
One thing to note is the TOPN function does not guarantee the order of the results. When you create your new table, you need to sort the Fill Rate column ascending or descending.
Unattempted
You can use the TOPN DAX function to give the top or bottom values in a table. For instance, you could create a table of the bottom 5 values using TOPN and ASC such as the below.
Fill Rate Bottom 5 = TOPN (5, ‘FillRate’, ‘FillRate’[Fill Rate], ASC)
If you wanted the same function to give you the top 5, you would change to DESC.
Fill Rate Top 5 = TOPN (5, ‘FillRate’, ‘FillRate’[Fill Rate], DESC)
One thing to note is the TOPN function does not guarantee the order of the results. When you create your new table, you need to sort the Fill Rate column ascending or descending.
Question 23 of 63
23. Question
CASE 3
You are a Supply Chain analytics manager and have data on customer fill rates. A fill rate is a KPI of the fraction of customer demand that is met through immediate stock availability. See the below exhibit for a sample of the ‘FillRate’ table.
You need to restrict a visual to show the bottom 5 customers with the lowest fill rates.
Solution: Create a measure of the bottom five customers using the RANKX function.
Does this solution meet your goal?
Correct
You can use a RANKX function to rank your fill rates and then use CALCULATE and a FILTER to limit the output to the bottom or top values.
Incorrect
You can use a RANKX function to rank your fill rates and then use CALCULATE and a FILTER to limit the output to the bottom or top values.
Unattempted
You can use a RANKX function to rank your fill rates and then use CALCULATE and a FILTER to limit the output to the bottom or top values.
Question 24 of 63
24. Question
CASE 3
You are a Supply Chain analytics manager and have data on customer fill rates. A fill rate is a KPI of the fraction of customer demand that is met through immediate stock availability. See the below exhibit for a sample of the ‘FillRate’ table.
You need to restrict a visual to show the bottom 5 customers with the lowest fill rates.
Solution: Apply a Basic Filter on the visual (Visual level filter)
Does this solution meet your goal?
Correct
A basic filter will not filter the bottom or top N items. However, if you use a Top N filter on the visual you can get the bottom 5 customer with the lowest fill rates.
Incorrect
A basic filter will not filter the bottom or top N items. However, if you use a Top N filter on the visual you can get the bottom 5 customer with the lowest fill rates.
Unattempted
A basic filter will not filter the bottom or top N items. However, if you use a Top N filter on the visual you can get the bottom 5 customer with the lowest fill rates.
Question 25 of 63
25. Question
You have a dashboard that is an important part of collaborative planning in your organization. Since the team is remote, you have been asked to allow users to provide feedback on the dashboard that will be visible to other team members. How would you achieve this goal?
Correct
Comments can be added to an entire dashboard, to individual visuals on a dashboard and can be seen by your colleagues. Additionally, when you add a comment to a report, Power BI captures the current filter and slicer values and creates a bookmark. This means that when you select or respond to a comment, the report page or report visual may change to show you the active filter and slicer selections when the comment was first added. You cannot add sticky notes to a dashboard You cannot a note to a group email through a dashboard. Lastly, you cannot add a note to an alert.
Incorrect
Comments can be added to an entire dashboard, to individual visuals on a dashboard and can be seen by your colleagues. Additionally, when you add a comment to a report, Power BI captures the current filter and slicer values and creates a bookmark. This means that when you select or respond to a comment, the report page or report visual may change to show you the active filter and slicer selections when the comment was first added. You cannot add sticky notes to a dashboard You cannot a note to a group email through a dashboard. Lastly, you cannot add a note to an alert.
Unattempted
Comments can be added to an entire dashboard, to individual visuals on a dashboard and can be seen by your colleagues. Additionally, when you add a comment to a report, Power BI captures the current filter and slicer values and creates a bookmark. This means that when you select or respond to a comment, the report page or report visual may change to show you the active filter and slicer selections when the comment was first added. You cannot add sticky notes to a dashboard You cannot a note to a group email through a dashboard. Lastly, you cannot add a note to an alert.
Question 26 of 63
26. Question
You have an HR dataset divided into regions. You use row-level security to ensure each manager can only see their regionÂ’s data. After you publish your report to Power BI Service, an HR manager calls and complains they cannot see all their data in the APAC region. How would you verify what the HR manager is seeing in Power BI Desktop?
Correct
You can validate a role in Power BI Desktop by going to the Modeling tab and select View as. You can then check the APAC region to simulate what the HR manager sees. Do not use Track user activities as this will not show you what row-level security data your user will see. Do not remove the HR managerÂ’s role and re-assign. Only do this if you have established that the HR manager was incorrectly assigned to the wrong region. Do not send the user your Power Bi Desktop file as they will be able to see all region data, which they do not have access to.
Incorrect
You can validate a role in Power BI Desktop by going to the Modeling tab and select View as. You can then check the APAC region to simulate what the HR manager sees. Do not use Track user activities as this will not show you what row-level security data your user will see. Do not remove the HR managerÂ’s role and re-assign. Only do this if you have established that the HR manager was incorrectly assigned to the wrong region. Do not send the user your Power Bi Desktop file as they will be able to see all region data, which they do not have access to.
Unattempted
You can validate a role in Power BI Desktop by going to the Modeling tab and select View as. You can then check the APAC region to simulate what the HR manager sees. Do not use Track user activities as this will not show you what row-level security data your user will see. Do not remove the HR managerÂ’s role and re-assign. Only do this if you have established that the HR manager was incorrectly assigned to the wrong region. Do not send the user your Power Bi Desktop file as they will be able to see all region data, which they do not have access to.
Question 27 of 63
27. Question
Your company has a Microsoft SharePoint site with all your manufacturing Bill of Materials (BOM) files in a subfolder. These files are all stores as Excel documents and have the same schema. As part of your analysis for the procurement team, you need to load all the Bill of Materials files together into a table in Power BI for analysis. You also need to edit some of the columns after the data has been loaded. How would you achieve this goal?
Correct
The steps to load a set of files from SharePoint with the same schema is: 1. Get Data 2. Select Sharepoint folder 3. Enter the URL 4. Navigate to the specific folder 5. Select Combine & Transform Data A is incorrect as you need to navigate first to the correct folder and there is no import button. C is incorrect as you do not enter a URL prior to selecting SharePoint folder as a data type. D is incorrect as there is no custom SQL code. When connecting to Microsoft SQL Server, you can add custom SQL.
Incorrect
The steps to load a set of files from SharePoint with the same schema is: 1. Get Data 2. Select Sharepoint folder 3. Enter the URL 4. Navigate to the specific folder 5. Select Combine & Transform Data A is incorrect as you need to navigate first to the correct folder and there is no import button. C is incorrect as you do not enter a URL prior to selecting SharePoint folder as a data type. D is incorrect as there is no custom SQL code. When connecting to Microsoft SQL Server, you can add custom SQL.
Unattempted
The steps to load a set of files from SharePoint with the same schema is: 1. Get Data 2. Select Sharepoint folder 3. Enter the URL 4. Navigate to the specific folder 5. Select Combine & Transform Data A is incorrect as you need to navigate first to the correct folder and there is no import button. C is incorrect as you do not enter a URL prior to selecting SharePoint folder as a data type. D is incorrect as there is no custom SQL code. When connecting to Microsoft SQL Server, you can add custom SQL.
Question 28 of 63
28. Question
You have a Date table with a date field called Date. You want to create a new column with the full month name and the year e.g. 03 October 2022. How would you create this DAX expression?
Correct
A “DD” will give a date field with a zero such as 03. A “MMMM” will give the full month name. The “YYYY” will give the full year. Do not use A. The single “Y” gives the day of the year as a number. The single “D” and “M” give a single number for day of the month and month number. Do not use B. The “MM” gives the month as a number e.g. 10. Do not use C. The “MMM” gives the month as an abbreviation e.g. OCT. https://docs.microsoft.com/en-us/dax/format-function-dax
Incorrect
A “DD” will give a date field with a zero such as 03. A “MMMM” will give the full month name. The “YYYY” will give the full year. Do not use A. The single “Y” gives the day of the year as a number. The single “D” and “M” give a single number for day of the month and month number. Do not use B. The “MM” gives the month as a number e.g. 10. Do not use C. The “MMM” gives the month as an abbreviation e.g. OCT. https://docs.microsoft.com/en-us/dax/format-function-dax
Unattempted
A “DD” will give a date field with a zero such as 03. A “MMMM” will give the full month name. The “YYYY” will give the full year. Do not use A. The single “Y” gives the day of the year as a number. The single “D” and “M” give a single number for day of the month and month number. Do not use B. The “MM” gives the month as a number e.g. 10. Do not use C. The “MMM” gives the month as an abbreviation e.g. OCT. https://docs.microsoft.com/en-us/dax/format-function-dax
Question 29 of 63
29. Question
You have sales data for a bike company and you calculate a measure of the sales percentage within each category.
You need to format the visualization to match the one shown in the exhibit.
How should you configure the visual?
Correct
In the format pane, expand conditional formatting. Select the column ‘Sales % Category’ from the dropdown and then turn on data bars.
Incorrect
In the format pane, expand conditional formatting. Select the column ‘Sales % Category’ from the dropdown and then turn on data bars.
Unattempted
In the format pane, expand conditional formatting. Select the column ‘Sales % Category’ from the dropdown and then turn on data bars.
Question 30 of 63
30. Question
You work for an airline company and have a dataset with a DirectQuery storage mode. You have built a report with several visuals on the page. Users complain of performance issues when using the visuals in the Power BI report. How would you optimize the report?
Correct
You should switch off interactions between visuals. Cross-filtering and cross-highlighting interactions cause queries to submit to the data source every time a user clicks on a visual when DirectQuery is used. You can disable interactions at the report level or for each visual on the page that is causing issues to fix the performance issue. In answer A, turning off security filters will not optimize the report and may be necessary for row-level security. In answer B, switching off single select for slicers will create more inefficiency. Single select is more optimal than multi-select. In answer D, removing background images will have a negligible impact to report optimization.
Incorrect
You should switch off interactions between visuals. Cross-filtering and cross-highlighting interactions cause queries to submit to the data source every time a user clicks on a visual when DirectQuery is used. You can disable interactions at the report level or for each visual on the page that is causing issues to fix the performance issue. In answer A, turning off security filters will not optimize the report and may be necessary for row-level security. In answer B, switching off single select for slicers will create more inefficiency. Single select is more optimal than multi-select. In answer D, removing background images will have a negligible impact to report optimization.
Unattempted
You should switch off interactions between visuals. Cross-filtering and cross-highlighting interactions cause queries to submit to the data source every time a user clicks on a visual when DirectQuery is used. You can disable interactions at the report level or for each visual on the page that is causing issues to fix the performance issue. In answer A, turning off security filters will not optimize the report and may be necessary for row-level security. In answer B, switching off single select for slicers will create more inefficiency. Single select is more optimal than multi-select. In answer D, removing background images will have a negligible impact to report optimization.
Question 31 of 63
31. Question
What data preview type would give you the below exhibit when you click on the Standard cost column?
Correct
The column profile feature provides a more in-depth look at the data in a column. Apart from the column distribution chart, it contains a column statistics chart.
Column quality shows the valid, error and empty percentages across all columns.
Monospaced applies a monospaced font to the data.
Column distribution provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.
Incorrect
The column profile feature provides a more in-depth look at the data in a column. Apart from the column distribution chart, it contains a column statistics chart.
Column quality shows the valid, error and empty percentages across all columns.
Monospaced applies a monospaced font to the data.
Column distribution provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.
Unattempted
The column profile feature provides a more in-depth look at the data in a column. Apart from the column distribution chart, it contains a column statistics chart.
Column quality shows the valid, error and empty percentages across all columns.
Monospaced applies a monospaced font to the data.
Column distribution provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.
Question 32 of 63
32. Question
Your company is looking to expand your Power BI resources. Some of the feedback from your team is that it is hard to test Power BI Service dashboards fully prior to release. Is there a better way to handle the lifecycle of your Power BI report and dashboard creation? What is the best solution to achieve this goal?
Correct
The deployment pipelines tool enables BI creators to manage the lifecycle of organizational content. Deployment pipelines enable creators to develop and test Power BI content in the Power BI service, before the content is consumed by users. Do not use Power BI Report Server, as this tool alone will not enable report lifecycle management. Creating separate workspaces is not an efficient way to manage a deployment lifecycle. Paginated reports are used for ‘pixel perfect’ reporting and will not assist in report lifecycle management.
Incorrect
The deployment pipelines tool enables BI creators to manage the lifecycle of organizational content. Deployment pipelines enable creators to develop and test Power BI content in the Power BI service, before the content is consumed by users. Do not use Power BI Report Server, as this tool alone will not enable report lifecycle management. Creating separate workspaces is not an efficient way to manage a deployment lifecycle. Paginated reports are used for ‘pixel perfect’ reporting and will not assist in report lifecycle management.
Unattempted
The deployment pipelines tool enables BI creators to manage the lifecycle of organizational content. Deployment pipelines enable creators to develop and test Power BI content in the Power BI service, before the content is consumed by users. Do not use Power BI Report Server, as this tool alone will not enable report lifecycle management. Creating separate workspaces is not an efficient way to manage a deployment lifecycle. Paginated reports are used for ‘pixel perfect’ reporting and will not assist in report lifecycle management.
Question 33 of 63
33. Question
You work for a cryptocurrency exchange and have a report of crypto transactions showing monthly trends. Your crypto transaction table has over 60 million rows. You need to optimize the reportÂ’s performance. Which TWO actions should you perform?
Correct
By creating a summary table at a monthly level, the amount of data that Power BI needs to process is significantly reduced. Furthermore, setting the storage mode on the crypto transaction table to DirectQuery means no data is imported or copied into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you are always viewing current data. Do not import the crypto transaction table as the 60 million row data set will create a huge data model and you need the flexibility to query the most up to date data. Limiting the visual types to bar and line charts will not have an impact on the data model.
Incorrect
By creating a summary table at a monthly level, the amount of data that Power BI needs to process is significantly reduced. Furthermore, setting the storage mode on the crypto transaction table to DirectQuery means no data is imported or copied into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you are always viewing current data. Do not import the crypto transaction table as the 60 million row data set will create a huge data model and you need the flexibility to query the most up to date data. Limiting the visual types to bar and line charts will not have an impact on the data model.
Unattempted
By creating a summary table at a monthly level, the amount of data that Power BI needs to process is significantly reduced. Furthermore, setting the storage mode on the crypto transaction table to DirectQuery means no data is imported or copied into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you are always viewing current data. Do not import the crypto transaction table as the 60 million row data set will create a huge data model and you need the flexibility to query the most up to date data. Limiting the visual types to bar and line charts will not have an impact on the data model.
Question 34 of 63
34. Question
You work for a sports company, and you build a Power BI data set with row-level security in the data model. The company is divided into three categories: footwear, apparel and equipment. In Power BI desktop, you create roles for each category and you add a DAX filter expression for each role on the product table. You add the Azure Active Directory security group for the category to each role. A new user starts in the equipment category. What is the best practice to ensure that the new user can only view equipment data?
Correct
The new user should be added to the Azure Active Directory for the Equipment category. Since you have used Azure Active Directory security groups to control membership of the roles, you should add and remove users using the Azure Active Directory. Do not change the DAX filter in Power BI Desktop. The DAX expression is used as a filter on rows displayed for a role and does not control the membership of that role. Membership of roles can either be managed in Azure Active Directory or in Power BI Service. While it is possible to add the userÂ’s email to a role in Power BI Service, it is not best practice in this case because you have already set up Azure Active Directory groups to control the membership of roles. Adding the user as a workspace member does not assist in row-level security. In the Power BI Service, members of a workspace have access to datasets in the workspace. Row-level security does not restrict this data access.
Incorrect
The new user should be added to the Azure Active Directory for the Equipment category. Since you have used Azure Active Directory security groups to control membership of the roles, you should add and remove users using the Azure Active Directory. Do not change the DAX filter in Power BI Desktop. The DAX expression is used as a filter on rows displayed for a role and does not control the membership of that role. Membership of roles can either be managed in Azure Active Directory or in Power BI Service. While it is possible to add the userÂ’s email to a role in Power BI Service, it is not best practice in this case because you have already set up Azure Active Directory groups to control the membership of roles. Adding the user as a workspace member does not assist in row-level security. In the Power BI Service, members of a workspace have access to datasets in the workspace. Row-level security does not restrict this data access.
Unattempted
The new user should be added to the Azure Active Directory for the Equipment category. Since you have used Azure Active Directory security groups to control membership of the roles, you should add and remove users using the Azure Active Directory. Do not change the DAX filter in Power BI Desktop. The DAX expression is used as a filter on rows displayed for a role and does not control the membership of that role. Membership of roles can either be managed in Azure Active Directory or in Power BI Service. While it is possible to add the userÂ’s email to a role in Power BI Service, it is not best practice in this case because you have already set up Azure Active Directory groups to control the membership of roles. Adding the user as a workspace member does not assist in row-level security. In the Power BI Service, members of a workspace have access to datasets in the workspace. Row-level security does not restrict this data access.
Question 35 of 63
35. Question
You lead a Power BI team for a turbine manufacturer. Your boss has asked your team to develop a custom ‘pbiviz’ visual in Power BI that shades the turbine areas according to the number of defects. Before you put together a team to develop the custom visual, you look into the steps to develop a custom visual to understand the skills required. When setting up an environment for developing a Power BI visual, what software do you first need to install?
Correct
To develop pbiviz files, you need to install node.js, a framework designed to build scalable applications based on the Javascript language. The steps to set up an environment for a custom visual are: 1. Install nodes.js 2. Install pbiviz 3. Create and install a certificate 4. Set up Power BI service for developing a visual 5. Install additional libraries (required for developing a visual, e.g. D3) Do not install c++, as this language cannot be used for pbiviz files. While python and R can be used to create custom visuals within Power BI, they cannot be used to create pbiviz files.
Incorrect
To develop pbiviz files, you need to install node.js, a framework designed to build scalable applications based on the Javascript language. The steps to set up an environment for a custom visual are: 1. Install nodes.js 2. Install pbiviz 3. Create and install a certificate 4. Set up Power BI service for developing a visual 5. Install additional libraries (required for developing a visual, e.g. D3) Do not install c++, as this language cannot be used for pbiviz files. While python and R can be used to create custom visuals within Power BI, they cannot be used to create pbiviz files.
Unattempted
To develop pbiviz files, you need to install node.js, a framework designed to build scalable applications based on the Javascript language. The steps to set up an environment for a custom visual are: 1. Install nodes.js 2. Install pbiviz 3. Create and install a certificate 4. Set up Power BI service for developing a visual 5. Install additional libraries (required for developing a visual, e.g. D3) Do not install c++, as this language cannot be used for pbiviz files. While python and R can be used to create custom visuals within Power BI, they cannot be used to create pbiviz files.
Question 36 of 63
36. Question
You have recently set up Power BI Service at your company. One of the senior managers expresses concern about publishing reports to the web with sensitive data. What can you do to prevent users from publishing content on the web?
Correct
To disable the ability for users to publish to the web, go to Admin Portal > Tenant settings > under Publish to web, check disable. This setting allows you to control whether users can use the publish to the web feature. Do not disable Allow content sharing with external users. You may need this functionality to share reports and workspaces with approved external users. There are no settings ‘Allow URL links’ nor ‘Block embedded links’.
Incorrect
To disable the ability for users to publish to the web, go to Admin Portal > Tenant settings > under Publish to web, check disable. This setting allows you to control whether users can use the publish to the web feature. Do not disable Allow content sharing with external users. You may need this functionality to share reports and workspaces with approved external users. There are no settings ‘Allow URL links’ nor ‘Block embedded links’.
Unattempted
To disable the ability for users to publish to the web, go to Admin Portal > Tenant settings > under Publish to web, check disable. This setting allows you to control whether users can use the publish to the web feature. Do not disable Allow content sharing with external users. You may need this functionality to share reports and workspaces with approved external users. There are no settings ‘Allow URL links’ nor ‘Block embedded links’.
Question 37 of 63
37. Question
Using the bookmarking features in the report designer in Power BI Desktop, there is a limitation of creating only one bookmark per page in a report. Is this statement correct?
Correct
You are allowed to create multiple bookmarks.
Incorrect
You are allowed to create multiple bookmarks.
Unattempted
You are allowed to create multiple bookmarks.
Question 38 of 63
38. Question
Which of the following statements are true with regard to using the Slicer visual in a Power BI report?
Correct
Slicer cannot be pinned to dashboard because dashboards are not interactive. Measure are not allowed to use in slicer.
Incorrect
Slicer cannot be pinned to dashboard because dashboards are not interactive. Measure are not allowed to use in slicer.
Unattempted
Slicer cannot be pinned to dashboard because dashboards are not interactive. Measure are not allowed to use in slicer.
Question 39 of 63
39. Question
Which of the following visuals is not included as part of Power BI and must be added as a custom visual?
Correct
Histogram is not added to Power BI tools by default, it needs to be added as custom visual.
Incorrect
Histogram is not added to Power BI tools by default, it needs to be added as custom visual.
Unattempted
Histogram is not added to Power BI tools by default, it needs to be added as custom visual.
Question 40 of 63
40. Question
What is the file format used to define a theme for a Power BI report?
Correct
The correct answer is:
B. JavaScript Object Notation (JSON)
Power BI reports use JSON files to define themes. These JSON files specify color schemes, font styles, and other visual elements used throughout the report. This format provides a flexible and easy-to-manage way to define and customize report themes.
Here are the other options and why they are incorrect:
A. Cascading Style Sheets (CCS):Â CSS is primarily used for styling web pages, not for defining Power BI themes.
C. Extensible Markup Language (XML):Â While XML can be used for various data formats, it’s not the standard format for Power BI themes.
D. Power BI Markup Language (PBIML):Â PBIML is a specific language used for defining Power BI report structure and data relationships, not for themes.
Incorrect
The correct answer is:
B. JavaScript Object Notation (JSON)
Power BI reports use JSON files to define themes. These JSON files specify color schemes, font styles, and other visual elements used throughout the report. This format provides a flexible and easy-to-manage way to define and customize report themes.
Here are the other options and why they are incorrect:
A. Cascading Style Sheets (CCS):Â CSS is primarily used for styling web pages, not for defining Power BI themes.
C. Extensible Markup Language (XML):Â While XML can be used for various data formats, it’s not the standard format for Power BI themes.
D. Power BI Markup Language (PBIML):Â PBIML is a specific language used for defining Power BI report structure and data relationships, not for themes.
Unattempted
The correct answer is:
B. JavaScript Object Notation (JSON)
Power BI reports use JSON files to define themes. These JSON files specify color schemes, font styles, and other visual elements used throughout the report. This format provides a flexible and easy-to-manage way to define and customize report themes.
Here are the other options and why they are incorrect:
A. Cascading Style Sheets (CCS):Â CSS is primarily used for styling web pages, not for defining Power BI themes.
C. Extensible Markup Language (XML):Â While XML can be used for various data formats, it’s not the standard format for Power BI themes.
D. Power BI Markup Language (PBIML):Â PBIML is a specific language used for defining Power BI report structure and data relationships, not for themes.
Question 41 of 63
41. Question
In Power BI Desktop Report view, which three options will create a measure in the Sales table?
Correct
Option two and three allow you to create a measure directly in the Sales table. Option one allows you to create a measure in any table, and then move it to the Sales table.
Incorrect
Option two and three allow you to create a measure directly in the Sales table. Option one allows you to create a measure in any table, and then move it to the Sales table.
Unattempted
Option two and three allow you to create a measure directly in the Sales table. Option one allows you to create a measure in any table, and then move it to the Sales table.
Question 42 of 63
42. Question
What are the three reasons for which you might use calculated tables?
Correct
You can use calculated tables to create a table based on the result of a function/formula. For example, you can use calculated tables to union tables and perform different types of merge join.
Incorrect
You can use calculated tables to create a table based on the result of a function/formula. For example, you can use calculated tables to union tables and perform different types of merge join.
Unattempted
You can use calculated tables to create a table based on the result of a function/formula. For example, you can use calculated tables to union tables and perform different types of merge join.
Question 43 of 63
43. Question
Which three fields are available when creating a Pie chart visualization?
Correct
While creating a Pie chart, you get options for Legend, Details, and Values fields.
Incorrect
While creating a Pie chart, you get options for Legend, Details, and Values fields.
Unattempted
While creating a Pie chart, you get options for Legend, Details, and Values fields.
Question 44 of 63
44. Question
By default, which filter level behaves the same as a slicer in a report in Power BI Desktop?
Correct
When you create a slicer in a report, the slicer will filter the visualizations on the current page, similar to page level filter.
Incorrect
When you create a slicer in a report, the slicer will filter the visualizations on the current page, similar to page level filter.
Unattempted
When you create a slicer in a report, the slicer will filter the visualizations on the current page, similar to page level filter.
Question 45 of 63
45. Question
Which two field options are available when creating a waterfall chart?
Correct
When creating a waterfall chart, you need to define both the Category and the Y Axis fields.
Incorrect
When creating a waterfall chart, you need to define both the Category and the Y Axis fields.
Unattempted
When creating a waterfall chart, you need to define both the Category and the Y Axis fields.
Question 46 of 63
46. Question
Months are sorted alphabetically in Stacked bar chart. What can you do to sort it by month number?
Correct
The correct answer is:
C. Modeling -> Select Month Column -> Sort By – MonthNumber
Here’s why this is the correct option:
A. Click on ellipses on Right Top Corner of visual -> Sort by – MonthNumber: This option might be available in some visualization tools, but it’s not universally applicable in Power BI. Sorting within the visual itself often doesn’t sort the underlying data and can lead to inconsistent behavior across different visualizations.
While option A might seem like a viable solution, there are important caveats to consider:
Potential Issues with Option A:
Tool Dependency:Â Not all visualization tools offer this functionality for sorting within the visual itself. This option might work in some tools but not universally, including in some versions of Power BI.
Temporary Sorting:Â Even if the tool offers this option, the sorting might only apply to the specific visual. This can lead to inconsistencies if you have multiple visualizations using the same month field.
Doesn’t Address Underlying Data:Â Sorting within the visual itself often doesn’t sort the underlying data model. This means the change might not persist when you refresh the data or create new visualizations.
When Option A Might Be Suitable
Option A could serve as a quick, temporary fix for sorting within a specific visual if your tool supports it and consistency across multiple visuals or refreshing data is not a major concern.
B. Right Click on field in report view and select sort by, then select MonthNumber: While this provides options for sorting within the report view, it doesn’t apply the sorting to the underlying data model, which is crucial for ensuring consistent sorting across all visualizations using the month column.
C. Modeling -> Select Month Column -> Sort By – MonthNumber is the most reliable and effective approach because:
Modeling refers to the area in Power BI where you manage the relationships and structure of your data model.
Selecting the Month Column specifies the specific data column you want to sort.
Sort By – MonthNumber explicitly defines the sorting criteria as the numerical month number, ensuring correct ordering based on month sequence (e.g., January, February, March…).
By using this option in the Modeling section, you apply the sorting logic to the underlying data model, which is reflected in all visuals that use the month column. This provides accurate and consistent month-based sorting across your entire report.
Incorrect
The correct answer is:
C. Modeling -> Select Month Column -> Sort By – MonthNumber
Here’s why this is the correct option:
A. Click on ellipses on Right Top Corner of visual -> Sort by – MonthNumber: This option might be available in some visualization tools, but it’s not universally applicable in Power BI. Sorting within the visual itself often doesn’t sort the underlying data and can lead to inconsistent behavior across different visualizations.
While option A might seem like a viable solution, there are important caveats to consider:
Potential Issues with Option A:
Tool Dependency:Â Not all visualization tools offer this functionality for sorting within the visual itself. This option might work in some tools but not universally, including in some versions of Power BI.
Temporary Sorting:Â Even if the tool offers this option, the sorting might only apply to the specific visual. This can lead to inconsistencies if you have multiple visualizations using the same month field.
Doesn’t Address Underlying Data:Â Sorting within the visual itself often doesn’t sort the underlying data model. This means the change might not persist when you refresh the data or create new visualizations.
When Option A Might Be Suitable
Option A could serve as a quick, temporary fix for sorting within a specific visual if your tool supports it and consistency across multiple visuals or refreshing data is not a major concern.
B. Right Click on field in report view and select sort by, then select MonthNumber: While this provides options for sorting within the report view, it doesn’t apply the sorting to the underlying data model, which is crucial for ensuring consistent sorting across all visualizations using the month column.
C. Modeling -> Select Month Column -> Sort By – MonthNumber is the most reliable and effective approach because:
Modeling refers to the area in Power BI where you manage the relationships and structure of your data model.
Selecting the Month Column specifies the specific data column you want to sort.
Sort By – MonthNumber explicitly defines the sorting criteria as the numerical month number, ensuring correct ordering based on month sequence (e.g., January, February, March…).
By using this option in the Modeling section, you apply the sorting logic to the underlying data model, which is reflected in all visuals that use the month column. This provides accurate and consistent month-based sorting across your entire report.
Unattempted
The correct answer is:
C. Modeling -> Select Month Column -> Sort By – MonthNumber
Here’s why this is the correct option:
A. Click on ellipses on Right Top Corner of visual -> Sort by – MonthNumber: This option might be available in some visualization tools, but it’s not universally applicable in Power BI. Sorting within the visual itself often doesn’t sort the underlying data and can lead to inconsistent behavior across different visualizations.
While option A might seem like a viable solution, there are important caveats to consider:
Potential Issues with Option A:
Tool Dependency:Â Not all visualization tools offer this functionality for sorting within the visual itself. This option might work in some tools but not universally, including in some versions of Power BI.
Temporary Sorting:Â Even if the tool offers this option, the sorting might only apply to the specific visual. This can lead to inconsistencies if you have multiple visualizations using the same month field.
Doesn’t Address Underlying Data:Â Sorting within the visual itself often doesn’t sort the underlying data model. This means the change might not persist when you refresh the data or create new visualizations.
When Option A Might Be Suitable
Option A could serve as a quick, temporary fix for sorting within a specific visual if your tool supports it and consistency across multiple visuals or refreshing data is not a major concern.
B. Right Click on field in report view and select sort by, then select MonthNumber: While this provides options for sorting within the report view, it doesn’t apply the sorting to the underlying data model, which is crucial for ensuring consistent sorting across all visualizations using the month column.
C. Modeling -> Select Month Column -> Sort By – MonthNumber is the most reliable and effective approach because:
Modeling refers to the area in Power BI where you manage the relationships and structure of your data model.
Selecting the Month Column specifies the specific data column you want to sort.
Sort By – MonthNumber explicitly defines the sorting criteria as the numerical month number, ensuring correct ordering based on month sequence (e.g., January, February, March…).
By using this option in the Modeling section, you apply the sorting logic to the underlying data model, which is reflected in all visuals that use the month column. This provides accurate and consistent month-based sorting across your entire report.
Question 47 of 63
47. Question
What is true about using variables in DAX?
Correct
Choice A: Variables are created only one time in the current context.
Partially true: Variables are created within a specific formula, function, or query scope. Their values persist throughout the entire scope they are defined in. However, they are not automatically scoped to the entire DAX expression or query.
Choice B: Maximum of 5 variables can be created per formula.
False: There is no strict limit on the number of variables you can create within a DAX formula. However, excessive variables can lead to complexity and readability concerns. It’s generally recommended to use variables judiciously for clarity and maintainability.
Choice C: Variables must be defined inside return.
False: Variables can be defined anywhere within the formula where they are used. Defining them before calculations can improve readability and code organization.
Additional points:
Variable scope:Â Variables defined within a nested formula or function have lower priority than those in the outer scope. If the same variable name is used in both scopes, the inner variable takes precedence within its scope.
Best practices:Â Use meaningful and descriptive variable names to enhance code readability. Consider using comments to explain the purpose of complex variables.
In summary:
Variables are created once within their specific scope (formula, function, or query) and their values persist throughout that scope.
There is no fixed limit on the number of variables per formula, but good practice suggests using them judiciously.
Variables can be defined anywhere within the formula as long as they are used before the point of reference.
Incorrect
Choice A: Variables are created only one time in the current context.
Partially true: Variables are created within a specific formula, function, or query scope. Their values persist throughout the entire scope they are defined in. However, they are not automatically scoped to the entire DAX expression or query.
Choice B: Maximum of 5 variables can be created per formula.
False: There is no strict limit on the number of variables you can create within a DAX formula. However, excessive variables can lead to complexity and readability concerns. It’s generally recommended to use variables judiciously for clarity and maintainability.
Choice C: Variables must be defined inside return.
False: Variables can be defined anywhere within the formula where they are used. Defining them before calculations can improve readability and code organization.
Additional points:
Variable scope:Â Variables defined within a nested formula or function have lower priority than those in the outer scope. If the same variable name is used in both scopes, the inner variable takes precedence within its scope.
Best practices:Â Use meaningful and descriptive variable names to enhance code readability. Consider using comments to explain the purpose of complex variables.
In summary:
Variables are created once within their specific scope (formula, function, or query) and their values persist throughout that scope.
There is no fixed limit on the number of variables per formula, but good practice suggests using them judiciously.
Variables can be defined anywhere within the formula as long as they are used before the point of reference.
Unattempted
Choice A: Variables are created only one time in the current context.
Partially true: Variables are created within a specific formula, function, or query scope. Their values persist throughout the entire scope they are defined in. However, they are not automatically scoped to the entire DAX expression or query.
Choice B: Maximum of 5 variables can be created per formula.
False: There is no strict limit on the number of variables you can create within a DAX formula. However, excessive variables can lead to complexity and readability concerns. It’s generally recommended to use variables judiciously for clarity and maintainability.
Choice C: Variables must be defined inside return.
False: Variables can be defined anywhere within the formula where they are used. Defining them before calculations can improve readability and code organization.
Additional points:
Variable scope:Â Variables defined within a nested formula or function have lower priority than those in the outer scope. If the same variable name is used in both scopes, the inner variable takes precedence within its scope.
Best practices:Â Use meaningful and descriptive variable names to enhance code readability. Consider using comments to explain the purpose of complex variables.
In summary:
Variables are created once within their specific scope (formula, function, or query) and their values persist throughout that scope.
There is no fixed limit on the number of variables per formula, but good practice suggests using them judiciously.
Variables can be defined anywhere within the formula as long as they are used before the point of reference.
Question 48 of 63
48. Question
You’re creating a fancy little dashboard using Power BI Service. The dashboard shows the accumulative increase in the global population over the last several decades. The dashboard will contain an introductory YouTube video that you have uploaded to the YouTube website. After uploading the video you copy the embedded HTML code and paste it into your dashboard.
Unfortunately the video is fixed to 560 pixels wide and you would like it to expand to fit the tile size. What should you do?
Correct
The best option to make the YouTube video expand to fit the tile size in your Power BI Service dashboard is:
A. Change the iFrame width and height attribute values to 100%
Here’s why this approach works:
iFrame Attributes:Â The embedded YouTube code likely utilizes an iFrame element to display the video within the dashboard. iFrame elements have width and height attributes that control their size.
Setting Values to 100%:Â By changing the width and height attributes of the iFrame to 100%, the video will attempt to fill the entire space available within the dashboard tile.
Why other options are not ideal:
B. Removing allowfullscreen:Â While the “allowfullscreen” parameter allows the video to go fullscreen, it doesn’t control the initial size within the tile.
C. Adding an outer DIV:Â This might introduce unnecessary nesting and wouldn’t guarantee the video expands to fit the tile.
D. Fixed Size Videos:Â While some video players might have fixed sizes, YouTube embeds typically allow some level of responsiveness. Setting the iFrame width and height to 100% leverages this flexibility to fit the tile size.
Additional Tips:
Test the changes in Power BI Service preview mode to ensure the video resizes as expected.
You might need to adjust the padding or margin within the iFrame code to fine-tune the video placement within the tile.
By modifying the iFrame’s width and height attributes, you can ensure your YouTube video adapts to the size of your Power BI dashboard tile.
Incorrect
The best option to make the YouTube video expand to fit the tile size in your Power BI Service dashboard is:
A. Change the iFrame width and height attribute values to 100%
Here’s why this approach works:
iFrame Attributes:Â The embedded YouTube code likely utilizes an iFrame element to display the video within the dashboard. iFrame elements have width and height attributes that control their size.
Setting Values to 100%:Â By changing the width and height attributes of the iFrame to 100%, the video will attempt to fill the entire space available within the dashboard tile.
Why other options are not ideal:
B. Removing allowfullscreen:Â While the “allowfullscreen” parameter allows the video to go fullscreen, it doesn’t control the initial size within the tile.
C. Adding an outer DIV:Â This might introduce unnecessary nesting and wouldn’t guarantee the video expands to fit the tile.
D. Fixed Size Videos:Â While some video players might have fixed sizes, YouTube embeds typically allow some level of responsiveness. Setting the iFrame width and height to 100% leverages this flexibility to fit the tile size.
Additional Tips:
Test the changes in Power BI Service preview mode to ensure the video resizes as expected.
You might need to adjust the padding or margin within the iFrame code to fine-tune the video placement within the tile.
By modifying the iFrame’s width and height attributes, you can ensure your YouTube video adapts to the size of your Power BI dashboard tile.
Unattempted
The best option to make the YouTube video expand to fit the tile size in your Power BI Service dashboard is:
A. Change the iFrame width and height attribute values to 100%
Here’s why this approach works:
iFrame Attributes:Â The embedded YouTube code likely utilizes an iFrame element to display the video within the dashboard. iFrame elements have width and height attributes that control their size.
Setting Values to 100%:Â By changing the width and height attributes of the iFrame to 100%, the video will attempt to fill the entire space available within the dashboard tile.
Why other options are not ideal:
B. Removing allowfullscreen:Â While the “allowfullscreen” parameter allows the video to go fullscreen, it doesn’t control the initial size within the tile.
C. Adding an outer DIV:Â This might introduce unnecessary nesting and wouldn’t guarantee the video expands to fit the tile.
D. Fixed Size Videos:Â While some video players might have fixed sizes, YouTube embeds typically allow some level of responsiveness. Setting the iFrame width and height to 100% leverages this flexibility to fit the tile size.
Additional Tips:
Test the changes in Power BI Service preview mode to ensure the video resizes as expected.
You might need to adjust the padding or margin within the iFrame code to fine-tune the video placement within the tile.
By modifying the iFrame’s width and height attributes, you can ensure your YouTube video adapts to the size of your Power BI dashboard tile.
Question 49 of 63
49. Question
How can you make sure that each category manager can see sales of their category only and CEO to see all sales in the same report?
Correct
Creating separate reports for each manager will duplicate the reports and make it difficult to maintain them. Creating a slicer in the report is not going to secure data at all. Dynamic row-level security is the most appropriate choice given that there is a table that can be used to filter categories based on the active username. The CEO can have a separate role to view everything.
Incorrect
Creating separate reports for each manager will duplicate the reports and make it difficult to maintain them. Creating a slicer in the report is not going to secure data at all. Dynamic row-level security is the most appropriate choice given that there is a table that can be used to filter categories based on the active username. The CEO can have a separate role to view everything.
Unattempted
Creating separate reports for each manager will duplicate the reports and make it difficult to maintain them. Creating a slicer in the report is not going to secure data at all. Dynamic row-level security is the most appropriate choice given that there is a table that can be used to filter categories based on the active username. The CEO can have a separate role to view everything.
Question 50 of 63
50. Question
In order to use the Power BI web part in SharePoint Online, the report author as well as all the report consumers require a Power BI Pro license. Is this statement true ?
Correct
All Sharepoint report viewers must have Power BI pro license.
Incorrect
All Sharepoint report viewers must have Power BI pro license.
Unattempted
All Sharepoint report viewers must have Power BI pro license.
Question 51 of 63
51. Question
Which of the following types of real-time data set in Power BI always store their data in Azure SQL Database?
Correct
Streaming data set don‘t store data in Azure SQL database.
Incorrect
Streaming data set don‘t store data in Azure SQL database.
Unattempted
Streaming data set don‘t store data in Azure SQL database.
Question 52 of 63
52. Question
Which of the following are advantages that Power BI dashboards have over Power BI reports?
Correct
First option is not correct because dashboard and report both offer Q&A functionality. Second option is also not correct because dashboards are not interactive. Only a case of interaction is if you pin a live page. Even in that case that visual that contains live report page will be interactive but it cannot interact with other tiles.
Incorrect
First option is not correct because dashboard and report both offer Q&A functionality. Second option is also not correct because dashboards are not interactive. Only a case of interaction is if you pin a live page. Even in that case that visual that contains live report page will be interactive but it cannot interact with other tiles.
Unattempted
First option is not correct because dashboard and report both offer Q&A functionality. Second option is also not correct because dashboards are not interactive. Only a case of interaction is if you pin a live page. Even in that case that visual that contains live report page will be interactive but it cannot interact with other tiles.
Question 53 of 63
53. Question
Which of the following are advantages that Power BI reports have over Power BI dashboards?
Correct
Reports don‘t support streaming datasets. This feature is available in dashboard tiles.
Incorrect
Reports don‘t support streaming datasets. This feature is available in dashboard tiles.
Unattempted
Reports don‘t support streaming datasets. This feature is available in dashboard tiles.
Question 54 of 63
54. Question
Which three properties of a tile can be edited in the Power BI dashboard from the Tile details window?
Correct
You can edit three properties of a tile in the Power BI dashboard from the Tile details window:
All three options are valid:
A. Title:Â You can rename the tile to provide a clear and concise description of the data it displays.
B. Subtitle:Â An optional subtitle can be added to provide further context or details about the tile’s content.
C. Destination link:Â You can define a link that users can click on the tile to navigate to a specific report, dashboard, or external webpage for further exploration.
Incorrect Option:
D. Color scheme:Â While the visual appearance of a tile can be customized, the Power BI dashboard doesn’t allow editing the color scheme directly from the Tile details window. You would typically modify the color scheme of the underlying report or visual element and the changes would be reflected in the tile.
Incorrect
You can edit three properties of a tile in the Power BI dashboard from the Tile details window:
All three options are valid:
A. Title:Â You can rename the tile to provide a clear and concise description of the data it displays.
B. Subtitle:Â An optional subtitle can be added to provide further context or details about the tile’s content.
C. Destination link:Â You can define a link that users can click on the tile to navigate to a specific report, dashboard, or external webpage for further exploration.
Incorrect Option:
D. Color scheme:Â While the visual appearance of a tile can be customized, the Power BI dashboard doesn’t allow editing the color scheme directly from the Tile details window. You would typically modify the color scheme of the underlying report or visual element and the changes would be reflected in the tile.
Unattempted
You can edit three properties of a tile in the Power BI dashboard from the Tile details window:
All three options are valid:
A. Title:Â You can rename the tile to provide a clear and concise description of the data it displays.
B. Subtitle:Â An optional subtitle can be added to provide further context or details about the tile’s content.
C. Destination link:Â You can define a link that users can click on the tile to navigate to a specific report, dashboard, or external webpage for further exploration.
Incorrect Option:
D. Color scheme:Â While the visual appearance of a tile can be customized, the Power BI dashboard doesn’t allow editing the color scheme directly from the Tile details window. You would typically modify the color scheme of the underlying report or visual element and the changes would be reflected in the tile.
Question 55 of 63
55. Question
What do you need to append to the URL of a Power BI dashboard in order to open it with the navigation pane collapsed by default?
Correct
When you append ?collapseNavigation=true at the end of a Power BI dashboard URL, it will take you to the Power BI Dashboard with the navigation pane collapsed.
Incorrect
When you append ?collapseNavigation=true at the end of a Power BI dashboard URL, it will take you to the Power BI Dashboard with the navigation pane collapsed.
Unattempted
When you append ?collapseNavigation=true at the end of a Power BI dashboard URL, it will take you to the Power BI Dashboard with the navigation pane collapsed.
Question 56 of 63
56. Question
Which feature is used to create alternative name for fields in tables. It will make it much easier for users to ask questions on dashboards?
Correct
The best feature to create alternative names for fields in tables to improve user experience with Power BI dashboards is:
C. Synonyms
Here’s why Synonyms is the correct option:
Power BI Q&A Functionality:Â Power BI offers a natural language query feature called Q&A that allows users to ask questions about their data using everyday language.
Synonym Definition:Â Synonyms are alternative words or phrases with similar meanings. By defining synonyms for table fields, you help Q&A understand the user’s intent even if they don’t use the exact field name.
Why other options are not ideal:
A. Duplicate Name:Â Creating duplicate names for fields can lead to confusion and data inconsistency. It’s not a recommended practice for managing field names.
B. Alternative:Â While “Alternative” might suggest providing another name, it’s not a specific feature within Power BI for managing synonyms.
By using Synonyms, you can enhance the user experience in Power BI dashboards by allowing users to ask questions using terms they’re more comfortable with, regardless of the actual field names in the data model.
Incorrect
The best feature to create alternative names for fields in tables to improve user experience with Power BI dashboards is:
C. Synonyms
Here’s why Synonyms is the correct option:
Power BI Q&A Functionality:Â Power BI offers a natural language query feature called Q&A that allows users to ask questions about their data using everyday language.
Synonym Definition:Â Synonyms are alternative words or phrases with similar meanings. By defining synonyms for table fields, you help Q&A understand the user’s intent even if they don’t use the exact field name.
Why other options are not ideal:
A. Duplicate Name:Â Creating duplicate names for fields can lead to confusion and data inconsistency. It’s not a recommended practice for managing field names.
B. Alternative:Â While “Alternative” might suggest providing another name, it’s not a specific feature within Power BI for managing synonyms.
By using Synonyms, you can enhance the user experience in Power BI dashboards by allowing users to ask questions using terms they’re more comfortable with, regardless of the actual field names in the data model.
Unattempted
The best feature to create alternative names for fields in tables to improve user experience with Power BI dashboards is:
C. Synonyms
Here’s why Synonyms is the correct option:
Power BI Q&A Functionality:Â Power BI offers a natural language query feature called Q&A that allows users to ask questions about their data using everyday language.
Synonym Definition:Â Synonyms are alternative words or phrases with similar meanings. By defining synonyms for table fields, you help Q&A understand the user’s intent even if they don’t use the exact field name.
Why other options are not ideal:
A. Duplicate Name:Â Creating duplicate names for fields can lead to confusion and data inconsistency. It’s not a recommended practice for managing field names.
B. Alternative:Â While “Alternative” might suggest providing another name, it’s not a specific feature within Power BI for managing synonyms.
By using Synonyms, you can enhance the user experience in Power BI dashboards by allowing users to ask questions using terms they’re more comfortable with, regardless of the actual field names in the data model.
Question 57 of 63
57. Question
Which page view types are available in Power BI Report View?
Correct
Full Screen is now available.
Incorrect
Full Screen is now available.
Unattempted
Full Screen is now available.
Question 58 of 63
58. Question
What is the primary purpose of the on-premises data gateway?
Correct
The primary purpose of the on-premises data gateway is:
A. To allow refreshing on-premises data sources from the Power BI Service
Here’s why this is the most likely answer:
Power BI Service Focus:Â The Power BI Service is a cloud-based business intelligence service. It allows users to create, share, and consume reports and dashboards.
Data Source Refresh:Â Since the Power BI Service resides in the cloud, it might not be able to directly access data sources located on-premises within a customer’s network. The on-premises data gateway acts as a bridge, allowing the Power BI Service to securely connect and refresh data from these on-premises sources.
Why other options are not ideal:
B. To store SSAS tabular models locally:Â SSAS tabular models are a type of data model used for Analysis Services. While on-premises storage is possible, the on-premises data gateway’s primary function isn’t model storage.
C. To allow refreshing on-premises data sources from the Power BI Report Server:Â Power BI Report Server is an on-premises version of Power BI, and it can directly access on-premises data sources without the need for a gateway. The gateway is typically used for refreshing data sources in the cloud-based Power BI Service.
D. To allow the rendering of mobile reports outside of the corporate network:Â While mobile report access might be a benefit, it’s not the primary purpose of the on-premises data gateway. The gateway focuses on enabling secure data access for refreshing reports and dashboards, not necessarily mobile report rendering.
Incorrect
The primary purpose of the on-premises data gateway is:
A. To allow refreshing on-premises data sources from the Power BI Service
Here’s why this is the most likely answer:
Power BI Service Focus:Â The Power BI Service is a cloud-based business intelligence service. It allows users to create, share, and consume reports and dashboards.
Data Source Refresh:Â Since the Power BI Service resides in the cloud, it might not be able to directly access data sources located on-premises within a customer’s network. The on-premises data gateway acts as a bridge, allowing the Power BI Service to securely connect and refresh data from these on-premises sources.
Why other options are not ideal:
B. To store SSAS tabular models locally:Â SSAS tabular models are a type of data model used for Analysis Services. While on-premises storage is possible, the on-premises data gateway’s primary function isn’t model storage.
C. To allow refreshing on-premises data sources from the Power BI Report Server:Â Power BI Report Server is an on-premises version of Power BI, and it can directly access on-premises data sources without the need for a gateway. The gateway is typically used for refreshing data sources in the cloud-based Power BI Service.
D. To allow the rendering of mobile reports outside of the corporate network:Â While mobile report access might be a benefit, it’s not the primary purpose of the on-premises data gateway. The gateway focuses on enabling secure data access for refreshing reports and dashboards, not necessarily mobile report rendering.
Unattempted
The primary purpose of the on-premises data gateway is:
A. To allow refreshing on-premises data sources from the Power BI Service
Here’s why this is the most likely answer:
Power BI Service Focus:Â The Power BI Service is a cloud-based business intelligence service. It allows users to create, share, and consume reports and dashboards.
Data Source Refresh:Â Since the Power BI Service resides in the cloud, it might not be able to directly access data sources located on-premises within a customer’s network. The on-premises data gateway acts as a bridge, allowing the Power BI Service to securely connect and refresh data from these on-premises sources.
Why other options are not ideal:
B. To store SSAS tabular models locally:Â SSAS tabular models are a type of data model used for Analysis Services. While on-premises storage is possible, the on-premises data gateway’s primary function isn’t model storage.
C. To allow refreshing on-premises data sources from the Power BI Report Server:Â Power BI Report Server is an on-premises version of Power BI, and it can directly access on-premises data sources without the need for a gateway. The gateway is typically used for refreshing data sources in the cloud-based Power BI Service.
D. To allow the rendering of mobile reports outside of the corporate network:Â While mobile report access might be a benefit, it’s not the primary purpose of the on-premises data gateway. The gateway focuses on enabling secure data access for refreshing reports and dashboards, not necessarily mobile report rendering.
Question 59 of 63
59. Question
Which feature allows different users to view the same report but access different subsets of data?
Correct
The feature that allows different users to view the same report but access different subsets of data is:
C. Row-level security (RLS)
Here’s why RLS is the best option:
Data Filtering at Row Level:Â RLS enables you to define security rules that filter data at the row level within a Power BI report or dataset. This means users see only the data rows that meet the criteria defined in the RLS rules.
User-Specific Access:Â RLS can be configured to use various factors to determine data visibility, such as user attributes (e.g., department, location) or membership in security groups. This allows you to grant access to the same report while controlling the specific data each user can see.
Why other options are not ideal:
A. Office 365 Groups:Â While Office 365 Groups can be used for collaboration and access control, it’s not specifically designed for row-level security within Power BI reports.
B. Two-factor authentication:Â This is a security measure to improve account security by requiring a second verification step during login. It doesn’t control data access within reports.
D. Query folding:Â Query folding is an optimization technique that pushes some query processing to the source database. While it can improve performance, it doesn’t directly control data access for different users.
Incorrect
The feature that allows different users to view the same report but access different subsets of data is:
C. Row-level security (RLS)
Here’s why RLS is the best option:
Data Filtering at Row Level:Â RLS enables you to define security rules that filter data at the row level within a Power BI report or dataset. This means users see only the data rows that meet the criteria defined in the RLS rules.
User-Specific Access:Â RLS can be configured to use various factors to determine data visibility, such as user attributes (e.g., department, location) or membership in security groups. This allows you to grant access to the same report while controlling the specific data each user can see.
Why other options are not ideal:
A. Office 365 Groups:Â While Office 365 Groups can be used for collaboration and access control, it’s not specifically designed for row-level security within Power BI reports.
B. Two-factor authentication:Â This is a security measure to improve account security by requiring a second verification step during login. It doesn’t control data access within reports.
D. Query folding:Â Query folding is an optimization technique that pushes some query processing to the source database. While it can improve performance, it doesn’t directly control data access for different users.
Unattempted
The feature that allows different users to view the same report but access different subsets of data is:
C. Row-level security (RLS)
Here’s why RLS is the best option:
Data Filtering at Row Level:Â RLS enables you to define security rules that filter data at the row level within a Power BI report or dataset. This means users see only the data rows that meet the criteria defined in the RLS rules.
User-Specific Access:Â RLS can be configured to use various factors to determine data visibility, such as user attributes (e.g., department, location) or membership in security groups. This allows you to grant access to the same report while controlling the specific data each user can see.
Why other options are not ideal:
A. Office 365 Groups:Â While Office 365 Groups can be used for collaboration and access control, it’s not specifically designed for row-level security within Power BI reports.
B. Two-factor authentication:Â This is a security measure to improve account security by requiring a second verification step during login. It doesn’t control data access within reports.
D. Query folding:Â Query folding is an optimization technique that pushes some query processing to the source database. While it can improve performance, it doesn’t directly control data access for different users.
Question 60 of 63
60. Question
You possess a Power BI Report with 5 tables arranged in a star schema. The data set is approximately 50 megabytes in size. Your report currently connects to the SQL Server backend using DirectQuery. What would you do to enable Quick Insights?
Correct
The best option to enable Quick Insights for your Power BI report is:
B. Convert the report from DirectQuery mode to Import mode
Here’s why converting to Import mode is necessary for Quick Insights:
DirectQuery Limitation:Â Quick Insights is a feature that analyzes the data model to discover trends and insights. It currently doesn’t support reports in DirectQuery mode. DirectQuery connects live to the underlying data source, and Power BI doesn’t have a local copy of the data for analysis with Quick Insights.
Import Mode Compatibility:Â In Import mode, Power BI imports a copy of the data from the SQL Server backend into the Power BI Service. This allows Quick Insights to access and analyze the data locally within the service.
Why other options are not ideal:
A. Azure Machine Learning:Â While Azure Machine Learning is a powerful service for building and deploying machine learning models, it’s not directly required for enabling Quick Insights. Quick Insights is a built-in Power BI Service feature that leverages existing data in the model.
C. Migrating to Azure SQL Database:Â Migrating the data source to Azure SQL Database might offer some benefits but isn’t necessary for enabling Quick Insights. As long as the data can be imported into Power BI Service, the source database location (on-premises SQL Server or Azure SQL Database) doesn’t affect Quick Insights functionality.
D. Denormalizing the Data:Â Denormalization involves modifying the data model to reduce the number of tables and joins. While it can improve query performance, it’s generally not recommended for star schema designs and might introduce data redundancy and maintenance challenges. It’s not necessary for enabling Quick Insights.
By converting your report to Import mode, you can leverage the built-in Quick Insights feature in Power BI Service to gain valuable insights from your data. Keep in mind that importing data can increase storage requirements in the Power BI Service, so consider the data size and refresh frequency when making this decision.
Incorrect
The best option to enable Quick Insights for your Power BI report is:
B. Convert the report from DirectQuery mode to Import mode
Here’s why converting to Import mode is necessary for Quick Insights:
DirectQuery Limitation:Â Quick Insights is a feature that analyzes the data model to discover trends and insights. It currently doesn’t support reports in DirectQuery mode. DirectQuery connects live to the underlying data source, and Power BI doesn’t have a local copy of the data for analysis with Quick Insights.
Import Mode Compatibility:Â In Import mode, Power BI imports a copy of the data from the SQL Server backend into the Power BI Service. This allows Quick Insights to access and analyze the data locally within the service.
Why other options are not ideal:
A. Azure Machine Learning:Â While Azure Machine Learning is a powerful service for building and deploying machine learning models, it’s not directly required for enabling Quick Insights. Quick Insights is a built-in Power BI Service feature that leverages existing data in the model.
C. Migrating to Azure SQL Database:Â Migrating the data source to Azure SQL Database might offer some benefits but isn’t necessary for enabling Quick Insights. As long as the data can be imported into Power BI Service, the source database location (on-premises SQL Server or Azure SQL Database) doesn’t affect Quick Insights functionality.
D. Denormalizing the Data:Â Denormalization involves modifying the data model to reduce the number of tables and joins. While it can improve query performance, it’s generally not recommended for star schema designs and might introduce data redundancy and maintenance challenges. It’s not necessary for enabling Quick Insights.
By converting your report to Import mode, you can leverage the built-in Quick Insights feature in Power BI Service to gain valuable insights from your data. Keep in mind that importing data can increase storage requirements in the Power BI Service, so consider the data size and refresh frequency when making this decision.
Unattempted
The best option to enable Quick Insights for your Power BI report is:
B. Convert the report from DirectQuery mode to Import mode
Here’s why converting to Import mode is necessary for Quick Insights:
DirectQuery Limitation:Â Quick Insights is a feature that analyzes the data model to discover trends and insights. It currently doesn’t support reports in DirectQuery mode. DirectQuery connects live to the underlying data source, and Power BI doesn’t have a local copy of the data for analysis with Quick Insights.
Import Mode Compatibility:Â In Import mode, Power BI imports a copy of the data from the SQL Server backend into the Power BI Service. This allows Quick Insights to access and analyze the data locally within the service.
Why other options are not ideal:
A. Azure Machine Learning:Â While Azure Machine Learning is a powerful service for building and deploying machine learning models, it’s not directly required for enabling Quick Insights. Quick Insights is a built-in Power BI Service feature that leverages existing data in the model.
C. Migrating to Azure SQL Database:Â Migrating the data source to Azure SQL Database might offer some benefits but isn’t necessary for enabling Quick Insights. As long as the data can be imported into Power BI Service, the source database location (on-premises SQL Server or Azure SQL Database) doesn’t affect Quick Insights functionality.
D. Denormalizing the Data:Â Denormalization involves modifying the data model to reduce the number of tables and joins. While it can improve query performance, it’s generally not recommended for star schema designs and might introduce data redundancy and maintenance challenges. It’s not necessary for enabling Quick Insights.
By converting your report to Import mode, you can leverage the built-in Quick Insights feature in Power BI Service to gain valuable insights from your data. Keep in mind that importing data can increase storage requirements in the Power BI Service, so consider the data size and refresh frequency when making this decision.
Question 61 of 63
61. Question
You encounter the 1 GB size limitation when uploading and refreshing your PBIX files. What is one way to work around this limitation?
Correct
Here’s the breakdown of the options to address the 1 GB size limitation for uploading and refreshing PBIX files:
Best Option:
B. Convert to DirectQuery for your data connections
Reasoning:
DirectQuery Approach:Â When using DirectQuery mode, Power BI connects live to the underlying data source (your SQL Server database in this case). The data isn’t imported into the Power BI Service, eliminating the file size limitation for the PBIX file itself. Queries are pushed to the data source, and only the results are transferred to the Power BI Service for visualization.
Why Other Options Are Not Ideal:
A. SUMMARIZE function:Â While the SUMMARIZE function can help optimize calculations and potentially reduce file size to some extent, it’s unlikely to be a significant factor for overcoming the 1 GB limitation.
C. Migrate to Azure SQL Database:Â Migrating the source database to Azure SQL Database might offer some benefits but doesn’t directly address the PBIX file size limitation. Power BI Service can still work with DirectQuery connections regardless of the database location (on-premises or Azure).
D. Run-length encoding and compression:Â While Power BI utilizes compression techniques, these are unlikely to be enough to significantly reduce the file size by 1 GB, especially for complex datasets.
Additional Considerations:
DirectQuery might have some performance implications compared to Import mode, as queries are executed on the source database. Ensure your database server can handle the additional workload.
Not all data sources support DirectQuery. Verify that your SQL Server version is compatible with this mode.
By switching to DirectQuery mode, you can bypass the PBIX file size limitation and continue working with your large dataset in Power BI Service. Remember to evaluate the potential performance impact on your data source.
Incorrect
Here’s the breakdown of the options to address the 1 GB size limitation for uploading and refreshing PBIX files:
Best Option:
B. Convert to DirectQuery for your data connections
Reasoning:
DirectQuery Approach:Â When using DirectQuery mode, Power BI connects live to the underlying data source (your SQL Server database in this case). The data isn’t imported into the Power BI Service, eliminating the file size limitation for the PBIX file itself. Queries are pushed to the data source, and only the results are transferred to the Power BI Service for visualization.
Why Other Options Are Not Ideal:
A. SUMMARIZE function:Â While the SUMMARIZE function can help optimize calculations and potentially reduce file size to some extent, it’s unlikely to be a significant factor for overcoming the 1 GB limitation.
C. Migrate to Azure SQL Database:Â Migrating the source database to Azure SQL Database might offer some benefits but doesn’t directly address the PBIX file size limitation. Power BI Service can still work with DirectQuery connections regardless of the database location (on-premises or Azure).
D. Run-length encoding and compression:Â While Power BI utilizes compression techniques, these are unlikely to be enough to significantly reduce the file size by 1 GB, especially for complex datasets.
Additional Considerations:
DirectQuery might have some performance implications compared to Import mode, as queries are executed on the source database. Ensure your database server can handle the additional workload.
Not all data sources support DirectQuery. Verify that your SQL Server version is compatible with this mode.
By switching to DirectQuery mode, you can bypass the PBIX file size limitation and continue working with your large dataset in Power BI Service. Remember to evaluate the potential performance impact on your data source.
Unattempted
Here’s the breakdown of the options to address the 1 GB size limitation for uploading and refreshing PBIX files:
Best Option:
B. Convert to DirectQuery for your data connections
Reasoning:
DirectQuery Approach:Â When using DirectQuery mode, Power BI connects live to the underlying data source (your SQL Server database in this case). The data isn’t imported into the Power BI Service, eliminating the file size limitation for the PBIX file itself. Queries are pushed to the data source, and only the results are transferred to the Power BI Service for visualization.
Why Other Options Are Not Ideal:
A. SUMMARIZE function:Â While the SUMMARIZE function can help optimize calculations and potentially reduce file size to some extent, it’s unlikely to be a significant factor for overcoming the 1 GB limitation.
C. Migrate to Azure SQL Database:Â Migrating the source database to Azure SQL Database might offer some benefits but doesn’t directly address the PBIX file size limitation. Power BI Service can still work with DirectQuery connections regardless of the database location (on-premises or Azure).
D. Run-length encoding and compression:Â While Power BI utilizes compression techniques, these are unlikely to be enough to significantly reduce the file size by 1 GB, especially for complex datasets.
Additional Considerations:
DirectQuery might have some performance implications compared to Import mode, as queries are executed on the source database. Ensure your database server can handle the additional workload.
Not all data sources support DirectQuery. Verify that your SQL Server version is compatible with this mode.
By switching to DirectQuery mode, you can bypass the PBIX file size limitation and continue working with your large dataset in Power BI Service. Remember to evaluate the potential performance impact on your data source.
Question 62 of 63
62. Question
Which option describes when you categorize a numerical identifier into specific ranges?
Correct
The best option that describes categorizing a numerical identifier into specific ranges is:
D. Binning
Here’s why:
Binning Definition:Â Binning is a data analysis technique where you group continuous numerical data points into a set of predefined intervals or categories called bins. These bins represent the ranges of values.
Why other options are not ideal:
A. List Grouping:Â While grouping can be used to organize data, it doesn’t necessarily involve creating specific ranges for numerical identifiers. You can group data based on various criteria, not just numerical ranges.
B. Aggregating:Â Aggregation involves combining data points into a single summary value (e.g., sum, average, count). While it can involve numerical identifiers, it doesn’t categorize them into specific ranges.
C. Summing:Â Summing is a specific type of aggregation that calculates the total value of a numerical column. It doesn’t involve creating ranges for the data points.
Incorrect
The best option that describes categorizing a numerical identifier into specific ranges is:
D. Binning
Here’s why:
Binning Definition:Â Binning is a data analysis technique where you group continuous numerical data points into a set of predefined intervals or categories called bins. These bins represent the ranges of values.
Why other options are not ideal:
A. List Grouping:Â While grouping can be used to organize data, it doesn’t necessarily involve creating specific ranges for numerical identifiers. You can group data based on various criteria, not just numerical ranges.
B. Aggregating:Â Aggregation involves combining data points into a single summary value (e.g., sum, average, count). While it can involve numerical identifiers, it doesn’t categorize them into specific ranges.
C. Summing:Â Summing is a specific type of aggregation that calculates the total value of a numerical column. It doesn’t involve creating ranges for the data points.
Unattempted
The best option that describes categorizing a numerical identifier into specific ranges is:
D. Binning
Here’s why:
Binning Definition:Â Binning is a data analysis technique where you group continuous numerical data points into a set of predefined intervals or categories called bins. These bins represent the ranges of values.
Why other options are not ideal:
A. List Grouping:Â While grouping can be used to organize data, it doesn’t necessarily involve creating specific ranges for numerical identifiers. You can group data based on various criteria, not just numerical ranges.
B. Aggregating:Â Aggregation involves combining data points into a single summary value (e.g., sum, average, count). While it can involve numerical identifiers, it doesn’t categorize them into specific ranges.
C. Summing:Â Summing is a specific type of aggregation that calculates the total value of a numerical column. It doesn’t involve creating ranges for the data points.
Question 63 of 63
63. Question
What does the Manage Relationships button accomplish?
Correct
Option A allows you to edit relationships in the Data Analysis Expressions (DAX) data model.
This means you can interpret relationship properties in the model diagram, set relationship properties, and use DAX functions that modify relationship behavior. In practical terms, this involves working with active and inactive relationships, as well as utilizing DAX functions like USERELATIONSHIP to adjust relationship behavior within the Power BI Desktop solution.
Now, let’s explain why the other options are incorrect:
Option B: Managing and editing table relationships in Power BI Desktop does not specifically involve editing relationships in the DAX data model. While it allows for editing relations between merged queries in Power Query, it does not directly relate to DAX data model relationships
Option C: Automatically normalizing your data model is not the primary function of the Manage Relationships button in Power BI. This button is more focused on managing and editing relationships within the data model rather than automatically normalizing it
Option D: Defining relationships for SQL tables to improve query performance is not the main purpose of the Manage Relationships button in Power BI. This button is specifically designed for managing and editing relationships within the Power BI data model, not for optimizing SQL table relationships for query performance
Option A allows you to edit relationships in the Data Analysis Expressions (DAX) data model.
This means you can interpret relationship properties in the model diagram, set relationship properties, and use DAX functions that modify relationship behavior. In practical terms, this involves working with active and inactive relationships, as well as utilizing DAX functions like USERELATIONSHIP to adjust relationship behavior within the Power BI Desktop solution.
Now, let’s explain why the other options are incorrect:
Option B: Managing and editing table relationships in Power BI Desktop does not specifically involve editing relationships in the DAX data model. While it allows for editing relations between merged queries in Power Query, it does not directly relate to DAX data model relationships
Option C: Automatically normalizing your data model is not the primary function of the Manage Relationships button in Power BI. This button is more focused on managing and editing relationships within the data model rather than automatically normalizing it
Option D: Defining relationships for SQL tables to improve query performance is not the main purpose of the Manage Relationships button in Power BI. This button is specifically designed for managing and editing relationships within the Power BI data model, not for optimizing SQL table relationships for query performance
Option A allows you to edit relationships in the Data Analysis Expressions (DAX) data model.
This means you can interpret relationship properties in the model diagram, set relationship properties, and use DAX functions that modify relationship behavior. In practical terms, this involves working with active and inactive relationships, as well as utilizing DAX functions like USERELATIONSHIP to adjust relationship behavior within the Power BI Desktop solution.
Now, let’s explain why the other options are incorrect:
Option B: Managing and editing table relationships in Power BI Desktop does not specifically involve editing relationships in the DAX data model. While it allows for editing relations between merged queries in Power Query, it does not directly relate to DAX data model relationships
Option C: Automatically normalizing your data model is not the primary function of the Manage Relationships button in Power BI. This button is more focused on managing and editing relationships within the data model rather than automatically normalizing it
Option D: Defining relationships for SQL tables to improve query performance is not the main purpose of the Manage Relationships button in Power BI. This button is specifically designed for managing and editing relationships within the Power BI data model, not for optimizing SQL table relationships for query performance