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 12 "
0 of 54 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
51
52
53
54
Answered
Review
Question 1 of 54
1. Question
You administer Power Bl for your organization.
You prevent users from adding custom visuals from Microsoft AppSource by disabling the Allow visuals created using the Power Bl SDK option in the tenant settings of the Power Bl service.
You need to provide a set of custom visuals for users to add to their reports in the Power Bl service.
What should you do?
Correct
You should add the permitted custom visuals to Organizational visuals. The option in tenant settings is Allow visuals created using the Power BI SDK. This option allows users to add custom visuals from a file, or from AppSource. The option is disabled by default and would prevent users from performing either action.
Visuals added to the Organizational visuals page are not affected by tenant settings and are available to all users. You should add the set of permitted custom visuals to the Organizational visuals.
You should not give users the .pbiviz files for the permitted custom visuals to import themselves. The “tenant setting” prevents custom visuals from being uploaded from files as well as being added from AppSource.
You should not apply an Active Directory Group Policy to set the EnableCustomVisuals registry key. This registry key only affects Power Bl Desktop and does not allow custom visuals to be used with the Power Bl service.
You should not publish the custom visuals to the Partner Center. You publish custom visuals to the Partner Center as the first step to making the custom visual available in AppSource. Users are prevented from using AppSource.
Incorrect
You should add the permitted custom visuals to Organizational visuals. The option in tenant settings is Allow visuals created using the Power BI SDK. This option allows users to add custom visuals from a file, or from AppSource. The option is disabled by default and would prevent users from performing either action.
Visuals added to the Organizational visuals page are not affected by tenant settings and are available to all users. You should add the set of permitted custom visuals to the Organizational visuals.
You should not give users the .pbiviz files for the permitted custom visuals to import themselves. The “tenant setting” prevents custom visuals from being uploaded from files as well as being added from AppSource.
You should not apply an Active Directory Group Policy to set the EnableCustomVisuals registry key. This registry key only affects Power Bl Desktop and does not allow custom visuals to be used with the Power Bl service.
You should not publish the custom visuals to the Partner Center. You publish custom visuals to the Partner Center as the first step to making the custom visual available in AppSource. Users are prevented from using AppSource.
Unattempted
You should add the permitted custom visuals to Organizational visuals. The option in tenant settings is Allow visuals created using the Power BI SDK. This option allows users to add custom visuals from a file, or from AppSource. The option is disabled by default and would prevent users from performing either action.
Visuals added to the Organizational visuals page are not affected by tenant settings and are available to all users. You should add the set of permitted custom visuals to the Organizational visuals.
You should not give users the .pbiviz files for the permitted custom visuals to import themselves. The “tenant setting” prevents custom visuals from being uploaded from files as well as being added from AppSource.
You should not apply an Active Directory Group Policy to set the EnableCustomVisuals registry key. This registry key only affects Power Bl Desktop and does not allow custom visuals to be used with the Power Bl service.
You should not publish the custom visuals to the Partner Center. You publish custom visuals to the Partner Center as the first step to making the custom visual available in AppSource. Users are prevented from using AppSource.
Question 2 of 54
2. Question
You create a Power Bl dashboard for streaming data from Azure IOT devices.
You need to configure Power Bl to visualize the IOT telemetry data. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. The streaming data is added in the data model in Power Bl Desktop.
2. The real-time data visual is added directly to the dashboard.
3. Azure Stream Analytics can supply streaming data for Power BI.
Correct
Here’s the correct answer:
No – Streaming data is not typically added directly to the Power BI Desktop data model. Power BI Desktop is primarily designed for static data analysis and reporting.
Yes – Real-time data visuals, such as streaming charts and maps, can be added directly to Power BI dashboards.
Yes – Azure Stream Analytics is a powerful service for processing and analyzing real-time streaming data from IoT devices. It can be used to transform and aggregate data before sending it to Power BI for visualization.
In summary:
Streaming data is not directly modeled in Power BI Desktop.
Real-time visualizations can be added to Power BI dashboards.
Azure Stream Analytics can be a valuable source of streaming data for Power BI.
Incorrect
Here’s the correct answer:
No – Streaming data is not typically added directly to the Power BI Desktop data model. Power BI Desktop is primarily designed for static data analysis and reporting.
Yes – Real-time data visuals, such as streaming charts and maps, can be added directly to Power BI dashboards.
Yes – Azure Stream Analytics is a powerful service for processing and analyzing real-time streaming data from IoT devices. It can be used to transform and aggregate data before sending it to Power BI for visualization.
In summary:
Streaming data is not directly modeled in Power BI Desktop.
Real-time visualizations can be added to Power BI dashboards.
Azure Stream Analytics can be a valuable source of streaming data for Power BI.
Unattempted
Here’s the correct answer:
No – Streaming data is not typically added directly to the Power BI Desktop data model. Power BI Desktop is primarily designed for static data analysis and reporting.
Yes – Real-time data visuals, such as streaming charts and maps, can be added directly to Power BI dashboards.
Yes – Azure Stream Analytics is a powerful service for processing and analyzing real-time streaming data from IoT devices. It can be used to transform and aggregate data before sending it to Power BI for visualization.
In summary:
Streaming data is not directly modeled in Power BI Desktop.
Real-time visualizations can be added to Power BI dashboards.
Azure Stream Analytics can be a valuable source of streaming data for Power BI.
Question 3 of 54
3. Question
You create a Power Bl report.
You need to improve report navigation.
Which options should you use for the stated task?
“Preserve slicer selection of a specific report page”
Correct
You should use Bookmarks to preserve slicer 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 slicer 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 slicer 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 4 of 54
4. 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 settings for the dashboard.
Does this solution meet the goal?
Correct
This solution meets the goal. You must enable Q&A in the settings for the dashboard. This option shows the Q&A search box at the top of the dashboard.
Incorrect
This solution meets the goal. You must enable Q&A in the settings for the dashboard. This option shows the Q&A search box at the top of the dashboard.
Unattempted
This solution meets the goal. You must enable Q&A in the settings for the dashboard. This option shows the Q&A search box at the top of the dashboard.
Question 5 of 54
5. 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: Add the Q&A visual to the report page.
Does this solution meet the goal?
Correct
This solution does not meet the goal The Q&A visual would be added to the report canvas and shown in the report and dashboard, not above all the visuals in the dashboard.
Incorrect
This solution does not meet the goal The Q&A visual would be added to the report canvas and shown in the report and dashboard, not above all the visuals in the dashboard.
Unattempted
This solution does not meet the goal The Q&A visual would be added to the report canvas and shown in the report and dashboard, not above all the visuals in the dashboard.
Question 6 of 54
6. Question
Imagine you have created a query named Customers in a Power BI Desktop to append the rows from three external tables with customer data into a single output table named Customers.
What would be the best approach to add a new fabricated ID column to the Customers table to ensure that every row in the Customers table contains a unique ID value?
Correct
Index column option is available in the query editor to add an indexed column starting from 0, 1, or custom number.
Incorrect
Index column option is available in the query editor to add an indexed column starting from 0, 1, or custom number.
Unattempted
Index column option is available in the query editor to add an indexed column starting from 0, 1, or custom number.
Question 7 of 54
7. Question
You have a dataset that contains survey results for the percentage of internet access by year, age, and gender. The age of the respondents is between 15 and 85 years old.
You need to create a bar chart showing the percentage of internet access for equal age ranges of 10 years. Which four actions should you perform in sequence? To answer, select the appropriate actions from the below listed options.
Correct
Here’s the sequence of actions to create a bar chart showing the percentage of internet access for equal age ranges of 10 years:
Right click on the Age column and select New Group.
Set Group type to Bin.
Set the Bin type to Number of bins.
Set the Bin count to 7.
Explanation:
Creating a Group:
You need to group the ages into 10-year intervals. Right-clicking on the “Age” column and selecting “New Group” allows you to create a new grouping for this column.
Setting Group Type to Bin:
“Bin” is the appropriate grouping type when you want to divide data into equal intervals.
Setting Bin Type to Number of bins:
Since you want to create 10-year age ranges, you’ll specify the number of bins directly.
Setting Bin Count to 7:
To create seven 10-year age ranges (15-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75-85) for the age range of 15 to 85, you need to set the “Bin count” to 7.
This sequence will effectively group the ages into the desired 10-year intervals, allowing you to create the bar chart with the correct age ranges on the x-axis.
Incorrect
Here’s the sequence of actions to create a bar chart showing the percentage of internet access for equal age ranges of 10 years:
Right click on the Age column and select New Group.
Set Group type to Bin.
Set the Bin type to Number of bins.
Set the Bin count to 7.
Explanation:
Creating a Group:
You need to group the ages into 10-year intervals. Right-clicking on the “Age” column and selecting “New Group” allows you to create a new grouping for this column.
Setting Group Type to Bin:
“Bin” is the appropriate grouping type when you want to divide data into equal intervals.
Setting Bin Type to Number of bins:
Since you want to create 10-year age ranges, you’ll specify the number of bins directly.
Setting Bin Count to 7:
To create seven 10-year age ranges (15-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75-85) for the age range of 15 to 85, you need to set the “Bin count” to 7.
This sequence will effectively group the ages into the desired 10-year intervals, allowing you to create the bar chart with the correct age ranges on the x-axis.
Unattempted
Here’s the sequence of actions to create a bar chart showing the percentage of internet access for equal age ranges of 10 years:
Right click on the Age column and select New Group.
Set Group type to Bin.
Set the Bin type to Number of bins.
Set the Bin count to 7.
Explanation:
Creating a Group:
You need to group the ages into 10-year intervals. Right-clicking on the “Age” column and selecting “New Group” allows you to create a new grouping for this column.
Setting Group Type to Bin:
“Bin” is the appropriate grouping type when you want to divide data into equal intervals.
Setting Bin Type to Number of bins:
Since you want to create 10-year age ranges, you’ll specify the number of bins directly.
Setting Bin Count to 7:
To create seven 10-year age ranges (15-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75-85) for the age range of 15 to 85, you need to set the “Bin count” to 7.
This sequence will effectively group the ages into the desired 10-year intervals, allowing you to create the bar chart with the correct age ranges on the x-axis.
Question 8 of 54
8. Question
You build a Power Bl report showing vendor purchases. The dataset contains five hundred to a thousand rows.
You need to add a visual that enables users to easily identify the outliers in the data. Which type of visual should you add?
Correct
You should add the scatter chart. The best visual to identify outliers is the scatter chart, which shows the relationship between two numerical values. Scatter charts display patterns in large sets of data and are, therefore, ideal for displaying outliers.
You should not add the key influencers visuals. The key influencers visual is an Al-powered visual that allows users to discover import factors that affect their metrics. The visual contrasts the relative importance of these factors. The Key influencers visual does not assist in identifying outliers.
You should not add the Decomposition Tree visual. It allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition Tree does not help users discover outliers.
You should not use the Chord visual. It displays the relationships between data in a matrix. The Chord visual is used to show the similarities in the data. The Chord visual does not help users identify outliers.
Incorrect
You should add the scatter chart. The best visual to identify outliers is the scatter chart, which shows the relationship between two numerical values. Scatter charts display patterns in large sets of data and are, therefore, ideal for displaying outliers.
You should not add the key influencers visuals. The key influencers visual is an Al-powered visual that allows users to discover import factors that affect their metrics. The visual contrasts the relative importance of these factors. The Key influencers visual does not assist in identifying outliers.
You should not add the Decomposition Tree visual. It allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition Tree does not help users discover outliers.
You should not use the Chord visual. It displays the relationships between data in a matrix. The Chord visual is used to show the similarities in the data. The Chord visual does not help users identify outliers.
Unattempted
You should add the scatter chart. The best visual to identify outliers is the scatter chart, which shows the relationship between two numerical values. Scatter charts display patterns in large sets of data and are, therefore, ideal for displaying outliers.
You should not add the key influencers visuals. The key influencers visual is an Al-powered visual that allows users to discover import factors that affect their metrics. The visual contrasts the relative importance of these factors. The Key influencers visual does not assist in identifying outliers.
You should not add the Decomposition Tree visual. It allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition Tree does not help users discover outliers.
You should not use the Chord visual. It displays the relationships between data in a matrix. The Chord visual is used to show the similarities in the data. The Chord visual does not help users identify outliers.
Question 9 of 54
9. Question
You are creating a Power Bl report for products ordered from vendors for the purchasing department. The purchasing department monitors suppliers and their performance against a suite of metrics.
The department needs a visualization to assist in identifying the factors that affect vendor performance. Which type of visualization should you add?
Correct
You should add the Key influencers visual. It is an Al-powered visual that allows users to discover important factors that affect their metrics. The visual contrasts the relative Importance of these factors.
You should not add the Q&A visual. The Q&A visual allows users to ask questions about their data and can generate visualizations. The Q&A visual will help users find quick answers on their data but it does not help users discover the factors affecting metrics.
You should not add the Key Performance Indicator (KPI) visual. The KPI visual shows a target value and the progress towards that target. The KPI visual is used to show metrics but does not help users discover the factors that affect them.
You should not add the Decomposition Tree visual. It allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition Tree does not help users discover the factors affecting metrics.
Incorrect
You should add the Key influencers visual. It is an Al-powered visual that allows users to discover important factors that affect their metrics. The visual contrasts the relative Importance of these factors.
You should not add the Q&A visual. The Q&A visual allows users to ask questions about their data and can generate visualizations. The Q&A visual will help users find quick answers on their data but it does not help users discover the factors affecting metrics.
You should not add the Key Performance Indicator (KPI) visual. The KPI visual shows a target value and the progress towards that target. The KPI visual is used to show metrics but does not help users discover the factors that affect them.
You should not add the Decomposition Tree visual. It allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition Tree does not help users discover the factors affecting metrics.
Unattempted
You should add the Key influencers visual. It is an Al-powered visual that allows users to discover important factors that affect their metrics. The visual contrasts the relative Importance of these factors.
You should not add the Q&A visual. The Q&A visual allows users to ask questions about their data and can generate visualizations. The Q&A visual will help users find quick answers on their data but it does not help users discover the factors affecting metrics.
You should not add the Key Performance Indicator (KPI) visual. The KPI visual shows a target value and the progress towards that target. The KPI visual is used to show metrics but does not help users discover the factors that affect them.
You should not add the Decomposition Tree visual. It allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition Tree does not help users discover the factors affecting metrics.
Question 10 of 54
10. Question
You create a Power Bl report that shows the visual in the below exhibit.
You need to show how the relationship between costs and sales changes over the months in the year.
What should you do?
Correct
You should use the Play Axis feature. Play Axis is an animation that can be used with the scatter chart visual to show how values change over time. Play Axis acts like a dynamic slicer showing the values for each time period in the series. You should add the month column to the Play Axis option for the visual. This will add a start button to the visual. Upon clicking, the visual will step through each period and the scatter bubbles will move as the period changes. The animation in the exhibit shows how the relationship between costs and sales changes over time.
You should not add a Ratio line in the Analytics pane. The Ratio line feature draws a straight line using the ratio of the values on the x and y axis. It does not show how values change over time. You should not add a relative date slicer to the page. A relative date slicer filters the visuals using the relative number of days. This slicer will simply show a subset of the data. It does not show how values change over time.
You should not create a quick measure to calculate the month-over-month change of sales. The quick measure will calculate the difference of sales each month but will not illustrate how the relationship between costs and sales change over time.
Incorrect
You should use the Play Axis feature. Play Axis is an animation that can be used with the scatter chart visual to show how values change over time. Play Axis acts like a dynamic slicer showing the values for each time period in the series. You should add the month column to the Play Axis option for the visual. This will add a start button to the visual. Upon clicking, the visual will step through each period and the scatter bubbles will move as the period changes. The animation in the exhibit shows how the relationship between costs and sales changes over time.
You should not add a Ratio line in the Analytics pane. The Ratio line feature draws a straight line using the ratio of the values on the x and y axis. It does not show how values change over time. You should not add a relative date slicer to the page. A relative date slicer filters the visuals using the relative number of days. This slicer will simply show a subset of the data. It does not show how values change over time.
You should not create a quick measure to calculate the month-over-month change of sales. The quick measure will calculate the difference of sales each month but will not illustrate how the relationship between costs and sales change over time.
Unattempted
You should use the Play Axis feature. Play Axis is an animation that can be used with the scatter chart visual to show how values change over time. Play Axis acts like a dynamic slicer showing the values for each time period in the series. You should add the month column to the Play Axis option for the visual. This will add a start button to the visual. Upon clicking, the visual will step through each period and the scatter bubbles will move as the period changes. The animation in the exhibit shows how the relationship between costs and sales changes over time.
You should not add a Ratio line in the Analytics pane. The Ratio line feature draws a straight line using the ratio of the values on the x and y axis. It does not show how values change over time. You should not add a relative date slicer to the page. A relative date slicer filters the visuals using the relative number of days. This slicer will simply show a subset of the data. It does not show how values change over time.
You should not create a quick measure to calculate the month-over-month change of sales. The quick measure will calculate the difference of sales each month but will not illustrate how the relationship between costs and sales change over time.
Question 11 of 54
11. Question
You have a Power BI Pro license.
You want to use the Al features of Power BI to enhance your data.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. You can analyze text in your dataset for positive or negative sentiment in Power Bl Desktop
2. The Key Influencers visual requires a Power BI premium subscription
3. You can create your own machine learning models and invoke the models from Power Bl Desktop.
Correct
Here are the correct answers to your questions:
Yes: You can analyze text in your dataset for positive or negative sentiment using Power BI’s Text Analytics feature.
No: The Key Influencers visual is available in Power BI Pro.
No: You cannot create custom machine learning models directly within Power BI Desktop. However, you can integrate models built using other tools like Azure Machine Learning into your Power BI reports.
Therefore, the correct answers are:
Yes
No
No
Incorrect
Here are the correct answers to your questions:
Yes: You can analyze text in your dataset for positive or negative sentiment using Power BI’s Text Analytics feature.
No: The Key Influencers visual is available in Power BI Pro.
No: You cannot create custom machine learning models directly within Power BI Desktop. However, you can integrate models built using other tools like Azure Machine Learning into your Power BI reports.
Therefore, the correct answers are:
Yes
No
No
Unattempted
Here are the correct answers to your questions:
Yes: You can analyze text in your dataset for positive or negative sentiment using Power BI’s Text Analytics feature.
No: The Key Influencers visual is available in Power BI Pro.
No: You cannot create custom machine learning models directly within Power BI Desktop. However, you can integrate models built using other tools like Azure Machine Learning into your Power BI reports.
Therefore, the correct answers are:
Yes
No
No
Question 12 of 54
12. Question
The marketing team needs a new dashboard to show the uptake of social users on the company’s corporate forum. The dashboard will contain one particular report that shows the total number of users that registered for the site in each of the months of the year. For this report you want to create a dataset with a calculated column that displays the date with the abbreviated month name followed by the four digit year e.g. Jan 2018.
Which DAX expression should you use?
Correct
FORMAT converts a value to text according to the specified format.
Incorrect
FORMAT converts a value to text according to the specified format.
Unattempted
FORMAT converts a value to text according to the specified format.
Question 13 of 54
13. Question
You are a data analyst for a retail organization.
You need to show a histogram of the quantity of items in a basket by the size of the basket. A sample set of the data is shown in the below exhibit.
You create a measure for the count of the quantity column.
How should you create the histogram? Select the appropriate options for the visual fields.
Correct
You should choose the Clustered column chart visual. A column chart visual in Power Bl shows the relationship between two data points: a measure and a dimension. A histogram differs from a normal column chart in that it only visualizes a single data point. To create a visualization showing a histogram, you start from either a bar or column chart. You should use the quantity for the value on the visual.
You should not use a Matrix chart. A Matrix chart is a table of data and cannot be used for a histogram.
You should create a group for the axis of the histogram. A histogram groups data into ranges or buckets and shows how many values are in each bucket. Creating a group with a number of bins and using the group Will show the quantity data in a histogram.
You should not use a measure for the axis. You should use the values on the chart as the count of quantity, not the axis.
You should not use the quantity for the axis. This would not generate a histogram. You should use the values on the chart as the count of quantity, not the axis.
Incorrect
You should choose the Clustered column chart visual. A column chart visual in Power Bl shows the relationship between two data points: a measure and a dimension. A histogram differs from a normal column chart in that it only visualizes a single data point. To create a visualization showing a histogram, you start from either a bar or column chart. You should use the quantity for the value on the visual.
You should not use a Matrix chart. A Matrix chart is a table of data and cannot be used for a histogram.
You should create a group for the axis of the histogram. A histogram groups data into ranges or buckets and shows how many values are in each bucket. Creating a group with a number of bins and using the group Will show the quantity data in a histogram.
You should not use a measure for the axis. You should use the values on the chart as the count of quantity, not the axis.
You should not use the quantity for the axis. This would not generate a histogram. You should use the values on the chart as the count of quantity, not the axis.
Unattempted
You should choose the Clustered column chart visual. A column chart visual in Power Bl shows the relationship between two data points: a measure and a dimension. A histogram differs from a normal column chart in that it only visualizes a single data point. To create a visualization showing a histogram, you start from either a bar or column chart. You should use the quantity for the value on the visual.
You should not use a Matrix chart. A Matrix chart is a table of data and cannot be used for a histogram.
You should create a group for the axis of the histogram. A histogram groups data into ranges or buckets and shows how many values are in each bucket. Creating a group with a number of bins and using the group Will show the quantity data in a histogram.
You should not use a measure for the axis. You should use the values on the chart as the count of quantity, not the axis.
You should not use the quantity for the axis. This would not generate a histogram. You should use the values on the chart as the count of quantity, not the axis.
Question 14 of 54
14. Question
You use the Key influencer visual to analyze which product lines influence customers’ decisions to choose certain payment methods.
You need to create a key influencer visual, as shown in the exhibit.
Payment method is cash
Payment method is credit card
Payment method is e-wallet
How should you configure the visual? To answer, select the appropriate options for the setup screen menus.
Correct
You should use the Payment method in the Analyze field and Product line in the Explain by field. The key influencers visual analyzes what influences customers to choose certain payment methods like cash, credit card, or e-wallet. It explains which product line has a higher tendency for a certain payment method.
You should not use Product line in the Analyze field. The exhibit shows the analysis of payment method by product line. If you use product line in the Analyze field, it will use the Explain by field to provide its impact on the selected product line. You should not use Sales in the Analyze or Explain by fields. The exhibit shows the analysis of payment method by product line.
You can choose only one attribute in the Analyze field and add multiple attributes to the Explain by field. The Al feature will provide the impact of the Explain by attributes on the Analyze attribute. In some cases, the Al feature might not be able to provide any insight. This might happen when there are not enough rows to build a hypothesis.
Incorrect
You should use the Payment method in the Analyze field and Product line in the Explain by field. The key influencers visual analyzes what influences customers to choose certain payment methods like cash, credit card, or e-wallet. It explains which product line has a higher tendency for a certain payment method.
You should not use Product line in the Analyze field. The exhibit shows the analysis of payment method by product line. If you use product line in the Analyze field, it will use the Explain by field to provide its impact on the selected product line. You should not use Sales in the Analyze or Explain by fields. The exhibit shows the analysis of payment method by product line.
You can choose only one attribute in the Analyze field and add multiple attributes to the Explain by field. The Al feature will provide the impact of the Explain by attributes on the Analyze attribute. In some cases, the Al feature might not be able to provide any insight. This might happen when there are not enough rows to build a hypothesis.
Unattempted
You should use the Payment method in the Analyze field and Product line in the Explain by field. The key influencers visual analyzes what influences customers to choose certain payment methods like cash, credit card, or e-wallet. It explains which product line has a higher tendency for a certain payment method.
You should not use Product line in the Analyze field. The exhibit shows the analysis of payment method by product line. If you use product line in the Analyze field, it will use the Explain by field to provide its impact on the selected product line. You should not use Sales in the Analyze or Explain by fields. The exhibit shows the analysis of payment method by product line.
You can choose only one attribute in the Analyze field and add multiple attributes to the Explain by field. The Al feature will provide the impact of the Explain by attributes on the Analyze attribute. In some cases, the Al feature might not be able to provide any insight. This might happen when there are not enough rows to build a hypothesis.
Question 15 of 54
15. Question
You are creating a Power Bl report for service requests received in your call center. The support department wants to be able to perform ad hoc analysis on calls against the company product range and determine the drivers behind incoming call volumes.
You need to allow users to perform root cause analysis.
Which visual should you use?
Correct
You should use a Decomposition Tree visual. The Decomposition Tree visual is an Al-powered visual that allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition tree Visual allows you to analyze a business metric however you want. Users can determine the high and low values for measures and use these to derive their workload drivers.
You should not use a Key influencer visual. The Key influencers visual is an Al-powered visual that allows users to discover import factors that affect their metrics. The visual contrasts the relative importance of these factors. The Key influencers visual allows you to analyze a category within your data and discover how that influences other data. The Key influencers visual does not assist in ad hoc root cause analysis. You should not use a Waterfall visual. Waterfall charts are for understanding how an initial value is affected by a series of changes. The Waterfall visual does not assist in root cause analysis.
You should not use a Treemap visual. Treemaps are for displaying large amounts of hierarchical data understanding how an initial value is affected by a series of changes. The Waterfall visual does not assist in root cause analysis.
Incorrect
You should use a Decomposition Tree visual. The Decomposition Tree visual is an Al-powered visual that allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition tree Visual allows you to analyze a business metric however you want. Users can determine the high and low values for measures and use these to derive their workload drivers.
You should not use a Key influencer visual. The Key influencers visual is an Al-powered visual that allows users to discover import factors that affect their metrics. The visual contrasts the relative importance of these factors. The Key influencers visual allows you to analyze a category within your data and discover how that influences other data. The Key influencers visual does not assist in ad hoc root cause analysis. You should not use a Waterfall visual. Waterfall charts are for understanding how an initial value is affected by a series of changes. The Waterfall visual does not assist in root cause analysis.
You should not use a Treemap visual. Treemaps are for displaying large amounts of hierarchical data understanding how an initial value is affected by a series of changes. The Waterfall visual does not assist in root cause analysis.
Unattempted
You should use a Decomposition Tree visual. The Decomposition Tree visual is an Al-powered visual that allows you to drill down into your data across multiple dimensions. The Decomposition Tree visual is used to conduct root cause analysis. The Decomposition tree Visual allows you to analyze a business metric however you want. Users can determine the high and low values for measures and use these to derive their workload drivers.
You should not use a Key influencer visual. The Key influencers visual is an Al-powered visual that allows users to discover import factors that affect their metrics. The visual contrasts the relative importance of these factors. The Key influencers visual allows you to analyze a category within your data and discover how that influences other data. The Key influencers visual does not assist in ad hoc root cause analysis. You should not use a Waterfall visual. Waterfall charts are for understanding how an initial value is affected by a series of changes. The Waterfall visual does not assist in root cause analysis.
You should not use a Treemap visual. Treemaps are for displaying large amounts of hierarchical data understanding how an initial value is affected by a series of changes. The Waterfall visual does not assist in root cause analysis.
Question 16 of 54
16. Question
You create a report about product sales and customer churn rates.
You need to restrict the visual to show the top five products with the highest churn rates.
Solution: Create a measure of the top five products using the TOPN DAX function.
Does this solution meet the goal?
Correct
This solution meets the goal. The measure will return the top five records. However, the TOPN DAX function does not guarantee the order of the results.
Incorrect
This solution meets the goal. The measure will return the top five records. However, the TOPN DAX function does not guarantee the order of the results.
Unattempted
This solution meets the goal. The measure will return the top five records. However, the TOPN DAX function does not guarantee the order of the results.
Question 17 of 54
17. Question
You create a report about product sales and customer churn rates.
You need to restrict the visual to show the top five products with the highest churn rates.
Solution: Apply Top N filter on Visual (Visual level filter)
Does this solution meet the goal?
Correct
This solution meets the goal. You can apply a visual level filer with filter type set to TOP N to show the top five products in a visualization.
Incorrect
This solution meets the goal. You can apply a visual level filer with filter type set to TOP N to show the top five products in a visualization.
Unattempted
This solution meets the goal. You can apply a visual level filer with filter type set to TOP N to show the top five products in a visualization.
Question 18 of 54
18. Question
Which of the following strategies are recommended when designing the queries to import data from an OLTP-style database into a Power Bl Desktop project?
Correct
In the context of importing data from an OLTP database into Power BI Desktop, there are multiple recommended strategies:
C. Refactoring the imported tables into a star schema.
D. Denormalizing the data model to make it better suited for data analysis and reporting.
Here’s a breakdown of why these options are the best fit:
C. Star Schema: This is a specific type of denormalized data model that excels in dimensional analysis, the core functionality of Power BI. It separates factual data (measures) from dimensional data (attributes) and connects them strategically to improve query performance for analysis. Refactoring the imported tables into a star schema is the recommended strategy. A star schema, with a central fact table surrounded by dimension tables, is better suited for analytical processing and reporting in Power BI
D. Denormalization: OLTP databases prioritize efficient data manipulation through normalization. However, this can lead to slow queries in Power BI when analyzing data. Denormalization reduces the need for complex joins and improves query speed by strategically duplicating data for faster retrieval. Denormalizing the data model to make it better suited for data analysis and reporting is also recommended. This aligns with the concept of refactoring the OLTP tables into a star schema, which involves denormalizing the data.
The other options are not ideal for this scenario:
A. Multidimensional Cube: While cubes offer lightning-fast aggregation and OLAP analysis, they’re not the primary data structure in Power BI. Power BI is designed to work with relational data models. Â Refactoring the imported tables into a multidimensional cube is not the recommended approach, as Power BI primarily uses tabular data models, not multidimensional cubes.
B. Normalization: This is the opposite of what we need for Power BI. Normalization optimizes database performance for transactions, not analysis. Normalizing the data model is not recommended, as it would make the model less suitable for analytical queries and reporting in Power BI. OLTP databases are typically highly normalized, which is not optimal for analytical processing.
In conclusion, when working with OLTP data in Power BI Desktop, both refactoring into a star schema (C) and denormalizing the data model (D) are recommended strategies to optimize query performance and enhance the overall data analysis experience.
In the context of importing data from an OLTP database into Power BI Desktop, there are multiple recommended strategies:
C. Refactoring the imported tables into a star schema.
D. Denormalizing the data model to make it better suited for data analysis and reporting.
Here’s a breakdown of why these options are the best fit:
C. Star Schema: This is a specific type of denormalized data model that excels in dimensional analysis, the core functionality of Power BI. It separates factual data (measures) from dimensional data (attributes) and connects them strategically to improve query performance for analysis. Refactoring the imported tables into a star schema is the recommended strategy. A star schema, with a central fact table surrounded by dimension tables, is better suited for analytical processing and reporting in Power BI
D. Denormalization: OLTP databases prioritize efficient data manipulation through normalization. However, this can lead to slow queries in Power BI when analyzing data. Denormalization reduces the need for complex joins and improves query speed by strategically duplicating data for faster retrieval. Denormalizing the data model to make it better suited for data analysis and reporting is also recommended. This aligns with the concept of refactoring the OLTP tables into a star schema, which involves denormalizing the data.
The other options are not ideal for this scenario:
A. Multidimensional Cube: While cubes offer lightning-fast aggregation and OLAP analysis, they’re not the primary data structure in Power BI. Power BI is designed to work with relational data models. Â Refactoring the imported tables into a multidimensional cube is not the recommended approach, as Power BI primarily uses tabular data models, not multidimensional cubes.
B. Normalization: This is the opposite of what we need for Power BI. Normalization optimizes database performance for transactions, not analysis. Normalizing the data model is not recommended, as it would make the model less suitable for analytical queries and reporting in Power BI. OLTP databases are typically highly normalized, which is not optimal for analytical processing.
In conclusion, when working with OLTP data in Power BI Desktop, both refactoring into a star schema (C) and denormalizing the data model (D) are recommended strategies to optimize query performance and enhance the overall data analysis experience.
In the context of importing data from an OLTP database into Power BI Desktop, there are multiple recommended strategies:
C. Refactoring the imported tables into a star schema.
D. Denormalizing the data model to make it better suited for data analysis and reporting.
Here’s a breakdown of why these options are the best fit:
C. Star Schema: This is a specific type of denormalized data model that excels in dimensional analysis, the core functionality of Power BI. It separates factual data (measures) from dimensional data (attributes) and connects them strategically to improve query performance for analysis. Refactoring the imported tables into a star schema is the recommended strategy. A star schema, with a central fact table surrounded by dimension tables, is better suited for analytical processing and reporting in Power BI
D. Denormalization: OLTP databases prioritize efficient data manipulation through normalization. However, this can lead to slow queries in Power BI when analyzing data. Denormalization reduces the need for complex joins and improves query speed by strategically duplicating data for faster retrieval. Denormalizing the data model to make it better suited for data analysis and reporting is also recommended. This aligns with the concept of refactoring the OLTP tables into a star schema, which involves denormalizing the data.
The other options are not ideal for this scenario:
A. Multidimensional Cube: While cubes offer lightning-fast aggregation and OLAP analysis, they’re not the primary data structure in Power BI. Power BI is designed to work with relational data models. Â Refactoring the imported tables into a multidimensional cube is not the recommended approach, as Power BI primarily uses tabular data models, not multidimensional cubes.
B. Normalization: This is the opposite of what we need for Power BI. Normalization optimizes database performance for transactions, not analysis. Normalizing the data model is not recommended, as it would make the model less suitable for analytical queries and reporting in Power BI. OLTP databases are typically highly normalized, which is not optimal for analytical processing.
In conclusion, when working with OLTP data in Power BI Desktop, both refactoring into a star schema (C) and denormalizing the data model (D) are recommended strategies to optimize query performance and enhance the overall data analysis experience.
When you optimize a data model for Q&A, which factor is the most important?
Correct
Out of the provided options, the most important factor for data model optimization for Q&A is:
A. Column names
Here’s why the other options are not as crucial:
B. Data model size: While a large data model might require more resources to process, the size itself doesn’t significantly impact Q&A performance. As long as the data is well-structured and accessible, Q&A systems can handle data models of various sizes.
C. Row count: Similar to data model size, the number of rows doesn’t directly impact Q&A performance unless it’s extremely large and affects query processing speed.
D. DAX Formulas: While DAX formulas are relevant for specific platforms like Power BI, they are not the primary factor in general Q&A optimization.
Clear and descriptive column names are essential for Q&A functionality because they enable the system to understand the meaning and context of the data. Users formulate their questions in natural language, and the Q&A system relies on the column names to accurately map user queries to the relevant data elements. With well-defined column names, the system can:
Identify relevant columns: The Q&A system can accurately match keywords in user queries to descriptive column names, leading to better interpretation of the user’s intent.
Improve accuracy: More accurate mapping of user queries to columns ensures that the Q&A system retrieves the most relevant data, enhancing the quality of the responses.
Enhance user experience: Clear column names make it easier for users to understand the data and formulate better questions, leading to a more productive and satisfying experience.
Therefore, focusing on clear and well-organized column names is the most critical aspect of data model optimization for Q&A systems.
Incorrect
Out of the provided options, the most important factor for data model optimization for Q&A is:
A. Column names
Here’s why the other options are not as crucial:
B. Data model size: While a large data model might require more resources to process, the size itself doesn’t significantly impact Q&A performance. As long as the data is well-structured and accessible, Q&A systems can handle data models of various sizes.
C. Row count: Similar to data model size, the number of rows doesn’t directly impact Q&A performance unless it’s extremely large and affects query processing speed.
D. DAX Formulas: While DAX formulas are relevant for specific platforms like Power BI, they are not the primary factor in general Q&A optimization.
Clear and descriptive column names are essential for Q&A functionality because they enable the system to understand the meaning and context of the data. Users formulate their questions in natural language, and the Q&A system relies on the column names to accurately map user queries to the relevant data elements. With well-defined column names, the system can:
Identify relevant columns: The Q&A system can accurately match keywords in user queries to descriptive column names, leading to better interpretation of the user’s intent.
Improve accuracy: More accurate mapping of user queries to columns ensures that the Q&A system retrieves the most relevant data, enhancing the quality of the responses.
Enhance user experience: Clear column names make it easier for users to understand the data and formulate better questions, leading to a more productive and satisfying experience.
Therefore, focusing on clear and well-organized column names is the most critical aspect of data model optimization for Q&A systems.
Unattempted
Out of the provided options, the most important factor for data model optimization for Q&A is:
A. Column names
Here’s why the other options are not as crucial:
B. Data model size: While a large data model might require more resources to process, the size itself doesn’t significantly impact Q&A performance. As long as the data is well-structured and accessible, Q&A systems can handle data models of various sizes.
C. Row count: Similar to data model size, the number of rows doesn’t directly impact Q&A performance unless it’s extremely large and affects query processing speed.
D. DAX Formulas: While DAX formulas are relevant for specific platforms like Power BI, they are not the primary factor in general Q&A optimization.
Clear and descriptive column names are essential for Q&A functionality because they enable the system to understand the meaning and context of the data. Users formulate their questions in natural language, and the Q&A system relies on the column names to accurately map user queries to the relevant data elements. With well-defined column names, the system can:
Identify relevant columns: The Q&A system can accurately match keywords in user queries to descriptive column names, leading to better interpretation of the user’s intent.
Improve accuracy: More accurate mapping of user queries to columns ensures that the Q&A system retrieves the most relevant data, enhancing the quality of the responses.
Enhance user experience: Clear column names make it easier for users to understand the data and formulate better questions, leading to a more productive and satisfying experience.
Therefore, focusing on clear and well-organized column names is the most critical aspect of data model optimization for Q&A systems.
Question 20 of 54
20. Question
What is true about using variables in DAX?
Correct
The statement that is true about using variables in DAX is:
A. Variables are created only one time in the current context.
Here’s why the other options are incorrect:
B. Variables must be defined inside return: While the VAR statement defining variables typically appears before the RETURN statement in a DAX measure, it’s not strictly enforced. Variables can be defined anywhere within the current context (e.g., within a single measure or calculated column).
C. Maximum of 5 variables can be created per formula: There’s no specific limit on the number of variables you can create in a single DAX formula. However, it’s generally recommended to use variables judiciously for readability and maintainability of your code. Using too many variables can make your formulas complex and difficult to understand.
Therefore, understanding that variables in DAX are defined only once within their current context is crucial for using them effectively in your formulas.
Incorrect
The statement that is true about using variables in DAX is:
A. Variables are created only one time in the current context.
Here’s why the other options are incorrect:
B. Variables must be defined inside return: While the VAR statement defining variables typically appears before the RETURN statement in a DAX measure, it’s not strictly enforced. Variables can be defined anywhere within the current context (e.g., within a single measure or calculated column).
C. Maximum of 5 variables can be created per formula: There’s no specific limit on the number of variables you can create in a single DAX formula. However, it’s generally recommended to use variables judiciously for readability and maintainability of your code. Using too many variables can make your formulas complex and difficult to understand.
Therefore, understanding that variables in DAX are defined only once within their current context is crucial for using them effectively in your formulas.
Unattempted
The statement that is true about using variables in DAX is:
A. Variables are created only one time in the current context.
Here’s why the other options are incorrect:
B. Variables must be defined inside return: While the VAR statement defining variables typically appears before the RETURN statement in a DAX measure, it’s not strictly enforced. Variables can be defined anywhere within the current context (e.g., within a single measure or calculated column).
C. Maximum of 5 variables can be created per formula: There’s no specific limit on the number of variables you can create in a single DAX formula. However, it’s generally recommended to use variables judiciously for readability and maintainability of your code. Using too many variables can make your formulas complex and difficult to understand.
Therefore, understanding that variables in DAX are defined only once within their current context is crucial for using them effectively in your formulas.
Question 21 of 54
21. Question
What are the reasons for which you might use calculated tables?
Correct
You can use calculated tables to create a table based on the result of a function/formula. For example, you can use calculated tables to union tables and perform different types of merge join.
Incorrect
You can use calculated tables to create a table based on the result of a function/formula. For example, you can use calculated tables to union tables and perform different types of merge join.
Unattempted
You can use calculated tables to create a table based on the result of a function/formula. For example, you can use calculated tables to union tables and perform different types of merge join.
Question 22 of 54
22. Question
You are creating a Power Bl report for products ordered by customers. You create a bar chart showing the number of units sold by product.
You need to configure the chart to show the average number of units sold per order.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
Correct
Here are two possible ways to achieve the goal of showing the average number of units sold per order in a Power BI report’s bar chart:
Option 1: Create a Measure using AVERAGE DAX function
Create a Measure: Go to the Modeling tab and select New Measure.
Define the Measure: In the formula bar, enter the following DAX formula:
Average Units Sold per Order = AVERAGEX(
Orders,
CALCULATE(SUM(Order[Units Sold]), SELECTEDORDERID)
)
This formula iterates through each order in the Orders table.
For each order, the CALCULATE function calculates the sum of units sold within the context of the current order (using SELECTEDORDERID).
The AVERAGEX function then calculates the average of these sums, effectively giving you the average units sold per order.
Replace Units Sold: In the chart’s Values section, replace the existing “Units Sold” field with the newly created “Average Units Sold per Order” measure.
Option 2: Right Click and Change Summarization to Average
Right-click on Units Sold: In the chart’s Values section, right-click on the “Units Sold” field.
Change Summarization: Select “Average” from the context menu.
This option directly applies the average aggregation to the “Units Sold” field within the chart itself.
Both methods achieve the same result: displaying the average number of units sold per order in the bar chart. The first option provides more flexibility as the measure can be reused in other calculations, while the second option is simpler and quicker to implement.
Incorrect
Here are two possible ways to achieve the goal of showing the average number of units sold per order in a Power BI report’s bar chart:
Option 1: Create a Measure using AVERAGE DAX function
Create a Measure: Go to the Modeling tab and select New Measure.
Define the Measure: In the formula bar, enter the following DAX formula:
Average Units Sold per Order = AVERAGEX(
Orders,
CALCULATE(SUM(Order[Units Sold]), SELECTEDORDERID)
)
This formula iterates through each order in the Orders table.
For each order, the CALCULATE function calculates the sum of units sold within the context of the current order (using SELECTEDORDERID).
The AVERAGEX function then calculates the average of these sums, effectively giving you the average units sold per order.
Replace Units Sold: In the chart’s Values section, replace the existing “Units Sold” field with the newly created “Average Units Sold per Order” measure.
Option 2: Right Click and Change Summarization to Average
Right-click on Units Sold: In the chart’s Values section, right-click on the “Units Sold” field.
Change Summarization: Select “Average” from the context menu.
This option directly applies the average aggregation to the “Units Sold” field within the chart itself.
Both methods achieve the same result: displaying the average number of units sold per order in the bar chart. The first option provides more flexibility as the measure can be reused in other calculations, while the second option is simpler and quicker to implement.
Unattempted
Here are two possible ways to achieve the goal of showing the average number of units sold per order in a Power BI report’s bar chart:
Option 1: Create a Measure using AVERAGE DAX function
Create a Measure: Go to the Modeling tab and select New Measure.
Define the Measure: In the formula bar, enter the following DAX formula:
Average Units Sold per Order = AVERAGEX(
Orders,
CALCULATE(SUM(Order[Units Sold]), SELECTEDORDERID)
)
This formula iterates through each order in the Orders table.
For each order, the CALCULATE function calculates the sum of units sold within the context of the current order (using SELECTEDORDERID).
The AVERAGEX function then calculates the average of these sums, effectively giving you the average units sold per order.
Replace Units Sold: In the chart’s Values section, replace the existing “Units Sold” field with the newly created “Average Units Sold per Order” measure.
Option 2: Right Click and Change Summarization to Average
Right-click on Units Sold: In the chart’s Values section, right-click on the “Units Sold” field.
Change Summarization: Select “Average” from the context menu.
This option directly applies the average aggregation to the “Units Sold” field within the chart itself.
Both methods achieve the same result: displaying the average number of units sold per order in the bar chart. The first option provides more flexibility as the measure can be reused in other calculations, while the second option is simpler and quicker to implement.
Question 23 of 54
23. Question
You create a Power Bl report containing a line chart that shows sales by month as shown in Exhibit 1 below.
Exhibit 1
You need to configure the visual as shown in Exhibit 2 below.
Exhibit 2
What should you do?
Correct
You should add a forecast in the Analytics pane. The forecasting feature is available for line charts in the Analytics pane. The Forecast feature generates projected future values with a confidence level. The black line in Exhibit 2 shows the predicted values and the grey shaded area indicates the upper and lower bound of possible future values for the confidence level specified.
You should not add an Average line in the Analytics pane. The Average line feature draws a straight line, typically horizontal, for the average of the values in the visual It does not forecast any values.
You should not add a trend line in the Analytics pane. The trend line feature draws a straight line, typically at an angle, showing the best fit of the values in the visual. It does not forecast any values.
You should not add a Play Axis to the visual. The Play Axis is an animation that is used with scatter charts to show how values change over time. It does not forecast any values.
Incorrect
You should add a forecast in the Analytics pane. The forecasting feature is available for line charts in the Analytics pane. The Forecast feature generates projected future values with a confidence level. The black line in Exhibit 2 shows the predicted values and the grey shaded area indicates the upper and lower bound of possible future values for the confidence level specified.
You should not add an Average line in the Analytics pane. The Average line feature draws a straight line, typically horizontal, for the average of the values in the visual It does not forecast any values.
You should not add a trend line in the Analytics pane. The trend line feature draws a straight line, typically at an angle, showing the best fit of the values in the visual. It does not forecast any values.
You should not add a Play Axis to the visual. The Play Axis is an animation that is used with scatter charts to show how values change over time. It does not forecast any values.
Unattempted
You should add a forecast in the Analytics pane. The forecasting feature is available for line charts in the Analytics pane. The Forecast feature generates projected future values with a confidence level. The black line in Exhibit 2 shows the predicted values and the grey shaded area indicates the upper and lower bound of possible future values for the confidence level specified.
You should not add an Average line in the Analytics pane. The Average line feature draws a straight line, typically horizontal, for the average of the values in the visual It does not forecast any values.
You should not add a trend line in the Analytics pane. The trend line feature draws a straight line, typically at an angle, showing the best fit of the values in the visual. It does not forecast any values.
You should not add a Play Axis to the visual. The Play Axis is an animation that is used with scatter charts to show how values change over time. It does not forecast any values.
Question 24 of 54
24. Question
You have a table that contains details for your product sales as shown in the below exhibit.
The salesperson is recorded on each sale. You have 1000 products with data spanning 30 years.
You create a Power Bl report with visuals that contain aggregations with the following visuals:
• a column chart with products in the axis, but there are too many product columns displayed
• a bar chart with the year of order in the axis, but there are too many bars displayed
• a pie chart with the quantity of products per order as the legend but, there are too many slices
You need to combine the data to make the visual more readable.
How should you combine the data? To answer, select the appropriate option for each action.
Correct
You should use grouping with the List type to combine distinct categories of data, such as products, in the column chart. Grouping of lists is used for categories of data where you need to combine distinct categories, or lists of values, into larger categories.
You should use binning to combine the year data in the bar chart. Binning is similar to grouping, but it is used for grouping continuous fields, such as numbers and dates.
You should use binning to combine numeric data in the pie chart Binning is similar to grouping, but it is used for grouping continuous fields, such as numbers and dates.
Incorrect
You should use grouping with the List type to combine distinct categories of data, such as products, in the column chart. Grouping of lists is used for categories of data where you need to combine distinct categories, or lists of values, into larger categories.
You should use binning to combine the year data in the bar chart. Binning is similar to grouping, but it is used for grouping continuous fields, such as numbers and dates.
You should use binning to combine numeric data in the pie chart Binning is similar to grouping, but it is used for grouping continuous fields, such as numbers and dates.
Unattempted
You should use grouping with the List type to combine distinct categories of data, such as products, in the column chart. Grouping of lists is used for categories of data where you need to combine distinct categories, or lists of values, into larger categories.
You should use binning to combine the year data in the bar chart. Binning is similar to grouping, but it is used for grouping continuous fields, such as numbers and dates.
You should use binning to combine numeric data in the pie chart Binning is similar to grouping, but it is used for grouping continuous fields, such as numbers and dates.
Question 25 of 54
25. Question
You use the Decomposition tree visual to analyze sales across different attributes, payment methods, and product lines, as shown in the below exhibit.
You need to create the visual. How should you complete the configuration? To answer, select the appropriate options for the setup menu.
Correct
You should use the Sales measure in the Analyze field and the payment method and product line measures in the Explain by field. Decomposition tree Al visuals allow you to analyze a measure across multiple dimension attributes, providing easier understanding of how sales are distributed between explain by attributes.
The exhibit shows the sales analysis, first by payment method and then by product line. You should not use payment method or product line in the Analyze field. The Analyze field in the Decomposition tree will take a measure or a quantitative value to be analyzed. Both payment method and product line are non-quantitative values. According to the exhibit, you first need to explain sales distribution across different payment methods and then how these sales are further distributed across each product line.
Incorrect
You should use the Sales measure in the Analyze field and the payment method and product line measures in the Explain by field. Decomposition tree Al visuals allow you to analyze a measure across multiple dimension attributes, providing easier understanding of how sales are distributed between explain by attributes.
The exhibit shows the sales analysis, first by payment method and then by product line. You should not use payment method or product line in the Analyze field. The Analyze field in the Decomposition tree will take a measure or a quantitative value to be analyzed. Both payment method and product line are non-quantitative values. According to the exhibit, you first need to explain sales distribution across different payment methods and then how these sales are further distributed across each product line.
Unattempted
You should use the Sales measure in the Analyze field and the payment method and product line measures in the Explain by field. Decomposition tree Al visuals allow you to analyze a measure across multiple dimension attributes, providing easier understanding of how sales are distributed between explain by attributes.
The exhibit shows the sales analysis, first by payment method and then by product line. You should not use payment method or product line in the Analyze field. The Analyze field in the Decomposition tree will take a measure or a quantitative value to be analyzed. Both payment method and product line are non-quantitative values. According to the exhibit, you first need to explain sales distribution across different payment methods and then how these sales are further distributed across each product line.
Question 26 of 54
26. Question
You create a Power Bl report and dashboard.
You need to allow users to add new visuals to Power Bl dashboards with minimal configuration.
What should you do?
Correct
You should use the View insights option on a visual on a dashboard. This opens the visual in focus mode. Related insight visuals are generated. Users can pin the insight card to the dashboard.
You should not add the Q&A visual to a report page and pin the page as a new dashboard. Although the Q&A visual can generate new visuals, users cannot pin these visuals to the dashboard.
You should not add the Q&A button to a report page and pin the page as a new dashboard. The Q&A button launches the Q&A explorer window. Although the Q&A explorer can generate new visuals, users cannot pin these visuals to the dashboard.
You should not enable the Q&A option in Page information on the report page. The Q&A option on the report page allows Q&A to use the page as an answer. It does not allow visuals to be added to the dashboard.
Incorrect
You should use the View insights option on a visual on a dashboard. This opens the visual in focus mode. Related insight visuals are generated. Users can pin the insight card to the dashboard.
You should not add the Q&A visual to a report page and pin the page as a new dashboard. Although the Q&A visual can generate new visuals, users cannot pin these visuals to the dashboard.
You should not add the Q&A button to a report page and pin the page as a new dashboard. The Q&A button launches the Q&A explorer window. Although the Q&A explorer can generate new visuals, users cannot pin these visuals to the dashboard.
You should not enable the Q&A option in Page information on the report page. The Q&A option on the report page allows Q&A to use the page as an answer. It does not allow visuals to be added to the dashboard.
Unattempted
You should use the View insights option on a visual on a dashboard. This opens the visual in focus mode. Related insight visuals are generated. Users can pin the insight card to the dashboard.
You should not add the Q&A visual to a report page and pin the page as a new dashboard. Although the Q&A visual can generate new visuals, users cannot pin these visuals to the dashboard.
You should not add the Q&A button to a report page and pin the page as a new dashboard. The Q&A button launches the Q&A explorer window. Although the Q&A explorer can generate new visuals, users cannot pin these visuals to the dashboard.
You should not enable the Q&A option in Page information on the report page. The Q&A option on the report page allows Q&A to use the page as an answer. It does not allow visuals to be added to the dashboard.
Question 27 of 54
27. Question
You are building Power Bl dashboards using a dataset shared with you. The data is unfamiliar to you and you do not know which visualizations to create.
You need to use the Quick Insights feature to help you build your report.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. The Quick insights feature is available in Power Bl Desktop.
2. The Quick insights feature requires that the storage mode on the data source is set to DirectQuery.
3. The Quick insights feature can discover the overall trends in a time series.
Correct
The Quick insights feature is only available in the Power Bl web service. It is not available in Power Bl Desktop.
The Quick insights feature requires that the storage mode is set to Import. The Quick insights feature does not work with DirectQuery; it only works with data that is imported into Power BI.
The Quick insights feature can find several types of insights. One of the insights is Overall trends in time series. Insights detects upward or downward trends in your time series data.
Incorrect
The Quick insights feature is only available in the Power Bl web service. It is not available in Power Bl Desktop.
The Quick insights feature requires that the storage mode is set to Import. The Quick insights feature does not work with DirectQuery; it only works with data that is imported into Power BI.
The Quick insights feature can find several types of insights. One of the insights is Overall trends in time series. Insights detects upward or downward trends in your time series data.
Unattempted
The Quick insights feature is only available in the Power Bl web service. It is not available in Power Bl Desktop.
The Quick insights feature requires that the storage mode is set to Import. The Quick insights feature does not work with DirectQuery; it only works with data that is imported into Power BI.
The Quick insights feature can find several types of insights. One of the insights is Overall trends in time series. Insights detects upward or downward trends in your time series data.
Question 28 of 54
28. Question
Which of the following types of real-time datasets in Power Bl always store their data in Azure SQL Database?
Correct
Out of the three options, only Push Datasets store their data in Azure SQL Database in Power BI.
Here’s a breakdown of each type:
Streaming Datasets: As the name suggests, these datasets receive data in a continuous stream. They do not store the data permanently in Azure SQL Database. Instead, they store the data in a temporary cache within the Power BI service for a short duration to support real-time visualizations.
Push Datasets: This type allows data to be pushed from external sources to the Power BI service. When a Push Dataset is created, the Power BI service automatically creates a new database within the service to store the data. This database is different from Azure SQL Database and resides solely within the Power BI service environment.
Hybrid Datasets:Â These datasets combine the functionality of both imported and live data sources. They can include data from various sources, including Azure SQL Database, but the data within the Power BI service itself is not necessarily stored in Azure SQL Database.
Therefore, Push Datasets are the only type that leverage an Azure SQL Database-like environment within the Power BI service to store their data for real-time access.
Out of the three options, only Push Datasets store their data in Azure SQL Database in Power BI.
Here’s a breakdown of each type:
Streaming Datasets: As the name suggests, these datasets receive data in a continuous stream. They do not store the data permanently in Azure SQL Database. Instead, they store the data in a temporary cache within the Power BI service for a short duration to support real-time visualizations.
Push Datasets: This type allows data to be pushed from external sources to the Power BI service. When a Push Dataset is created, the Power BI service automatically creates a new database within the service to store the data. This database is different from Azure SQL Database and resides solely within the Power BI service environment.
Hybrid Datasets:Â These datasets combine the functionality of both imported and live data sources. They can include data from various sources, including Azure SQL Database, but the data within the Power BI service itself is not necessarily stored in Azure SQL Database.
Therefore, Push Datasets are the only type that leverage an Azure SQL Database-like environment within the Power BI service to store their data for real-time access.
Out of the three options, only Push Datasets store their data in Azure SQL Database in Power BI.
Here’s a breakdown of each type:
Streaming Datasets: As the name suggests, these datasets receive data in a continuous stream. They do not store the data permanently in Azure SQL Database. Instead, they store the data in a temporary cache within the Power BI service for a short duration to support real-time visualizations.
Push Datasets: This type allows data to be pushed from external sources to the Power BI service. When a Push Dataset is created, the Power BI service automatically creates a new database within the service to store the data. This database is different from Azure SQL Database and resides solely within the Power BI service environment.
Hybrid Datasets:Â These datasets combine the functionality of both imported and live data sources. They can include data from various sources, including Azure SQL Database, but the data within the Power BI service itself is not necessarily stored in Azure SQL Database.
Therefore, Push Datasets are the only type that leverage an Azure SQL Database-like environment within the Power BI service to store their data for real-time access.
You need to assign the appropriate workspace roles to co-workers to perform certain tasks. You must use the lowest permission level necessary to accomplish the tasks.
Which roles should you use? To answer, select the appropriate option.
“To publish apps”
Correct
You should assign the member role to users so they are able to publish apps. The member role allows you to publish or update an app.
Incorrect
You should assign the member role to users so they are able to publish apps. The member role allows you to publish or update an app.
Unattempted
You should assign the member role to users so they are able to publish apps. The member role allows you to publish or update an app.
Question 30 of 54
30. Question
You have a Power Bl dataset that consists of a fact table and the market dimension tables as shown in the exhibit. The fact table has 25,000 records. The market table has four records corresponding to business areas, MarketA, MarketB, MarketC, and MarketD.
You create a Power Bl report containing visualizations for this data.
You need to configure Power Bl so that users can only see the data for the business area they belong to.
Which five actions should you perform in sequence? To answer, select the appropriate list of actions.
Correct
You should perform the following actions in order:
1. Create roles in Power Bl Desktop.
2. Select the dimension table.
3. Add a DAX expression to filter the data using market.
4. Publish to Power Bl service.
5. Assign each user to a role.
First, you should create a role for each business area in Power Bl Desktop. You must create roles before any of the other steps.
Next, you should select the dimension table named Market. Filters provide better performance if the filter is defined on the dimension table.
Then, you should add a DAX expression to filter the data. You should match the filter to the business area, MarketA, MarketB, MarketC, or MarketD. The DAX filter expression will be written like [Market] = “MarketA”. Then, you should publish to the Power Bl service. You must publish after defining the roles and filters. You cannot assign users to roles in Power Bl Desktop, you can only assign users to roles in Power Bl Service.
Finally, you should assign each user to a role in Power Bl Service.
You should not select the fact table. The filter expression should be created on the dimension table.
You should not add a DAX expression to filter the data using userprincipalname. The data in the fact table or the dimension tables does not have a user email address to match to userprincipalname. The userprincipalname function always returns the user in the format of their email address.
Incorrect
You should perform the following actions in order:
1. Create roles in Power Bl Desktop.
2. Select the dimension table.
3. Add a DAX expression to filter the data using market.
4. Publish to Power Bl service.
5. Assign each user to a role.
First, you should create a role for each business area in Power Bl Desktop. You must create roles before any of the other steps.
Next, you should select the dimension table named Market. Filters provide better performance if the filter is defined on the dimension table.
Then, you should add a DAX expression to filter the data. You should match the filter to the business area, MarketA, MarketB, MarketC, or MarketD. The DAX filter expression will be written like [Market] = “MarketA”. Then, you should publish to the Power Bl service. You must publish after defining the roles and filters. You cannot assign users to roles in Power Bl Desktop, you can only assign users to roles in Power Bl Service.
Finally, you should assign each user to a role in Power Bl Service.
You should not select the fact table. The filter expression should be created on the dimension table.
You should not add a DAX expression to filter the data using userprincipalname. The data in the fact table or the dimension tables does not have a user email address to match to userprincipalname. The userprincipalname function always returns the user in the format of their email address.
Unattempted
You should perform the following actions in order:
1. Create roles in Power Bl Desktop.
2. Select the dimension table.
3. Add a DAX expression to filter the data using market.
4. Publish to Power Bl service.
5. Assign each user to a role.
First, you should create a role for each business area in Power Bl Desktop. You must create roles before any of the other steps.
Next, you should select the dimension table named Market. Filters provide better performance if the filter is defined on the dimension table.
Then, you should add a DAX expression to filter the data. You should match the filter to the business area, MarketA, MarketB, MarketC, or MarketD. The DAX filter expression will be written like [Market] = “MarketA”. Then, you should publish to the Power Bl service. You must publish after defining the roles and filters. You cannot assign users to roles in Power Bl Desktop, you can only assign users to roles in Power Bl Service.
Finally, you should assign each user to a role in Power Bl Service.
You should not select the fact table. The filter expression should be created on the dimension table.
You should not add a DAX expression to filter the data using userprincipalname. The data in the fact table or the dimension tables does not have a user email address to match to userprincipalname. The userprincipalname function always returns the user in the format of their email address.
Question 31 of 54
31. Question
You create a new workspace named Department and publish your Power Bl report to this workspace.
You need to distribute a report among the executives without giving them direct access to the workspace.
Which four options are essential for an app to be published for the first time? Each correct answer presents part of the solution.
Correct
You should perform the following actions:
• Select the Department workspace
• Click the Publish App button.
• In the Setup tab, provide the App name and description.
• In the Permissions tab, specify the users who can view the app.
The workspace is newly created and no one is assigned any permissions to this workspace. The workspace needs to have content, only then will it show the Publish App button.
You should first select the workspace named Department and click the Publish App button. If you have enabled the new look of Power Bl Service, you will be able to see the Create App button. If not, you will see the Publish App button.
You also need to provide an App name and description in the Setup tab. You do not need to provide anything in the navigation tab because the report name is already filled.
You need to provide in the permissions tab the email addresses of the users you want to share this app with. You should not use the Click Update App button. This button will only appear if you have already published the app. As mentioned earlier, since we are publishing an app for the first time, we can only see the Publish app button. The Update App button allows you to update the content of an already published app.
You should not use the Under Navigation tab to provide the report name option. By default, the navigation tab picks a name that is the same as your report name in the workspace. This step is not essential. You can change this name if you want this is an optional step.
Incorrect
You should perform the following actions:
• Select the Department workspace
• Click the Publish App button.
• In the Setup tab, provide the App name and description.
• In the Permissions tab, specify the users who can view the app.
The workspace is newly created and no one is assigned any permissions to this workspace. The workspace needs to have content, only then will it show the Publish App button.
You should first select the workspace named Department and click the Publish App button. If you have enabled the new look of Power Bl Service, you will be able to see the Create App button. If not, you will see the Publish App button.
You also need to provide an App name and description in the Setup tab. You do not need to provide anything in the navigation tab because the report name is already filled.
You need to provide in the permissions tab the email addresses of the users you want to share this app with. You should not use the Click Update App button. This button will only appear if you have already published the app. As mentioned earlier, since we are publishing an app for the first time, we can only see the Publish app button. The Update App button allows you to update the content of an already published app.
You should not use the Under Navigation tab to provide the report name option. By default, the navigation tab picks a name that is the same as your report name in the workspace. This step is not essential. You can change this name if you want this is an optional step.
Unattempted
You should perform the following actions:
• Select the Department workspace
• Click the Publish App button.
• In the Setup tab, provide the App name and description.
• In the Permissions tab, specify the users who can view the app.
The workspace is newly created and no one is assigned any permissions to this workspace. The workspace needs to have content, only then will it show the Publish App button.
You should first select the workspace named Department and click the Publish App button. If you have enabled the new look of Power Bl Service, you will be able to see the Create App button. If not, you will see the Publish App button.
You also need to provide an App name and description in the Setup tab. You do not need to provide anything in the navigation tab because the report name is already filled.
You need to provide in the permissions tab the email addresses of the users you want to share this app with. You should not use the Click Update App button. This button will only appear if you have already published the app. As mentioned earlier, since we are publishing an app for the first time, we can only see the Publish app button. The Update App button allows you to update the content of an already published app.
You should not use the Under Navigation tab to provide the report name option. By default, the navigation tab picks a name that is the same as your report name in the workspace. This step is not essential. You can change this name if you want this is an optional step.
Question 32 of 54
32. Question
You create a Power Bl workspace in the new workspace experience.
You need to permit the following groups of users to access the workspace to perform specific actions on workspace content. You must use the principle of least privilege.
• Users in GroupA must be able to publish Power Bl apps.
• Users in GroupB must be able to publish Power Bl reports.
• UserC must be able to build reports using the workspace datasets in different workspaces without any additional configuration.
Which workspace role should you assign to the users? To answer, select the appropriate role to the below-stated user.
“Users in GroupA”
Correct
A user with the Member role can publish and update an app. The Contributor role cannot publish an app.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
You should not use the Viewer role. The Viewer role has read access to the content in the workspace. A user with the Viewer role cannot create content or publish content in the workspace.
Incorrect
A user with the Member role can publish and update an app. The Contributor role cannot publish an app.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
You should not use the Viewer role. The Viewer role has read access to the content in the workspace. A user with the Viewer role cannot create content or publish content in the workspace.
Unattempted
A user with the Member role can publish and update an app. The Contributor role cannot publish an app.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
You should not use the Viewer role. The Viewer role has read access to the content in the workspace. A user with the Viewer role cannot create content or publish content in the workspace.
Question 33 of 54
33. Question
Which of the following resources are automatically provisioned when you create a new app workspace in the Power Bl Service?
Correct
The new workspace experience changes the relationship between Power Bl workspaces and Office 365 groups. You aren’t automatically be creating an Offce 365 group every time you create one of the new workspaces.
Incorrect
The new workspace experience changes the relationship between Power Bl workspaces and Office 365 groups. You aren’t automatically be creating an Offce 365 group every time you create one of the new workspaces.
Unattempted
The new workspace experience changes the relationship between Power Bl workspaces and Office 365 groups. You aren’t automatically be creating an Offce 365 group every time you create one of the new workspaces.
Question 34 of 54
34. Question
You create datasets, reports, and dashboards in Power Bl.
You need to make these assets easily available to other users and indicate how they should be used. You need to configure the assets to meet the requirements.
To answer, select the appropriate option for the below requirement.
“Configure a dashboard so that the sensitivity of its data is visible”
Correct
Data classification tags can be added to dashboards. These tags appear next to the dashboard name or on the dashboard tile.
Incorrect
Data classification tags can be added to dashboards. These tags appear next to the dashboard name or on the dashboard tile.
Unattempted
Data classification tags can be added to dashboards. These tags appear next to the dashboard name or on the dashboard tile.
Question 35 of 54
35. Question
You create a Power Bl workspace in the new workspace experience.
You need to permit the following groups of users to access the workspace to perform specific actions on workspace content. You must use the principle of least privilege.
• Users in GroupA must be able to publish Power Bl apps.
• Users in GroupB must be able to publish Power Bl reports.
• UserC must be able to build reports using the workspace datasets in different workspaces without any additional configuration.
Which workspace role should you assign to the users? To answer, select the appropriate role for the below-stated user.
“UserC”
Correct
Users in a workspace with the Contributor role automatically have Build permission for datasets in the workspace. The Build permission means that they can build new content, such as a report, on the dataset outside of the workspace.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
Incorrect
Users in a workspace with the Contributor role automatically have Build permission for datasets in the workspace. The Build permission means that they can build new content, such as a report, on the dataset outside of the workspace.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
Unattempted
Users in a workspace with the Contributor role automatically have Build permission for datasets in the workspace. The Build permission means that they can build new content, such as a report, on the dataset outside of the workspace.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
Question 36 of 54
36. Question
Overview:
Company1 is a manufacturing company that is adopting Power BI for its analytics and insights requirements.
Power Bl Desktop and Power Bl Service will be used to generate reports and dashboards for Operations, Human Resources, Sales, and Finance departments.
Management are concerned over access to data and reports.
You need to plan the setup, security and administration of the Power Bl environment.
You will run a pilot with the Sales department to verify your proposed configuration before deploying the other departments.
Existing environment:
Company1 has Office 365 deployed.
Company1 uses Azure AD Security groups for access control.
Office 365 Groups are used for collaboration.
Data Sources:
Excel spreadsheets will be the source of data for the pilot.
There are other data sources that will be used after the pilot:
SQL Server
SharePoint lists
JSON files
Zendesk
Report development:
There is a team of business intelligence analysts who will create the reports and dashboards.
This team will load, transform, and cleanse the data. They will then model the data and create datasets for use across the organization.
Changes made by the developers should be automatically deployed to users.
Security requirements:
Developers should not have access to production data.
Developers should not have access to reports and dashboards in production.
Business users should not have access to developer data or assets.
Board members must be able to access select reports and dashboards.
Excel files used in reports should only be accessible from their workspace.
Users must only have access to the data in their department.
Users in the Sales department must only have access to data in their territory.
The reports and dashboards for a department should only be accessible by business users in the same department.
Business users should not be able to edit the reports and dashboards. Business users should not be able to create new reports or dashboards.
Board members are not part of the company network.
Requirement:
How should you configure Power Bl workspaces to meet the security requirements for management of reports and dashboards?
Correct
When you create a deployment pipeline and select a workspace, Power Bl automatically creates the other two environments, Testing and Production, when you deploy your content. Each workspace in the pipeline has different users so developers will not have access to the assets in the testing or productions workspaces. You can define dataset and data source rules to change the data source for each workspace. This will remove the need for developers to require access to the production data. Deployment pipelines require Power Bl Premium capacity. The Power Bl Admin defines which pipeline stages are available. You should not have a single workspace and publish an app. An app is part of the workspace it is published from. By publishing an app, the developers will have access to the reports and dashboards. There will be no separation between developers and production data.
You should not have a single workspace and share the reports and dashboards. The developers will have access to the reports and dashboards. There will be no separation between developers and production data.
You should not have two workspaces and share the dataset from development to production. The developers will have access to the reports and dashboards. Developer will have access to production data.
Incorrect
When you create a deployment pipeline and select a workspace, Power Bl automatically creates the other two environments, Testing and Production, when you deploy your content. Each workspace in the pipeline has different users so developers will not have access to the assets in the testing or productions workspaces. You can define dataset and data source rules to change the data source for each workspace. This will remove the need for developers to require access to the production data. Deployment pipelines require Power Bl Premium capacity. The Power Bl Admin defines which pipeline stages are available. You should not have a single workspace and publish an app. An app is part of the workspace it is published from. By publishing an app, the developers will have access to the reports and dashboards. There will be no separation between developers and production data.
You should not have a single workspace and share the reports and dashboards. The developers will have access to the reports and dashboards. There will be no separation between developers and production data.
You should not have two workspaces and share the dataset from development to production. The developers will have access to the reports and dashboards. Developer will have access to production data.
Unattempted
When you create a deployment pipeline and select a workspace, Power Bl automatically creates the other two environments, Testing and Production, when you deploy your content. Each workspace in the pipeline has different users so developers will not have access to the assets in the testing or productions workspaces. You can define dataset and data source rules to change the data source for each workspace. This will remove the need for developers to require access to the production data. Deployment pipelines require Power Bl Premium capacity. The Power Bl Admin defines which pipeline stages are available. You should not have a single workspace and publish an app. An app is part of the workspace it is published from. By publishing an app, the developers will have access to the reports and dashboards. There will be no separation between developers and production data.
You should not have a single workspace and share the reports and dashboards. The developers will have access to the reports and dashboards. There will be no separation between developers and production data.
You should not have two workspaces and share the dataset from development to production. The developers will have access to the reports and dashboards. Developer will have access to production data.
Question 37 of 54
37. Question
You need to assign the appropriate workspace roles to co-workers to perform certain tasks. You must use the lowest permission level necessary to accomplish the tasks.
Which roles should you use? To answer, select the appropriate option.
“To read workspace reports”
Correct
You should assign the viewer role to users to provide read-only access to reports. The viewer role allows read-only access to the workspace.
Incorrect
You should assign the viewer role to users to provide read-only access to reports. The viewer role allows read-only access to the workspace.
Unattempted
You should assign the viewer role to users to provide read-only access to reports. The viewer role allows read-only access to the workspace.
Question 38 of 54
38. Question
You have Power Bl Premium with allocated capacity.
You import data into Power Bl from a webpage and create a Power Bl report. You need to ensure that the data for your visuals that is extracted from the web page is up to date.
You decide to automate the updating process from the data source. How and where should you configure the dataset to meet the requirements?
“The storage mode that requires a refresh schedule to be configured..”
Correct
Only the Import storage mode requires a data source refresh. DirectQuery and LiveConnect datasets query the data source directly when a user accesses a report or visual.
Incorrect
Only the Import storage mode requires a data source refresh. DirectQuery and LiveConnect datasets query the data source directly when a user accesses a report or visual.
Unattempted
Only the Import storage mode requires a data source refresh. DirectQuery and LiveConnect datasets query the data source directly when a user accesses a report or visual.
Question 39 of 54
39. Question
Data in your organization must be classified as either None, Personal, or Confidential.
You need to protect confidential data in your Power BI reports within Power Bl and when data is exported from Power BI. Information protection has been enabled on your Power Bl tenant.
Which three actions should you perform in sequence? To answer, select the appropriate list of actions.
Correct
You should perform the following steps in order:
1. Create and publish labels in Microsoft 365.
2. Open the settings pane on the Power Bl report.
3. Select the sensitivity label.
First, you should create and publish labels in Microsoft 365. Power Bl uses the sensitivity labels created in Microsoft 365. You must create and publish the labels before they can be used in Power Bl. Information Protection must also be enabled in the Power Bl Admin Portal.
Next, you should open the settings pane on the Power Bl report. You can set the sensitivity label on datasets, reports, and dashboards. Data exported from the report to Excel, PowerPoint, or PDF will have the sensitivity label included in the file.
Finally, you should select the sensitivity label. You need to choose the Confidential label for the report. You should not open the Tenant settings in Power Bl Admin Portal. Information protection is enabled in the Power Bl Admin Portal, but the labels are created in Microsoft 365, and labels are applied to Power Bl content.
You should not add a data classification tag. Data classification tags are used on reports and dashboards and are used to raise awareness about the sensitivity of data with those using the reports and dashboards. Data classification tags can be added to dashboards. These tags appear next to the dashboard name or on the dashboard tile. However, data classification tags do not protect the data outside of Power BI. You should not set Export data to None. Setting Export data to None will prevent any summary or underlying data from being exported at all. Users still need to export data.
Incorrect
You should perform the following steps in order:
1. Create and publish labels in Microsoft 365.
2. Open the settings pane on the Power Bl report.
3. Select the sensitivity label.
First, you should create and publish labels in Microsoft 365. Power Bl uses the sensitivity labels created in Microsoft 365. You must create and publish the labels before they can be used in Power Bl. Information Protection must also be enabled in the Power Bl Admin Portal.
Next, you should open the settings pane on the Power Bl report. You can set the sensitivity label on datasets, reports, and dashboards. Data exported from the report to Excel, PowerPoint, or PDF will have the sensitivity label included in the file.
Finally, you should select the sensitivity label. You need to choose the Confidential label for the report. You should not open the Tenant settings in Power Bl Admin Portal. Information protection is enabled in the Power Bl Admin Portal, but the labels are created in Microsoft 365, and labels are applied to Power Bl content.
You should not add a data classification tag. Data classification tags are used on reports and dashboards and are used to raise awareness about the sensitivity of data with those using the reports and dashboards. Data classification tags can be added to dashboards. These tags appear next to the dashboard name or on the dashboard tile. However, data classification tags do not protect the data outside of Power BI. You should not set Export data to None. Setting Export data to None will prevent any summary or underlying data from being exported at all. Users still need to export data.
Unattempted
You should perform the following steps in order:
1. Create and publish labels in Microsoft 365.
2. Open the settings pane on the Power Bl report.
3. Select the sensitivity label.
First, you should create and publish labels in Microsoft 365. Power Bl uses the sensitivity labels created in Microsoft 365. You must create and publish the labels before they can be used in Power Bl. Information Protection must also be enabled in the Power Bl Admin Portal.
Next, you should open the settings pane on the Power Bl report. You can set the sensitivity label on datasets, reports, and dashboards. Data exported from the report to Excel, PowerPoint, or PDF will have the sensitivity label included in the file.
Finally, you should select the sensitivity label. You need to choose the Confidential label for the report. You should not open the Tenant settings in Power Bl Admin Portal. Information protection is enabled in the Power Bl Admin Portal, but the labels are created in Microsoft 365, and labels are applied to Power Bl content.
You should not add a data classification tag. Data classification tags are used on reports and dashboards and are used to raise awareness about the sensitivity of data with those using the reports and dashboards. Data classification tags can be added to dashboards. These tags appear next to the dashboard name or on the dashboard tile. However, data classification tags do not protect the data outside of Power BI. You should not set Export data to None. Setting Export data to None will prevent any summary or underlying data from being exported at all. Users still need to export data.
Question 40 of 54
40. Question
You create a Power Bl workspace in the new workspace experience.
You need to permit the following groups of users to access the workspace to perform specific actions on workspace content. You must use the principle of least privilege.
• Users in GroupA must be able to publish Power Bl apps.
• Users in GroupB must be able to publish Power Bl reports.
• UserC must be able to build reports using the workspace datasets in different workspaces without any additional configuration.
Which workspace role should you assign to the users? To answer, select the appropriate role to the below-stated user.
“Users in GroupB”
Correct
A user with the Contributor role can create, update, and publish content including reports within a workspace. The Member role also has these privileges, but the Member role has additional privileges that are not required to publish a report.
Users in a workspace with the Contributor role automatically have Build permission for datasets in the workspace. The Build permission means that they can build new content, such as a report, on the dataset outside of the workspace.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
Incorrect
A user with the Contributor role can create, update, and publish content including reports within a workspace. The Member role also has these privileges, but the Member role has additional privileges that are not required to publish a report.
Users in a workspace with the Contributor role automatically have Build permission for datasets in the workspace. The Build permission means that they can build new content, such as a report, on the dataset outside of the workspace.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
Unattempted
A user with the Contributor role can create, update, and publish content including reports within a workspace. The Member role also has these privileges, but the Member role has additional privileges that are not required to publish a report.
Users in a workspace with the Contributor role automatically have Build permission for datasets in the workspace. The Build permission means that they can build new content, such as a report, on the dataset outside of the workspace.
You should not use the Admin role. Users with Admin role have full privileges on the workspace. The principle of least privileges means that if there is a role with fewer privileges that fulfills the requirements, that role should be used instead.
Question 41 of 54
41. Question
You implement a security role named EmployeeAddress to filter employees based on their login account in the Power Bl service.
You need to add 100 users to this role so they can view a report based on row-level security settings.
Which two actions should you perform? Each correct answer presents part of the solution.
Correct
You should create a security group in Active Directory and assign users to this group. Once the security group is created, you should add that security group to the EmployeeAddress security role. You can validate row-level security using the Test as role option. You can provide another user’s email address to verify what they can see in the dashboard.
You should not create a group in Power Bl. When you create a classic workspace, Power Bl creates a group in Office 365. You can assign users to these groups, but these groups are not supported for row-level security (RLS) role assignments. Office 365 groups are now shown as Microsoft 365 or M365 groups.
Incorrect
You should create a security group in Active Directory and assign users to this group. Once the security group is created, you should add that security group to the EmployeeAddress security role. You can validate row-level security using the Test as role option. You can provide another user’s email address to verify what they can see in the dashboard.
You should not create a group in Power Bl. When you create a classic workspace, Power Bl creates a group in Office 365. You can assign users to these groups, but these groups are not supported for row-level security (RLS) role assignments. Office 365 groups are now shown as Microsoft 365 or M365 groups.
Unattempted
You should create a security group in Active Directory and assign users to this group. Once the security group is created, you should add that security group to the EmployeeAddress security role. You can validate row-level security using the Test as role option. You can provide another user’s email address to verify what they can see in the dashboard.
You should not create a group in Power Bl. When you create a classic workspace, Power Bl creates a group in Office 365. You can assign users to these groups, but these groups are not supported for row-level security (RLS) role assignments. Office 365 groups are now shown as Microsoft 365 or M365 groups.
Question 42 of 54
42. Question
You have a data model as shown in the below exhibit for sales opportunity data.
Each salesperson has a sales manager. You create a Power Bl report for a sales team’s opportunities. Salespeople must only be able to see their own data. Sales managers must be able to see all data. You create a DAX measure to calculate the monthly commission amount on sales.
You need to configure row-level security (RLS) and create two roles named SalesPerson and SalesManager. Salespeople are assigned to the SalesPerson role. Sales managers are assigned to the SalesManager role.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Setting the DAX Filter expression on the SalesPerson role to [Email Address] = userprincipalname() allows salespeople to only view their own data.
2. Salespeople will be able to see their commission amount.
3. Setting the DAX Filter expression on the SalesManager role to FALSE() allows Sales managers to view all data.
Correct
Setting the DAX Filter expression on the SalesPerson role to [Email Address] = userprincipalname() allows salespeople to only view their own data. The DAX userprincipalname() function returns the email address of the user. When using the dynamic method for RLS, the system will compare the user’s email address with the email address in the Employee table. The relationship between Employee table and the Fact table will restrict the rows to those for that employee. You can validate whether a user can only see their own data in both Power Bl Desktop and Power Bl service. You can use View As role in Power Bl Desktop and Test As role in Power Bl service to test RLS. You will need to enter the email address of the user to simulate their access.
Salespeople will be able to see their commission amount. You cannot use RLS to limit the measures that salespeople can see. RLS filters rows only. RLS cannot be configured to restrict access to tables, columns, or measures.
Setting the DAX Filter expression on the SalesManager role to FALSE() does not allow users assigned to this role to view all data. Setting the DAX Filter expression to FALSE() will return no rows. You should set the DAX Filter expression to TRUE().
Incorrect
Setting the DAX Filter expression on the SalesPerson role to [Email Address] = userprincipalname() allows salespeople to only view their own data. The DAX userprincipalname() function returns the email address of the user. When using the dynamic method for RLS, the system will compare the user’s email address with the email address in the Employee table. The relationship between Employee table and the Fact table will restrict the rows to those for that employee. You can validate whether a user can only see their own data in both Power Bl Desktop and Power Bl service. You can use View As role in Power Bl Desktop and Test As role in Power Bl service to test RLS. You will need to enter the email address of the user to simulate their access.
Salespeople will be able to see their commission amount. You cannot use RLS to limit the measures that salespeople can see. RLS filters rows only. RLS cannot be configured to restrict access to tables, columns, or measures.
Setting the DAX Filter expression on the SalesManager role to FALSE() does not allow users assigned to this role to view all data. Setting the DAX Filter expression to FALSE() will return no rows. You should set the DAX Filter expression to TRUE().
Unattempted
Setting the DAX Filter expression on the SalesPerson role to [Email Address] = userprincipalname() allows salespeople to only view their own data. The DAX userprincipalname() function returns the email address of the user. When using the dynamic method for RLS, the system will compare the user’s email address with the email address in the Employee table. The relationship between Employee table and the Fact table will restrict the rows to those for that employee. You can validate whether a user can only see their own data in both Power Bl Desktop and Power Bl service. You can use View As role in Power Bl Desktop and Test As role in Power Bl service to test RLS. You will need to enter the email address of the user to simulate their access.
Salespeople will be able to see their commission amount. You cannot use RLS to limit the measures that salespeople can see. RLS filters rows only. RLS cannot be configured to restrict access to tables, columns, or measures.
Setting the DAX Filter expression on the SalesManager role to FALSE() does not allow users assigned to this role to view all data. Setting the DAX Filter expression to FALSE() will return no rows. You should set the DAX Filter expression to TRUE().
Question 43 of 54
43. Question
You need to create Power Bl reports using multiple data sources. The reports are not up to date.
You need to discover which data source has stale data.
What should you do?
Correct
You should use the Lineage view feature. The Lineage view shows the flow of data from the dataset to the reports and dashboards. You can see when a dataset was last refreshed and the next scheduled refresh date and time.
You should not use the usage metrics report. This report shows the number of views of a report and who is viewing the report. It does not show when the data was last refreshed.
You should not download the PBIX file for the report. Downloading the report as a PBIX file allows you to view and edit the report in Power Bl Desktop. It will not inform you about the state of the data. You should not analyze in Excel. Analyze in Excel will create an Excel spreadsheet that you can open on your local computer with the data from the report. It will not inform you about the state of the data.
Incorrect
You should use the Lineage view feature. The Lineage view shows the flow of data from the dataset to the reports and dashboards. You can see when a dataset was last refreshed and the next scheduled refresh date and time.
You should not use the usage metrics report. This report shows the number of views of a report and who is viewing the report. It does not show when the data was last refreshed.
You should not download the PBIX file for the report. Downloading the report as a PBIX file allows you to view and edit the report in Power Bl Desktop. It will not inform you about the state of the data. You should not analyze in Excel. Analyze in Excel will create an Excel spreadsheet that you can open on your local computer with the data from the report. It will not inform you about the state of the data.
Unattempted
You should use the Lineage view feature. The Lineage view shows the flow of data from the dataset to the reports and dashboards. You can see when a dataset was last refreshed and the next scheduled refresh date and time.
You should not use the usage metrics report. This report shows the number of views of a report and who is viewing the report. It does not show when the data was last refreshed.
You should not download the PBIX file for the report. Downloading the report as a PBIX file allows you to view and edit the report in Power Bl Desktop. It will not inform you about the state of the data. You should not analyze in Excel. Analyze in Excel will create an Excel spreadsheet that you can open on your local computer with the data from the report. It will not inform you about the state of the data.
Question 44 of 54
44. Question
You have Power Bl Premium with allocated capacity.
You import data into Power Bl from a webpage and create a Power Bl report. You need to ensure that the data for your visuals that is extracted from the web page is up to date.
You decide to automate the updating process from the data source. How and where should you configure the dataset to meet the requirements?
“The number of time slots per day that can be configured in the refresh schedule..”
Correct
You can configure up to eight daily time slots if your dataset is on shared capacity or 48 times slots on Power Bl Premium.
Incorrect
You can configure up to eight daily time slots if your dataset is on shared capacity or 48 times slots on Power Bl Premium.
Unattempted
You can configure up to eight daily time slots if your dataset is on shared capacity or 48 times slots on Power Bl Premium.
Question 45 of 54
45. Question
You create datasets, reports, and dashboards in Power Bl.
You need to make these assets easily available to other users and indicate how they should be used. You need to configure the assets to meet the requirements.
To answer, select the appropriate option for the below requirement.
“List a report on the Power BI Home page”
Correct
Reports, dashboards, and apps can be featured. A report that has been featured will appear on the Power Bl Home page.
Incorrect
Reports, dashboards, and apps can be featured. A report that has been featured will appear on the Power Bl Home page.
Unattempted
Reports, dashboards, and apps can be featured. A report that has been featured will appear on the Power Bl Home page.
Question 46 of 54
46. Question
You are a data analyst at a company that uses Power Bl. The company has 12 departments. You have created a Power Bl report that shows data for the organization’s staff and training from the HR dataset. You have been asked to create the same report for each department.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
Correct
You can add a parameter to a report to make the report dynamic. Dynamic reports are valuable because a single report can be used for multiple purposes. By using parameters, you can reuse the same report for all departments.
You can also create a URL using a parameter that filters the report. You can specify the department in the QueryString for the URL and the report will show the data for the department. You can simply create a separate URL for each department.
You should not create a dataset for each department, copy the report, and use the report with the department dataset. This will duplicate work and effort both for the datasets and the reports.
You should not create a workspace for each department and add the report to the workspace. Creating a workspace does not affect the data retrieved. Workspaces are for collaboration in building reports and dashboards.
Incorrect
You can add a parameter to a report to make the report dynamic. Dynamic reports are valuable because a single report can be used for multiple purposes. By using parameters, you can reuse the same report for all departments.
You can also create a URL using a parameter that filters the report. You can specify the department in the QueryString for the URL and the report will show the data for the department. You can simply create a separate URL for each department.
You should not create a dataset for each department, copy the report, and use the report with the department dataset. This will duplicate work and effort both for the datasets and the reports.
You should not create a workspace for each department and add the report to the workspace. Creating a workspace does not affect the data retrieved. Workspaces are for collaboration in building reports and dashboards.
Unattempted
You can add a parameter to a report to make the report dynamic. Dynamic reports are valuable because a single report can be used for multiple purposes. By using parameters, you can reuse the same report for all departments.
You can also create a URL using a parameter that filters the report. You can specify the department in the QueryString for the URL and the report will show the data for the department. You can simply create a separate URL for each department.
You should not create a dataset for each department, copy the report, and use the report with the department dataset. This will duplicate work and effort both for the datasets and the reports.
You should not create a workspace for each department and add the report to the workspace. Creating a workspace does not affect the data retrieved. Workspaces are for collaboration in building reports and dashboards.
Question 47 of 54
47. Question
You have Power Bl Premium with allocated capacity.
You import data into Power Bl from a webpage and create a Power Bl report. You need to ensure that the data for your visuals that is extracted from the web page is up to date.
You decide to automate the updating process from the data source. How and where should you configure the dataset to meet the requirements?
“The tool where the refresh schedule is configured..”
Correct
The Scheduled refresh feature is only available in the Power Bl service, it is not available in Power Bl Desktop or Mobile. The Scheduled refresh feature in Power Bl Service allows you to define the frequency and time slots to refresh a particular dataset. You can configure up to eight daily time slots if your dataset is on shared capacity or 48 times slots on Power Bl Premium.
Incorrect
The Scheduled refresh feature is only available in the Power Bl service, it is not available in Power Bl Desktop or Mobile. The Scheduled refresh feature in Power Bl Service allows you to define the frequency and time slots to refresh a particular dataset. You can configure up to eight daily time slots if your dataset is on shared capacity or 48 times slots on Power Bl Premium.
Unattempted
The Scheduled refresh feature is only available in the Power Bl service, it is not available in Power Bl Desktop or Mobile. The Scheduled refresh feature in Power Bl Service allows you to define the frequency and time slots to refresh a particular dataset. You can configure up to eight daily time slots if your dataset is on shared capacity or 48 times slots on Power Bl Premium.
Question 48 of 54
48. Question
You need to assign the appropriate workspace roles to co-workers to perform certain tasks. You must use the lowest permission level necessary to accomplish the tasks.
Which roles should you use? To answer, select the appropriate option.
“To publish content to the workspace”
Correct
You should assign the contributor role to users so they are able to publish content to the workspace. The contributor role allows you to create and edit content in the workspace and publish content to the workspace.
You should not assign the admin role to users so they can publish content or apps. The admin role allows you to publish or update an app with additional privileges to delete the workspace.
Incorrect
You should assign the contributor role to users so they are able to publish content to the workspace. The contributor role allows you to create and edit content in the workspace and publish content to the workspace.
You should not assign the admin role to users so they can publish content or apps. The admin role allows you to publish or update an app with additional privileges to delete the workspace.
Unattempted
You should assign the contributor role to users so they are able to publish content to the workspace. The contributor role allows you to create and edit content in the workspace and publish content to the workspace.
You should not assign the admin role to users so they can publish content or apps. The admin role allows you to publish or update an app with additional privileges to delete the workspace.
Question 49 of 54
49. Question
Overview:
Company1 is a manufacturing company that is adopting Power BI for its analytics and insights requirements.
Power Bl Desktop and Power Bl Service will be used to generate reports and dashboards for Operations, Human Resources, Sales, and Finance departments.
Management are concerned over access to data and reports.
You need to plan the setup, security and administration of the Power Bl environment.
You will run a pilot with the Sales department to verify your proposed configuration before deploying the other departments.
Existing environment:
Company1 has Office 365 deployed.
Company1 uses Azure AD Security groups for access control.
Office 365 Groups are used for collaboration.
Data Sources:
Excel spreadsheets will be the source of data for the pilot.
There are other data sources that will be used after the pilot:
SQL Server
SharePoint lists
JSON files
Zendesk
Report development:
There is a team of business intelligence analysts who will create the reports and dashboards.
This team will load, transform, and cleanse the data. They will then model the data and create datasets for use across the organization.
Changes made by the developers should be automatically deployed to users.
Security requirements:
Developers should not have access to production data.
Developers should not have access to reports and dashboards in production.
Business users should not have access to developer data or assets.
Board members must be able to access select reports and dashboards.
Excel files used in reports should only be accessible from their workspace.
Users must only have access to the data in their department.
Users in the Sales department must only have access to data in their territory.
The reports and dashboards for a department should only be accessible by business users in the same department.
Business users should not be able to edit the reports and dashboards. Business users should not be able to create new reports or dashboards.
Board members are not part of the company network.
Requirement:
What are two possible ways to control access to data in the Sales department? Each correct answer presents a complete solution.
Correct
To control access to data as specified in the Security requirements, you will need to configure Row-level security (RLS) in the dataset. RLS will be applied to users who are assigned the Viewer role in the workspace. Viewers can only consume the reports and dashboards. This is one of the two solutions that meets the goal.
RLS is also applied if the workspace is published as an app. You should distribute the app to the required end users. The users do not need to be assigned a role in the workspace and will only be able to use the reports and dashboards in the app. This solution also meets the goal. You should not use an app and set Allow all users to connect to the app’s underlying datasets using the Build permission. This option allows users to build their own reports and dashboards based on the dataset in the app. Creating new reports is against the security requirements. You should not create workspaces for each territory and assign users in each territory the Member role. Users with the Member role can edit the reports and dashboards in the workspace. Editing reports is against the security requirements.
Incorrect
To control access to data as specified in the Security requirements, you will need to configure Row-level security (RLS) in the dataset. RLS will be applied to users who are assigned the Viewer role in the workspace. Viewers can only consume the reports and dashboards. This is one of the two solutions that meets the goal.
RLS is also applied if the workspace is published as an app. You should distribute the app to the required end users. The users do not need to be assigned a role in the workspace and will only be able to use the reports and dashboards in the app. This solution also meets the goal. You should not use an app and set Allow all users to connect to the app’s underlying datasets using the Build permission. This option allows users to build their own reports and dashboards based on the dataset in the app. Creating new reports is against the security requirements. You should not create workspaces for each territory and assign users in each territory the Member role. Users with the Member role can edit the reports and dashboards in the workspace. Editing reports is against the security requirements.
Unattempted
To control access to data as specified in the Security requirements, you will need to configure Row-level security (RLS) in the dataset. RLS will be applied to users who are assigned the Viewer role in the workspace. Viewers can only consume the reports and dashboards. This is one of the two solutions that meets the goal.
RLS is also applied if the workspace is published as an app. You should distribute the app to the required end users. The users do not need to be assigned a role in the workspace and will only be able to use the reports and dashboards in the app. This solution also meets the goal. You should not use an app and set Allow all users to connect to the app’s underlying datasets using the Build permission. This option allows users to build their own reports and dashboards based on the dataset in the app. Creating new reports is against the security requirements. You should not create workspaces for each territory and assign users in each territory the Member role. Users with the Member role can edit the reports and dashboards in the workspace. Editing reports is against the security requirements.
Question 50 of 54
50. Question
You create a Power Bl report with a very large dataset. You want to improve the performance of the dataset refresh by using incremental refresh.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. The Incremental Refresh feature should only be used on data sources that support query folding.
2. Two PowerQuery parameters named RangeStart and RangeEnd are required for an incremental refresh.
3. A date field is required on a table in the dataset.
Correct
The Incremental Refresh feature should only be used on data sources and queries that support query folding. If query folding is not supported, the Incremental Refresh feature will pull all of the data multiple times.
For an incremental refresh, the datasets are filtered by two date/time parameters in PowerQuery. These parameters are named RangeStart and RangeEnd.
You need a date field to specify how the filter will return the incremental record changes. Without a date field, you cannot use incremental refresh.
Incorrect
The Incremental Refresh feature should only be used on data sources and queries that support query folding. If query folding is not supported, the Incremental Refresh feature will pull all of the data multiple times.
For an incremental refresh, the datasets are filtered by two date/time parameters in PowerQuery. These parameters are named RangeStart and RangeEnd.
You need a date field to specify how the filter will return the incremental record changes. Without a date field, you cannot use incremental refresh.
Unattempted
The Incremental Refresh feature should only be used on data sources and queries that support query folding. If query folding is not supported, the Incremental Refresh feature will pull all of the data multiple times.
For an incremental refresh, the datasets are filtered by two date/time parameters in PowerQuery. These parameters are named RangeStart and RangeEnd.
You need a date field to specify how the filter will return the incremental record changes. Without a date field, you cannot use incremental refresh.
Question 51 of 54
51. Question
To complete the sentence below, select the appropriate option.
Correct
A workspace owner can endorse a dataset to Promoted for organizational use without needing verification from the tenant admin. If you are a member of a workspace with write permissions, you can promote a dataset.
You can request a certification of a promoted dataset. A user or security group can be defined in Power Bl Admin portal > tenant settings > Certification > allow users who can certify a dataset. This will act as an additional oversight for certifying a dataset. By default, this setting is disabled for the entire organization, meaning that only the tenant admin can certify a dataset.
Incorrect
A workspace owner can endorse a dataset to Promoted for organizational use without needing verification from the tenant admin. If you are a member of a workspace with write permissions, you can promote a dataset.
You can request a certification of a promoted dataset. A user or security group can be defined in Power Bl Admin portal > tenant settings > Certification > allow users who can certify a dataset. This will act as an additional oversight for certifying a dataset. By default, this setting is disabled for the entire organization, meaning that only the tenant admin can certify a dataset.
Unattempted
A workspace owner can endorse a dataset to Promoted for organizational use without needing verification from the tenant admin. If you are a member of a workspace with write permissions, you can promote a dataset.
You can request a certification of a promoted dataset. A user or security group can be defined in Power Bl Admin portal > tenant settings > Certification > allow users who can certify a dataset. This will act as an additional oversight for certifying a dataset. By default, this setting is disabled for the entire organization, meaning that only the tenant admin can certify a dataset.
Question 52 of 54
52. Question
You create a Power Bl dataset and report for a multi-national organization. You configure row-level security (RLS) in the data model. Users are restricted to accessing rows only for their own country. You should follow the best practices for managing security.
You create roles for each country. You add a DAX Filter expression for each role on the country table. You add the Azure Active Directory (Azure AD) security group for the country to each role. A new user starts in Country A.
You need to ensure that the user can only view data for Country A. What should you do?
Correct
You should add the user to the Azure AD security group for County A. You have configured the row-level security groups to control the membership of each role. You should therefore add and remove users from roles by changing their membership of Azure AD security groups.
You should not manage roles in Power Bl Desktop and change the DAX filter expression on the role of Country A. The DAX filter expression controls which rows are displayed for the role. They do not control the membership of the role. Membership of roles is configured in the Power Bl service.
You should not edit the security on the dataset in the Power Bl service and add the user’s email address to the role for Country A. Although this will allow the user to access the data for the country, this is not best practice because you used Azure AD security groups to control the membership of roles.
You should not change the access in the Power Bl workspace and add the user’s email address with the Member role. As a member of the workspace, the user will be able to see data for all countries and will not be restricted by row-level security.
Incorrect
You should add the user to the Azure AD security group for County A. You have configured the row-level security groups to control the membership of each role. You should therefore add and remove users from roles by changing their membership of Azure AD security groups.
You should not manage roles in Power Bl Desktop and change the DAX filter expression on the role of Country A. The DAX filter expression controls which rows are displayed for the role. They do not control the membership of the role. Membership of roles is configured in the Power Bl service.
You should not edit the security on the dataset in the Power Bl service and add the user’s email address to the role for Country A. Although this will allow the user to access the data for the country, this is not best practice because you used Azure AD security groups to control the membership of roles.
You should not change the access in the Power Bl workspace and add the user’s email address with the Member role. As a member of the workspace, the user will be able to see data for all countries and will not be restricted by row-level security.
Unattempted
You should add the user to the Azure AD security group for County A. You have configured the row-level security groups to control the membership of each role. You should therefore add and remove users from roles by changing their membership of Azure AD security groups.
You should not manage roles in Power Bl Desktop and change the DAX filter expression on the role of Country A. The DAX filter expression controls which rows are displayed for the role. They do not control the membership of the role. Membership of roles is configured in the Power Bl service.
You should not edit the security on the dataset in the Power Bl service and add the user’s email address to the role for Country A. Although this will allow the user to access the data for the country, this is not best practice because you used Azure AD security groups to control the membership of roles.
You should not change the access in the Power Bl workspace and add the user’s email address with the Member role. As a member of the workspace, the user will be able to see data for all countries and will not be restricted by row-level security.
Question 53 of 54
53. Question
You create datasets, reports, and dashboards in Power Bl.
You need to make these assets easily available to other users and indicate how they should be used. You need to configure the assets to meet the requirements.
To answer, select the appropriate option for the below requirement.
“Make a dataset discoverable without requiring permission from the Power BI Admin”
Correct
Datasets can be made discoverable by endorsing them. There are two endorsement options: Promoted and Certified. A user with write permission on a workspace can use the Promotion option without requiring permission from a Power Bl Admin. The dataset will be listed with the promoted icon next to its name.
Incorrect
Datasets can be made discoverable by endorsing them. There are two endorsement options: Promoted and Certified. A user with write permission on a workspace can use the Promotion option without requiring permission from a Power Bl Admin. The dataset will be listed with the promoted icon next to its name.
Unattempted
Datasets can be made discoverable by endorsing them. There are two endorsement options: Promoted and Certified. A user with write permission on a workspace can use the Promotion option without requiring permission from a Power Bl Admin. The dataset will be listed with the promoted icon next to its name.
Question 54 of 54
54. Question
You manage the Power Bl admin portal. Company policy says that only specific people can create new workspaces. You have a security group named WorkspaceCreator. Some new users complain that they are unable to create a new workspace. These users are already added to WorkspaceCreator security group. You need to allow these users to create new workspaces within the stated guidelines.
Which four actions should you perform in sequence in the Power Bl admin portal? To answer, move the appropriate actions from the list of possible actions to the answer area and arrange them in the correct order.
Correct
You should perform the following actions in order:
1. Go to Power Bl admin portal > Tenant settings.
2. Choose Workspace settings > Create workspaces (new workspace experience).
3. Under Apply to, choose Specific security groups, and add the WorkspaceCreator security group.
4. Click Apply.
From the Power Bl admin portal you can navigate to the Tenant settings page.
There, choose Workspace settings and select the Create workspaces (new workspace experience) option. You can enable new workspace creation for the entire organization or only for specific users through security groups. The scenario states that you only need to allow specific users to create workspaces. Under the Apply to option, choose specific security groups, and add the WorkspaceCreator security group. These new users are part of the WorkspaceCreator security group. Adding this group will give users permission to create workspaces.
Finally, click Apply to save and apply the tenant level changes.
You should not use Choose Workspace settings > Block classic workspace creation. This option is used to restrict the creation of classic workspaces. If it is enabled, users will not be able to create a workspace using the classic experience. By default this option is disabled, allowing users to choose between classic and new workspace creation.
Incorrect
You should perform the following actions in order:
1. Go to Power Bl admin portal > Tenant settings.
2. Choose Workspace settings > Create workspaces (new workspace experience).
3. Under Apply to, choose Specific security groups, and add the WorkspaceCreator security group.
4. Click Apply.
From the Power Bl admin portal you can navigate to the Tenant settings page.
There, choose Workspace settings and select the Create workspaces (new workspace experience) option. You can enable new workspace creation for the entire organization or only for specific users through security groups. The scenario states that you only need to allow specific users to create workspaces. Under the Apply to option, choose specific security groups, and add the WorkspaceCreator security group. These new users are part of the WorkspaceCreator security group. Adding this group will give users permission to create workspaces.
Finally, click Apply to save and apply the tenant level changes.
You should not use Choose Workspace settings > Block classic workspace creation. This option is used to restrict the creation of classic workspaces. If it is enabled, users will not be able to create a workspace using the classic experience. By default this option is disabled, allowing users to choose between classic and new workspace creation.
Unattempted
You should perform the following actions in order:
1. Go to Power Bl admin portal > Tenant settings.
2. Choose Workspace settings > Create workspaces (new workspace experience).
3. Under Apply to, choose Specific security groups, and add the WorkspaceCreator security group.
4. Click Apply.
From the Power Bl admin portal you can navigate to the Tenant settings page.
There, choose Workspace settings and select the Create workspaces (new workspace experience) option. You can enable new workspace creation for the entire organization or only for specific users through security groups. The scenario states that you only need to allow specific users to create workspaces. Under the Apply to option, choose specific security groups, and add the WorkspaceCreator security group. These new users are part of the WorkspaceCreator security group. Adding this group will give users permission to create workspaces.
Finally, click Apply to save and apply the tenant level changes.
You should not use Choose Workspace settings > Block classic workspace creation. This option is used to restrict the creation of classic workspaces. If it is enabled, users will not be able to create a workspace using the classic experience. By default this option is disabled, allowing users to choose between classic and new workspace creation.
X
The End of Exam. SkillCertPro Wishes you all the best for your exam.