CCFH-202B Question #4: Real Exam Question with Answer & Explanation

The correct answer is A. By renaming the fields with the "rename" command after the transforming command e.g. "stats. The rename command is used to rename fields while using transforming commands such as table, chart, and stats. It can be used after the transforming command and specify the old and new field names with the AS keyword. You can rename fields as it would not affect sub-queries and s

Question

How do you rename fields while using transforming commands such as table, chart, and stats?

Options

ABy renaming the fields with the "rename" command after the transforming command e.g. "stats
BYou cannot rename fields as it would affect sub-queries and statistical analysis
CBy using the "renamed" keyword after the field name eg "stats count renamed totalcount by
DBy specifying the desired name after the field name eg "stats count totalcount by ComputerName"

Explanation

The rename command is used to rename fields while using transforming commands such as table, chart, and stats. It can be used after the transforming command and specify the old and new field names with the AS keyword. You can rename fields as it would not affect sub-queries and statistical analysis, as long as you use the correct field names in your queries. The renamed keyword and the desired name after the field name are not valid ways to rename fields.

Community Discussion

No community discussion yet for this question.

Full CCFH-202B Practice