Free Microsoft 70-779 Exam Question 1

Recent Questions

Free Microsoft 70-779 Exam Question 1

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 the worksheet.
D. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be
null.

ANSWER

Answer: A


Microsoft Exams