DRAG DROP

You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide.

You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.

You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

HOTSPOT

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

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

https://community.powerbi.com/t5/Power-Query/Append-vs-Append-as-new-for-performance/td-p/1822710

HOTSPOT

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Hide

Optimize data by hiding fields and sorting visualization data

Box 2: Delete

The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.

Reference: https://tessellationtech.io/optimizing-power-bi-reports/

You have a prospective customer list that contains 1,500 rows of data.

The list contains the following fields:

✑ First name

✑ Last name

✑ Email address

✑ State/Region

✑ Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

HOTSPOT

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table.

Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: A DAX Calculated measure

Box 2: Date.EndofQuarter(#date([Year],[Mont],1))

ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates.

The following sample formula creates a measure that returns the end of the quarter, for the current context.

= ENDOFQUARTER(DateTime[DateKey])

Reference: https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

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?

Reveal Solution Hide Solution

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

Reveal Solution Hide Solution

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

Reveal Solution Hide Solution

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged

contains the date and time each compliant occurred.

The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

Reveal Solution Hide Solution

DRAG DROP

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions