70-778 試験問題を無料オンラインアクセス

You have a Power BI model that has the following tables:
* Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
* Salesperson (Salesperson_id, Salesperson_name, address)
* Product (Product_id, Product_Name)
You need to create the following relationships:
* Sales to Product
* Sales to Sales person
You need to ensure that you can create a report that displays the count of products sold by each salesperson.
How should you configure the relationships? To answer, drag the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

Explanation

References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

You have the following table named Location.

The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations.
What should you do?

• A.Change the name of the Location table to
• B.Add a Geoportal column to the Location table.
• C.Replace the values in the GeoCode column with postal codes or zip codes.
• D.Change the Default Summarization of the GeoCode column.
• E.Change the name of the GeoCode column to
• F.Change the Data Type of the GeoCode column.

You open powerbi.com as 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.

正解：

Explanation

References: https://docs.microsoft.com/en-us/power-bi/service-data-classification

You have sales data in a spreadsheet named Sales.xlsx.
You need to provide a detailed sales report to several managers.
From the Power BI service, you create an app workspace named SalesWorkspace.
Which three actions should you perform in sequence next? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

正解：

Explanation

References:
https://docs.microsoft.com/en-us/power-bi/service-report-create-new
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power BI service.
Solution: From Excel, click Publish to Power BI, and then click Export.
Does this meet the goal?

• A.No
• B.Yes