Exam 70-779 topic 1 question 67 discussion

Actual exam question from Microsoft's 70-779

Question #: 67
Topic #: 1

You have a workbook query that loads data from a table named Products.
Products contains a column named InternalPrice 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 InternalPrice column.
What will occur when you load the data to a worksheet?

A. An error message will appear and all the columns except InternalPrice and ResellerPrice will load to the worksheet.
B. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be correct.
C. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null.
D. An error message will appear and all the data will fail to load.

Show Suggested Answer

Suggested Answer: C 🗳️

by JohnFan at Oct. 7, 2019, 9:05 a.m.