Microsoft 70-778 Free Practice Questions

New Questions 2

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.

View Answer

New Questions 3

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?

A. Configure the app workspace for Premium capacity.

B. Enable anonymous access for the Sales site.

C. Configure the Portal Site Connection for the Sales site.

D. Disable the Embed content in apps setting from the Tenant settings in Power BI.

View Answer

New Questions 4

You plan to create several datasets by using the Power BI service. You have the files configured as shown in the following table.

You need to identify which files can be used as datasets.

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

A. Data 1

B. Data2

C. Data 3

D. Data4

E. Data 5

View Answer

New Questions 5

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.

View Answer

New Questions 6

Your organization has a team of power users who recently created 20 Power BI dashboards.

The power users share the dashboards with other users in the organization.

When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards. What should you do first?

A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

B. From the Power BI Admin portal, modify the Privacy Settings.

C. From the properties of each dashboard, modify the Share dashboard settings.

D. Instruct each user to install Microsoft Office 2021.

View Answer

New Questions 7

You embed a Power BI report in a Microsoft SharePoint Online page.

A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: u201cThis content isnu2021t availableu201d.

User1 is unable to view the report.

You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

You need to ensure that User1 can view the report form SharePoint Online. What should you do?

A. Publish the app workspace.

B. Edit the settings of the Power BI web part.

C. Modify the members of the app workplace.

D. Share the dashboards in the app workspace.

View Answer

New Questions 8

You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should you do?

A. From the Power BI Admin portal, click Usage metrics.

B. From the Office 365 Admin center, click Users.

C. From the Office 365 Admin center, click Groups.

D. From the Power BI Admin portal, click Tenant settings.

View Answer

New Questions 9

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.

View Answer

New Questions 10

You have the following two queries in Power BI Desktop:

u2711 A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database

u2711 A query named Query2 that retrieves a table named Enterprise_Customers from

an Oracle database

Both tables have the same columns.

You need to combine the data from SMB_Customers and Enterprise_Customers. Which command should you use?

A. Combine Files

B. Merge Columns

C. Merge Queries

D. Append Queries

View Answer

New Questions 11

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

u2711 Assets( AssetsID, AssetName, Purchase_DateID, Value)

u2711 Date( DateID, Date, Month, Week, Year)

The tables have relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the percentage that the total assets value

increased since one year ago. Which DAX formula should you use?

A. (sum(Assets[Value])

u2013CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR(u2021Dateu2021[Date])))/CALCULATE

(sum(Assets[Value]),SAMEPERIODLASTYEAR (u2021Dateu2021 [Date]))

B. CALCULATEx(sum(Assets[Value]) DATESYTD (u2021Dateu2021[Date]))/sum(Assets[Value])

C. sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (u2021Dateu2021 [Date]))

D. CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (u2021Dateu2021

[Date]))/sum(Assets[Value])

View Answer