Mobile Menu

[Free] EnsurePass Microsoft 70-778 Real Exam Dumps Questions 11-20

by admin, February 7, 2020

Get Full Version of the Exam
http://www.EnsurePass.com/70-778.html

Question No.11

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

  1. Yes

  2. No

Correct Answer: B

Question No.12

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 virtualizations 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 answer area and arrange them in the correct order.

image

Correct Answer:

image

Question No.13

You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales.

You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?

  1. DATEADD

  2. TOTALYTD

  3. DATESYTD

  4. ENDOFYEAR

Correct Answer: C

Explanation:

Year to Date in Previous/Prior Year

Question No.14

HOTSPOT

Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:

image

image

Access a published Power BI app Modify reports in an app workspace

image

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) licenses, 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.

image

Correct Answer:

image

Question No.15

You have a workspace that contains 10 dashboards. A dashboard named Sales 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?

  1. From the settings of the workspace, modify the Language Settings.

  2. From the properties of the dashboard, modify the Qamp;A settings.

  3. From the Sales Data dashboard, modify the dashboard as a Favorite.

  4. From the properties of the datasets, modify the Qamp;A and Cortana settings.

Correct Answer: D

Explanation:

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

Question No.16

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 properties of each dashboard, you modify the Share settings. Does this meet the goal?

  1. Yes

  2. No

Correct Answer: B

Explanation:

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

Question No.17

You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.

You need to ensure that all the visualization in the report can be consumed by users.

Which three types of visualizations should you include in the report? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

  1. bubble maps

  2. custom visuals

  3. R visuals

  4. breadcrumbs

  5. funnel charts

Correct Answer: ABE

Explanation:

https://docs.microsoft.com/en-us/power-bi/report-server/install-powerbi-desktop

Question No.18

Note: This question is part of a series of questions that use 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 button.)

image

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

image

You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values.

End of Repeated Scenario.

You need to create a measure of Sales[SalesAmount] where Product[Color] is Red or Product[Size] is 50.

Which DAX formula should you use?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: C

Question No.19

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 query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.

You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.

You need to ensure that nonnumeric values in the CustomerlD column are set to 0. Solution: From Query Editor, select the CustomerlD column and click Remove Errors. Does this meet the goal?

  1. Yes

  2. No

Correct Answer: B

Question No.20

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?

  1. Yes

  2. No

Correct Answer: B

Get Full Version of the Exam
70-778 Dumps
70-778 VCE and PDF

Categories