Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI

Question 1 of 32

1

You are creating a report in Power BI Desktop.
You are consuming the following tables.

You need to ensure that the months appear in the order of the calendar.
How should you sort the MonthName column?

Select one of the following:

A. by MonthNumber
B. ascending
C. descending
D. by DateKey

Explanation

Question 2 of 32

1

DRAG DROP -
From Power BI service, you publish an app that contains one dashboard and one report. Q&A is enabled on the dashboard.
In Q&A, a user types the query count of clients and fails to receive any results. The user then types the query count of subscribers and receives the expected results.
You need to ensure that the user can use both queries to receive the same results.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Select correct option below corresponding to the highlighted orange point

Delete and publish the app

Enable & config data class for dashboard

Edit the dashboard settings from PBI.com

Publish the report to app workspaces

Edit the synonyms

Update the app from powerbi.com

Explanation

Question 3 of 32

1

Click on each orange point and select the correct answer.

HOTSPOT -
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
-> Access a published Power BI app.
Modify reports in an app workspace.

-> Share dashboards created in My Workspace.
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) license, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Explanation

Question 4 of 32

1

You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data.
In Power BI Desktop, you have the following query for the cube.

The query retrieves 25,499 records.
When you check the data warehouse that is the source of the cube, you discover that there are 26,423 records.
You need to ensure that the query retrieves all 26,423 records.
What should you do?

Select one of the following:

A. From Query Editor, refresh all the data.
B. Change the query to use Live connection mode.
C. Delete the Remove Duplicates step.
D. Add an Unpivot Columns step.

Explanation

Question 5 of 32

1

You have a query that retrieves sales data. A sample of the data is shown in the following table.

You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row.
What should you click on the Transform tab in Query Editor?

Select one of the following:

A. Format, and then Clean
B. Date, and then Earliest
C. Fill, and then Down
D. Replace Values, and then Replace Errors

Explanation

Question 6 of 32

1

Your organization has a Microsoft Office 365 subscription.
When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. (Click the Exhibit button.)

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

Select one of the following:

A. From the Microsoft Azure Active Directory admin center, assign a Power BI (free) license to each user.
B. From the Power BI Admin portal, modify the Tenant settings.
C. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet.
D. From the properties of each dashboard, modify the Share dashboard settings.

Explanation

Question 7 of 32

1

You have the following two queries in Power BI Desktop:
-> A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
-> 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?

Select one of the following:

A. Combine Files
B. Merge Queries
C. Merge Columns
D. Append Queries

Explanation

Question 8 of 32

1

You are creating a Power BI Desktop report that has several bar charts and a date slicer.
You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year.
What should you do before you publish the report?

Select one of the following:

A. Configure report level filters, and then create groups that use the List group type.
B. Configure drillthrough filters for each bar chart, and then select Selection Pane.
C. Filter the bar charts by using the slicer, and then create bookmarks.
D. Configure page level filters, and then create groups that use the Bin group type.

Explanation

Question 9 of 32

1

DRAG DROP -
You create a report in Power BI Desktop.
You need to embed the report into a Microsoft SharePoint Online site.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Select correct option below corresponding to the highlighted orange point

Pin a visualization

Pin a live page

Publish the report to Power BI service

Obtain an embed link for SharePoint

Add a webpart to a page

Explanation

Question 10 of 32

1

You have a Power BI app named App1. The privacy for the App1 app workspace is set to Private.
A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
You need to ensure that User1 sees App1 from the My organization AppSource.
What should you do?

Select one of the following:

A. From the app workspace, click Update app, configure the Access setting, and then click Update app.
B. From the app workspace, share the dashboard.
C. From the app workspace settings, add a member.
D. From the app workspace, click Update app, configure the Content settings, and then click Update app.

Explanation

Question 11 of 32

1

You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a slicer to filter the data by year.
You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year.
What should you do?

Select one of the following:

