Microsoft Power BI Test – 11

You need to create relationships in the data model to enable visuals to be created that contain data from both tables.

How should you model these tables?

Select 1 option(s):

Percentile95 = PERCENTILEX.EXC(RegionalSales, RegionalSales[Sales], 0.95)
When you add the measure to a line chart visualization, an error is shown with unsupported percentile.
You need to resolve the error and show the 95% percentile on the visual. What should you do?

Select 1 option(s):

You need to produce reports showing average values for devicetype and readingtype. The Telemetry table is set to DirectQuery storage mode. You need to create aggregations for date, devicetype, readingtype, and readingvalue.
Which of the following five actions should you perform in sequence?

Select 1 option(s):

You need to show the variance of sales for the different product types. You decide to use a Quick measure.
How should you configure the Quick measure? Select the correct column names for the Quick Measure setup.

Select 2 option(s):

You write a measure to calculate the Percentage of Sales. The measure is calculating the percentages incorrectly as shown in the exhibit named Incorrect below.

Incorrect
You need to re-write the measure so that the percentage is correct for each country and region and the total percentage is 100 percent. The measure should calculate the percentages as shown in the below exhibit named Correct.

Correct
How should you re-write the measure? To answer, select the appropriate option from the drop-down menu.

Select 1 option(s):

The Customer table contains the names and IDs of the customers. The Product table contains the ids and names of the products. When a customer purchases from the retail establishment, a record in the Basket table is created to link the Customer to that purchase. The Products added to their Basket are stored in the Basket Items table.
You need to find the number of customers who purchased the same set of products. You add a slicer for Product Name to your report to choose the set of products.
How should you create the measure to count the number of customers who purchased the products selected? To answer, select the appropriate option.

Select 1 option(s):

You have a slicer that filters employees based on Salary range. You have another slicer that filters employees based on Company.
A visualization that shows employees along with salaries is not showing the correct values. You need the Company slicer to show only values within the range of the Salary slicer. You need to fix the relationship between the Employee and Salary tables.
Which two actions should you perform? Each correct answer presents part of the solution.

Select 2 option(s):

Orders are received during the working week and are typically shipped within a week.
You need to define a date table to support visualizations. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. A date table must have a column with the Date data type.
2. You can mark the table named Sales as a date table.
3. You can create two date tables, one for order date and one for ship date, and mark both as date tables.

Select 1 option(s):

Users report poor performance when using your report.
How can you identify the source of the performance issues?

Select 1 option(s):

You have the following measure that is performing poorly The measure calculates the change in sales each year.
SalesChangeYoY = IF(SUM(Sales[Amount]), DIVIDE([SumofSales] – CALCULATE([SumofSales], SAMEPERIODLASTYEAR(Sales[Date])), CALCULATE([SumofSales], SAMEPERIODLASTYEAR(Sales[Date]))))
You need to improve the performance of the measure. What should you do?

Select 1 option(s):

Which two DAX expressions can you use to achieve your goal? Each correct answer presents a complete solution.

Select 2 option(s):

You need to optimize model performance. Which two actions should you perform? Each correct answer presents part of the solution.

Select 2 option(s):

You need to configure the Sales table and its columns for users to successfully use the Q&A feature in Dashboards.
Solution: Mark the Sales table as the date table. Does this solution meet the goal?

Select 1 option(s):

Which visualizations should you use for each requirement stated below:
Identify outliers in customers with sales opportunities.

Select 1 option(s):

Select 1 option(s):

You need to show users how the data in the dashboards is classified.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Data classifications are defined at the tenant level.
2. Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups.
3. The data classification for a dashboard is always displayed.

Select 1 option(s):

When you hover over a data point in the visual you need to also show the value of goods sold, Total sales.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

Select 2 option(s):

Select 1 option(s):

• Medium Impact (MEDI) as default.
• High Impact (HIGH).
You need to use the newly created classifications in the dashboards. The Production dashboard should be classified as Medium Impact. The Manufacturing dashboard should be classified as High Impact.
Which two actions should you perform? Each correct answer presents part of the solution.

Select 2 option(s):

Which of the following solves the problem? More than one answer can be correct.

Select 2 option(s):

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 Q&A button on the report page.
Does this solution meet the goal?

Select 1 option(s):

Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.
You need to customize themes to meet these requirements.
Which theme should you use for the following requirement?
“Set the tile background color”

Select 1 option(s):

You create a Power Bl report with a visual that shows employees with low scoring KPls. You pin the visual to a dashboard and share the dashboard with users in Human Resources (HR).
HR users need to be able to generate a list of employees to investigate for poor performance and import that list into their HR system.
What should you do?

Select 1 option(s):

Select 1 option(s):

Which visualizations should you use for each requirement stated below:
Show the factors that affect the outcome of sales opportunities.

Select 1 option(s):

Which visualizations should you use for the below-stated requirement?
“Take actions from within a report”

Select 1 option(s):

You need to format a visualization to match the one shown in the exhibit.

