[Free] 2019(Nov) EnsurePass Microsoft 70-778 Dumps with VCE and PDF 11-20

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 contain 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 mil not appear in the review screen.

You have a query for a table named Sales Sales has a column Named Customer lD. The Data Type of Customer ID 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 CustomerID column and click Replace Errors鈥?Does this meet the goal?

  1. Yes

  2. No

Correct Answer: A

Question No.12

You have an app workplace that contains a dashboard and four reports. All the reports are generated from a smote dataset that contains sales data for your company. The reports display the data contoured as shown in the following table.

image

You need to ensure that the users of the reports can locate the correct report by using natural language queries.

What should you do?

  1. From the properties of the dataset. create tour Featured Qamp;A Questions.

  2. From the Format settings of the reports, modify the Page Information.

  3. From the properties of the dataset. modify the Qamp;A and Cortana settings.

  4. From the properties of the workspace, modify the language Settings.

Correct Answer: A

Question No.13

You have the following two queries in Power BI Desktop:

image

A Query named Query 1 that retrieves a table named SM8_ Customers from a Microsoft SQL Server database

image

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?

  1. Combine Files

  2. Merge Columns

  3. Merge Queries

  4. Append Queries

Correct Answer: C

Question No.14

You have a table in Power B1 Desktop as shown m the following exhibit.

image

You pivot the columns as shown in the following exhibit.

image

You need to resolve the error in row 3. The solution must preserve all the data. What should you do?

  1. Change the Data Type of the Value column.

  2. Select the Score column, and then dick Remove Errors,

  3. Select the Key column, and then click Remove Duplicates.

  4. Change the Aggregate Value function of the pivot.

Correct Answer: B

Question No.15

DRAG DROP

You have a Microsoft Exert 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 m sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

image

Correct Answer:

image

Question No.16

DRAG DROP

Note: This question it 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 the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that contains the following tables.

image

The Oder table contains more than one million rows.

The Store table has a relationship to the Monthy_returns table on the StoreID column. This is the only relationship between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data. End of repeated scenario.

You need to configure a KPI indicator to show the monthly sales of a store versus the target sales of that store.

How should you configure the KPI indicator? To answer, drag the appropriate columns to the correct fields. Each column may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

image

Correct Answer:

image

Question No.17

Your organization has a team of power users who recently created 20 Power BI dashboards. The power users share the dashboards with other users m the organization

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

image

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

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

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

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

  4. Instruct each user to install Microsoft Office 2016.

Correct Answer: A

Question No.18

You have an on-premises Power BI Report Server.

You plan to create a report in Power BI Desktop and to publish the report to the report server. Which data source should the report use?

  1. Microsoft Azure SQL Database

  2. a Microsoft SQL Server database

  3. a Microsoft SQL Server Analysis Services (SSAS) database

  4. Microsoft Excel

Correct Answer: D

Question No.19

DRAG DROP

Note: This question it 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)

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

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 need to edit the Product Category table query to match the desired Power BI model.

How should you complete the advanced query? To answer, drag the appropriate values to the correct targets Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

image

Correct Answer:

image

Question No.20

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?

  1. From the app workspace, click Update app, and then configure the Access settings.

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

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

  4. Modify the members of the app workspace.

Correct Answer: B

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.