Microsoft
70-778 · Question #96
70-778 Question #96: Real Exam Question with Answer & Explanation
Sign in or unlock 70-778 to reveal the answer and full explanation for question #96. The question stem and answer options stay visible for context.
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
Unlock 70-778 to see the answer
You've previewed enough free 70-778 questions. Unlock 70-778 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.