You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI semantic model named Model1 that contains two table named DimDate and FactSales.
There is an active relationship between DimDate and FactSales. DimDate is marked as the date table.
FactSales contains the following data.

Model1 contains the following measure:

You have a report that uses Model1. The report has a single report page that has a page level filter set to may
9, 2024. The result of the Previous Year measure is displayed in a card visual.
Which value appear in the card visual?

• A.10
• B.35
• C.60
• D.15

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
You have a semantic model as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: create an active relationship for PaymentDate
In a Microsoft Power BI semantic model with multiple relationships between the same two tables (e.g., FactSales and DimDate), only one relationship can be active at a time.
To select or compare values based on a secondary date, such as PaymentDate, while keeping OrderDate as the primary (active) link, you typically set the PaymentDate relationship as inactive and use the USERELATIONSHIP DAX function within a measure to invoke it.
Key Facts
Active vs. Inactive: Only one active relationship can exist between two tables; additional connections are automatically set as inactive (dotted line).
Invoking Inactive Relationships: To calculate metrics based on PaymentDate (the inactive link), you must wrap your measure in a CALCULATE function:
Total Payments = CALCULATE(SUM(FactSales[Amount]),
USERELATIONSHIP(DimDate[DateKey], FactSales[PaymentDate])).
Filtering Behavior: By default, any filter applied to the DimDate table will only propagate to FactSales through the active relationship (likely OrderDate).
Alternative (Role-Playing Dimensions): Instead of active/inactive relationships, you can create separate "role-playing" date tables (e.g., a DimOrderDate and a DimPaymentDate table) to allow independent filtering in the same visual without special DAX.
Box 2: role-playing
The DimDate table is a role-playing dimension. This is a common data modeling technique where a single physical dimension table is used multiple times within the same fact table, with each instance serving a different logical purpose or "role".
In your Power BI semantic model:
Single Physical Table: You have one physical DimDate table containing all date-related attributes.
Multiple Logical Roles: This single table is linked to the FactSales table through three different foreign keys: OrderDate, PaymentDate, and ShippingDate. Each of these columns represents a different "role" the date dimension plays.
Relationships in Power BI: In Power BI's data model, only one of these relationships can be active at a time (indicated by a solid line in the relationship view), while the others remain inactive (indicated by dotted lines).
Reference:
https://datasturdy.com/active-vs-inactive-relationships-in-power-bi-what-we-need-to-know
https://www.thedataschool.co.uk/svetlana-brazukevich/role-playing-dimensions-in-power-bi

Comment: *

Name: *

Email: *

Verification: *

You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

Comment: *

Name: *

Email: *

Verification: *

In Power Query Editor, you have a query named Sales Data that contains the following columns.

You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the site of the semantic model.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE Each correct selection is worth one point.

• A.Disable the load for the sales Data query.
• B.Reference the Sales Data query to create the new queries.
• C.Clear Include in report refresh for the Sales Data query.
• D.Disable the load for the Sales Fact query.
• E.Duplicate the Sates Data query to create the new queries.

Comment: *

Name: *

Email: *

Verification: *