A. Pin each visualization to the dashboard, and then add a web content tile.
B. Add a page level filter, and then pin each visualization to the dashboard.
C. Publish the app workspace.
D. Pin the report as a live page.

Explanation

Question 12 of 32

1

A data analyst publishes several Power BI visualizations to a blog.
You discover that some of the visualizations contain data that is considered private by your company.
You need to prevent the visualizations from being published to the blog.
What should you do?

Select one of the following:

A. From the Power BI Admin portal, disable the Publish to web setting.
B. From the Power BI settings, delete the embedded codes.
C. From the Power BI Admin portal, disable the Share content with external users setting.
D. From the dashboard settings, modify the Share dashboard settings.

Explanation

Question 13 of 32

1

You have an app workspace that contains two datasets named dataset1 and dataset2. Dataset1 connects to a Microsoft Azure SQL database. Dataset2 connects to a Microsoft Excel file stored in Microsoft OneDrive for Business.
You create a report named Report1 that uses dataset1.
You pin Report1 to a dashboard named Dashboard1.
You publish the app workspace to all the users in your organization.
You need to delete dataset2 from the app workspace.
What should you do first?

Select one of the following:

A. Delete Dashboard1.
B. Delete Report1.
C. Unpublish the app.
D. Configure the refresh settings for Dataset2.

Explanation

Question 14 of 32

1

You create a report in the Power BI service.
You plan to provide external users with access to the report by publishing the report to a public blog.
You need to ensure that the report in the blog post will be updated as the data is refreshed.
What should you do in the Power BI service?

Select one of the following:

A. Publish the app workspace to the entire organization. In the blog post, use the URL of the app workspace.
B. Share the report. In the blog post, use the URL of the dashboard.
C. Publish the report to the web. In the blog post, use the embed code URL.
D. In the blog post, use the URL of the report.

Explanation

Question 15 of 32

1

In the Power BI service, you create an app workspace 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?

Select one of the following:

A. Modify the members of the app workspace.
B. Configure security for the dataset used by the app.
C. Share the dashboard, and then modify the Access settings of the dashboard.
D. From the app workspace, click Update app, and then configure the Access settings.

Explanation

Question 16 of 32

1

You embed a Power BI report in a Microsoft SharePoint Online page.
A user named User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: â€œThis content isnâ€™t available.â€
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 from SharePoint Online.
What should you do?

Select one of the following:

A. Publish the app workspace.
B. Share the dashboard in the app workspace.
C. Edit the settings of the Power BI web part.
D. Modify the members of the app workspace.

Explanation

Question 17 of 32

1

You have a Power BI model that contains the following two tables:
-> Assets (AssetID, AssetName, Purchase_DateID, Value)
-> 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 percentage that the total assets value increased since one year ago.
Which DAX formula should you use?

Select one of the following:

