[Free] EnsurePass Microsoft 70-778 Real Exam Dumps Questions 31-40

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

Question No.31

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 Power BI Admin portal, you modify the Dashboard 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.32

You plan to use Power BI Desktop to import 100 CSV files.

The files contain data from different stores. The files have the same structure and are stored in a network share.

You need to import the CSV files into one table. The solution must minimize administrative effort. What should you do?

  1. Add a folder data source and use the Combine Files command.

  2. Add a folder data source and use the Merge Queries command.

  3. Add a Microsoft Excel data source and use the Merge Queries command.

  4. Add text/CSV data sources and use the Append Queries command.

Correct Answer: A

Explanation:

https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

Question No.33

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. Click Replace Errors… and enter a value of 0

Does this meet the goal?

  1. Yes

  2. No

Correct Answer: A

Question No.34

DRAG DROP

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

image

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

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 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 frag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

image

Correct Answer:

image

Question No.35

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.

image

Correct Answer:

image

Question No.36

DRAG DROP

You have a query named FactlnternetSales used by several Power BI reports. The query is shown in the exhibit. (Click the Exhibit button.)

image

You plan to create a bar chart showing the count of sales by year that have a SalesAmount greater than $1,000.

You need to create a measure that will be used in the bar chart.

How should you complete the DAX formula? 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.37

You have a Power BI report in an app workspace.

You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.

Which information should you provide to the application developers?

  1. The application token and the report URL

  2. The report URL and a user name

  3. The app workspace name and the access key

  4. The access key and the report ID

Correct Answer: C

Explanation:

https://docs.microsoft.com/en-us/power-bi/developer/integrate-report

Question No.38

Your company has a custom line-of-business application named SalesApp.

The developers of SalesApp want to push data into the Power BI service to create several visualizations.

You need to ensure that the developers can push the data from SalesApp to the Power BI service. What should you do?

  1. Go to portal.azure.com and create a web app.

  2. Go to dev.powerbi.com/apps and register an application.

  3. Go to app.powerbi.com/admin-portal and click Publish to web.

  4. Go to app.powerbi.com and create an app workspace.

Correct Answer: B

Explanation:

https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-register-app-with- azure-ad

Question No.39

You have an on-premises Power BI Report Server.

You plan to create a report in Power BI Desktop and 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: C

Explanation:

https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources

Question No.40

You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd.

You create a new Power BI Desktop model that uses 120 tables from SQLDev. You plan to publish the Power BI file to the Power BI service.

You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort.

What should you do from Query Editor before you publish the model?

  1. Create a new connection to SQLProd, and then import the tables from SQLProd.

  2. Delete the existing queries, and then add new data sources.

  3. Configure the Data source settings.

  4. Edit the source of each table query.

Correct Answer: D

Explanation:

https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data

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

Leave a Comment

Your email address will not be published. Required fields are marked *