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

Comment: *

Name: *

Email: *

Verification: *

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager.
You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.
How should you provision access to the reports for the HR managers?

• A.Publish the reports to a different workspace other than the one hosting the datasets.
• B.Publish the reports in an app and grant the HR managers access permission.
• C.Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
• D.Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

Comment: *

Name: *

Email: *

Verification: *

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.

Correct Answer:

Explanation

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

Comment: *

Name: *

Email: *

Verification: *

You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:
Identify months that have order counts above the mean.
Display the mean monthly order count.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.
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:

Comment: *

Name: *

Email: *

Verification: *