A. (sum(Assets[Value]) - CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR('Date'[Date])))/CALCULATE(sum(Assets[Value])), SAMEPERIODLASTYEAR('Date'[Date])))
B. CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR('Date'[Date]))/ (sum(Assets[Value])
C. CALCULATE(sum(Assets[Value]),DATESYTD(('Date'[Date]))/ (sum(Assets[Value])
D. (sum(Assets[Value]) - CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR('Date'[Date]))/

Explanation

Question 18 of 32

1

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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate.
Date contains one column named Date.
The tables have the following relationships:
-> Sales[DueDate] and Date[Date]
-> Sales[ShipDate] and Date[Date]
-> Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create a calculated table. You create a measure that uses the new table.
Does this meet the goal?

Select one of the following:

Yes
No

Explanation

Question 19 of 32

1

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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate.
Date contains one column named Date.
The tables have the following relationships:
-> Sales[DueDate] and Date[Date]
-> Sales[ShipDate] and Date[Date]
-> Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions.
Does this meet the goal?

Select one of the following:

Yes
No

Explanation

Question 20 of 32

1

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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate.
Date contains one column named Date.
The tables have the following relationships:
-> Sales[DueDate] and Date[Date]
-> Sales[ShipDate] and Date[Date]
-> Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
Does this meet the goal?

Select one of the following:

Yes
No

Explanation

Question 21 of 32

1

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 user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Microsoft Office 365 Admin center, you remove User1 from the All Users security group.
Does this meet the goal?

Select one of the following:

Yes
No

Explanation

Question 22 of 32

1

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 user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI.
Does this meet the goal?

Select one of the following:

Yes
No

Explanation

Question 23 of 32

1

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 user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the PowerBI setting, you modify the Developer Settings.
Does this meet the goal?

Select one of the following:

Yes
No

Explanation

Question 24 of 32

1

You plan to embed multiple visualizations in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.

Which two visualizations can you embed into the website? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Select one or more of the following:

A. Visual 1
B. Visual 2
C. Visual 3
D. Visual 4
E. Visual 5

Explanation

Question 25 of 32

1

You have a workspace that contains 10 dashboards. A dashboard named Sales Data displays data from two datasets. You discover that users are unable to find data on the dashboard by using natural language queries.
You need to ensure that the users can find data by using natural language queries.
What should you do?

Select one of the following:

A. From the settings of the workspace, modify the Language Settings.
B. From the Sales Data dashboard, set the dashboard as a Favorite.
C. From the properties of the datasets, modify the Q&A and Cortana settings.
D. From the properties of the dashboard, modify the Q&A settings.

Explanation

Question 26 of 32

1

DRAG DROP -
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the visualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE. More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Select and Place:

Select correct option below corresponding to the highlighted orange point

Install on-prem data gateway (personal)

Config gateway con settings for dataset

Add subscriptions for the reports

Install Power BI Desktop

Config schedule refresh settings for DS

Explanation

Question 27 of 32

1

You manage a Power BI model that has two tables named Sales and Product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of Unites States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

Select one of the following:

A. Add the following filters to a report. CountryRegionName is United States ProductCategory is Clothing
B. From Power BI Desktop, create a new role that has the following filters. [CountryRegionName] = "United States" [ProductCategory] = "Clothing"
C. Add the following filters in Query Editor. CountryRegionName is United States ProductCategory is Clothing
D. From Power BI Desktop, create a new role that has the following filter. [CountryRegionName] = "United States" && [ProductCategory] = "Clothing"

Explanation

Question 28 of 32

1

You create a report in the Power BI service that displays the following visualizations:
-> A KPI that displays the count of customers
-> A table that displays the count of customers by country
-> A line chart that displays the count of customers by year
You need to receive an alert when the total number of customers reaches 10,000.
What should you do first?

Select one of the following:

A. Pin the line chart to a dashboard.
B. Pin the KPI to a dashboard.
C. Embed the report into a Microsoft SharePoint page.
D. Pin the report to a dashboard.

Explanation

Question 29 of 32

1

You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?

Select one of the following:

A. Subscriptions
B. Workbooks
C. Dashboards
D. Datasets

Explanation

Question 30 of 32

1

You have an app workspace named Retail Store Analysis in the Power BI service.
You need to manage the members that have access to the app workspace using the least amount of administrative effort.
What should you do?

Select one of the following:

A. From the Office 365 Admin center, click Users.
B. From the Power BI Admin portal, click Tenant settings.
C. From the Power BI Admin portal, click Usage metrics.
D. From the Office 365 Admin center, click Groups.

Explanation

Question 31 of 32

1

You have a Microsoft Excel spreadsheet that contains a table named Sales.
You need to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?

Select one of the following:

A. From the Power BI service, import the data from the Excel workbook.
B. From Excel, publish the workbook to the Power BI service.
C. From the Power BI tab in Excel, pin the table.
D. From the Power BI service, upload the Excel workbook.

Explanation

Question 32 of 32

1

DRAG DROP -
You have a table named Sales. Sales contains the data shown in the following table.

Select correct option below corresponding to the highlighted orange point

CALCULATE

PREVIOUSYEAR

DATEADD

SAMEPERIODLASTYEAR

SUMX

	Created by Darryl Ward over 3 years ago

Quiz on Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI, created by Darryl Ward on 10/10/2020.

Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI

Question 1 of 32

You are creating a report in Power BI Desktop. You are consuming the following tables. You need to ensure that the months appear in the order of the calendar. How should you sort the MonthName column?

Select one of the following:

Explanation

Question 2 of 32

Select correct option below corresponding to the highlighted orange point

Explanation

Question 3 of 32

Click on each orange point and select the correct answer.

Explanation

Question 4 of 32

Select one of the following:

Explanation

Question 5 of 32

You have a query that retrieves sales data. A sample of the data is shown in the following table. You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row. What should you click on the Transform tab in Query Editor?

Select one of the following:

Explanation

Question 6 of 32

Your organization has a Microsoft Office 365 subscription. When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. (Click the Exhibit button.) You need to ensure that all the users can access the Power BI service. What should you do first?

Select one of the following:

Explanation

Question 7 of 32

Select one of the following:

Explanation

Question 8 of 32

You are creating a Power BI Desktop report that has several bar charts and a date slicer. You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year. What should you do before you publish the report?

Select one of the following:

Explanation

Question 9 of 32

Select correct option below corresponding to the highlighted orange point

Explanation

Question 10 of 32

Select one of the following:

Explanation

Question 11 of 32

Select one of the following:

Explanation

Question 12 of 32

A data analyst publishes several Power BI visualizations to a blog. You discover that some of the visualizations contain data that is considered private by your company. You need to prevent the visualizations from being published to the blog. What should you do?

Select one of the following:

Explanation

Question 13 of 32

Select one of the following:

Explanation

Question 14 of 32

You create a report in the Power BI service. You plan to provide external users with access to the report by publishing the report to a public blog. You need to ensure that the report in the blog post will be updated as the data is refreshed. What should you do in the Power BI service?

Select one of the following:

Explanation

Question 15 of 32

In the Power BI service, you create an app workspace 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?

Select one of the following:

Explanation

Question 16 of 32

Select one of the following:

Explanation

Question 17 of 32

Select one of the following:

Explanation

Question 18 of 32

Select one of the following:

Explanation

Question 19 of 32

Select one of the following:

Explanation

Question 20 of 32

Select one of the following:

Explanation

Question 21 of 32

Select one of the following:

Explanation

Question 22 of 32

Select one of the following:

Explanation

Question 23 of 32

Select one of the following:

Explanation

Question 24 of 32

Select one or more of the following:

You are creating a report in Power BI Desktop.
You are consuming the following tables.

You need to ensure that the months appear in the order of the calendar.
How should you sort the MonthName column?

You have a query that retrieves sales data. A sample of the data is shown in the following table.

You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row.
What should you click on the Transform tab in Query Editor?

Your organization has a Microsoft Office 365 subscription.
When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. (Click the Exhibit button.)

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

You are creating a Power BI Desktop report that has several bar charts and a date slicer.
You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year.
What should you do before you publish the report?

A data analyst publishes several Power BI visualizations to a blog.
You discover that some of the visualizations contain data that is considered private by your company.
You need to prevent the visualizations from being published to the blog.
What should you do?

You create a report in the Power BI service.
You plan to provide external users with access to the report by publishing the report to a public blog.
You need to ensure that the report in the blog post will be updated as the data is refreshed.
What should you do in the Power BI service?

In the Power BI service, you create an app workspace 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?

You manage a Power BI model that has two tables named Sales and Product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of Unites States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?

You have an app workspace named Retail Store Analysis in the Power BI service.
You need to manage the members that have access to the app workspace using the least amount of administrative effort.
What should you do?

You have a Microsoft Excel spreadsheet that contains a table named Sales.
You need to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?

DRAG DROP -
You have a table named Sales. Sales contains the data shown in the following table.