HOTSPOT

You have a query that retrieves data from a Microsoft Azure SQL database.

You discover that column named ErrorCode has several values starting with a space character, and a column named SubStatus contains several non-printable characters.

You need to remove all the leading whitespaces from ErrorCode and all the non-printable characters from SubStatus. All other data must be retained.

What should you do on each column? To answer, drag the appropriate tasks to the correct columns. Each task 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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

References:

https://msdn.microsoft.com/en-us/library/mt260494.aspx

https://msdn.microsoft.com/en-us/library/mt253328.aspx

You have a Microsoft SharePoint Online site named Sales.

Your company has 1,000 sales users. All the sales users can access Sales.

You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.

You need to ensure that all the sales can view the report from the Sales site.

What should you do?

Reveal Solution Hide Solution

You plan to use Power BI Embedded to deliver reports in a web application.

You need to ensure that the reports display live data.

Which data source you should use?

Reveal Solution Hide Solution

You have a table named Sales.

A sample of the data in Sales is shown

in the following table.

You created a stacked column chart visualization that displays ProductName by Date.

You discover that the axis for the visualization displays all the individual dates.

You need to ensure that the visualization displays ProductName by year and that you can drill down to see ProductName by week and day.

What should you do first?

Reveal Solution Hide Solution

You plan to create a Power BI report.

You have the schema model shown in the exhibit. (Click the exhibit).

The model has the following relationships:

– Store the District based on DistrictID

– Sales to Store based on LocationID

– Sales to Date based on PeriodID

– Sales to Item based on ItemID

You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.

When the district managers view the sales report, they see Sales by Items for all stores.

You need to ensure that the district managers can see Sales by items for the stores they manage only.

How should you configure the relationship from Sales to Item?

Reveal Solution Hide Solution

You have a Microsoft Excel 2016 workbook that has a Power Pivot model.

The model contains the following tables:

– Product (Product_id, Producct_Name)

– Sales (Order_id, Order_Date, Product_id, Selasperson_id, Sales_Amount)

– Salesperson (Salesperson_id, Salesperson_name, address)

The model has the following relationships:

– Sales to Product

– Sales to Salesperson

You create a new Power BI file and import the Power Pivot model.

You need to ensure that you can generate a report that displays the count of products sold by each salesperson.

What should you do before you create the report?

Reveal Solution Hide Solution

You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category.

You need to ensure that when you select a year on the bar chart, the donut remains unchanged.

What should you do?

Reveal Solution Hide Solution

You have a Power BI model that contains the following tables:

– Sales (Sales_ID, DateID, sales_amount)

– Date (DateID, Date, Month, week, Year)

The tables have a relationship. Date is marked as a date table in the Power BI model.

You need to create a measure to calculate the sales for the last 12 months.

Which DAX formula should you use?

Reveal Solution Hide Solution

DRAG DROP

You have a Power BI model that contains a table named Sales. Sales contains columns named SalesAmount, OrderDate, SalesPerson, and OrderID.

You need to create a measure to calculate the last 12 months of sales. You must start from the last date a sale was made and ignore any filters set on the report.

How should you complete the DAX formula? To answer, drag the appropriate values to the correct targets. Each value 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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

References:

https://msdn.microsoft.com/en-us/library/ee634380.aspx

https://msdn.microsoft.com/en-us/library/ee634795.aspx

You have two tables named CustomerVisits and Date in a Power BI model.

You create a measure to calculate the number of customer visits.

You use the measure in the report shown in the exhibit. (Click the Exhibit.)

You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.

You need to fix the report to display the correct data for each month.

What should you do?

Reveal Solution Hide Solution