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 11 "
0 of 50 questions answered correctly
Your time:
Time has elapsed
Your Final Score is : 0
You have attempted : 0
Number of Correct Questions : 0 and scored 0
Number of Incorrect Questions : 0 and Negative marks 0
Average score
Your score
PL-300
You have attempted: 0
Number of Correct Questions: 0 and scored 0
Number of Incorrect Questions: 0 and Negative marks 0
You can review your answers by clicking view questions. Important Note : Open Reference Documentation Links in New Tab (Right Click and Open in New Tab).
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Answered
Review
Question 1 of 50
1. Question
You create a Power Bl report for regional sales data.
You write a measure to calculate the Percentage of Sales. The measure is calculating the percentages incorrectly as shown in the exhibit named Incorrect below.
Incorrect
You need to re-write the measure so that the percentage is correct for each country and region and the total percentage is 100 percent. The measure should calculate the percentages as shown in the below exhibit named Correct.
Correct
How should you re-write the measure? To answer, select the appropriate option from the drop-down menu.
Correct
You should configure the measure using REMOVEFILTERS as shown below:
Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionalSales[Sales]), REMOVEFILTERS()))
The REMOVEFILTERS function removes all filters in the context so the grand total is used to calculate the percentages for the country and region rows.
You should not use ALL(RegionalSales[Country]). This will only show the percentages for the country rows. The region sub-total rows will all show a percentage of 100 percent because the filter will only calculate for the country rows. Additionally, the country percentage calculated is the percentage for the region, not the percentage of the grand total.
You should not use ALLSELECTED(‘RegionalSales'[Region]). This will only show the correct percentages for the region sub-totals. The country rows will all show a percentage of 100 percent because the filter will only calculate for the region rows.
Incorrect
You should configure the measure using REMOVEFILTERS as shown below:
Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionalSales[Sales]), REMOVEFILTERS()))
The REMOVEFILTERS function removes all filters in the context so the grand total is used to calculate the percentages for the country and region rows.
You should not use ALL(RegionalSales[Country]). This will only show the percentages for the country rows. The region sub-total rows will all show a percentage of 100 percent because the filter will only calculate for the country rows. Additionally, the country percentage calculated is the percentage for the region, not the percentage of the grand total.
You should not use ALLSELECTED(‘RegionalSales'[Region]). This will only show the correct percentages for the region sub-totals. The country rows will all show a percentage of 100 percent because the filter will only calculate for the region rows.
Unattempted
You should configure the measure using REMOVEFILTERS as shown below:
Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionalSales[Sales]), REMOVEFILTERS()))
The REMOVEFILTERS function removes all filters in the context so the grand total is used to calculate the percentages for the country and region rows.
You should not use ALL(RegionalSales[Country]). This will only show the percentages for the country rows. The region sub-total rows will all show a percentage of 100 percent because the filter will only calculate for the country rows. Additionally, the country percentage calculated is the percentage for the region, not the percentage of the grand total.
You should not use ALLSELECTED(‘RegionalSales'[Region]). This will only show the correct percentages for the region sub-totals. The country rows will all show a percentage of 100 percent because the filter will only calculate for the region rows.
Question 2 of 50
2. Question
Overview:
Company1 Pharmaceuticals develops, manufactures, and supplies healthcare products. Company1 has annual reporting requirements including a balance sheet, income statement, and a profit and loss report for the previous year with projections tor the current year. The reporting within the financial system is limited and does not meet the Company’s requirements. Historically, producing these statements and reports has taken significant manual effort that was error-prone, and it has not been possible to perform useful analysis on financial data.
Planned Changes:
Power BI service and Power BI Desktop will be used to generate financial reports, statements, and analysis tor financial data.
Data Sources:
The finance system holds all financial data including sales and expenses. The finance system holds the chart of accounts. The finance system stores its data in an on-premises SQL Server. Sales prediction and budget plans are stored in Excel workbooks in SharePoint Online.
Reporting Requirements:
The following information should be produced:
> Income trend
> Expenditure trend
> Comparison of income and expenditure for the current year with the previous year
> Comparison of planned income and expenditure for next year with the current year.
Users should also be able to:
> Drill down on data by country and territory.
> Drill down using the chart of accounts structure.
> Use the Q&A feature of Power BI.
Security Requirements:
C level executives should have access to all analysis. Country and Territory managers should only have access to data for their country/territory.
Chart of Accounts:
Expenditure:
Income:
Predicted Sales:
Budget:
Data Model:
Question:
You have a visualization that shows the Budget amount by Account Number. You need to enable the drill down on the chart of account structure on the visualization.
Are the four actions mentioned below should be performed in sequence to achieve the goal? Select Yes if true, otherwise select No.
1. Click on the Parent Account Number column and select New hierarchy.
2. Click on the Account Number column and select Add to hierarchy.
3. In the visualization, replace the Account Number with the new hierarchy
4. Enable drill down on the visualization.
Correct
First, you should create a hierarchy by clicking on the Parent Account Number column and selecting New hierarchy. A hierarchy is required to implement the drill-down functionality. This creates a new hierarchy with the Parent Account Number as the top level in the hierarchy. You can add further columns to the hierarchy.
Then, you should click on the Account Number column and select Add to hierarchy. This adds the Account Number column as the second level in the hierarchy.
Then, you should replace the Account Number with the new hierarchy in the visualization. You need to add the hierarchy to the visualization before you can enable drill down.
Finally, you should enable drill down on the visualization. Enable drill-down allows the users to drill down on the visualization.
Incorrect
First, you should create a hierarchy by clicking on the Parent Account Number column and selecting New hierarchy. A hierarchy is required to implement the drill-down functionality. This creates a new hierarchy with the Parent Account Number as the top level in the hierarchy. You can add further columns to the hierarchy.
Then, you should click on the Account Number column and select Add to hierarchy. This adds the Account Number column as the second level in the hierarchy.
Then, you should replace the Account Number with the new hierarchy in the visualization. You need to add the hierarchy to the visualization before you can enable drill down.
Finally, you should enable drill down on the visualization. Enable drill-down allows the users to drill down on the visualization.
Unattempted
First, you should create a hierarchy by clicking on the Parent Account Number column and selecting New hierarchy. A hierarchy is required to implement the drill-down functionality. This creates a new hierarchy with the Parent Account Number as the top level in the hierarchy. You can add further columns to the hierarchy.
Then, you should click on the Account Number column and select Add to hierarchy. This adds the Account Number column as the second level in the hierarchy.
Then, you should replace the Account Number with the new hierarchy in the visualization. You need to add the hierarchy to the visualization before you can enable drill down.
Finally, you should enable drill down on the visualization. Enable drill-down allows the users to drill down on the visualization.
Question 3 of 50
3. Question
You work for a retail organization that uses Power Bl. The schema for the tables is shown in the below exhibits.
The Customer table contains the names and IDs of the customers. The Product table contains the ids and names of the products. When a customer purchases from the retail establishment, a record in the Basket table is created to link the Customer to that purchase. The Products added to their Basket are stored in the Basket Items table.
You need to find the number of customers who purchased the same set of products. You add a slicer for Product Name to your report to choose the set of products.
How should you create the measure to count the number of customers who purchased the products selected? To answer, select the appropriate option.
Correct
You should use the following DAX functions:
ProductsSelected = DISTINCTCOUNT(‘Product'[ProductID])
PurchasedSelected = IF(DISTINCTCOUNT(‘Basket Items'[ProductID]) [ProductsSelected], 1, 0)
CustomerCount = SUMX(VALUES(Customer[CustomerID]), [PurchasedSelected])
You should use the DISTINCTCOUNT function to count the number of ProductsSelected and PurchasedSelected. You need to find the number of products on the slicer and the number of baskets with the same number of products purchased.
You should use the IF function to create a true or false value if the number of items in the basket matches the number of products selected. This measure is not very useful on its own but will be used in the CustomerCount measure.
You should use the SUMX function to determine for each row in the Customer table if the measure in the second argument is true. The X function evaluates each row in turn. CustomerCount is the number of customers who bought all of the products selected on the slicer.
Incorrect
You should use the following DAX functions:
ProductsSelected = DISTINCTCOUNT(‘Product'[ProductID])
PurchasedSelected = IF(DISTINCTCOUNT(‘Basket Items'[ProductID]) [ProductsSelected], 1, 0)
CustomerCount = SUMX(VALUES(Customer[CustomerID]), [PurchasedSelected])
You should use the DISTINCTCOUNT function to count the number of ProductsSelected and PurchasedSelected. You need to find the number of products on the slicer and the number of baskets with the same number of products purchased.
You should use the IF function to create a true or false value if the number of items in the basket matches the number of products selected. This measure is not very useful on its own but will be used in the CustomerCount measure.
You should use the SUMX function to determine for each row in the Customer table if the measure in the second argument is true. The X function evaluates each row in turn. CustomerCount is the number of customers who bought all of the products selected on the slicer.
Unattempted
You should use the following DAX functions:
ProductsSelected = DISTINCTCOUNT(‘Product'[ProductID])
PurchasedSelected = IF(DISTINCTCOUNT(‘Basket Items'[ProductID]) [ProductsSelected], 1, 0)
CustomerCount = SUMX(VALUES(Customer[CustomerID]), [PurchasedSelected])
You should use the DISTINCTCOUNT function to count the number of ProductsSelected and PurchasedSelected. You need to find the number of products on the slicer and the number of baskets with the same number of products purchased.
You should use the IF function to create a true or false value if the number of items in the basket matches the number of products selected. This measure is not very useful on its own but will be used in the CustomerCount measure.
You should use the SUMX function to determine for each row in the Customer table if the measure in the second argument is true. The X function evaluates each row in turn. CustomerCount is the number of customers who bought all of the products selected on the slicer.
Question 4 of 50
4. Question
You import a table into Power BI. The schema is shown in the below exhibit.
You need to configure the columns in the table.
Which Summarize option should you recommend for aggregating the columns for use in visualizations?
Correct
You should use the Sum aggregation for the Amount field. Amount is a decimal number, and analysis of total sales will be required for visualizations. Adding aggregations will reduce the size of the model and improve performance.
You should use the Count aggregation for the Order Number field. Order Number is an integer and is the unique reference for the Sales table. The type of visualizations that will be required for Order Number is the number of orders placed, so a count is the best aggregation option.
You should not use aggregation for the DateKey field. DateKey is a Date/time field. There are no useful aggregations for dates. You should not perform aggregations unless necessary because aggregations cause loss of detail.
You should not use Average as an aggregation for the Sales table. If you use Average, you will not be able to calculate the sum of sales.
Incorrect
You should use the Sum aggregation for the Amount field. Amount is a decimal number, and analysis of total sales will be required for visualizations. Adding aggregations will reduce the size of the model and improve performance.
You should use the Count aggregation for the Order Number field. Order Number is an integer and is the unique reference for the Sales table. The type of visualizations that will be required for Order Number is the number of orders placed, so a count is the best aggregation option.
You should not use aggregation for the DateKey field. DateKey is a Date/time field. There are no useful aggregations for dates. You should not perform aggregations unless necessary because aggregations cause loss of detail.
You should not use Average as an aggregation for the Sales table. If you use Average, you will not be able to calculate the sum of sales.
Unattempted
You should use the Sum aggregation for the Amount field. Amount is a decimal number, and analysis of total sales will be required for visualizations. Adding aggregations will reduce the size of the model and improve performance.
You should use the Count aggregation for the Order Number field. Order Number is an integer and is the unique reference for the Sales table. The type of visualizations that will be required for Order Number is the number of orders placed, so a count is the best aggregation option.
You should not use aggregation for the DateKey field. DateKey is a Date/time field. There are no useful aggregations for dates. You should not perform aggregations unless necessary because aggregations cause loss of detail.
You should not use Average as an aggregation for the Sales table. If you use Average, you will not be able to calculate the sum of sales.
Question 5 of 50
5. Question
You create a data model and report in Power Bl desktop. The data model contains multiple tables, many relationships, and a set of measures.
Users report poor performance when using your report.
How can you identify the source of the performance issues?
Correct
You should use the Performance analyzer in Power Bl Desktop to identify the source of the performance issues. Performance analyzer examines all aspects of your data model and report including DAX queries and visuals. Performance analyzer allows you to sort by the longest running queries, so you can identify performance bottlenecks and target these for further analysis.
You should not use the DAX Studio tool. DAX Studio allows you to analyze DAX queries for performance. DAX Studio does not identify the DAX queries in a model that are performing badly. You must first use the Performance analyzer to identify the poorly performing DAX queries.
You should not use the Tabular Editor. Tabular Editor is used to build and manage models. It does not have any performance analysis features.
You should not use the ALM Toolkit. The ALM Toolkit compares Power Bl datasets and manages the differential deployment of datasets to production environments.
Incorrect
You should use the Performance analyzer in Power Bl Desktop to identify the source of the performance issues. Performance analyzer examines all aspects of your data model and report including DAX queries and visuals. Performance analyzer allows you to sort by the longest running queries, so you can identify performance bottlenecks and target these for further analysis.
You should not use the DAX Studio tool. DAX Studio allows you to analyze DAX queries for performance. DAX Studio does not identify the DAX queries in a model that are performing badly. You must first use the Performance analyzer to identify the poorly performing DAX queries.
You should not use the Tabular Editor. Tabular Editor is used to build and manage models. It does not have any performance analysis features.
You should not use the ALM Toolkit. The ALM Toolkit compares Power Bl datasets and manages the differential deployment of datasets to production environments.
Unattempted
You should use the Performance analyzer in Power Bl Desktop to identify the source of the performance issues. Performance analyzer examines all aspects of your data model and report including DAX queries and visuals. Performance analyzer allows you to sort by the longest running queries, so you can identify performance bottlenecks and target these for further analysis.
You should not use the DAX Studio tool. DAX Studio allows you to analyze DAX queries for performance. DAX Studio does not identify the DAX queries in a model that are performing badly. You must first use the Performance analyzer to identify the poorly performing DAX queries.
You should not use the Tabular Editor. Tabular Editor is used to build and manage models. It does not have any performance analysis features.
You should not use the ALM Toolkit. The ALM Toolkit compares Power Bl datasets and manages the differential deployment of datasets to production environments.
Question 6 of 50
6. Question
You create reports using the data model shown in the below exhibit.
You have the following measure that is performing poorly The measure calculates the change in sales each year.
SalesChangeYoY = IF(SUM(Sales[Amount]), DIVIDE([SumofSales] – CALCULATE([SumofSales], SAMEPERIODLASTYEAR(Sales[Date])), CALCULATE([SumofSales], SAMEPERIODLASTYEAR(Sales[Date]))))
You need to improve the performance of the measure. What should you do?
Correct
You should rewrite the measures using DAX variables. The measure is recalculating the same period last year twice and the sum of sales twice. Variables make measures more efficient because they remove the need to evaluate the same expression twice, reducing processing time. You can create the measure as follows.
SalesChangeYoY =
VAR SumofSales = SUM(Sales[Amount])
VAR SalesLastYear = CALCULATE ([SumofSales], SAMEPERIODLASTYEAR (Sales[Date]) )
RETURN IF(SumofSales, DIVIDE(([SumofSales] – SalesLastYear), SalesLastYear))
If you rewrite the measure with variables, you also reduce its complexity and make the DAX functions more readable.
You should not change the cardinality of both the relationships to many-to-many. The cardinality will not affect these measures or their performance. Changing the relationship to many-to-many is required when the rows in both tables are not unique and you need to filter on values in the tables.
You should not create a calculated column containing the sales amount for the previous year. Calculated columns are calculated for every row in the table. This will take more space in the dataset and longer to process when refreshing the dataset.
You should not change the cross filter directions on both relationships to Both. Bi-directional relationships require more processing and can negatively impact on performance.
Incorrect
You should rewrite the measures using DAX variables. The measure is recalculating the same period last year twice and the sum of sales twice. Variables make measures more efficient because they remove the need to evaluate the same expression twice, reducing processing time. You can create the measure as follows.
SalesChangeYoY =
VAR SumofSales = SUM(Sales[Amount])
VAR SalesLastYear = CALCULATE ([SumofSales], SAMEPERIODLASTYEAR (Sales[Date]) )
RETURN IF(SumofSales, DIVIDE(([SumofSales] – SalesLastYear), SalesLastYear))
If you rewrite the measure with variables, you also reduce its complexity and make the DAX functions more readable.
You should not change the cardinality of both the relationships to many-to-many. The cardinality will not affect these measures or their performance. Changing the relationship to many-to-many is required when the rows in both tables are not unique and you need to filter on values in the tables.
You should not create a calculated column containing the sales amount for the previous year. Calculated columns are calculated for every row in the table. This will take more space in the dataset and longer to process when refreshing the dataset.
You should not change the cross filter directions on both relationships to Both. Bi-directional relationships require more processing and can negatively impact on performance.
Unattempted
You should rewrite the measures using DAX variables. The measure is recalculating the same period last year twice and the sum of sales twice. Variables make measures more efficient because they remove the need to evaluate the same expression twice, reducing processing time. You can create the measure as follows.
SalesChangeYoY =
VAR SumofSales = SUM(Sales[Amount])
VAR SalesLastYear = CALCULATE ([SumofSales], SAMEPERIODLASTYEAR (Sales[Date]) )
RETURN IF(SumofSales, DIVIDE(([SumofSales] – SalesLastYear), SalesLastYear))
If you rewrite the measure with variables, you also reduce its complexity and make the DAX functions more readable.
You should not change the cardinality of both the relationships to many-to-many. The cardinality will not affect these measures or their performance. Changing the relationship to many-to-many is required when the rows in both tables are not unique and you need to filter on values in the tables.
You should not create a calculated column containing the sales amount for the previous year. Calculated columns are calculated for every row in the table. This will take more space in the dataset and longer to process when refreshing the dataset.
You should not change the cross filter directions on both relationships to Both. Bi-directional relationships require more processing and can negatively impact on performance.
Question 7 of 50
7. Question
You have a table named Sales. You need to create a measure that calculates sales from the previous year based on a dynamic period, as shown in the below exhibit.
Which two DAX expressions can you use to achieve your goal? Each correct answer presents a complete solution.
Correct
To create a measure that calculates the previous year’s sales, you should use one of the following DAX expressions:
_PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar'[Date].[Date], -1, YEAR))
_PY Sales = CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR(‘Calendar'[Date]))
In the first DAX expression, are using the DATEADD() function to calculate last year’s date based on a dynamic period. If the current filter context is July 2020, it will return July 2019. It can work with day, month, quarter, and year intervals. The CALCULATE() function has two parts. The first part aggregates the sales column, and the second part applies the filter context to the expression.
In the second DAX expression, are using the SAMEPERIODLASTYEAR() function to calculate last year’s date based on a dynamic period. This function is very similar to the DATEADD() function The only limitation is that it can go back one year, while with the DATEADD() function you can go back or forward by providing a number of interval arguments. The CALCULATE() function is very similar. The difference is the second part, where you are using the SAMEPERIODLASTYEAR() function to provide the filter context to the expression.
You should not use the following expression:
_PY Sales = CALCULATE(SUM(Sales[Sales]), PARALLELPERIOD(‘Calendar'[Date], -1, YEAR))
The PARALLELPERIOD() function cannot work with a dynamic period. If you compare sales from July 2020, it will return all of 2019 because it uses a static period.
You should not use the following expression:
_PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar'[Date].[Date], -1, MONTH))
This expression calculates sales for the previous month. The DATEADD(‘Calendar'[Date].[Date], -1, MONTH)) part calculates dates for the past month.
Incorrect
To create a measure that calculates the previous year’s sales, you should use one of the following DAX expressions:
_PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar'[Date].[Date], -1, YEAR))
_PY Sales = CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR(‘Calendar'[Date]))
In the first DAX expression, are using the DATEADD() function to calculate last year’s date based on a dynamic period. If the current filter context is July 2020, it will return July 2019. It can work with day, month, quarter, and year intervals. The CALCULATE() function has two parts. The first part aggregates the sales column, and the second part applies the filter context to the expression.
In the second DAX expression, are using the SAMEPERIODLASTYEAR() function to calculate last year’s date based on a dynamic period. This function is very similar to the DATEADD() function The only limitation is that it can go back one year, while with the DATEADD() function you can go back or forward by providing a number of interval arguments. The CALCULATE() function is very similar. The difference is the second part, where you are using the SAMEPERIODLASTYEAR() function to provide the filter context to the expression.
You should not use the following expression:
_PY Sales = CALCULATE(SUM(Sales[Sales]), PARALLELPERIOD(‘Calendar'[Date], -1, YEAR))
The PARALLELPERIOD() function cannot work with a dynamic period. If you compare sales from July 2020, it will return all of 2019 because it uses a static period.
You should not use the following expression:
_PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar'[Date].[Date], -1, MONTH))
This expression calculates sales for the previous month. The DATEADD(‘Calendar'[Date].[Date], -1, MONTH)) part calculates dates for the past month.
Unattempted
To create a measure that calculates the previous year’s sales, you should use one of the following DAX expressions:
_PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar'[Date].[Date], -1, YEAR))
_PY Sales = CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR(‘Calendar'[Date]))
In the first DAX expression, are using the DATEADD() function to calculate last year’s date based on a dynamic period. If the current filter context is July 2020, it will return July 2019. It can work with day, month, quarter, and year intervals. The CALCULATE() function has two parts. The first part aggregates the sales column, and the second part applies the filter context to the expression.
In the second DAX expression, are using the SAMEPERIODLASTYEAR() function to calculate last year’s date based on a dynamic period. This function is very similar to the DATEADD() function The only limitation is that it can go back one year, while with the DATEADD() function you can go back or forward by providing a number of interval arguments. The CALCULATE() function is very similar. The difference is the second part, where you are using the SAMEPERIODLASTYEAR() function to provide the filter context to the expression.
You should not use the following expression:
_PY Sales = CALCULATE(SUM(Sales[Sales]), PARALLELPERIOD(‘Calendar'[Date], -1, YEAR))
The PARALLELPERIOD() function cannot work with a dynamic period. If you compare sales from July 2020, it will return all of 2019 because it uses a static period.
You should not use the following expression:
_PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar'[Date].[Date], -1, MONTH))
This expression calculates sales for the previous month. The DATEADD(‘Calendar'[Date].[Date], -1, MONTH)) part calculates dates for the past month.
Question 8 of 50
8. Question
You have a Product table and a Sales table that are connected through a one-to-many relationship using the ProductName column, as shown in the exhibit.
You need to optimize model performance. Which two actions should you perform? Each correct answer presents part of the solution.
Correct
You should remove the existing relationship based on the ProductName column between the Product and Sales tables. The ProductName column has a data type assigned as text in both tables, and this causes model slowness.
You should also create a new one-to-many relationship between the Product and Sales tables using the ProductlD column. The ProductlD column has a data type assigned as whole number in both tables, and integer keys perform better than text keys when two tables are joined.
You should not create a one-to-many relationship between the Sales and Product tables using the ProductlD column. The direction of the relationship is also important, and since the Product table has unique Product values, it should be used for filter propagation, not the Sales table.
You should not change the data type of the ProductName column from text to whole number in the Product table. This will cause other problems in your reports, and some of the visuals might not render properly Since ProductName has a data type assigned as text, it might not be possible for Power Query to transform all text values to whole numbers.
Incorrect
You should remove the existing relationship based on the ProductName column between the Product and Sales tables. The ProductName column has a data type assigned as text in both tables, and this causes model slowness.
You should also create a new one-to-many relationship between the Product and Sales tables using the ProductlD column. The ProductlD column has a data type assigned as whole number in both tables, and integer keys perform better than text keys when two tables are joined.
You should not create a one-to-many relationship between the Sales and Product tables using the ProductlD column. The direction of the relationship is also important, and since the Product table has unique Product values, it should be used for filter propagation, not the Sales table.
You should not change the data type of the ProductName column from text to whole number in the Product table. This will cause other problems in your reports, and some of the visuals might not render properly Since ProductName has a data type assigned as text, it might not be possible for Power Query to transform all text values to whole numbers.
Unattempted
You should remove the existing relationship based on the ProductName column between the Product and Sales tables. The ProductName column has a data type assigned as text in both tables, and this causes model slowness.
You should also create a new one-to-many relationship between the Product and Sales tables using the ProductlD column. The ProductlD column has a data type assigned as whole number in both tables, and integer keys perform better than text keys when two tables are joined.
You should not create a one-to-many relationship between the Sales and Product tables using the ProductlD column. The direction of the relationship is also important, and since the Product table has unique Product values, it should be used for filter propagation, not the Sales table.
You should not change the data type of the ProductName column from text to whole number in the Product table. This will cause other problems in your reports, and some of the visuals might not render properly Since ProductName has a data type assigned as text, it might not be possible for Power Query to transform all text values to whole numbers.
Question 9 of 50
9. Question
You load sales data into Power BI. Your organization uses many different terms for sales data such as revenue, net sales, and total sales.
You need to configure the Sales table and its columns for users to successfully use the Q&A feature in Dashboards.
Solution: Mark the Sales table as the date table. Does this solution meet the goal?
Correct
No, marking the Sales table as the date table is not the ideal solution for this specific goal.
Here’s why:
Q&A and Date Tables: The Q&A feature in Power BI is primarily designed for analyzing data over time. Marking the Sales table as a date table would likely confuse Q&A and lead to inaccurate results.
Focus on Synonyms: The challenge lies in handling the different terms used for sales data (“revenue,” “net sales,” “total sales”). Marking the Sales table as a date table doesn’t address this issue.
Possible Solutions:
Create Synonyms: Use Power BI’s “Manage Synonyms” feature to create synonyms for the different sales terms. This allows users to ask questions using any of the terms and still get results based on the “Sales” column.
Data Model Relationships and Descriptive Names: Ensure a clear relationship between the Sales table and other relevant tables in your data model. Use descriptive names for the columns containing sales data (e.g., “Total Sales Amount”).
By focusing on synonyms and clear data modeling, you can improve the usability of your Power BI report and ensure Q&A understands the different terms for your sales data.
Incorrect
No, marking the Sales table as the date table is not the ideal solution for this specific goal.
Here’s why:
Q&A and Date Tables: The Q&A feature in Power BI is primarily designed for analyzing data over time. Marking the Sales table as a date table would likely confuse Q&A and lead to inaccurate results.
Focus on Synonyms: The challenge lies in handling the different terms used for sales data (“revenue,” “net sales,” “total sales”). Marking the Sales table as a date table doesn’t address this issue.
Possible Solutions:
Create Synonyms: Use Power BI’s “Manage Synonyms” feature to create synonyms for the different sales terms. This allows users to ask questions using any of the terms and still get results based on the “Sales” column.
Data Model Relationships and Descriptive Names: Ensure a clear relationship between the Sales table and other relevant tables in your data model. Use descriptive names for the columns containing sales data (e.g., “Total Sales Amount”).
By focusing on synonyms and clear data modeling, you can improve the usability of your Power BI report and ensure Q&A understands the different terms for your sales data.
Unattempted
No, marking the Sales table as the date table is not the ideal solution for this specific goal.
Here’s why:
Q&A and Date Tables: The Q&A feature in Power BI is primarily designed for analyzing data over time. Marking the Sales table as a date table would likely confuse Q&A and lead to inaccurate results.
Focus on Synonyms: The challenge lies in handling the different terms used for sales data (“revenue,” “net sales,” “total sales”). Marking the Sales table as a date table doesn’t address this issue.
Possible Solutions:
Create Synonyms: Use Power BI’s “Manage Synonyms” feature to create synonyms for the different sales terms. This allows users to ask questions using any of the terms and still get results based on the “Sales” column.
Data Model Relationships and Descriptive Names: Ensure a clear relationship between the Sales table and other relevant tables in your data model. Use descriptive names for the columns containing sales data (e.g., “Total Sales Amount”).
By focusing on synonyms and clear data modeling, you can improve the usability of your Power BI report and ensure Q&A understands the different terms for your sales data.
Question 10 of 50
10. Question
You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.
Which visualizations should you use for each requirement stated below:
Identify outliers in customers with sales opportunities.
Correct
The Scatter visual displays patterns in data and helps the user identify outlier values. You can use the Scatter visual to show information about the customer and their sales opportunities to identify outliers in the sales process.
Incorrect
The Scatter visual displays patterns in data and helps the user identify outlier values. You can use the Scatter visual to show information about the customer and their sales opportunities to identify outliers in the sales process.
Unattempted
The Scatter visual displays patterns in data and helps the user identify outlier values. You can use the Scatter visual to show information about the customer and their sales opportunities to identify outliers in the sales process.
Question 11 of 50
11. Question
Which of the following visuals is not included as part of Power Bl and must be added as a custom visual?
Correct
Histogram is not added to Power Bl tools by default, it needs to be added as custom visual.
Incorrect
Histogram is not added to Power Bl tools by default, it needs to be added as custom visual.
Unattempted
Histogram is not added to Power Bl tools by default, it needs to be added as custom visual.
Question 12 of 50
12. Question
You create multiple Power Bl dashboards. You define the data classifications and tags.
You need to show users how the data in the dashboards is classified.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Data classifications are defined at the tenant level.
2. Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups.
3. The data classification for a dashboard is always displayed.
Correct
Here’s the breakdown of the statements:
Data classifications are defined at the tenant level.
Yes – Data classifications in Power BI are defined at the tenant level, meaning they apply across all workspaces and datasets within that tenant.
Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups.
No – While Azure AD can be used for authentication and authorization in Power BI, data classification itself is a separate mechanism. Access control to dashboards is primarily managed through workspace permissions and row-level security within Power BI.
The data classification for a dashboard is always displayed.
No – The display of data classification within a dashboard is configurable. You can choose whether to display the classification to users or not.
In summary:
Data classifications are tenant-level settings.
Access control to dashboards is not directly tied to data classification through Azure AD security groups.
The display of data classification within a dashboard is optional.
Incorrect
Here’s the breakdown of the statements:
Data classifications are defined at the tenant level.
Yes – Data classifications in Power BI are defined at the tenant level, meaning they apply across all workspaces and datasets within that tenant.
Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups.
No – While Azure AD can be used for authentication and authorization in Power BI, data classification itself is a separate mechanism. Access control to dashboards is primarily managed through workspace permissions and row-level security within Power BI.
The data classification for a dashboard is always displayed.
No – The display of data classification within a dashboard is configurable. You can choose whether to display the classification to users or not.
In summary:
Data classifications are tenant-level settings.
Access control to dashboards is not directly tied to data classification through Azure AD security groups.
The display of data classification within a dashboard is optional.
Unattempted
Here’s the breakdown of the statements:
Data classifications are defined at the tenant level.
Yes – Data classifications in Power BI are defined at the tenant level, meaning they apply across all workspaces and datasets within that tenant.
Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups.
No – While Azure AD can be used for authentication and authorization in Power BI, data classification itself is a separate mechanism. Access control to dashboards is primarily managed through workspace permissions and row-level security within Power BI.
The data classification for a dashboard is always displayed.
No – The display of data classification within a dashboard is configurable. You can choose whether to display the classification to users or not.
In summary:
Data classifications are tenant-level settings.
Access control to dashboards is not directly tied to data classification through Azure AD security groups.
The display of data classification within a dashboard is optional.
Question 13 of 50
13. Question
You create the stacked column chart shown in the below exhibit.
When you hover over a data point in the visual you need to also show the value of goods sold, Total sales.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
Correct
You can add Total sales to Tooltips for the visual. The default tooltip for a visual display is the data point’s value and category. In the exhibit, this will be the Product, Segment, and Units Sold. You can add custom further data points as tooltips to the visual. After you add Total Sales to Tooltips, hovering over the visual will show Product, Segment, Units Sold, and Total sales.
You can also create a report tooltip page containing a visualization for Total sales that replaces the default tooltip. After creating a report tooltip page containing Total sales, hovering over the stacked column chart displays the report tooltip and the Total sales value.
You should not add Total sales to Drill through on the visual. The drill-through feature is used to create a report that focuses on a specific entity, such as Product or Segment.
You should not enable Data labels on the visual. This option shows the number of Units Sold for each Segment of the stacked column. It does not show the Total sales. You should not enable Total labels on the visual. This option shows the total number of Units Sold above each column. It does not show the Total sales.
Incorrect
You can add Total sales to Tooltips for the visual. The default tooltip for a visual display is the data point’s value and category. In the exhibit, this will be the Product, Segment, and Units Sold. You can add custom further data points as tooltips to the visual. After you add Total Sales to Tooltips, hovering over the visual will show Product, Segment, Units Sold, and Total sales.
You can also create a report tooltip page containing a visualization for Total sales that replaces the default tooltip. After creating a report tooltip page containing Total sales, hovering over the stacked column chart displays the report tooltip and the Total sales value.
You should not add Total sales to Drill through on the visual. The drill-through feature is used to create a report that focuses on a specific entity, such as Product or Segment.
You should not enable Data labels on the visual. This option shows the number of Units Sold for each Segment of the stacked column. It does not show the Total sales. You should not enable Total labels on the visual. This option shows the total number of Units Sold above each column. It does not show the Total sales.
Unattempted
You can add Total sales to Tooltips for the visual. The default tooltip for a visual display is the data point’s value and category. In the exhibit, this will be the Product, Segment, and Units Sold. You can add custom further data points as tooltips to the visual. After you add Total Sales to Tooltips, hovering over the visual will show Product, Segment, Units Sold, and Total sales.
You can also create a report tooltip page containing a visualization for Total sales that replaces the default tooltip. After creating a report tooltip page containing Total sales, hovering over the stacked column chart displays the report tooltip and the Total sales value.
You should not add Total sales to Drill through on the visual. The drill-through feature is used to create a report that focuses on a specific entity, such as Product or Segment.
You should not enable Data labels on the visual. This option shows the number of Units Sold for each Segment of the stacked column. It does not show the Total sales. You should not enable Total labels on the visual. This option shows the total number of Units Sold above each column. It does not show the Total sales.
Question 14 of 50
14. Question
After you have pinned a report visual to create a dashboard tile, you can later modify the visual’s properties and the Power Bl service will automatically update the dashboard tile with the new visual property values.
Correct
lf you update a visualization that is used to create the tile, the tile doesn’t change. If you pinned a line chart from a report and then you convert the line chart to a bar chart, the dashboard tile continues to show a line chart. The data refreshes, but the visualization type does not.
Incorrect
lf you update a visualization that is used to create the tile, the tile doesn’t change. If you pinned a line chart from a report and then you convert the line chart to a bar chart, the dashboard tile continues to show a line chart. The data refreshes, but the visualization type does not.
Unattempted
lf you update a visualization that is used to create the tile, the tile doesn’t change. If you pinned a line chart from a report and then you convert the line chart to a bar chart, the dashboard tile continues to show a line chart. The data refreshes, but the visualization type does not.
Question 15 of 50
15. Question
You have two dashboards in the same workspace named Production and Manufacturing. Your company Power Bl administrator creates the following two dashboard data classifications:
• Medium Impact (MEDI) as default.
• High Impact (HIGH).
You need to use the newly created classifications in the dashboards. The Production dashboard should be classified as Medium Impact. The Manufacturing dashboard should be classified as High Impact.
Which two actions should you perform? Each correct answer presents part of the solution.
Correct
You can configure the dashboard data classification as follows:
Go to Manufacturing dashboard > settings and set Data classification as High Impact. You can also set the data classification from the main settings gear icon at the top. There, you select Settings, then choose Dashboard and set Data classification.
For the Production dashboard, you do not need to configure anything specific. This dashboard will use the default classification, Medium Impact. When the Power Bl administrator creates the dashboard data classification, the default classification is assigned to all dashboards that do not have any classification previously configured.
Incorrect
You can configure the dashboard data classification as follows:
Go to Manufacturing dashboard > settings and set Data classification as High Impact. You can also set the data classification from the main settings gear icon at the top. There, you select Settings, then choose Dashboard and set Data classification.
For the Production dashboard, you do not need to configure anything specific. This dashboard will use the default classification, Medium Impact. When the Power Bl administrator creates the dashboard data classification, the default classification is assigned to all dashboards that do not have any classification previously configured.
Unattempted
You can configure the dashboard data classification as follows:
Go to Manufacturing dashboard > settings and set Data classification as High Impact. You can also set the data classification from the main settings gear icon at the top. There, you select Settings, then choose Dashboard and set Data classification.
For the Production dashboard, you do not need to configure anything specific. This dashboard will use the default classification, Medium Impact. When the Power Bl administrator creates the dashboard data classification, the default classification is assigned to all dashboards that do not have any classification previously configured.
Question 16 of 50
16. Question
To create a column chart that displays Quantity by Color and can be drilled down to show Quantity by Stock Item.
Which of the following solves the problem? More than one answer can be correct.
Correct
Putting in Tooltips or legend will not allow showing stock item names and drill-down options, respectively.
Incorrect
Putting in Tooltips or legend will not allow showing stock item names and drill-down options, respectively.
Unattempted
Putting in Tooltips or legend will not allow showing stock item names and drill-down options, respectively.
Question 17 of 50
17. Question
You have Power Bl Premium with assigned capacity. You have a dataset containing employee key performance indicators (KPls).
You create a Power Bl report with a visual that shows employees with low scoring KPls. You pin the visual to a dashboard and share the dashboard with users in Human Resources (HR).
HR users need to be able to generate a list of employees to investigate for poor performance and import that list into their HR system.
What should you do?
Correct
You should grant HR users the Build permission on the dataset. You can export data from a visual in a dashboard to a CSV file. If you have filtered the visualization, then the .csv export will also be filtered. Users require the Build permission to export the underlying data of the visual to work with it outside Power Bl. If a user has Read permission on a workspace and dataset, they can export the data. Build permission allows you to control whether users can download data from visuals without having to give access to the workspace.
You should not apply a sensitivity label in the dashboard settings. Sensitivity labels do not affect access to content within Power Bl. Sensitivity labels are not applied to data exported to CSV, but only to Excel, PowerPoint, and PDF files.
You should not grant HR users the Reshare permission on the dataset. Reshare allows users to share a dashboard or a report. Reshare does not allow you to export data from Power Bl.
You should not configure Cloud App Security. Cloud App Security allows you to monitor Power Bl for user access and activity. Cloud App Security will prevent data from being exported to devices that do not meet your Azure Active Directory conditional access policies. Cloud App Security will not enable or disable HR users from downloading data from a Power Bl visual.
Incorrect
You should grant HR users the Build permission on the dataset. You can export data from a visual in a dashboard to a CSV file. If you have filtered the visualization, then the .csv export will also be filtered. Users require the Build permission to export the underlying data of the visual to work with it outside Power Bl. If a user has Read permission on a workspace and dataset, they can export the data. Build permission allows you to control whether users can download data from visuals without having to give access to the workspace.
You should not apply a sensitivity label in the dashboard settings. Sensitivity labels do not affect access to content within Power Bl. Sensitivity labels are not applied to data exported to CSV, but only to Excel, PowerPoint, and PDF files.
You should not grant HR users the Reshare permission on the dataset. Reshare allows users to share a dashboard or a report. Reshare does not allow you to export data from Power Bl.
You should not configure Cloud App Security. Cloud App Security allows you to monitor Power Bl for user access and activity. Cloud App Security will prevent data from being exported to devices that do not meet your Azure Active Directory conditional access policies. Cloud App Security will not enable or disable HR users from downloading data from a Power Bl visual.
Unattempted
You should grant HR users the Build permission on the dataset. You can export data from a visual in a dashboard to a CSV file. If you have filtered the visualization, then the .csv export will also be filtered. Users require the Build permission to export the underlying data of the visual to work with it outside Power Bl. If a user has Read permission on a workspace and dataset, they can export the data. Build permission allows you to control whether users can download data from visuals without having to give access to the workspace.
You should not apply a sensitivity label in the dashboard settings. Sensitivity labels do not affect access to content within Power Bl. Sensitivity labels are not applied to data exported to CSV, but only to Excel, PowerPoint, and PDF files.
You should not grant HR users the Reshare permission on the dataset. Reshare allows users to share a dashboard or a report. Reshare does not allow you to export data from Power Bl.
You should not configure Cloud App Security. Cloud App Security allows you to monitor Power Bl for user access and activity. Cloud App Security will prevent data from being exported to devices that do not meet your Azure Active Directory conditional access policies. Cloud App Security will not enable or disable HR users from downloading data from a Power Bl visual.
Question 18 of 50
18. Question
What happens when you click on Focus mode of a tile in Power Bl dashboard?
Correct
When you click on Focus mode of a tile in a Power BI dashboard, the most likely scenario is:
A. The tile you selected expands and takes the full space.
Here’s why:
Focus mode: This feature is designed to allow users to focus on a specific tile in a dashboard and view its details in a larger format. Clicking on the Focus mode icon (usually a square expanding to a larger square) triggers this behavior.
Zooming in: The selected tile expands to fill the available space on the screen, making the data and visuals within the tile easier to see and interact with. Other tiles and elements on the dashboard are temporarily hidden.
Data accessibility: This allows users to explore the tile in more detail without having to switch to a different view or report. They can analyze the data points, hover over elements for additional information, and potentially interact with the visuals using available features (drilling down, filtering, etc.).
While other options might apply in certain situations:
B. Power BI desktop file opens: Clicking on a tile wouldn’t typically open the Power BI desktop file itself.
C. Power BI desktop file gets downloaded: Downloading the Power BI file also wouldn’t happen automatically by clicking on Focus mode.
D. Report from which the tile was pinned opens: Clicking on Focus mode wouldn’t necessarily open the full report from which the tile was pinned. It focuses solely on the selected tile and its data within the dashboard context.
Therefore, focus mode primarily serves the purpose of zooming in on a specific tile for detailed exploration within the existing dashboard view.
Incorrect
When you click on Focus mode of a tile in a Power BI dashboard, the most likely scenario is:
A. The tile you selected expands and takes the full space.
Here’s why:
Focus mode: This feature is designed to allow users to focus on a specific tile in a dashboard and view its details in a larger format. Clicking on the Focus mode icon (usually a square expanding to a larger square) triggers this behavior.
Zooming in: The selected tile expands to fill the available space on the screen, making the data and visuals within the tile easier to see and interact with. Other tiles and elements on the dashboard are temporarily hidden.
Data accessibility: This allows users to explore the tile in more detail without having to switch to a different view or report. They can analyze the data points, hover over elements for additional information, and potentially interact with the visuals using available features (drilling down, filtering, etc.).
While other options might apply in certain situations:
B. Power BI desktop file opens: Clicking on a tile wouldn’t typically open the Power BI desktop file itself.
C. Power BI desktop file gets downloaded: Downloading the Power BI file also wouldn’t happen automatically by clicking on Focus mode.
D. Report from which the tile was pinned opens: Clicking on Focus mode wouldn’t necessarily open the full report from which the tile was pinned. It focuses solely on the selected tile and its data within the dashboard context.
Therefore, focus mode primarily serves the purpose of zooming in on a specific tile for detailed exploration within the existing dashboard view.
Unattempted
When you click on Focus mode of a tile in a Power BI dashboard, the most likely scenario is:
A. The tile you selected expands and takes the full space.
Here’s why:
Focus mode: This feature is designed to allow users to focus on a specific tile in a dashboard and view its details in a larger format. Clicking on the Focus mode icon (usually a square expanding to a larger square) triggers this behavior.
Zooming in: The selected tile expands to fill the available space on the screen, making the data and visuals within the tile easier to see and interact with. Other tiles and elements on the dashboard are temporarily hidden.
Data accessibility: This allows users to explore the tile in more detail without having to switch to a different view or report. They can analyze the data points, hover over elements for additional information, and potentially interact with the visuals using available features (drilling down, filtering, etc.).
While other options might apply in certain situations:
B. Power BI desktop file opens: Clicking on a tile wouldn’t typically open the Power BI desktop file itself.
C. Power BI desktop file gets downloaded: Downloading the Power BI file also wouldn’t happen automatically by clicking on Focus mode.
D. Report from which the tile was pinned opens: Clicking on Focus mode wouldn’t necessarily open the full report from which the tile was pinned. It focuses solely on the selected tile and its data within the dashboard context.
Therefore, focus mode primarily serves the purpose of zooming in on a specific tile for detailed exploration within the existing dashboard view.
Question 19 of 50
19. Question
You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.
Which visualizations should you use for each requirement stated below:
Show the factors that affect the outcome of sales opportunities.
Correct
The Key influencers visual is used to show the factors that affect the metric being analyzed. You can use the Key influencers visual to determine the factors that affect whether a sales opportunity is won or lost.
Incorrect
The Key influencers visual is used to show the factors that affect the metric being analyzed. You can use the Key influencers visual to determine the factors that affect whether a sales opportunity is won or lost.
Unattempted
The Key influencers visual is used to show the factors that affect the metric being analyzed. You can use the Key influencers visual to determine the factors that affect whether a sales opportunity is won or lost.
Question 20 of 50
20. Question
You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.
Which visualizations should you use for the below-stated requirement?
“Take actions from within a report”
Correct
You can embed a Canvas Power App in a Power Bl report using the Power Apps visual. The Power App can interact with the data in the report and with the other visuals. Users can use the Power App to perform actions from within Power Bl reports and dashboards.
Incorrect
You can embed a Canvas Power App in a Power Bl report using the Power Apps visual. The Power App can interact with the data in the report and with the other visuals. Users can use the Power App to perform actions from within Power Bl reports and dashboards.
Unattempted
You can embed a Canvas Power App in a Power Bl report using the Power Apps visual. The Power App can interact with the data in the report and with the other visuals. Users can use the Power App to perform actions from within Power Bl reports and dashboards.
Question 21 of 50
21. Question
You create a Power Bl report containing a corrplot R visual for a dataset that has 1 million rows of sales data. You publish the report to the Power Bl service. Users can only see some of the sales data and an error is displayed.
You need to identify the root cause of this issue. What is preventing all the data from be displayed?
Correct
The visual has too many rows. R visuals are limited to 150,000 rows. If there are more than 150,000 rows, only the top 150,000 rows are displayed and a message is displayed on the image. R aggregates similar data automatically, but there must still be less than 150,000 data points for the R visual to display data.
If the data is unique, it will be displayed for R visuals. R visuals group data by default, and duplicate rows are not displayed.
Corrplot is supported in powerbi.com. Corrplot is published in CRAN. The Power Bl service supports R packages published in CRAN.
R visuals are supported in Power Bl apps. R visuals are not supported with Publish to Web.
Incorrect
The visual has too many rows. R visuals are limited to 150,000 rows. If there are more than 150,000 rows, only the top 150,000 rows are displayed and a message is displayed on the image. R aggregates similar data automatically, but there must still be less than 150,000 data points for the R visual to display data.
If the data is unique, it will be displayed for R visuals. R visuals group data by default, and duplicate rows are not displayed.
Corrplot is supported in powerbi.com. Corrplot is published in CRAN. The Power Bl service supports R packages published in CRAN.
R visuals are supported in Power Bl apps. R visuals are not supported with Publish to Web.
Unattempted
The visual has too many rows. R visuals are limited to 150,000 rows. If there are more than 150,000 rows, only the top 150,000 rows are displayed and a message is displayed on the image. R aggregates similar data automatically, but there must still be less than 150,000 data points for the R visual to display data.
If the data is unique, it will be displayed for R visuals. R visuals group data by default, and duplicate rows are not displayed.
Corrplot is supported in powerbi.com. Corrplot is published in CRAN. The Power Bl service supports R packages published in CRAN.
R visuals are supported in Power Bl apps. R visuals are not supported with Publish to Web.
Question 22 of 50
22. Question
You create several Power Bl report pages.
You need to make the report pages more interactive for users.
To answer, drag the appropriate Power Bl feature for the stated requirement.
“Create a view of a report page with the filters applied”
Correct
You can use the Bookmarks feature to store a report page and its configuration so that you can return to that view later. Bookmarks keep the filters and slicers that have been applied to the visuals on the page.
Incorrect
You can use the Bookmarks feature to store a report page and its configuration so that you can return to that view later. Bookmarks keep the filters and slicers that have been applied to the visuals on the page.
Unattempted
You can use the Bookmarks feature to store a report page and its configuration so that you can return to that view later. Bookmarks keep the filters and slicers that have been applied to the visuals on the page.
Question 23 of 50
23. Question
You create Power Bl reports and dashboards.
Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.
You need to customize themes to meet these requirements.
Which theme should you use for the following requirement?
“Set the colors for data in visuals”
Correct
Colors for data in visuals can be set on both dashboard and report themes. The data Colors element is available in both dashboard and report themes.
Incorrect
Colors for data in visuals can be set on both dashboard and report themes. The data Colors element is available in both dashboard and report themes.
Unattempted
Colors for data in visuals can be set on both dashboard and report themes. The data Colors element is available in both dashboard and report themes.
Question 24 of 50
24. Question
You work for a multinational company as a data analyst.
You create a Power Bl report for your company. The report has three pages containing visualizations of sales data. You need to filter the visuals for all three report pages whenever a country is selected.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
Correct
The Sync slicers feature allows slicers on separate report pages to be synchronized so when a slicer is changed on one page, the slicer is changed on the other pages simultaneously. By adding slicers for Country on each page and configuring Sync slicers, the visuals on all pages will be filtered whenever a country is selected on any page. This is one of the two ways to filter all visuals on all pages at the same time.
Adding a report level filter for Country will filter all visuals on all pages. This is one of the two ways to filter all visuals on all pages at the same time.
Adding a page level filter for Country will only filter visuals on that page. A page level filter will not filter all visuals on all pages at the same time.
Adding a visual for Country and setting the interaction behavior for each of the other visuals will only filter visuals on the same page. A visual for Country will not filter all visuals on all pages at the same time. Bookmarks store a report page and its configuration so that you can return to that view later. Bookmarks keep the filters and slicers that have been applied to the visuals on the page. Bookmarks are for each page, not a set of pages, and therefore cannot be used to filter all visuals on all pages at the same time.
Incorrect
The Sync slicers feature allows slicers on separate report pages to be synchronized so when a slicer is changed on one page, the slicer is changed on the other pages simultaneously. By adding slicers for Country on each page and configuring Sync slicers, the visuals on all pages will be filtered whenever a country is selected on any page. This is one of the two ways to filter all visuals on all pages at the same time.
Adding a report level filter for Country will filter all visuals on all pages. This is one of the two ways to filter all visuals on all pages at the same time.
Adding a page level filter for Country will only filter visuals on that page. A page level filter will not filter all visuals on all pages at the same time.
Adding a visual for Country and setting the interaction behavior for each of the other visuals will only filter visuals on the same page. A visual for Country will not filter all visuals on all pages at the same time. Bookmarks store a report page and its configuration so that you can return to that view later. Bookmarks keep the filters and slicers that have been applied to the visuals on the page. Bookmarks are for each page, not a set of pages, and therefore cannot be used to filter all visuals on all pages at the same time.
Unattempted
The Sync slicers feature allows slicers on separate report pages to be synchronized so when a slicer is changed on one page, the slicer is changed on the other pages simultaneously. By adding slicers for Country on each page and configuring Sync slicers, the visuals on all pages will be filtered whenever a country is selected on any page. This is one of the two ways to filter all visuals on all pages at the same time.
Adding a report level filter for Country will filter all visuals on all pages. This is one of the two ways to filter all visuals on all pages at the same time.
Adding a page level filter for Country will only filter visuals on that page. A page level filter will not filter all visuals on all pages at the same time.
Adding a visual for Country and setting the interaction behavior for each of the other visuals will only filter visuals on the same page. A visual for Country will not filter all visuals on all pages at the same time. Bookmarks store a report page and its configuration so that you can return to that view later. Bookmarks keep the filters and slicers that have been applied to the visuals on the page. Bookmarks are for each page, not a set of pages, and therefore cannot be used to filter all visuals on all pages at the same time.
Question 25 of 50
25. Question
You have a matrix visual that shows Sales % and Sales by Product Line as shown in the exhibit.
The Sales % measure shows as a percentage the contribution of sales in that product line for overall sales. You need to add a background color to the Sales measure as follows:
When the Sales % contribution is >= 15 and <=17 percent, highlight it in light yellow.
What should you do to configure conditional formatting? To answer, select the appropriate options for each of the blank field.
Correct
You should configure conditional formatting for the Sales measure as follows:
Format by > Rules
Based on fields > Sales % measure
Rules: If value is greater than or equal to 0.15 Number and is less than or equal to 0.17 Number then select light yellow.
When you choose to format by rules, you can add custom rules to define a range of percentage values that you want to highlight in a specific color. You can define a range using the following operators: greater than or equal to and less than or equal to. You can also specify that you want to use these values as numbers.
You should use 0.15 and 0.17 as numbers. The Sales % measure is a percentage value. This means that the decimal number 0.17 becomes 17% when converted to a percentage value. If you use 17, it will become 1700% when converted into a percentage value. If you choose values to be used as percentages, this will not work correctly with the stated rule of Sales % contribution is 15 and 17 percent. As per current limitations, you cannot apply rule-based formatting with percentage rules.
You should not use the color scale in the Format by field. This allows you to choose formatting from a color scheme for minimum and maximum values based on the selected fields. You can use a diverging color to distinguish between the minimum and the maximum value.
You should not use the field value in the Format by field. This allows you to choose formatting from an already defined field in your model, which you can use for a color scheme.
You should not use Sales in the “Based on field” option. Here, formatting will be based on the Sales measure values rather than the Sales % values, as required in this scenario.
Incorrect
You should configure conditional formatting for the Sales measure as follows:
Format by > Rules
Based on fields > Sales % measure
Rules: If value is greater than or equal to 0.15 Number and is less than or equal to 0.17 Number then select light yellow.
When you choose to format by rules, you can add custom rules to define a range of percentage values that you want to highlight in a specific color. You can define a range using the following operators: greater than or equal to and less than or equal to. You can also specify that you want to use these values as numbers.
You should use 0.15 and 0.17 as numbers. The Sales % measure is a percentage value. This means that the decimal number 0.17 becomes 17% when converted to a percentage value. If you use 17, it will become 1700% when converted into a percentage value. If you choose values to be used as percentages, this will not work correctly with the stated rule of Sales % contribution is 15 and 17 percent. As per current limitations, you cannot apply rule-based formatting with percentage rules.
You should not use the color scale in the Format by field. This allows you to choose formatting from a color scheme for minimum and maximum values based on the selected fields. You can use a diverging color to distinguish between the minimum and the maximum value.
You should not use the field value in the Format by field. This allows you to choose formatting from an already defined field in your model, which you can use for a color scheme.
You should not use Sales in the “Based on field” option. Here, formatting will be based on the Sales measure values rather than the Sales % values, as required in this scenario.
Unattempted
You should configure conditional formatting for the Sales measure as follows:
Format by > Rules
Based on fields > Sales % measure
Rules: If value is greater than or equal to 0.15 Number and is less than or equal to 0.17 Number then select light yellow.
When you choose to format by rules, you can add custom rules to define a range of percentage values that you want to highlight in a specific color. You can define a range using the following operators: greater than or equal to and less than or equal to. You can also specify that you want to use these values as numbers.
You should use 0.15 and 0.17 as numbers. The Sales % measure is a percentage value. This means that the decimal number 0.17 becomes 17% when converted to a percentage value. If you use 17, it will become 1700% when converted into a percentage value. If you choose values to be used as percentages, this will not work correctly with the stated rule of Sales % contribution is 15 and 17 percent. As per current limitations, you cannot apply rule-based formatting with percentage rules.
You should not use the color scale in the Format by field. This allows you to choose formatting from a color scheme for minimum and maximum values based on the selected fields. You can use a diverging color to distinguish between the minimum and the maximum value.
You should not use the field value in the Format by field. This allows you to choose formatting from an already defined field in your model, which you can use for a color scheme.
You should not use Sales in the “Based on field” option. Here, formatting will be based on the Sales measure values rather than the Sales % values, as required in this scenario.
Question 26 of 50
26. Question
You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.
How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Create a bookmark for each report page.
• Add four buttons to the home page and set action type to Bookmark.
• On each button, select the bookmark for the page.
Does this solution meet the goal?
Correct
This solution meets the goal. Bookmarks store the report page and how it is configured. When you add a button and set the Action type to Bookmark, it becomes a way of navigating to the report page for that bookmark.
Incorrect
This solution meets the goal. Bookmarks store the report page and how it is configured. When you add a button and set the Action type to Bookmark, it becomes a way of navigating to the report page for that bookmark.
Unattempted
This solution meets the goal. Bookmarks store the report page and how it is configured. When you add a button and set the Action type to Bookmark, it becomes a way of navigating to the report page for that bookmark.
Question 27 of 50
27. Question
You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.
How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Set Include in app to Yes for the report.
• Create a Power BI app.
• Enable navigation builder.
• Include the report in the navigation.
• Publish the app.
Does this solution meet the goal?
Correct
This solution does not meet the goal These steps create an app containing the dashboards and reports in the workspace. The app has a navigation pane. The navigation pane contains menu items for the dashboards and reports. It does not include menu items for each report page.
Incorrect
This solution does not meet the goal These steps create an app containing the dashboards and reports in the workspace. The app has a navigation pane. The navigation pane contains menu items for the dashboards and reports. It does not include menu items for each report page.
Unattempted
This solution does not meet the goal These steps create an app containing the dashboards and reports in the workspace. The app has a navigation pane. The navigation pane contains menu items for the dashboards and reports. It does not include menu items for each report page.
Question 28 of 50
28. Question
You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.
Which visualizations should you use for each requirement stated below:
Show progress of sales opportunities won against target.
Correct
The Key Performance Indicator (KPI) visual shows the progress made toward a measurable goal Sales targets are a goal, and the sales won is the progress made. The KPI visual is the best option for showing sales progress against their targets.
Incorrect
The Key Performance Indicator (KPI) visual shows the progress made toward a measurable goal Sales targets are a goal, and the sales won is the progress made. The KPI visual is the best option for showing sales progress against their targets.
Unattempted
The Key Performance Indicator (KPI) visual shows the progress made toward a measurable goal Sales targets are a goal, and the sales won is the progress made. The KPI visual is the best option for showing sales progress against their targets.
Question 29 of 50
29. Question
You create a report page and pin the page to a dashboard in the Power BI service. You receive many enquiries from users asking you about the data and requesting additional visuals on the dashboard.
You need to enable the Q&A feature that appears as “Ask a question about your data” at the top of the dashboard above the visuals.
How should you enable this feature?
Solution: Enable the Q&A option in Page information on the report page.
Does this solution meet the goal?
Correct
This solution does not meet the goal The Q&A option on the report page allows Q&A to use the page as an answer. You can add an alternate name for the report.
Incorrect
This solution does not meet the goal The Q&A option on the report page allows Q&A to use the page as an answer. You can add an alternate name for the report.
Unattempted
This solution does not meet the goal The Q&A option on the report page allows Q&A to use the page as an answer. You can add an alternate name for the report.
Question 30 of 50
30. Question
You have a dashboard in Power Bl that has visuals created from data in the Common Data Service. The dashboard contains a KPI visual.
You need to automate the notification of alerts when the KPI value exceeds a threshold. Which two options are available when configuring an alert in Power Bl service? Each correct answer presents a complete solution.
Correct
When an alert rule is triggered, a notification is created that is visible in the notification center in Power Bl. Alerts can optionally be sent by email.
A Power Automate flow can also be triggered by a Power Bl alert. The Power Bl connector contains the trigger named “When a data driven alert is triggered”. You can create a Power Automate flow using this trigger to send notifications using any of the connectors available with Power Automate, including text messages, Microsoft Teams messages, email, and even social media posts.
Calling a webhook is not an option for a Power Bl data alert. Calling webhooks when an event is triggered is a feature of the Common Data Service in the Power Platform.
If a user has the Power Bl mobile app installed, notifications will appear on their mobile device. If and how notification of alerts appear on the mobile device is controlled by settings in the mobile app. You cannot configure whether a mobile notification is sent when configuring alert rules in Power Bl service.
Incorrect
When an alert rule is triggered, a notification is created that is visible in the notification center in Power Bl. Alerts can optionally be sent by email.
A Power Automate flow can also be triggered by a Power Bl alert. The Power Bl connector contains the trigger named “When a data driven alert is triggered”. You can create a Power Automate flow using this trigger to send notifications using any of the connectors available with Power Automate, including text messages, Microsoft Teams messages, email, and even social media posts.
Calling a webhook is not an option for a Power Bl data alert. Calling webhooks when an event is triggered is a feature of the Common Data Service in the Power Platform.
If a user has the Power Bl mobile app installed, notifications will appear on their mobile device. If and how notification of alerts appear on the mobile device is controlled by settings in the mobile app. You cannot configure whether a mobile notification is sent when configuring alert rules in Power Bl service.
Unattempted
When an alert rule is triggered, a notification is created that is visible in the notification center in Power Bl. Alerts can optionally be sent by email.
A Power Automate flow can also be triggered by a Power Bl alert. The Power Bl connector contains the trigger named “When a data driven alert is triggered”. You can create a Power Automate flow using this trigger to send notifications using any of the connectors available with Power Automate, including text messages, Microsoft Teams messages, email, and even social media posts.
Calling a webhook is not an option for a Power Bl data alert. Calling webhooks when an event is triggered is a feature of the Common Data Service in the Power Platform.
If a user has the Power Bl mobile app installed, notifications will appear on their mobile device. If and how notification of alerts appear on the mobile device is controlled by settings in the mobile app. You cannot configure whether a mobile notification is sent when configuring alert rules in Power Bl service.
Question 31 of 50
31. Question
Which 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 32 of 50
32. Question
You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.
How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Add four images to the home page and set action type to Page navigation.
• Select the destination page for each image.
Does this solution meet the goal?
Correct
This solution meets the goal. The Page navigation Action type is supported for shapes and images, not just buttons. When you use the Page navigation Action type, you select the Report page you wish to navigate to as the destination page. Clicking on the image will navigate to the Report page associated with the image.
Incorrect
This solution meets the goal. The Page navigation Action type is supported for shapes and images, not just buttons. When you use the Page navigation Action type, you select the Report page you wish to navigate to as the destination page. Clicking on the image will navigate to the Report page associated with the image.
Unattempted
This solution meets the goal. The Page navigation Action type is supported for shapes and images, not just buttons. When you use the Page navigation Action type, you select the Report page you wish to navigate to as the destination page. Clicking on the image will navigate to the Report page associated with the image.
Question 33 of 50
33. Question
You create a report in Power Bl.
You need to configure the page for use with screen reader software for partially sighted users.
What should you configure on the report page so that the screen reader follows a logical sequence?
Correct
You should set the Tab order for each visualization. You arrange the visuals in order by using the up and down arrows in the Selection Pane, or by using drag and drop into the desired order. Tab Order is used by keyboard users to navigate the report page. Screen reader software will follow the sequence set in the tab order. You can also skip visuals by hiding the visual from the Tab order. Screen reader software uses the Alt-Text on a visual to read about the visual.
You should not use Bookmark groups. Bookmark groups are a collection of bookmarks. Bookmarks capture the currently configured view of a report page, including filters, slicers, and the state of visuals. Bookmarks are not used by screen reader software.
You should not use Layer order. Layer order is used to control the order in which visuals are added to the report page. This is important if you have visuals that overlap each other. Layer order is not used by screen reader software.
You should not use Focus mode. Focus mode expands out a visualization on the screen to take the full report canvas, hiding other visuals. You can still interact with the visual while in Focus mode.
Incorrect
You should set the Tab order for each visualization. You arrange the visuals in order by using the up and down arrows in the Selection Pane, or by using drag and drop into the desired order. Tab Order is used by keyboard users to navigate the report page. Screen reader software will follow the sequence set in the tab order. You can also skip visuals by hiding the visual from the Tab order. Screen reader software uses the Alt-Text on a visual to read about the visual.
You should not use Bookmark groups. Bookmark groups are a collection of bookmarks. Bookmarks capture the currently configured view of a report page, including filters, slicers, and the state of visuals. Bookmarks are not used by screen reader software.
You should not use Layer order. Layer order is used to control the order in which visuals are added to the report page. This is important if you have visuals that overlap each other. Layer order is not used by screen reader software.
You should not use Focus mode. Focus mode expands out a visualization on the screen to take the full report canvas, hiding other visuals. You can still interact with the visual while in Focus mode.
Unattempted
You should set the Tab order for each visualization. You arrange the visuals in order by using the up and down arrows in the Selection Pane, or by using drag and drop into the desired order. Tab Order is used by keyboard users to navigate the report page. Screen reader software will follow the sequence set in the tab order. You can also skip visuals by hiding the visual from the Tab order. Screen reader software uses the Alt-Text on a visual to read about the visual.
You should not use Bookmark groups. Bookmark groups are a collection of bookmarks. Bookmarks capture the currently configured view of a report page, including filters, slicers, and the state of visuals. Bookmarks are not used by screen reader software.
You should not use Layer order. Layer order is used to control the order in which visuals are added to the report page. This is important if you have visuals that overlap each other. Layer order is not used by screen reader software.
You should not use Focus mode. Focus mode expands out a visualization on the screen to take the full report canvas, hiding other visuals. You can still interact with the visual while in Focus mode.
Question 34 of 50
34. Question
You create Power Bl reports and dashboards.
Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.
You need to customize themes to meet these requirements.
Which theme should you use for the following requirement?
“Set the background image”
Correct
Background images can be set in both dashboard and report themes. In a dashboard theme, you can upload an image file. For a report theme, you must edit the theme JSON file and add a base64-encoded string for the image.
Incorrect
Background images can be set in both dashboard and report themes. In a dashboard theme, you can upload an image file. For a report theme, you must edit the theme JSON file and add a base64-encoded string for the image.
Unattempted
Background images can be set in both dashboard and report themes. In a dashboard theme, you can upload an image file. For a report theme, you must edit the theme JSON file and add a base64-encoded string for the image.
Question 35 of 50
35. Question
Which properties of a tile can be edited in the Power Bl dashboard from the Tile details window? Choose the correct answers.
Correct
The following properties of a tile can be edited in the Power BI dashboard from the Tile details window:
A. SubtitleC. TitleD. Destination link
Here’s why these options are editable:
Subtitle:Â You can add or edit a subtitle to provide additional context or information about the tile’s data.
Title:Â You can rename the tile to give it a more descriptive or meaningful name within the dashboard context.
Destination link:Â You can specify a URL or another dashboard page where users will be directed when they click on the tile. This enables interactive navigation within the Power BI environment.
Properties not editable in the Tile details window:
B. Color scheme:Â While the Tile details window doesn’t directly offer color scheme editing, you can modify the visual theme of the entire dashboard, which can indirectly impact the color scheme of your tiles if they are using the default theme. You can also potentially find theme customization options within the specific visual type used for the tile (e.g., modifying the color of a chart) using the visual formatting options.
Remember, the specific options available in the Tile details window might vary slightly depending on the type of tile you’re working with or the version of Power BI you’re using. However, the ability to edit title, subtitle, and destination link is widely available and useful for enhancing your dashboards.
Incorrect
The following properties of a tile can be edited in the Power BI dashboard from the Tile details window:
A. SubtitleC. TitleD. Destination link
Here’s why these options are editable:
Subtitle:Â You can add or edit a subtitle to provide additional context or information about the tile’s data.
Title:Â You can rename the tile to give it a more descriptive or meaningful name within the dashboard context.
Destination link:Â You can specify a URL or another dashboard page where users will be directed when they click on the tile. This enables interactive navigation within the Power BI environment.
Properties not editable in the Tile details window:
B. Color scheme:Â While the Tile details window doesn’t directly offer color scheme editing, you can modify the visual theme of the entire dashboard, which can indirectly impact the color scheme of your tiles if they are using the default theme. You can also potentially find theme customization options within the specific visual type used for the tile (e.g., modifying the color of a chart) using the visual formatting options.
Remember, the specific options available in the Tile details window might vary slightly depending on the type of tile you’re working with or the version of Power BI you’re using. However, the ability to edit title, subtitle, and destination link is widely available and useful for enhancing your dashboards.
Unattempted
The following properties of a tile can be edited in the Power BI dashboard from the Tile details window:
A. SubtitleC. TitleD. Destination link
Here’s why these options are editable:
Subtitle:Â You can add or edit a subtitle to provide additional context or information about the tile’s data.
Title:Â You can rename the tile to give it a more descriptive or meaningful name within the dashboard context.
Destination link:Â You can specify a URL or another dashboard page where users will be directed when they click on the tile. This enables interactive navigation within the Power BI environment.
Properties not editable in the Tile details window:
B. Color scheme:Â While the Tile details window doesn’t directly offer color scheme editing, you can modify the visual theme of the entire dashboard, which can indirectly impact the color scheme of your tiles if they are using the default theme. You can also potentially find theme customization options within the specific visual type used for the tile (e.g., modifying the color of a chart) using the visual formatting options.
Remember, the specific options available in the Tile details window might vary slightly depending on the type of tile you’re working with or the version of Power BI you’re using. However, the ability to edit title, subtitle, and destination link is widely available and useful for enhancing your dashboards.
Question 36 of 50
36. 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 37 of 50
37. Question
You create a Power Bl report.
You need to improve report navigation.
Which options should you use for the stated task?
“Preserve visual selection of a specific report page”
Correct
You should use Bookmarks to preserve visual selection on a report page. Bookmarks allow you to preserve the filter, slicer, and visual state selections of current page. You can view bookmarks as a slideshow.
Incorrect
You should use Bookmarks to preserve visual selection on a report page. Bookmarks allow you to preserve the filter, slicer, and visual state selections of current page. You can view bookmarks as a slideshow.
Unattempted
You should use Bookmarks to preserve visual selection on a report page. Bookmarks allow you to preserve the filter, slicer, and visual state selections of current page. You can view bookmarks as a slideshow.
Question 38 of 50
38. Question
You create a dashboard in Power Bl with several visuals.
You need to explain how the dashboard will appear on a mobile device using the Power Bl app. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. By default, in the Power Bl mobile, all tiles on a dashboard appear with the same size in a vertical list.
2. Enabling Dashboard tile flow causes the tiles to be displayed on a mobile device as they are on a web browser.
3. Creating a Phone view of a dashboard, allows you to resize and rearrange the visuals for the Power Bl mobile app.
Correct
When you view a dashboard in portrait mode on a phone, by default the tiles are laid out one after another in a vertical list. All tiles are the same size.
Dashboard tile flow aligns all visuals to the top left corner of the dashboard. It has no effect on how the tiles are rendered on a mobile device.
You can create a Phone view for a dashboard. In this view you can resize, rearrange, and hide the visuals without affecting the web view.
Incorrect
When you view a dashboard in portrait mode on a phone, by default the tiles are laid out one after another in a vertical list. All tiles are the same size.
Dashboard tile flow aligns all visuals to the top left corner of the dashboard. It has no effect on how the tiles are rendered on a mobile device.
You can create a Phone view for a dashboard. In this view you can resize, rearrange, and hide the visuals without affecting the web view.
Unattempted
When you view a dashboard in portrait mode on a phone, by default the tiles are laid out one after another in a vertical list. All tiles are the same size.
Dashboard tile flow aligns all visuals to the top left corner of the dashboard. It has no effect on how the tiles are rendered on a mobile device.
You can create a Phone view for a dashboard. In this view you can resize, rearrange, and hide the visuals without affecting the web view.
Question 39 of 50
39. Question
You have a report page named Sales which contains visual A, showing total sales for each city for the selected year, as shown in the below exhibit.
You need to configure an interaction for this visual. When clicking Drill through, it should redirect to a detail page that shows Sales for the selected city by Product Line and will preserve all the filters from the Sales page.
Which four actions should you perform? Each correct answer presents part of the solution.
Correct
You should perform the following actions:
• Create a new page named Detail.
• Create a table visual named Visual B to show total sales by city and product line.
• On the Detail page, under the drill through option, add City column as the drill through field.
• On the Detail page, under the drill through, option set Keep all filters to On.
To create a drill through interaction on Visual A, you first need to create a Detail page Then, place a table visual on this page to show total sales by city and product line.
Next, on the Detail page, under the drill through option, add City column as the drill through field.
Finally, set Keep all filters to On on the Detail page, so that it can preserve all the filters from the Sales page.
You should not use the drill through option to keep all filters to On on the Sales page. This would be useful if the Sales page is being used as a drill through page and we want to keep all filters from calling the page.
You should not use the drill through option and add City column as the drill through field for the Sales page. This will allow you to create a redirection from any other page to the Sales page using the City column by utilizing the same drill through feature.
Incorrect
You should perform the following actions:
• Create a new page named Detail.
• Create a table visual named Visual B to show total sales by city and product line.
• On the Detail page, under the drill through option, add City column as the drill through field.
• On the Detail page, under the drill through, option set Keep all filters to On.
To create a drill through interaction on Visual A, you first need to create a Detail page Then, place a table visual on this page to show total sales by city and product line.
Next, on the Detail page, under the drill through option, add City column as the drill through field.
Finally, set Keep all filters to On on the Detail page, so that it can preserve all the filters from the Sales page.
You should not use the drill through option to keep all filters to On on the Sales page. This would be useful if the Sales page is being used as a drill through page and we want to keep all filters from calling the page.
You should not use the drill through option and add City column as the drill through field for the Sales page. This will allow you to create a redirection from any other page to the Sales page using the City column by utilizing the same drill through feature.
Unattempted
You should perform the following actions:
• Create a new page named Detail.
• Create a table visual named Visual B to show total sales by city and product line.
• On the Detail page, under the drill through option, add City column as the drill through field.
• On the Detail page, under the drill through, option set Keep all filters to On.
To create a drill through interaction on Visual A, you first need to create a Detail page Then, place a table visual on this page to show total sales by city and product line.
Next, on the Detail page, under the drill through option, add City column as the drill through field.
Finally, set Keep all filters to On on the Detail page, so that it can preserve all the filters from the Sales page.
You should not use the drill through option to keep all filters to On on the Sales page. This would be useful if the Sales page is being used as a drill through page and we want to keep all filters from calling the page.
You should not use the drill through option and add City column as the drill through field for the Sales page. This will allow you to create a redirection from any other page to the Sales page using the City column by utilizing the same drill through feature.
Question 40 of 50
40. Question
You create a Power Bl report. The report has multiple pages with many visuals.
Users need to be able to view this report on their mobile devices.
You need to optimize the report for use on mobile devices.
Which two optimizations can you perform? Each correct answer presents a complete solution.
Correct
In Power Bl desktop, you can switch to the mobile layout view of a report page. In this view, you can add and remove visuals from the report to the mobile canvas. You can also resize the visuals. You should only include important visuals in the mobile layout to optimize the report for mobile devices.
Additionally, you can resize slicers and make a slicer responsive so that it will resize automatically in the mobile app.
You should not apply a report theme. Themes only change the colors and fonts used in visuals. Themes do not change how visuals are organized in the mobile app.
You should not remove data labels. Properties for a visual such as data labels apply to both the desktop and mobile view. You cannot change the properties for a visual, only for the mobile view. You should not set the page size. The mobile app uses the mobile layout, if defined. You should switch to the mobile layout view and arrange the visuals using the phone emulator canvas. The selected page size does not affect the mobile layout.
Incorrect
In Power Bl desktop, you can switch to the mobile layout view of a report page. In this view, you can add and remove visuals from the report to the mobile canvas. You can also resize the visuals. You should only include important visuals in the mobile layout to optimize the report for mobile devices.
Additionally, you can resize slicers and make a slicer responsive so that it will resize automatically in the mobile app.
You should not apply a report theme. Themes only change the colors and fonts used in visuals. Themes do not change how visuals are organized in the mobile app.
You should not remove data labels. Properties for a visual such as data labels apply to both the desktop and mobile view. You cannot change the properties for a visual, only for the mobile view. You should not set the page size. The mobile app uses the mobile layout, if defined. You should switch to the mobile layout view and arrange the visuals using the phone emulator canvas. The selected page size does not affect the mobile layout.
Unattempted
In Power Bl desktop, you can switch to the mobile layout view of a report page. In this view, you can add and remove visuals from the report to the mobile canvas. You can also resize the visuals. You should only include important visuals in the mobile layout to optimize the report for mobile devices.
Additionally, you can resize slicers and make a slicer responsive so that it will resize automatically in the mobile app.
You should not apply a report theme. Themes only change the colors and fonts used in visuals. Themes do not change how visuals are organized in the mobile app.
You should not remove data labels. Properties for a visual such as data labels apply to both the desktop and mobile view. You cannot change the properties for a visual, only for the mobile view. You should not set the page size. The mobile app uses the mobile layout, if defined. You should switch to the mobile layout view and arrange the visuals using the phone emulator canvas. The selected page size does not affect the mobile layout.
Question 41 of 50
41. Question
You need to configure data alerts for a dashboard.
Which three visuals can be configured for data alerts? Each correct answer presents a complete solution.
Correct
You can configure data alerts for card, gauge, and KPI visuals. Data alerts are only available from the Power Bl service and can be configured for these three visuals. Data alerts allow you to send notifications when a certain limit is reached. For example, you can create an alert to send a notification when sales reach one million. You can also set alerts to send notifications if growth is negative.
Card visuals allow you to represent single value, either text or number. It is used to highlight the importance of that attribute, like total sales in your report.
The Gauge visual allows you to track progress against a measurable goal. It can be used to visualize sales against the yearly target. It shows a dial to represent the progress made and a pointer to represent the target value.
The KPI visual allows you to track progress against a measurable goal. It can be used to visualize sales against monthly targets.
You cannot configure data alerts for line or matrix visuals. A line chart plots a series of data points connected through a line. The Matrix visual allows you to show aggregated results in tabular form.
Incorrect
You can configure data alerts for card, gauge, and KPI visuals. Data alerts are only available from the Power Bl service and can be configured for these three visuals. Data alerts allow you to send notifications when a certain limit is reached. For example, you can create an alert to send a notification when sales reach one million. You can also set alerts to send notifications if growth is negative.
Card visuals allow you to represent single value, either text or number. It is used to highlight the importance of that attribute, like total sales in your report.
The Gauge visual allows you to track progress against a measurable goal. It can be used to visualize sales against the yearly target. It shows a dial to represent the progress made and a pointer to represent the target value.
The KPI visual allows you to track progress against a measurable goal. It can be used to visualize sales against monthly targets.
You cannot configure data alerts for line or matrix visuals. A line chart plots a series of data points connected through a line. The Matrix visual allows you to show aggregated results in tabular form.
Unattempted
You can configure data alerts for card, gauge, and KPI visuals. Data alerts are only available from the Power Bl service and can be configured for these three visuals. Data alerts allow you to send notifications when a certain limit is reached. For example, you can create an alert to send a notification when sales reach one million. You can also set alerts to send notifications if growth is negative.
Card visuals allow you to represent single value, either text or number. It is used to highlight the importance of that attribute, like total sales in your report.
The Gauge visual allows you to track progress against a measurable goal. It can be used to visualize sales against the yearly target. It shows a dial to represent the progress made and a pointer to represent the target value.
The KPI visual allows you to track progress against a measurable goal. It can be used to visualize sales against monthly targets.
You cannot configure data alerts for line or matrix visuals. A line chart plots a series of data points connected through a line. The Matrix visual allows you to show aggregated results in tabular form.
Question 42 of 50
42. Question
You create a report page in Power BI.
You need to create a dashboard that will be simultaneously updated whenever the report page is updated.
What should you do?
Correct
You should pin the report to a new dashboard as a live page. Pinning a report as a live page enables changes to the report to appear simultaneously in the dashboard tiles when the report page is refreshed. You should not create a new dashboard and pin each of the visuals from the report page as individual tiles.
If you pin individual visuals as tiles on a dashboard, the visuals are not automatically updated when the report page is updated. The data is refreshed, but changes to the visualization are not. If you change the type of visualization used when you created the tile, the tile does not change. For example, if you pin a pie chart from a report page and then change the pie chart to a bar chart, the dashboard tile continues to show a pie chart.
You should not enable Dashboard tile flow in dashboard settings. Dashboard tile flow aligns all visuals to the top left corner of the dashboard. It has no effect on how dashboards are updated. You should not enable Persistent filters in report settings. Persistent filters allow end users to save filters on the report. It has no effect on how dashboards are updated.
Incorrect
You should pin the report to a new dashboard as a live page. Pinning a report as a live page enables changes to the report to appear simultaneously in the dashboard tiles when the report page is refreshed. You should not create a new dashboard and pin each of the visuals from the report page as individual tiles.
If you pin individual visuals as tiles on a dashboard, the visuals are not automatically updated when the report page is updated. The data is refreshed, but changes to the visualization are not. If you change the type of visualization used when you created the tile, the tile does not change. For example, if you pin a pie chart from a report page and then change the pie chart to a bar chart, the dashboard tile continues to show a pie chart.
You should not enable Dashboard tile flow in dashboard settings. Dashboard tile flow aligns all visuals to the top left corner of the dashboard. It has no effect on how dashboards are updated. You should not enable Persistent filters in report settings. Persistent filters allow end users to save filters on the report. It has no effect on how dashboards are updated.
Unattempted
You should pin the report to a new dashboard as a live page. Pinning a report as a live page enables changes to the report to appear simultaneously in the dashboard tiles when the report page is refreshed. You should not create a new dashboard and pin each of the visuals from the report page as individual tiles.
If you pin individual visuals as tiles on a dashboard, the visuals are not automatically updated when the report page is updated. The data is refreshed, but changes to the visualization are not. If you change the type of visualization used when you created the tile, the tile does not change. For example, if you pin a pie chart from a report page and then change the pie chart to a bar chart, the dashboard tile continues to show a pie chart.
You should not enable Dashboard tile flow in dashboard settings. Dashboard tile flow aligns all visuals to the top left corner of the dashboard. It has no effect on how dashboards are updated. You should not enable Persistent filters in report settings. Persistent filters allow end users to save filters on the report. It has no effect on how dashboards are updated.
Question 43 of 50
43. Question
You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.
Which visualizations should you use for the below-stated requirement?
“Use scikit learn machine learning in visuals”
Correct
Scikit-learn is a Python library for creating and visualizing machine learning models.
Incorrect
Scikit-learn is a Python library for creating and visualizing machine learning models.
Unattempted
Scikit-learn is a Python library for creating and visualizing machine learning models.
Question 44 of 50
44. Question
What is the file format used to define a theme for a Power Bl report?
Correct
JavaScript Object Notation (JSON) is the file format used to define a theme for a Power Bl report.
Incorrect
JavaScript Object Notation (JSON) is the file format used to define a theme for a Power Bl report.
Unattempted
JavaScript Object Notation (JSON) is the file format used to define a theme for a Power Bl report.
Question 45 of 50
45. Question
You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.
Which visualizations should you use for the below-stated requirement?
“Use JavaScript to create visuals”
Correct
D3 is a JavaScript library for creating visuals. D3 is supported in Power Bl by adding a custom visualization from AppSource.
Incorrect
D3 is a JavaScript library for creating visuals. D3 is supported in Power Bl by adding a custom visualization from AppSource.
Unattempted
D3 is a JavaScript library for creating visuals. D3 is supported in Power Bl by adding a custom visualization from AppSource.
Question 46 of 50
46. Question
You create a report in Power Bl Desktop containing many visualizations.
You need to apply the fonts and colors to match your corporate standards. What should you do?
Correct
You should customize the theme. You can change the entire report, including setting corporate colors and changing the font to be used for visuals and text on the page. The best practice is to create a corporate theme and apply it to all reports and dashboards.
You should not change the font on each visualization. This will take a lot of effort and will not address the requirement to change the colors used in visualizations.
You should not set the Data colors on each visualization. This will take a lot of effort and will not address the font requirement. If you customize the Data colors on a visual, any colors applied by a theme will not be applied until you use Revert to the default.
You should not set the font family on the page display settings. This is not inherited by visualizations on the page and would only affect the report filters.
Incorrect
You should customize the theme. You can change the entire report, including setting corporate colors and changing the font to be used for visuals and text on the page. The best practice is to create a corporate theme and apply it to all reports and dashboards.
You should not change the font on each visualization. This will take a lot of effort and will not address the requirement to change the colors used in visualizations.
You should not set the Data colors on each visualization. This will take a lot of effort and will not address the font requirement. If you customize the Data colors on a visual, any colors applied by a theme will not be applied until you use Revert to the default.
You should not set the font family on the page display settings. This is not inherited by visualizations on the page and would only affect the report filters.
Unattempted
You should customize the theme. You can change the entire report, including setting corporate colors and changing the font to be used for visuals and text on the page. The best practice is to create a corporate theme and apply it to all reports and dashboards.
You should not change the font on each visualization. This will take a lot of effort and will not address the requirement to change the colors used in visualizations.
You should not set the Data colors on each visualization. This will take a lot of effort and will not address the font requirement. If you customize the Data colors on a visual, any colors applied by a theme will not be applied until you use Revert to the default.
You should not set the font family on the page display settings. This is not inherited by visualizations on the page and would only affect the report filters.
Question 47 of 50
47. Question
You have a dashboard tile that shows the manufacturing effciency using a card visual. The manufacturing effciency measure is formatted as a percentage. Your company requires a notification to be sent when effciency drops below 70 percent.
You need to configure email alerts to meet this requirement.
Which four actions should you perform? Each correct answer presents part of the solution.
Correct
You should perform the following actions:
• Choose More options on the Manufacturing efficiency card visual and click on Manage alerts.
• Click the + Add alert rule button.
• Choose Below in the Condition field and set the Threshold value to 0.7.
• Check the Send me email too checkbox and click Save and close.
You can configure data alerts on a card visual using the Manage alerts option. You can add a rule button to define a rule for the alerts. You can choose the condition as Above or Below depending on the requirement. In this scenario, you should choose Below and set the threshold value to 0.7 because this is a percentage value.
You should not set the threshold value to 70. This will be considered 7000 when converted into a percentage value.
You should not click the Save and close button. This will save and close the alert rule changes. You also need to send an email notification, as required in the scenario.
Incorrect
You should perform the following actions:
• Choose More options on the Manufacturing efficiency card visual and click on Manage alerts.
• Click the + Add alert rule button.
• Choose Below in the Condition field and set the Threshold value to 0.7.
• Check the Send me email too checkbox and click Save and close.
You can configure data alerts on a card visual using the Manage alerts option. You can add a rule button to define a rule for the alerts. You can choose the condition as Above or Below depending on the requirement. In this scenario, you should choose Below and set the threshold value to 0.7 because this is a percentage value.
You should not set the threshold value to 70. This will be considered 7000 when converted into a percentage value.
You should not click the Save and close button. This will save and close the alert rule changes. You also need to send an email notification, as required in the scenario.
Unattempted
You should perform the following actions:
• Choose More options on the Manufacturing efficiency card visual and click on Manage alerts.
• Click the + Add alert rule button.
• Choose Below in the Condition field and set the Threshold value to 0.7.
• Check the Send me email too checkbox and click Save and close.
You can configure data alerts on a card visual using the Manage alerts option. You can add a rule button to define a rule for the alerts. You can choose the condition as Above or Below depending on the requirement. In this scenario, you should choose Below and set the threshold value to 0.7 because this is a percentage value.
You should not set the threshold value to 70. This will be considered 7000 when converted into a percentage value.
You should not click the Save and close button. This will save and close the alert rule changes. You also need to send an email notification, as required in the scenario.
Question 48 of 50
48. Question
You work on the new filter pane experience for a Power Bl report.
What can you achieve by using the new filter pane experience?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Hide specific filters from report consumers.
2. Lock specific filters so report consumers cannot edit them.
3. Disable the search for the Filters pane.
Correct
Here’s the breakdown of the statements:
Hide specific filters from report consumers.
Yes – The new filter pane experience allows you to control the visibility of filters for report consumers. You can selectively hide certain filters from their view, simplifying the filtering process and preventing confusion.
Lock specific filters so report consumers cannot edit them.
Yes – You can lock specific filters, making them read-only for report consumers. This ensures that the filter values remain unchanged, preserving the intended analysis or maintaining data integrity.
Disable the search for the Filters pane.
No – The search functionality within the Filters pane is generally a valuable feature for users to quickly locate specific filters. Disabling it would hinder the user experience and make it harder to find and apply filters.
Therefore, the correct answers are:
Yes
Yes
No
Incorrect
Here’s the breakdown of the statements:
Hide specific filters from report consumers.
Yes – The new filter pane experience allows you to control the visibility of filters for report consumers. You can selectively hide certain filters from their view, simplifying the filtering process and preventing confusion.
Lock specific filters so report consumers cannot edit them.
Yes – You can lock specific filters, making them read-only for report consumers. This ensures that the filter values remain unchanged, preserving the intended analysis or maintaining data integrity.
Disable the search for the Filters pane.
No – The search functionality within the Filters pane is generally a valuable feature for users to quickly locate specific filters. Disabling it would hinder the user experience and make it harder to find and apply filters.
Therefore, the correct answers are:
Yes
Yes
No
Unattempted
Here’s the breakdown of the statements:
Hide specific filters from report consumers.
Yes – The new filter pane experience allows you to control the visibility of filters for report consumers. You can selectively hide certain filters from their view, simplifying the filtering process and preventing confusion.
Lock specific filters so report consumers cannot edit them.
Yes – You can lock specific filters, making them read-only for report consumers. This ensures that the filter values remain unchanged, preserving the intended analysis or maintaining data integrity.
Disable the search for the Filters pane.
No – The search functionality within the Filters pane is generally a valuable feature for users to quickly locate specific filters. Disabling it would hinder the user experience and make it harder to find and apply filters.
Therefore, the correct answers are:
Yes
Yes
No
Question 49 of 50
49. Question
Months are sorted alphabetically in Stacked bar chart. What can you do to sort it by month number?
Correct
The correct answer is: Modeling > Select Month Column > Sort By – MonthNumber.
Here’s why:
Modeling is where you define the data structure and relationships in Power BI.
Sorting a column in the modeling view affects how it’s used throughout the report.
By selecting the Month column and sorting it by MonthNumber, you’re telling Power BI to order the months based on their numerical values, not alphabetically.
This will ensure that the stacked bar chart displays the months in the correct numerical order.
Incorrect
The correct answer is: Modeling > Select Month Column > Sort By – MonthNumber.
Here’s why:
Modeling is where you define the data structure and relationships in Power BI.
Sorting a column in the modeling view affects how it’s used throughout the report.
By selecting the Month column and sorting it by MonthNumber, you’re telling Power BI to order the months based on their numerical values, not alphabetically.
This will ensure that the stacked bar chart displays the months in the correct numerical order.
Unattempted
The correct answer is: Modeling > Select Month Column > Sort By – MonthNumber.
Here’s why:
Modeling is where you define the data structure and relationships in Power BI.
Sorting a column in the modeling view affects how it’s used throughout the report.
By selecting the Month column and sorting it by MonthNumber, you’re telling Power BI to order the months based on their numerical values, not alphabetically.
This will ensure that the stacked bar chart displays the months in the correct numerical order.
Question 50 of 50
50. 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.
X
Use Page numbers below to navigate to other practice tests