SAP
C_DS_42 · Question #66
C_DS_42 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock C_DS_42 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Question
You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column). How do you calculate the average salaries for each department in the Query transform in SAP Data Services?
Options
- ASpecify the DEPARTMENT column on the GROUP BY tab.
- BEnter avg(SALARY) on the Mapping tab.
- CEnter avg(SALARY) on the SELECT tab.
- DSpecify the DEPARTMENT code on the WHERE tab.
Unlock C_DS_42 to see the answer
You've previewed enough free C_DS_42 questions. Unlock C_DS_42 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.