Get 70-779 PDF Dumps for Simple Good results: Realexamdumps.com

 Question #:1

You have a table that contains data relating to exam candidates and their associated scores.

You need to visualize the exam data by separating the data into quartiles. The visualization must display the

mean score and must identify any outliers.

Which type of chart should you use?

A. line

B. histogram

C. Bpie

D. box and whisker

Answer: D

Question #:2

You import the data from two next files into a PowerPivot model to create two tables named Customers andInvoices. Each table contains a column named CustomerID.

When you attempt to create a relationship between the Customers table and the Invoices table by using the

CustomerID column from each table, the relationship cannot be created due to duplicate CustomerID values.

You need to ensure that you can create the relationship.

What should you do?

A. Add an index column to the Customers query

B. Add an index column to the Invoices query

C. Group the Customers query by CustomerID

D. Sort the Invoices query by CustomerID, and then add a Fill Down step

Answer: C

Question #:3

You add two tables named Date and Invoices to a data model, Invoices contains a column named InvoiceDate

that has a Data Type of Date, Date contains a column named DateID that has a Data Type of which Number.

DateID is in the format of YYYYMMDD.

You need to create a relationship between Date and Invoices.

What should you do first?

A. Change the Data Type of InvoiceDate and DateID to Text.

B. Create a measure in Invoices that uses the Format DAX Function.

C. Change the Data Type of DateID to Date.

D. Create a calculated column in Invoices that uses the Format DAX function.

Answer: C

Explanation

https://support.office.com/en-us/article/data-types-in-data-models-e2388f62-6122-4e2b-bcad-053e3da9ba90?ui=en

Question #:4

You have a workbook query that loads data from a table named Products.

Products contains a column named IntemalPrice that has a Data Type of Decimal.

From Query Editor you create a custom column named ResellerPrice that uses a formula to multiply

InternalPrice by 1.2, and then you remove the IntemalPrice column.

What will occur when you load the data to a worksheet?

A. All the columns except InternalPrice will load to the worksheet The values in ResellerPrice will be

correct.

B. An error message will appear and all the data will fail to load.

C. An error message will appear and all the columns except InternalPnce and ResellerPrice will load to theworksheet.

D. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null.

Answer: D