Snowflake SnowPro Core Exam
Questions and Answers 100% Verified
True or False: A single database can exist in more than one Snowflake account. - ANSWER - 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 - ANSWER - 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.
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.
- ANSWER - 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. -
ANSWER - False
Reference:https://docs.snowflake.com/en/user-guide/connecting.html
Which statement best describes ג€clusteringג€?
A. Clustering represents the way data is grouped together and stored within Snowflake's micro-
partitions
B. The database administrator must define the clustering methodology for each Snowflake table
C. The clustering key must be included on the COPY command when loading data into
Snowflake
D. Clustering can be disabled within a Snowflake account - ANSWER - A. Clustering represents
the way data is grouped together and stored within Snowflake's micro-partitions
True or False: The COPY command must specify a File Format in order to execute. - ANSWER
- FALSE=>most voted
Snowflake Document shows FALSE, file format is option parameters
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#required-parameters
Which of the following objects can be cloned? (Choose four.)
A. Tables Most Voted
B. Named File Formats Most Voted
C. Schemas Most Voted
D. Shares
E. Databases Most Voted
F. Users - ANSWER - A. Tables Most Voted
B. Named File Formats Most Voted
C. Schemas Most Voted
E. Databases Most Voted
,This command is primarily used for creating zero-copy clones of databases, schemas, and
tables; however, it can also be used to quickly/easily create clones of other schema objects (i.e.
external stages, file formats, and sequences).
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 - ANSWER - 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
=> 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 - ANSWER - ????
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
A virtual warehouse is one or more clusters of compute resources that enable executing
queries, loading data, and performing other DML operations. Snowflake credits are used to pay
for the processing time used by each virtual warehouse.
Snowflake credits are charged based on the number of virtual warehouses you use, how long
they run, and their size.
Snowflake is designed for which type of workloads? (Choose two.)
A. OLAP (Analytics) workloads Most Voted
B. OLTP (Transactional) workloads
C. Concurrent workloads Most Voted
D. On-premise workloads - ANSWER - A. OLAP (Analytics) workloads Most
C. Concurrent workloads Most Voted
Votedhttps://www.snowflake.com/guides/olap-vs-oltp
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
A. To accommodate more queries
B. To accommodate more users
C. To accommodate fluctuations in workload
D. To accommodate a more complex workload Most Voted - ANSWER - Given Answer: A. To
accommodate more queries; Used voted : D. To accommodate a more complex workload Most
Voted
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
Resizing a warehouse generally improves query performance, particularly for larger, more
complex queries. It can also help reduce the queuing that occurs if a warehouse does not have
enough compute resources to process all the queries that are submitted concurrently. Note that
warehouse resizing is not intended for handling concurrency issues; instead, use additional
warehouses to handle the workload or use a multi-cluster warehouse (if this feature is available
for your account).
Snowflake supports resizing a warehouse at any time, even while running. If a query is running
slowly and you have additional queries of similar size and complexity that you want to run on the
same warehouse, you might choose to resize the warehouse while it is running;
Questions and Answers 100% Verified
True or False: A single database can exist in more than one Snowflake account. - ANSWER - 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 - ANSWER - 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.
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.
- ANSWER - 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. -
ANSWER - False
Reference:https://docs.snowflake.com/en/user-guide/connecting.html
Which statement best describes ג€clusteringג€?
A. Clustering represents the way data is grouped together and stored within Snowflake's micro-
partitions
B. The database administrator must define the clustering methodology for each Snowflake table
C. The clustering key must be included on the COPY command when loading data into
Snowflake
D. Clustering can be disabled within a Snowflake account - ANSWER - A. Clustering represents
the way data is grouped together and stored within Snowflake's micro-partitions
True or False: The COPY command must specify a File Format in order to execute. - ANSWER
- FALSE=>most voted
Snowflake Document shows FALSE, file format is option parameters
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#required-parameters
Which of the following objects can be cloned? (Choose four.)
A. Tables Most Voted
B. Named File Formats Most Voted
C. Schemas Most Voted
D. Shares
E. Databases Most Voted
F. Users - ANSWER - A. Tables Most Voted
B. Named File Formats Most Voted
C. Schemas Most Voted
E. Databases Most Voted
,This command is primarily used for creating zero-copy clones of databases, schemas, and
tables; however, it can also be used to quickly/easily create clones of other schema objects (i.e.
external stages, file formats, and sequences).
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 - ANSWER - 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
=> 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 - ANSWER - ????
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
A virtual warehouse is one or more clusters of compute resources that enable executing
queries, loading data, and performing other DML operations. Snowflake credits are used to pay
for the processing time used by each virtual warehouse.
Snowflake credits are charged based on the number of virtual warehouses you use, how long
they run, and their size.
Snowflake is designed for which type of workloads? (Choose two.)
A. OLAP (Analytics) workloads Most Voted
B. OLTP (Transactional) workloads
C. Concurrent workloads Most Voted
D. On-premise workloads - ANSWER - A. OLAP (Analytics) workloads Most
C. Concurrent workloads Most Voted
Votedhttps://www.snowflake.com/guides/olap-vs-oltp
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
A. To accommodate more queries
B. To accommodate more users
C. To accommodate fluctuations in workload
D. To accommodate a more complex workload Most Voted - ANSWER - Given Answer: A. To
accommodate more queries; Used voted : D. To accommodate a more complex workload Most
Voted
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
Resizing a warehouse generally improves query performance, particularly for larger, more
complex queries. It can also help reduce the queuing that occurs if a warehouse does not have
enough compute resources to process all the queries that are submitted concurrently. Note that
warehouse resizing is not intended for handling concurrency issues; instead, use additional
warehouses to handle the workload or use a multi-cluster warehouse (if this feature is available
for your account).
Snowflake supports resizing a warehouse at any time, even while running. If a query is running
slowly and you have additional queries of similar size and complexity that you want to run on the
same warehouse, you might choose to resize the warehouse while it is running;
