Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 71:

  You have a Power BI model for sales data. You create a measure to calculate the year-to- date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?

  A. DATE ADD
  B. LASTDATE
  C. ENDOFVEAR
  D. PREVIOUSYEAR
  D. PREVIOUSYEAR

• Question 72:

  DRAG DROP

  You have a column named phone_number. The values in the columns are in one of the following formats:

  999-999-9999x123

  1-999-999-9999x232

  +1-999-999-9999x66x666

  The values after x in the phone-number column indicate the phone extension.

  You need to create a custom column in Query Editor that contains only the phone extensions.

  How should you complete the 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 point.

  Select and Place:

  

  

• Question 73:

  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 Monthly_returns table and Date[Date_ID]. What should you do before you create the relationship?

  A. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
  B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
  C. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
  D. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.
  B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.

• Question 74:

  HOTSPOT

  You have a Power BI model that has the following tables:

  Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) Salesperson (Salesperson_id, Salesperson_name, address) Product (Product_id, Product_Name)

  You need to create the following relationships:

  Sales to Product

  Sales to Sales person

  You need to ensure that you can create a report that displays the count of products sold by each salesperson.

  How should you configure the relationships? To answer, drag the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 75:

  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 B! Desktop to create an analytics solution for the data.

  End of repeated scenario.

  You need to create a chart that displays a sum of Order[Order_amount] by month for the Order_ship_date column and the Order_date column.

  How should you model the data?

  A. Add a second Date table named Ship_date to the model. Create a many-to-many relationship from Date[Date_ID] to Order [Order_date] and a many-to-many relationship from Ship_date[DateJD] to Order[Order_ship_date].
  B. Add a second Date table named Ship_date to the model. Create a one-to-many relationship from Date[Date_ID] to Order [Order_date] and a one-to-many relationship from Ship_date[Date_ID] to Order[Order_ship_dateJ.
  C. Create a one-to-many relationship from Date[Date_ID] to Order[Order_date] and another relationship from Date[Date_ID] to Monthly_returns[Date_IDJ.
  D. Create a one-to-many relationship from Date[Date_ID] to Order[Order_date] and another relationship from Date[Date_ID] to Order[Order_ship_date].
  D. Create a one-to-many relationship from Date[Date_ID] to Order[Order_date] and another relationship from Date[Date_ID] to Order[Order_ship_date].

• Question 76:

  You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart The date value in AdivityDate is a number column named DatelD. DatelD is in the YYYYMMDD format.

  What should you do in the model before you create the relationship?

  A. Change the Data Type of ActivityStart to Date.
  B. Create a measure in ActivityLog that uses the format DAX function.
  C. Change the Data Type of DatelD to Date.
  D. Create a calculated column in ActivityLog that uses the format DAX function.
  D. Create a calculated column in ActivityLog that uses the format DAX function.

• Question 77:

  You embed a Power BI report in a Microsoft SharePoint Online page.

  A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: "This content isn't available".

  User1 is unable to view the report.

  You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

  You need to ensure that User1 can view the report form SharePoint Online.

  What should you do?

  A. Publish the app workspace.
  B. Edit the settings of the Power BI web part.
  C. Modify the members of the app workplace.
  D. Share the dashboards in the app workspace.
  C. Modify the members of the app workplace.

• Question 78:

  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 implement the Power BI model.

  You need to create a hierarchy that has Category, Subcategory, and Product.

  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.

  NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

  Select and Place:

  

  

• Question 79:

  DRAG DROP

  You need to create a measure named YTDPreviousSales that will be used in a table visualization. YTDPreviousSales must show the year-to-date (YTD) sales of the previous year for the same month. A sample of the desired data is shown in the following table.

  

  How should you complete the measure? 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:

  

  

  ---

  You are configuring the relationships between the following tables.

  

• Question 80:

  You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the exhibit).

  

  The model has the following relationships:

  Store the District based on DistrictID

  Sales to Store based on LocationID

  Sales to Date based on PeriodID

  Sales to Item based on ItemID

  You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.

  When the district managers view the sales report, they see Sales by Items for all stores.

  You need to ensure that the district managers can see Sales by items for the stores they manage only.

  How should you configure the relationship from Sales to Item?

  A. Change the Cardinality to One to one (1:1).
  B. Change the Cardinality to One to Many (1.*).
  C. Select Assume Referential Integrity.
  D. Change the Cross filter direction to Both.
  D. Change the Cross filter direction to Both.