Manage Roles and Role-Based Access Control COF-C03 Practice Questions (Page 5)

Questions 21–22

1. 21application · medium

   A user with the ACCOUNTADMIN role needs to transfer ownership of a table to the DATA_ENGINEER role. What is the correct command?

   • AALTER TABLE SALES SET OWNER = DATA_ENGINEER;
   • BGRANT ALL PRIVILEGES ON TABLE SALES TO ROLE DATA_ENGINEER;
   • CDROP TABLE SALES AND RECREATE IT AS DATA_ENGINEER;
   • DGRANT OWNERSHIP ON TABLE SALES TO ROLE DATA_ENGINEER;
   Reveal Solution Discussion Select an answer first
2. 22application · easy

   An organization has a role hierarchy where the DATA_ENGINEER role is a child of the DATA_SCIENCE role. The DATA_SCIENCE role has SELECT on the CUSTOMER table. A user is granted only the DATA_ENGINEER role. What privileges does this user have on the CUSTOMER table?

   • ASELECT, but only if the user also has the DATA_SCIENCE role active.
   • BSELECT, because DATA_ENGINEER inherits privileges from DATA_SCIENCE.
   • CNo privileges, because the user was not granted DATA_SCIENCE directly.
   • DOnly the privileges explicitly granted to DATA_ENGINEER.
   Reveal Solution Discussion Select an answer first