Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 21:

  You have a query named FactlnternetSales used by several Power BI reports. The query is shown in the exhibit.

  

  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.

  Select and Place:

  

  

• Question 22:

  You create a report in Power BI Desktop.

  You need to embed the report into a Microsoft SharePoint Online site.

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

  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 contains the following tables.

  

  The following columns contain data 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 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.

  End of repeated scenario.

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

  How should you configure the KPI indicator? To answer, drag the appropriate column 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.

  Select and Place:

  

  

• Question 24:

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

  

  You pivot the columns as shown in the following exhibit.

  

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

  A. Change the Data Type of the Value column.
  B. Select the Score column, and then click Remove Errors.
  C. Select the Key column, and then click Remove Duplicates
  D. Change the Aggregate Value Function of the pivot.
  D. Change the Aggregate Value Function of the pivot.

• Question 25:

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

  

  You plan to develop a Power BI model as 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 are implementing the Power BI model.

  You need to edit the Product Category 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 pint.

  Select and Place:

  

  

• Question 26:

  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 contains the following tables.

  

  The following columns contain data 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 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.

  End of repeated scenario.

  You need to display the month as a three-letter abbreviation, followed by the year, such as jan2017.

  You add a calculated column in Power BI.

  Which DAX formula should you use for the calculated column? 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 bat between panes or scroll to view continent.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  

• Question 27:

  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?

  A. Yes
  B. No
  A. Yes

• Question 28:

  You have a service published to a website.

  When you connect to the website, you receive the following data.

  

  You need to create a query that retrieves the Categories data and the Customers data. Which type of source should you use?

  A. JSON
  B. Text/CSV
  C. OData Feed
  D. XML
  D. XML

• Question 29:

  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.

  A. bubble maps
  B. custom visuals
  C. R visuals
  D. breadcrumbs
  E. funnel charts
  A. bubble maps
  B. custom visuals
  E. funnel charts

• Question 30:

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

  

  You plan to develop a Power BI model as 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 need to create a measure of Sales[SalesAmount] where Product[Color] is Red or Product[Size] is 50.

  Which DAX formula should you use?

  

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C