SnowPro Core Certification — Question 1248
What can a reader account user do when accessing shared data? (Choose two.)
Answer options
- A. Insert new data using the COPY INTO [location] command.
- B. Execute secure User-Defined Functions (UDFs).
- C. Remove records using the DELETE command.
- D. Select data from secure views.
- E. Modify records using the UPDATE and MERGE commands.
Correct answer: B, D
Explanation
The correct answers are B and D because a reader account is granted the ability to execute secure User-Defined Functions (UDFs) and select data from secure views, but does not have permissions to insert, delete, or modify records. Options A, C, and E involve actions that require higher permissions than those assigned to a reader account.