Snowflake
SOL-C01 · Question #281
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 r
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #281. The question stem and answer options stay visible for context.
Snowflake Account and Security
Question
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?
Options
- ACREATE DATABASE SALES DB; GRANT USAGE ON DATABASE SALES DB TO ROLE DATA
- BCREATE OR REPLACE DATABASE SALES DB; GRANT USAGE ON DATABASE SALES DB TO
- CUSE ROLE ACCOUNTADMIN; CREATE DATABASE SALES DB; GRANT USAGE ON
- DUSE ROLE ACCOUNTADMIN; CREATE DATABASE SALES DB; GRANT USAGE ON
- EUSE ROLE ACCOUNTADMIN; CREATE OR REPLACE DATABASE SALES DB; GRANT USAGE
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Role-Based Access Control#Database Management#Permissions#DDL/DCL