Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 81:

  Your organization has a Microsoft Office 365 subscription.

  When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. (Click the Exhibit button.)

  

  You need to ensure that all the users can access the Power BI service. What should you do first?

  A. From the Microsoft Azure Active Directory admin center, assign a Power BI (free) license to each user.
  B. From the Power BI Admin portal, modify the Tenant settings.
  C. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet.
  D. From the properties of each dashboard, modify the Share dashboard settings.
  C. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet.

• Question 82:

  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 plan to create a chart that displays total Order [Order_amount] by Store [Name].

  You need to modify the model to ensure that you can create the chart.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. To the Order table, add a column that uses the RELATED(`Store' [Store_ID]) DAX formula.
  B. Create a relationship between the Order table and the Store table.
  C. To the Order table, add a measure that uses the COUNT (`Order'[Order_amount]) DAX formula.
  D. To the order table, add a measure that uses the SUM (`Order' [Order_amount]) DAX formula.
  A. To the Order table, add a column that uses the RELATED(`Store' [Store_ID]) DAX formula.
  D. To the order table, add a measure that uses the SUM (`Order' [Order_amount]) DAX formula.

• Question 83:

  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: Configure the axis to use ProductCategory, then ProductSubcategory, and then Products. Configure Inventory as the value.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 84:

  You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

  A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.

  You need to ensure that User sees App1 from the My organization AppSource. What should you do?

  A. From the app workspace, click Update app, configure the Content settings, and then click Update app.
  B. From the app workspace settings, add a member.
  C. From the app workspace, click Update app, configure the Access setting, and then click Update app.
  D. From the app workspace, share the dashboard.
  C. From the app workspace, click Update app, configure the Access setting, and then click Update app.

• Question 85:

  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. DATEADD
  B. TOTALYTD
  C. DATESYTD
  D. ENDOFYEAR
  C. DATESYTD

• Question 86:

  Note: This question is a 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 query for a table named Sales. Sales has a column named CustomerID. The Data type of CustomerID is Whole Number.

  You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.

  You need to ensure that nonnumeric values in the CustomerID column are set to 0.

  Solution: From Query Editor, select the CustomerID column and click Replace Values...

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 87:

  You create a KPI visualization in Power BI Desktop that uses the month as the trend axis.

  You discover that the data is not sorted by month.

  You need to change the sort order of the visualization.

  What should you do first?

  A. Convert the visualization to a different type.
  B. Remove the trend axis from the visualization.
  C. Modify the visual level filters.
  D. Modify the drill through filters.
  B. Remove the trend axis from the visualization.

• Question 88:

  You have a workspace that contains 10 dashboards. A dashboard named Sales Data from two datasets. You discover that users are unable to find data on the dashboard by using natural language queries. You need to ensure that the users can find data by using natural language queries.

  What should you do?

  A. From the settings of the workspace, modify the Language Settings.
  B. From the properties of the dashboard, modify the QandA settings.
  C. From the Sales Data dashboard, modify the dashboard as a Favorite.
  D. From the properties of the datasets, modify the QandA and Cortana settings.
  D. From the properties of the datasets, modify the QandA and Cortana settings.

• Question 89:

  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 PowerBI setting, you modify the Developer Settings.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 90:

  You have an app workspace named Retail Store Analysis in the Power Bl service.

  You need to manage the members that have access to the app workspace using the least amount of administrative effort.

  What should you do?

  A. From the Power Bl Admin portal, click Usage metrics .
  B. From the Office 365 Admin center, click Groups.
  C. From the Office 365 Admin center, click Users.
  D. From the Power Bl Admin portal, click Tenant settings.
  A. From the Power Bl Admin portal, click Usage metrics .