Exam SOL-C01 Topic 2 Question 69 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 69
Topic #: 2

You need to create a database named 'SALES DB' that is only accessible to users with the
'ACCOUNTADMIN' role. After the database is created, you want to grant the 'USAGE' privilege on it to a custom role named 'DATA ANALYST. Which sequence of commands is the MOST efficient and correct way to achieve this?

A. CREATE DATABASE SALES DB; GRANT USAGE ON DATABASE SALES DB TO ROLE DATA ANALYST; B. CREATE OR REPLACE DATABASE SALES DB; GRANT USAGE ON DATABASE SALES DB TO ROLE DATA ANALYST; C. USE ROLE ACCOUNTADMIN; CREATE DATABASE SALES DB; GRANT USAGE ON
DATABASE SALES DB TO ROLE DATA ANALYST; D. USE ROLE ACCOUNTADMIN; CREATE DATABASE SALES DB; GRANT USAGE ON
DATABASE SALES DB TO ROLE DATA ANALYST; USE ROLE DATA ANALYST; E. USE ROLE ACCOUNTADMIN; CREATE OR REPLACE DATABASE SALES DB; GRANT USAGE ON DATABASE SALES DB TO ROLE DATA ANALYST,

Suggested Answer: E Vote an answer

Option E is the most efficient and correct. You first need to assume the 'ACCOUNTADMIN' role to ensure you have the necessary privileges to create the database. While not strictly necessary,
'CREATE OR REPLACE is often preferred as it allows the script to be re-run without errors if the database already exists. Finally, you grant the USAGE' privilege to the 'DATA ANALYST role.
Options A and B do not specify to assume the 'ACCOUNTADMIN' role first. Options C and D does not use the 'CREATE OR REPLACE which is slightly inefficient and option D returns role to Data Analyst after creation which is not required.

by Ron at Mar 03, 2026, 01:47 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business