Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 61:

  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: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 62:

  You have a Power Pivot model that includes a KPI.

  You need to create a visualization based on the Power Pivot model as shown in the exhibit. (Click the Exhibit button.)

  

  Which type of visualization should you use?

  A. matrix
  B. KPI
  C. multi row card
  D. table
  B. KPI

• Question 63:

  You have the visualization shown in the following exhibit.

  

  You need to display the values as shown in the following exhibit.

  

  What should you do?

  A. Create a calculated column that adds the % symbol to the values.
  B. From the Modeling tab, change the Data Type to Percentage.
  C. Edit the query of the data source and change the Data Type to Percentage.
  D. Create a measure that adds the % symbol to the values,
  D. Create a measure that adds the % symbol to the values,

• Question 64:

  You have a Power BI model for sales data.

  You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period.

  Which DAX function should you use?

  A. PARALLELPERIOD
  B. SAMEPERIODLAST YEAR
  C. DATESYTD
  D. PREVIOUSYEAR
  A. PARALLELPERIOD

• Question 65:

  You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data. In Power BI Desktop, you have the following query for the cube.

  

  The query retrieves 25,499 records.

  When you check the data warehouse that is the source of the cube, you discover that there are 26,423 records.

  You need to ensure that the query retrieves all 26,423 records.

  What should you do?

  A. From Query Editor, refresh all the data.
  B. Change the query to use Live connection mode.
  C. Delete the Remove Duplicates step.
  D. Add an Unpivot Columns step.
  C. Delete the Remove Duplicates step.

• Question 66:

  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 Excel, click Publish to Power BI, and then click Export. Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 67:

  You are importing sales data from a Microsoft Excel file named Sales.xlsx into Power BI Desktop.

  You need to create a bar chart showing the total sales amount by region.

  When you create the bar chart, the regions appear as expected, but the sales amount value displays the count of sales amount instead of the sum of sales amount each region.

  You need to modify the query to ensure that the data appears correctly.

  What should you do?

  A. Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server.
  B. In Query Editor, add a calculated column that totals the sales amount column.
  C. Change the Data Type of sales amount column to Numeric.
  D. Refresh the data model.
  B. In Query Editor, add a calculated column that totals the sales amount column.

• Question 68:

  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 are modifying the model to report on the number of order.

  You need to calculate the number of orders.

  What should you do?

  A. Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.
  B. Create a calculated measure that uses the SUM (Order_ID) DAX formula.
  C. Create a calculated column that uses the SUM (Order_ID) DAX formula.
  D. Create a calculated column that uses the COUNTA (Order_ID) DAX formula.
  A. Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.

• Question 69:

  Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service.

  Which three operations can the developers achieve by using the API? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  A. Retrieve rows from a dataset
  B. Create a dataset
  C. Add rows to a dataset
  D. Refresh an imported dataset
  E. Add a member to a row-level security role
  A. Retrieve rows from a dataset
  B. Create a dataset
  C. Add rows to a dataset

• Question 70:

  HOTSPOT

  You have the following tables.

  

  You need to create a measure to calculate a running total of TransactionQuantity.

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

  NOTE: Each correct selection is worth one point.

  Hot Area: