Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 111:

  In the Power BI service, you create an app workplace that contains several dashboards.

  You need to provide a user named [email protected] with the ability to edit and publish dashboards.

  What should you do?

  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.
  C. Share the dashboard, and then modify the Access settings of the dashboard.

• Question 112:

  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?

  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.
  A. From the app workspace, click Update app, configure the Access setting, and then click Update app.

• Question 113:

  You create a new app workspace. You add a user named Userl1 as a member of the workspace. Userl1 can edit content.

  You plan to create a report in an app workspace that uses data from a Microsoft Azure SQL database.

  You need to create the report. The solution must ensure that Userl1 can edit the report from Power BI Desktop and from powerbi.com.

  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:

  

  

• Question 114:

  You plan to create several datasets by using the Power BI service. You have the files configured as shown in the following table.

  

  You need to identify which files can be used as datasets.

  Which two files should you identify? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Data 1
  B. Data2
  C. Data 3
  D. Data4
  E. Data 5
  A. Data 1
  E. Data 5

• Question 115:

  You open the Power BI Admin portal as shown in the following graphic.

  

  All the app workspaces use the customer's capacity.

  Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 116:

  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?

  A. Yes
  B. No
  B. No

• Question 117:

  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?

  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.
  C. From the Power BI tab in Excel, pin the table.

• Question 118:

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

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

  

  The following columns contain date information:

  -Date[Month] in the mmyyyy format

  -Date[Date_ID] in the ddmmyyyy format

  -Date[Date_name] in the mm/dd/yyyy format

  -

  Monthly_returns[Month_ID] in the mmyyyy format

  The Order table contains more than one million rows.

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

  You plan to use Power BI Desktop to create an analytics solution for the data. You need to create a relationship between the Order table and the Store table on the Store_ID column.

  What should you do before you create the relationship?

  A. In the Order table query, use the Table.TrasformRows function.
  B. In the Store table query, use the Table.TrasformRows function.
  C. In the Store table query, use the Table.TrasformColumnTypes function.
  D. In the Order table query, use the Table.TrasformColumnTypes function.
  C. In the Store table query, use the Table.TrasformColumnTypes function.

• Question 119:

  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 the Power BI service, get the data from SharePoint Online, and then click Import.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 120:

  You plan to use Power BI Embedded to deliver reports in a web application.

  You need to ensure that the reports display live data.

  Which data source you should use?

  A. Microsoft Azure Data Lake Store
  B. Microsoft Azure Table Storage
  C. Microsoft Azure HDInsight D. Microsoft Azure SQL Database
  D