Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 141:

  You have a query that retrieves sales data. A sample of the data is shown in the following table.

  

  You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row. What should you click on the Transform tab in Query Editor?

  A. Format, and then Clean
  B. Date, and then Earliest
  C. Fill, and then Down
  D. Replace Values, and then Replace Errors
  C. Fill, and then Down

• Question 142:

  You have a table named Sales. A sample of the data in Sales is shown in the following table.

  

  You created a stacked column chart visualization that displays ProductName by Date.

  You discover that the axis for the visualization displays all the individual dates.

  You need to ensure that the visualization displays ProductName by year and that you can drill down to see ProductName by week and day.

  What should you do first?

  A. Configure a visual filter for the Date column that uses an advanced filter.
  B. Create a new table that has columns for the date, year, week, and day.
  C. Create a new hierarchy in the Sales table.
  D. Format the virtualization and set the type of the X-Axis to Categorical.
  B. Create a new table that has columns for the date, year, week, and day.

• Question 143:

  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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.

  The tables have the following relationships:

  The active relationship is on Sales[DueDate].

  You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.

  Solution: You create a calculated table. You create a measure that uses the new table.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 144:

  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.

  Start of repeated scenario

  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 StoreJD column. This is the only relationship between the tables.

  You plan to use Power Bl Desktop to create an analytics solution for the data.

  End of repeated scenario.

  You are modeling the data in Power Bl.

  You need to import only a sample of the data from the Order table.

  What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  A. In the Power Bl model, create a calculated table.
  B. From Query Editor, create a custom column that uses a custom column formula.
  C. From Query Editor, add a select statement that uses a where clause to the source definition.
  D. From Query Editor, create a column by using Column From Examples.
  E. From Query Editor, filter the table by Order_date.
  C. From Query Editor, add a select statement that uses a where clause to the source definition.
  E. From Query Editor, filter the table by Order_date.

• Question 145:

  You have a customer table in Power BI Desktop. The customer table contains the columns as shown in the following table.

  

  You need to create a custom column that hides the first three digits of the SSN. The values in the new column must have the xxx-99-9999 format.

  How should you complete the Query Editor 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 146:

  You have the report shown in the following exhibit.

  

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

  You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization.

  The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data.

  You need to ensure that the users will see the current data when they view the dashboard.

  How should you configure the connection to the data source?

  A. Deploy an on-premises data gateway (personal mode). Connect to the data by using the Connect live option.
  B. Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode.
  C. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode.
  D. Deploy an on-premises data gateway. Connect to the data by using the Connect live option.
  D. Deploy an on-premises data gateway. Connect to the data by using the Connect live option.

• Question 148:

  You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit.

  

  You need to ensure that when you click the bar of a country, only the values for that country are shown on the Revenue by Year and Manufacturer chart.

  A. Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Filter.
  B. Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Highlight.
  C. Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Filter.
  D. Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Highlight.
  C. Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Filter.

• Question 149:

  DRAG DROP

  You have a Power BI model that contains a table named Sales. Sales contains columns named SalesAmount, OrderDate, SalesPerson, and OrderID.

  You need to create a measure to calculate the last 12 months of sales. You must start from the last date a sale was made and ignore any filters set on the report.

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

  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: Create a new hierarchy that contains ProductCategory, then ProductSubcategory, and then Products. Configure the hierarchy as the axis. Configure Inventory as the value.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes