70-778 | 10 Tips For Latest 70-778 practice test

Q2. HOTSPOT

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.

Answer:

Explanation:

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

Q3. HOTSPOT

You have the following tables.

You need to create a measure to calculate a running total of TransactionQuantity.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Answer:

Explanation:

References: http://www.daxpatterns.com/cumulative-total/

Q4. 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?

A. Set a visual level filter on the bar chart.

B. Edit the interactions form the Format menu.

C. Set a visual level filter on the donut chart.

D. Add a slicer to the page that uses the year column.

Answer: B

Explanation:

References: https://www.excelguru.ca/blog/2021/11/23/visual-interactions-in-power-bi/

Q5. 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:

u2711 Store the District based on DistrictID

u2711 Sales to Store based on LocationID

u2711 Sales to Date based on PeriodID

u2711 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?

A. Change the Cardinality to One to one (1:1).

B. Change the Cardinality to One to Many (1.*).

C. Select Assume Referential Integrity.

D. Change the Cross filter direction to Both.

Answer: D

Explanation:

References: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-admin-rls/

Q6. You have a Microsoft Excel 2021 workbook that has a Power Pivot model. The model contains the following tables:

u2711 Product (Product_id, Producct_Name)

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

u2711 Salesperson (Salesperson_id, Salesperson_name, address)

The model has the following relationships:

u2711 Sales to Product

u2711 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?

A. Create a many-to-one relationship between Product and Salesperson.

B. For each relashionship, change the Cardinality to One to One (1:1).

C. Create a one-to-one relashionship between Product and Salesporson.

D. For each relationship, change the Cross filter direction to Both.

Answer: D

Explanation:

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

Q7. You have a Power BI model for sales data.

You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period.

Which DAX function should you use?

A. PARALLELPERIOD

B. SAMEPERIODLAST YEAR

C. DATESYTD

D. PREVIOUSYEAR

Answer: A

Explanation:

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

Q8. Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values. End of repeated scenario.

You implement the Power BI model.

You add another table named Territory to the model. A sample of the data is shown in the following table.

You need to create a relationship between the Territory table and the Sales table.

Which function should you use in the query for Territory before you create the relationship?

A. Table.RemoveMatchingRows

B. Table.Distinct

C. Table.InDistinct

D. Table.ReplaceMatchingRows

Answer: B

Explanation:

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

Q9. You have a Power BI report in an app workspace.

You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.

Which information should you provide to the application developers?

A. The application token and the report URL

B. The report URL and a user name

C. The app workspace name and the access key

D. The access key and the report ID

Answer: C

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/developer/integrate-report

Q10. Note: This question is a 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.

Your company has 1,000 users in a Microsoft Office 365 subscription.

A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users.

You discover that a use name User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards.

Solution: From the Power BI Admin portal, you modify the Dashboard settings. Does this meet the goal?

A. Yes

B. No

Answer: B

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-admin-administering-power-bi-in-your-organization#how-do-i-remove-power-bi-for-users-that-already-signed-up

Q11. In the Power BI service, you create an app workplace that contains several dashboards.

You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.

What should you do?

A. From the app workplace, click Update app, and then configure the Access settings.

B. Share the dashboard, and then modify the Access settings of the dashboard.

C. Configure security for the dataset used by the app.

D. Modify the members of the app workspace.

Answer: D

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365