SOL-C01 Question #60: Real Exam Question with Answer & Explanation

Question

A data engineer is tasked with creating a new database called `SALES DATA within a Snowflake account. They want to ensure that only users with the 'ACCOUNTADMIN' role or a custom role 'SALES ADMIN' can manage the database's overall configuration. Which of the following steps are necessary to achieve this? (Choose all that apply)

Options

• AGrant the `OWNERSHIP' privilege on the 'SALES_DATX database to the 'SALES_ADMIN' role.
• BGrant the `CREATE SCHEMA' privilege on the `SALES DATA' database to the 'SALES_ADMIN'
• CGrant the `MODIFY privilege on the DATABASE object to the 'SALES_ADMIN' role.
• DGrant the `USAGE privilege on the 'DATABASE object to the `SALES ADMINS role.
• EThe 'ACCOUNTADMIN' role already has sufficient privileges; no additional grants are needed for

Explanation

The 'OWNERSHIP' privilege grants the 'SALES ADMIN' role full control over the 'SALES DATA' database, including configuration. ACCOUNTADMIN' inherently has ownership over all objects and requires no additional grants. 'CREATE SCHEMA' is for creating schemas within the database, 'MODIFY is not a valid privilege on 'DATABASE object, and ` USAGE allows access but not management of the database object itself.

No community discussion yet for this question.