Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 151:

  You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company. The reports display the data configured as shown in the following table.

  

  You need to ensure that the users of the reports can locate the correct report by using natural language queries. What should you do?

  A. From the properties of the dataset, create four Featured QandA Questions.
  B. From the Format settings of the reports, modify the Page Information.
  C. From the properties of the dataset, modify the QandA and Cortana settings.
  D. From the properties of the workspace, modify the Language Settings.
  C. From the properties of the dataset, modify the QandA and Cortana settings.

• Question 152:

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

  1. Product (Product_id, Product_Name)

  2. Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)

  3. Salesperson (Salesperson_id, Salesperson_name, address)

  You plan to create the following measure.

  Measure1 = DISTINCTCOUNT(Sales[ProductID])

  You need to create the following relationships:

  1. Sales to Product

  2. Sales to Salesperson

  The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 153:

  From Power BI Desktop, you create a query that imports the following table.

  

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

  

  What should you do?

  A. From the Extract menu, click Last Characters.
  B. From the Extract menu, click Text After Delimiter.
  C. From the Format menu, click Trim.
  D. From the Split Column menu, click BY Delimiter.
  B. From the Extract menu, click Text After Delimiter.

• Question 154:

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

  Sales (Sales_ID, DateID, sales_amount) Date (DateID, Date, Month, week, Year)

  The tables have a relationship. Date is marked as a date table in the Power BI model.

  You need to create a measure to calculate the sales for the last 12 months.

  Which DAX formula should you use?

  A. CALCULATEx(SUM(sales[sales_amount]) DATESYTD (`Date' [Date]))
  B. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR (`Date' [Date]))
  C. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(`Date'[Date]))
  D. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]),DATESYTD(`Date'[Date]))
  C. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(`Date'[Date]))

• Question 155:

  You have two tables named CustomerVisits and Date in a Power BI model.

  You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)

  

  You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.

  You need to fix the report to display the correct data for each month.

  What should you do?

  A. Create a relationship between the CustomerVisits table and the Date table.
  B. Create a hierarchy in the Date table.
  C. Modify the n=measure to use the CALCULATE DAX function.
  D. Modify the measure to use the SUM DAX function.
  A. Create a relationship between the CustomerVisits table and the Date table.