Microsoft 70-779 Online Practice Questions and Exam Preparation

Microsoft 70-779 Online Questions & Answers

• Question 21:

  You have two visualization as shown in the following exhibit.

  

  Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. Note: Each correct answer is worth one point.

  Hot Area:

  

  

• Question 22:

  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 two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1. but only a subset of the data.

  You add Test1 as a data source, and you select 10 tables. You configure several transformations.

  You need to connect the model to the tables in Production1. The solution must maintain the existing transformations.

  Solution: You delete the existing queries, and then you add new data sources.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 23:

  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 Excel workbook that contains a table named Table1. A sample of the data in Table1 is shown in the following table.

  

  You need to create a PivotTable in PowerPivot as shown in the exhibit. (Click the Exhibit button.)

  

  Solution: You create a hierarchy named Products that contains ProductCategory, ProductSubCategory, and ProductName. You add a PivotTable. You drag Products to the Rows field. You drag Price to the Values field. Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 24:

  You need to configure a PivotChart as shown in the following exhibit.

  

  Which chart element should you enable?

  A. Data Labels
  B. Axis Titles
  C. Data Table
  D. Error Bars
  B. Axis Titles

• Question 25:

  You have a table in a Microsoft SQL Server database that has more than 5 columns. A sample of the data and some of the columns are shown in the following table.

  

  The table contains more than two million rows. You have 100 clients and 10 products.

  You need to load the data to Excel. The solution must minimize the amount of memory used by the model.

  What should you do?

  A. Move the database to a Microsoft Azure SQL database. Load the table to the data model.
  B. Load the data to the data model as three tables named Clients, Orders, and Products. Ensure that each table has only the relevant columns. Remove duplicate rows from Clients and Products.
  C. Load the data to one worksheet.
  D. Load the data to three worksheets named Clients, Orders, and Products. Ensure that each worksheet has only the relevant columns. Remove duplicate rows from Clients and Products.
  B. Load the data to the data model as three tables named Clients, Orders, and Products. Ensure that each table has only the relevant columns. Remove duplicate rows from Clients and Products.

• Question 26:

  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 thescenario is the same in each question in this series. Start of repeated scenario. You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the exhibit. (Click the Exhibit

  button.) Exhibit:

  

  Your company has 100 product subcategories and more than 10,000 products.

  End of repeated scenario.

  You need to create a chart as shown in the following exhibit.

  

  Which type of chart should you use?

  A. Line with markers
  B. clustered column
  C. stacked column
  D. combo
  D. combo

• Question 27:

  You have an Excel workbook that contains two tables named User and Activity.

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

  Users will use QandA in the Power BI service to perform natural language queries.

  You need to ensure that the users can query the term employee and receive results from the User table.

  What should you do before you publish to Power BI?

  A. From the Power Pivot model, edit the synonyms.
  B. From PowerPivot Settings, modify the language options.
  C. From PowerPivot Settings modify the categorization options.
  D. From Workbook Connections, add a connection.
  B. From PowerPivot Settings, modify the language options.

• Question 28:

  From a workbook query, you import a table that has the following data.

  

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

  

  What should you do?

  A. From the Format menu, click Trim.
  B. From the Format menu, click Clean.
  C. From the Split Column menu, click By Delimiter.
  D. From the Extract menu, click Last Characters.
  A. From the Format menu, click Trim.

• Question 29:

  You have a table named Sales that has three columns named Region, Country, and SalesAmount. You create a PivotTable as shown in the following exhibit.

  

  You need to ensure that the PivotTable appears in three columns as shown in the following exhibit.

  

  What should you do?

  A. On the Design tab, click Report Layout and then click Show in Compact Form.
  B. Move Country from the Rows area to the Columns area.
  C. Move Country from the Rows area to the Values area.
  D. On the Design tab, click Report Layout and then click Show in Tabular Form.
  D. On the Design tab, click Report Layout and then click Show in Tabular Form.

• Question 30:

  HOTSPOT

  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 are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit. (Click the Exhibit button.)

  Data Sample exhibit:

  

  

  The data model is shown in the Data Model exhibit. (Click the Exhibit button.)

  

  The tables in the model contain the following data:

  1. DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue column.

  2. Workshops have a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always Firstname Lastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.

  3. RepairTypes has a list of all the repair types

  4. Dates has a list of dates from 2015 to 2018

  End of repeated scenario.

  You need to add a custom column to the workbook query for Workshops that contains the email address of the workshop manager. The format of the email address is [email protected].

  How should you complete the query from Query Editor? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area: