- (Exam Topic 4)
You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: A scatter plot...
A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the horizontal axis. It depends on the data the chart represents.
Box 2: Automatically find clusters
Scatter charts are a great choice to show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

1. A. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
2. B. Duplicate the Date query in Power Query and use active relationships between both Date tables.
3. C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
4. D. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Correct Answer: D
Only one relationship can be active.
Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

- (Exam Topic 4)
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

1. A. Share the dashboard to the user.
2. B. Create a subscription.
3. C. Create a data alert.
4. D. Tag the user in a comment.

Correct Answer: C
You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you. Power BI e-mail subscriptions allow you to:
Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh.
Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly. Note: Email subscriptions don't support most custom visuals. The one exception is those custom visuals that
have been certified.
Email subscriptions don't support R-powered custom visuals at this time. Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

- (Exam Topic 4)
You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A. Which settings should you modify from the Power BI Settings?

1. A. Subscriptions
2. B. Dashboards
3. C. Datasets
4. D. Workbooks

Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured-questions

- (Exam Topic 1)
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend. Box 4: Targets[sales_target]
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A