問題文
A nightly extract that runs as a service account produced a file in which the shipper contact column contains masked values, and a copy of that data made with SELECT INTO into a staging table is masked as well. The service account holds SELECT on the source table. Which change corrects both outputs?
選択肢
- Change the extract to read through a view over the masked column, because a projection of a masked column returns the underlying value.
- Remove the mask from the column during the extract window and re-apply it afterwards, because an expression that references a masked column is masked as well and so the mask itself has to be taken out of the way.
- Grant the service account the unmasking permission alongside its SELECT, because copying and exporting performed by a user without that permission produce masked values in the destination.
- Add the service account to the role that owns the schema, because ownership of the schema conveys the unmasking permission.