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.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?

• A.comments
• B.tiles
• C.Microsoft Information Protection sensitivity labels
• D.Active Directory groups

Comment: *

Name: *

Email: *

Verification: *

You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Create one-to-many relationships between the tables.
• B.Create a calculated table that contains Ad_id, Site_name, and Impression_date.
• C.Create a calculated measure that aggregates by using the COUNTROWS function.
• D.Group the impressions by Ad_id, Site_name, and Impression_date.
  Aggregate by using the CountRows function.

Comment: *

Name: *

Email: *

Verification: *

You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: One-to-many
Box 2: Both
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the
"many" side (bi-directional).
Note:

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

Comment: *

Name: *

Email: *

Verification: *

You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

• A.one-to-many from Transaction to Customer
• B.one-to-many from Customer to Transaction
• C.many-to-many between Customer and Transaction
• D.one-to-one between Customer and Transaction

Comment: *

Name: *

Email: *

Verification: *