Microsoft
70-778 · Question #96
You have a query that retrieves sales data. A sample of the data is shown in the following table. You need to ensure that the values in the Date column contain a date. Null values must be replaced…
The correct answer is C. Fill, and then Down. See the full explanation below for the reasoning.
Question
You have a query that retrieves sales data. A sample of the data is shown in the following table. You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row. What should you click on the Transform tab in Query Editor?
Exhibit
Options
- AFormat, and then Clean
- BDate, and then Earliest
- CFill, and then Down
- DReplace Values, and then Replace Errors
How the community answered
(39 responses)- A8% (3)
- B15% (6)
- C74% (29)
- D3% (1)
Community Discussion
No community discussion yet for this question.