Microsoft
70-779 · Question #64
70-779 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 70-779 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
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
Unlock 70-779 to see the answer
You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.