Microsoft 70-778 Online Practice Questions and Exam Preparation

Microsoft 70-778 Online Questions & Answers

• Question 1:

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

  The tables have the following relationships:

  Sales [DueDate] and Date [Date]

  Sales [ShipDate] and Date [Date]

  Sales [OrderDate] and Date [Date]

  The active relationship is on Sales [DueDate].

  You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any 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 2:

  You have the following tables.

  

  You need to create a new table that displays the top 10 customers by the total of SalesAmount.

  How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 3:

  Your organization has a team of power users who recently created 20 Power BI dashboards.

  The power users share the dashboards with other users in the organization.

  When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

  

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

  A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
  B. From the Power BI Admin portal, modify the Privacy Settings.
  C. From the properties of each dashboard, modify the Share dashboard settings.
  D. Instruct each user to install Microsoft Office 2016.
  A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

• Question 4:

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

  The tables have the following relationships:

  Sales [DueDate] and Date [Date]

  Sales [ShipDate] and Date [Date]

  Sales [OrderDate] and Date [Date]

  The active relationship is on Sales [DueDate].

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

  Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 5:

  You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.

  You need to ensure that all the visualization in the report can be consumed by users.

  Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Funnel charts
  B. Custom visuals
  C. Bubble maps
  D. Breadcrumbs
  E. R visuals
  D. Breadcrumbs
  E. R visuals

• Question 6:

  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 has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

  

  You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

  

  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 add a measure to rank total sales by product. The results must appear as shown in the following table.

  

  Which DAX formula should you use?

  A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)
  B. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Dense)
  C. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Skip)
  D. Product Ranking= RANKX (ALL (`Product'), [SalesAmount], , Asc, Dense
  B. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Dense)

• Question 7:

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

  Assets( AssetsID, AssetName, Purchase_DateID, Value) Date( DateID, Date, Month, Week, Year)

  The tables have relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the percentage that the total assets value increased since one year ago.

  Which DAX formula should you use?

  A. (sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR(`Date'[Date])))/CALCULATE (sum(Assets[Value]),SAMEPERIODLASTYEAR (`Date' [Date]))
  B. CALCULATEx(sum(Assets[Value]) DATESYTD (`Date'[Date]))/sum(Assets[Value])
  C. sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (`Date' [Date]))
  D. CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (`Date' [Date]))/sum(Assets[Value])
  C. sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (`Date' [Date]))

• Question 8:

  HOTSPOT

  You have the following tables.

  

  You need to create a new table that displays the top 10 customers by the total of SalesAmount.

  How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 9:

  You have a Power BI report that is configured to use row-level security (RLS).

  You have the following roles:

  A manager role that limits managers to see only the sales data from the stores they manage.

  A region role that limits users to see only the data from their respective region

  You plan to use Power BU Embedded to embed the report into an application. The application will authenticate the users.

  You need to ensure that RLS is enforced when accessing the embedded report.

  What should you do?

  A. In the access token for the application, include the user name and the role name.
  B. In the access token for the application, include the report URL and the Microsoft Azure Active Directory Domain name.
  C. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.
  D. From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access.
  A. In the access token for the application, include the user name and the role name.

• Question 10:

  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 an app workspace that contains a report. The report contains sensitive data.

  You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.

  Solution: From Publish to web, generate an iFrame.

  Does this meet the goal?

  A. Yes
  B. No
  B. No