Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 101:

  You are creating a report in Power BI Desktop. You are consuming the following tables.

  

  Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format. You create the report shown in the exhibit. (Click the Exhibit button.)

  

  You need to ensure that the months appear in the order of the calendar. How should you sort the MonthName column?

  A. by MonthNumber
  B. ascending
  C. descending
  D. by DateKey
  A. by MonthNumber

• Question 102:

  You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.)

  

  The file is in c:\data\.

  You need to ensure that you can publish the file to Power BI.

  What should you do first?

  A. Save the file in a Microsoft SharePoint document library.
  B. Decrypt the workbook.
  C. Add a digital signature to the workbook.
  D. Set the file attributes to read-only.
  B. Decrypt the workbook.

• Question 103:

  You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd.

  You create a new Power BI Desktop model that uses 120 tables from SQLDev.

  You plan to publish the Power BI file to the Power BI service.

  You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort.

  What should you do from Query Editor before you publish the model?

  A. Create a new connection to SQLProd, and then import the tables from SQLProd.
  B. Delete the existing queries, and then add new data sources.
  C. Configure the Data source settings.
  D. Edit the source of each table query.
  D. Edit the source of each table query.

• Question 104:

  You have an app workspace that contains two datasets named dataset1 and dataset2. Dataset1 connects to a Microsoft Azure SQL database. Dataset2 connects to a Microsoft Excel file stored in Microsoft OneDrive for Business.

  You create a report named Report1 that uses dataset1.

  You pin Report1 to a dashboard named Dashboard1.

  You publish the app workspace to all the users in your organization.

  You need to delete dataset2 from the app workspace.

  What should you do first?

  A. Delete Dashboard1.
  B. Delete Report1.
  C. Unpublish the app.
  D. Configure the refresh settings for Dataset2.
  C. Unpublish the app.

• Question 105:

  You have a Power BI report in an app workspace.

  You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.

  Which information should you provide to the application developers?

  A. The application token and the report URL
  B. The report URL and a user name
  C. The app workspace name and the access key
  D. The access key and the report ID
  C. The app workspace name and the access key

• Question 106:

  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 user named User1. User1 is a member of a security group named Contoso PowerBI.

  User1 has access to a workspace named Contoso Workspace.

  You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.

  Solution: From the Microsoft Office 365 Admin center, you remove User1 from the All Users security group.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 107:

  DRAG DROP

  You have sales data in a spreadsheet named Sales.xlsx.

  You need to provide a detailed sales report to several managers.

  From the Power BI service, you create an app workspace named SalesWorkspace.

  Which three actions should you perform in sequence next? 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 108:

  DRAG DROP

  You have a Microsoft Excel workbook that contains two tables.

  From Power BI, you create a dashboard that displays data from the tables.

  You update the tables each day.

  You need to ensure that the virtualizations in the dashboard are updated daily. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.

  Select and Place:

  

  

• Question 109:

  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 two copies of the Date table named

  ShipDate and OrderDateGet. You create a measure that uses the new tables.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 110:

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

  

  The model has the following relationships:

  Store to 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 Store by Items report, they see items for all the stores.

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

  How should you configure the relationship from Sales to Item?

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