Microsoft
70-779 · Question #64
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…
The correct answer is A. All the columns except InternalPrice will load to the worksheet The values in ResellerPrice will be. See the full explanation below for the reasoning.
Question
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?
Options
- AAll the columns except InternalPrice will load to the worksheet The values in ResellerPrice will be
- BAn error message will appear and all the data will fail to load.
- CAn error message will appear and all the columns except InternalPnce and ResellerPrice will load
- DAll the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be
How the community answered
(42 responses)- A79% (33)
- B12% (5)
- C7% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.