The graduated color is determined by the percentage change since the previous quarter.
How should you configure the visual? Select the appropriate option for the two process steps.

Select 2 option(s):

You need to identify the root cause of this issue. What is preventing all the data from be displayed?

Select 1 option(s):

You need to make the report pages more interactive for users.
To answer, drag the appropriate Power Bl feature for the stated requirement.
“Create a view of a report page with the filters applied”

Select 1 option(s):

Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.
You need to customize themes to meet these requirements.
Which theme should you use for the following requirement?
“Set the colors for data in visuals”

Select 1 option(s):

You create a Power Bl report for your company. The report has three pages containing visualizations of sales data. You need to filter the visuals for all three report pages whenever a country is selected.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

Select 2 option(s):

How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Create a bookmark for each report page.
• Add four buttons to the home page and set action type to Bookmark.
• On each button, select the bookmark for the page.
Does this solution meet the goal?

Select 1 option(s):

How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Set Include in app to Yes for the report.
• Create a Power BI app.
• Enable navigation builder.
• Include the report in the navigation.
• Publish the app.
Does this solution meet the goal?

Select 1 option(s):

You need to configure the interactions of the visuals.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. To make the Sales by Product visual show the portion of the segment selected in the Pie chart, you should select the Sales by Product visual and edit the interactions on the Sales by Segment chart.
2. To not filter the Sales by Segment chart when a column in the Sales by Product visual is clicked, you should set the interaction behavior to None.
3. To focus on the proportion of Sales by Product for a selected segment, you should set the interaction behavior to Filter.

Select 1 option(s):

Select 3 option(s):

Which visualizations should you use for each requirement stated below:
Show progress of sales opportunities won against target.

Select 1 option(s):

You need to enable the Q&A feature that appears as “Ask a question about your data” at the top of the dashboard above the visuals.
How should you enable this feature?
Solution: Enable the Q&A option in Page information on the report page.
Does this solution meet the goal?

Select 1 option(s):

You need to automate the notification of alerts when the KPI value exceeds a threshold. Which two options are available when configuring an alert in Power Bl service? Each correct answer presents a complete solution.

Select 2 option(s):

Select 3 option(s):

How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Add four images to the home page and set action type to Page navigation.
• Select the destination page for each image.
Does this solution meet the goal?

Select 1 option(s):

You need to configure the page for use with screen reader software for partially sighted users.
What should you configure on the report page so that the screen reader follows a logical sequence?

Select 1 option(s):

Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.
You need to customize themes to meet these requirements.
Which theme should you use for the following requirement?
“Set the background image”

Select 1 option(s):

Select 3 option(s):

Select 1 option(s):

Select 1 option(s):

You need to improve report navigation.
Which options should you use for the stated task?
“Preserve visual selection of a specific report page”

Select 1 option(s):

You need to explain how the dashboard will appear on a mobile device using the Power Bl app. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. By default, in the Power Bl mobile, all tiles on a dashboard appear with the same size in a vertical list.
2. Enabling Dashboard tile flow causes the tiles to be displayed on a mobile device as they are on a web browser.
3. Creating a Phone view of a dashboard, allows you to resize and rearrange the visuals for the Power Bl mobile app.

Select 1 option(s):

You need to make the report pages more interactive for users.
To answer, drag the appropriate Power Bl feature for the stated requirement.
“Show and hide visuals on a report page”

Select 1 option(s):

How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Add four buttons to the home page and set action type to Page navigation.
• Select the destination page for each button.
Does this solution meet the goal?

Select 1 option(s):

You need to improve report navigation.
Which options should you use for the stated task?
“Add report navigation, so users can directly go to a specific report page”

Select 1 option(s):

You need to configure an interaction for this visual. When clicking Drill through, it should redirect to a detail page that shows Sales for the selected city by Product Line and will preserve all the filters from the Sales page.
Which four actions should you perform? Each correct answer presents part of the solution.

Select 4 option(s):

Users need to be able to view this report on their mobile devices.
You need to optimize the report for use on mobile devices.
Which two optimizations can you perform? Each correct answer presents a complete solution.

Select 2 option(s):

Which three visuals can be configured for data alerts? Each correct answer presents a complete solution.

Select 3 option(s):

You need to create a dashboard that will be simultaneously updated whenever the report page is updated.
What should you do?

Select 1 option(s):

Which visualizations should you use for the below-stated requirement?
“Use scikit learn machine learning in visuals”

Select 1 option(s):

Select 1 option(s):

Which visualizations should you use for the below-stated requirement?
“Use JavaScript to create visuals”

Select 1 option(s):

You need to apply the fonts and colors to match your corporate standards. What should you do?

Select 1 option(s):

You need to configure email alerts to meet this requirement.
Which four actions should you perform? Each correct answer presents part of the solution.

Select 4 option(s):

What can you achieve by using the new filter pane experience?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Hide specific filters from report consumers.
2. Lock specific filters so report consumers cannot edit them.
3. Disable the search for the Filters pane.

Select 1 option(s):

Select 1 option(s):

Is this statement correct?

Select 1 option(s):