Snowflake SnowPro Core Exam Questions with Detailed
Solutions 2025 Update
True or False: A single database can exist in more than one Snowflake account. Correct
Ans-B. False
https://docs.snowflake.com/en/sql-reference/ddl-database.html
A database is a logical grouping of schemas. Each database belongs to a single Snowflake
account.
Which of the following roles is recommended to be used to create and manage users and
roles?
A. SYSADMIN
B. SECURITYADMIN
C. PUBLIC
D. ACCOUNTADMIN Correct Ans-D. ACCOUNTADMIN
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN
role. This user should then create one or more additional users who are assigned the
USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN
role or another role that is granted the global CREATE USER privilege.
,Snowflake SnowPro Core Exam Questions with Detailed
Solutions 2025 Update
We strongly recommend the following precautions when assigning the ACCOUNTADMIN role
to users:
The ACCOUNTADMIN role is intended for performing initial setup tasks in the system and
managing account-level objects and tasks on a day-to-day basis. As such, it should not be used
to create objects in your account, unless you absolutely need these objects to have the
highest level of secure access. If you create objects with the ACCOUNTADMIN role and you
want users to have access to these objects, you must explicitly grant privileges on the objects
to the roles for these users.
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
Correct Ans-True Most Voted. Reference:https://docs.snowflake.com/en/user-guide-data-
unload.html
Snowflake supports specifying a SELECT statement instead of a table in the COPY INTO
<location> command. The results of the query are written to one or more files as specified in
the command and the file(s) are stored in the specified location (internal or external).
True or False: A customer using SnowSQL / native connectors will be unable to also use the
Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.
Correct Ans-False
,Snowflake SnowPro Core Exam Questions with Detailed
Solutions 2025 Update
Reference:https://docs.snowflake.com/en/user-guide/connecting.html
SnowSQL is the command line client for connecting to Snowflake to execute SQL queries and
perform all DDL and DML operations, including loading data into and unloading data out of
database tables.
!!! Account-level storage usage can be monitored via
A. The Snowflake Web Interface (UI) in the Databases section
B. The Snowflake Web Interface (UI) in the Account -> Billing & Usage section
C. The Information Schema -> ACCOUNT_USAGE_HISTORY View
D. The Account Usage Schema -> ACCOUNT_USAGE_METRICS View Correct Ans-B. The
Snowflake Web Interface (UI) in the Account -> Billing & Usage section
https://docs.snowflake.com/en/user-guide/admin-usage-billing.html
Classic Web Interface
Click Account » Billing & Usage » Average Storage Used.
=>There is no ACCOUNT_USAGE_HISTORY VIEW under informaiton schema
, Snowflake SnowPro Core Exam Questions with Detailed
Solutions 2025 Update
=> There is no ACCOUNT_USAGE_METRICS View under Account Usage Schema
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
A. Number of users
B. Warehouse size
C. Amount of data processed
D. # of clusters for the Warehouse Correct Ans-????
Correct answer show
B. Warehouse size
C. Amount of data processed
Community voted, I think this is right
B. Warehouse size
D. # of clusters for the Warehouse
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage
Virtual Warehouse Credit Usage
Solutions 2025 Update
True or False: A single database can exist in more than one Snowflake account. Correct
Ans-B. False
https://docs.snowflake.com/en/sql-reference/ddl-database.html
A database is a logical grouping of schemas. Each database belongs to a single Snowflake
account.
Which of the following roles is recommended to be used to create and manage users and
roles?
A. SYSADMIN
B. SECURITYADMIN
C. PUBLIC
D. ACCOUNTADMIN Correct Ans-D. ACCOUNTADMIN
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN
role. This user should then create one or more additional users who are assigned the
USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN
role or another role that is granted the global CREATE USER privilege.
,Snowflake SnowPro Core Exam Questions with Detailed
Solutions 2025 Update
We strongly recommend the following precautions when assigning the ACCOUNTADMIN role
to users:
The ACCOUNTADMIN role is intended for performing initial setup tasks in the system and
managing account-level objects and tasks on a day-to-day basis. As such, it should not be used
to create objects in your account, unless you absolutely need these objects to have the
highest level of secure access. If you create objects with the ACCOUNTADMIN role and you
want users to have access to these objects, you must explicitly grant privileges on the objects
to the roles for these users.
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
Correct Ans-True Most Voted. Reference:https://docs.snowflake.com/en/user-guide-data-
unload.html
Snowflake supports specifying a SELECT statement instead of a table in the COPY INTO
<location> command. The results of the query are written to one or more files as specified in
the command and the file(s) are stored in the specified location (internal or external).
True or False: A customer using SnowSQL / native connectors will be unable to also use the
Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.
Correct Ans-False
,Snowflake SnowPro Core Exam Questions with Detailed
Solutions 2025 Update
Reference:https://docs.snowflake.com/en/user-guide/connecting.html
SnowSQL is the command line client for connecting to Snowflake to execute SQL queries and
perform all DDL and DML operations, including loading data into and unloading data out of
database tables.
!!! Account-level storage usage can be monitored via
A. The Snowflake Web Interface (UI) in the Databases section
B. The Snowflake Web Interface (UI) in the Account -> Billing & Usage section
C. The Information Schema -> ACCOUNT_USAGE_HISTORY View
D. The Account Usage Schema -> ACCOUNT_USAGE_METRICS View Correct Ans-B. The
Snowflake Web Interface (UI) in the Account -> Billing & Usage section
https://docs.snowflake.com/en/user-guide/admin-usage-billing.html
Classic Web Interface
Click Account » Billing & Usage » Average Storage Used.
=>There is no ACCOUNT_USAGE_HISTORY VIEW under informaiton schema
, Snowflake SnowPro Core Exam Questions with Detailed
Solutions 2025 Update
=> There is no ACCOUNT_USAGE_METRICS View under Account Usage Schema
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
A. Number of users
B. Warehouse size
C. Amount of data processed
D. # of clusters for the Warehouse Correct Ans-????
Correct answer show
B. Warehouse size
C. Amount of data processed
Community voted, I think this is right
B. Warehouse size
D. # of clusters for the Warehouse
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage
Virtual Warehouse Credit Usage
