Which two functions can the data architect use to accomplish this in the script?

Refer to the exhibit.

A data architect needs to transform the values for SalesYear from ‘Sales 2016’ to display only the year values ‘2016’ and ‘2017’ in the table.

Which two functions can the data architect use to accomplish this in the script? (Choose two.)
A . Right(‘$(vSalesSheet)’ as SalesYear
B . Left($(vSalesSheet)’ 4) as SalesYear
C . SubField($(vSalesSheet)’,’ ‘,2) as SalesYear
D . LTrim(‘$(vSalesSheet)’) as SalesYear
E . SubField($(vSalesSheet)’,’ ‘,1 ) as SalesYear

View Answer

Answer: AC