Task 4.2: Apply Authorization Mechanisms DEA-C01 Practice Questions (Page 3)

Questions 11–12

1. 11foundation · easy

   A data engineer needs to remove a user's ability to insert data into a table in Amazon Redshift. Which SQL command should the engineer use?

   • ADENY INSERT ON table TO user
   • BALTER USER DROP INSERT ON table
   • CREVOKE INSERT ON table FROM user
   • DDELETE PRIVILEGE INSERT ON table FROM user
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   A data engineer needs to revoke a user's access to a specific column in a table managed by AWS Lake Formation. Which Lake Formation permission should the engineer revoke?

   • ADESCRIBE on the column
   • BALTER on the column
   • CINSERT on the column
   • DSELECT on the column
   Reveal Solution Discussion Select an answer first