Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 11:

  You are creating a Power BI Desktop report that has several bar charts and a date slicer. You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year. What should you do before you publish the report?

  A. Configure report level filters, and then create groups that use the List group type.
  B. Configure drillthrough filters for each bar chart, and then select Selection Pane.
  C. Filter the bar charts by using the slicer, and then create bookmarks.
  D. Configure page level filters, and then create groups that use the Bin group type.
  C. Filter the bar charts by using the slicer, and then create bookmarks.

• Question 12:

  You have a Power BI model that contains a table named Sales. Sales has the following three measures:

  1. A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.

  2. A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.

  A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year]

  

• Question 13:

  You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source.

  You need to ensure that you can use R visualization.

  Which action should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Download and install Microsoft R Server.
  B. Download and install RStudio Server on the computer that has Power BI Desktop installed.
  C. Install SQL Server R Services on the server that runs SQL Server.
  D. Enable R Scripting on the computer that has Power BI Desktop installed.
  E. Download and install Microsoft R on the computer that has Power BI Desktop installed.
  E. Download and install Microsoft R on the computer that has Power BI Desktop installed.

• Question 14:

  You have a query that uses a Microsoft Excel data source. The data source contains the following table.

  

  You need the data to appear as shown in the following table.

  

  What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 15:

  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?

  A. Microsoft Azure SQL Database
  B. a Microsoft SQL Server database
  C. a Microsoft SQL Server Analysis Services (SSAS) database
  D. Microsoft Excel
  C. a Microsoft SQL Server Analysis Services (SSAS) database

• Question 16:

  You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

  You need to add a new column that contains the data in the format of nnn-nnn-nnnn.

  How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 17:

  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?

  A. Add a folder data source and use the Combine Files command.
  B. Add a folder data source and use the Merge Queries command.
  C. Add a Microsoft Excel data source and use the Merge Queries command.
  D. Add text/CSV data sources and use the Append Queries command.
  A. Add a folder data source and use the Combine Files command.

• Question 18:

  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 table named Toys. Toys contains the columns configured as shown in the following table.

  

  You plan to add a stacked column chart visualization that will display Inventory by ProductCategory.

  You need to ensure that a user can select a specific product category in the visualization, and can drill down to view Inventory for ProductSubcategory and then Products within ProductSubcategory.

  Solution: Configure ProductCategory as the axis. Configure ProductSubcategory as the legend. Configure Products as the value. Add a slicer and configure inventory as the field.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 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 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 Bl service.

  Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 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 an app workspace that contains a report. The report contains sensitive data.

  You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.

  Solution: Configure the app workspace to be read-only for members and to run in a shared capacity.

  Does this meet the goal?

  A. Yes
  B. No
  B. No