You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

• A.Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
• B.Duplicate the Date query in Power Query and use active relationships between both Date tables.
• C.On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
• D.Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Comment: *

Name: *

Email: *

Verification: *

Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?

• A.text box
• B.custom streaming data
• C.web content
• D.video

Comment: *

Name: *

Email: *

Verification: *

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

• A.Select Column distribution.
• B.Select the sales_amount column and apply a number filter.
• C.Select Column profile, and then select the sales_amount column.
• D.Transform the sales_amount column to replace negative values with 0.

Correct Answer: C

Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
* Executives require a visual that shows sales by region.
* Regional managers require a visual to analyze weekly sales and returns.
* Sales managers must be able to see the sales data of their respective region only.
* The sales managers require a visual to analyze sales performance versus sales targets.
* The sale department requires reports that contain the number of sales transactions.
* Users must be able to see the month in reports as shown in the following example: Feb 2020.
* The customer service department requires a visual that can be filtered by both sales month and ship month independently.

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You have the data lineage 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:

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *