You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users.
Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
User 1 = Member
User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces

Comment: *

Name: *

Email: *

Verification: *

You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

• A.Add a measure to the visual that uses the following DAX expression.
  Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],.40)
• B.Create a horizontal line that has a fixed value of 24,000.
• C.Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
• D.Add a measure to the visual that uses the following DAX expression.
  Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Comment: *

Name: *

Email: *

Verification: *

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
• B.a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.
• C.a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
• D.a pie chart that shows balances by account category without filters.
• E.a ribbon chart that shows balances by quarter and accounts in the legend.

Comment: *

Name: *

Email: *

Verification: *

You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Graphical user interface, text Description automatically generated with medium confidence

Box 1: Append Queries as New.
There are two primary ways of combining queries: merging and appending.
* When you have one or more columns that you'd like to add to another query, you merge the queries.
* When you have additional rows of data that you'd like to add to an existing query, you append the query.
Box 2: Disable loading the query to the data model
For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.
Reference:
https://docs.microsoft.com/en-us/power-query/append-queries

Comment: *

Name: *

Email: *

Verification: *