Free Download 70-778 Examp Dump: Microsoft.70-778.PrepAway.2020-11-14.134q.vcex

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

Yes
No

Correct answer: B

Question 2

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?

Yes
No

Correct answer: A

Explanation:

References:https://msdn.microsoft.com/en-us/library/ee634966.aspxhttps://msdn.microsoft.com/en-us/library/ee634825.aspxhttps://msdn.microsoft.com/en-us/library/ee634791.aspx

References:

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

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

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

Question 3

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?

Yes
No

Correct answer: B

Question 4

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?

Yes
No

Correct answer: B

Question 5

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?

Yes
No

Correct answer: A

Explanation:

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

Question 6

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?

Yes
No

Correct answer: B

Question 7

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.

Visual 1
Visual 2
Visual 3
Visual 4
Visual 5

Correct answer: BD

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

Question 8

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?

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

Correct answer: C

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview

Question 9

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.

Correct answer: To work with this question, an Exam Simulator is required.

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Question 10

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?

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

Correct answer: A

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter

Exam	Analyzing and Visualizing Data with Microsoft Power BI
Number	70-778
File Name	Microsoft.70-778.PrepAway.2020-11-14.134q.vcex
Size	9 MB
Posted	Nov 14, 2020
Download	Microsoft.70-778.PrepAway.2020-11-14.134q.vcex

Download Microsoft.70-778.PrepAway.2020-11-14.134q.vcex

File Info

How to open VCEX & EXAM Files?

Demo Questions