Snowflake SnowPro Core Practice Exam
4 Questions and Answers (Graded A)
Snowflake's approach to the management of system access combines which of the following
models? (Choose two.) - ANSWER - Role-Based Access Control (RBAC)
Discretionary Access Control (DAC)
Snowflake's approach to access control combines aspects from both of the following models:
Discretionary Access Control (DAC): Each object has an owner, who can in turn grant access to
that object.
Role-based Access Control (RBAC): Access privileges are assigned to roles, which are in turn
assigned to users.
What happens to the shared objects for users in a consumer account from a share, once a
database has been created in that account? - ANSWER - The shared objects become
accessible.
Once a database is created (in a consumer account) from a share, all the shared objects are
accessible to users in the consumer account.
Which of the following Snowflake capabilities are available in all Snowflake editions? - ANSWER
- Automatic encryption of all data
Object-level access control
Which of the following file formats is not supported by Snowflake to unload data? - ANSWER -
Arvo
A File Format object describes and stores the format information required to load data into
Snowflake tables. You can specify different parameters, such as the file's delimiter, if you want
to skip the header or not, etc.
,Streams are Snowflake objects that record data manipulation language (DML) changes made to
tables and views, including INSERTS, UPDATES, and DELETES, as well as metadata about
each change. A stream can also be referred to as a "table stream".
Which statements are true concerning Snowflake's underlying cloud infrastructure? - ANSWER -
Snowflake uses the core compute and storage services of each cloud provider for its own
compute and storage.
Snowflake data and services are deployed in at least three availability zones within a cloud
provider's region.
Which of the following SQL statements will list the version of the drivers currently being used? -
ANSWER - Execute SELECT CURREN_CLIENT(); from an application
CURRENT_CLIENT() -- name and version of connected client CURRENT_VERSION() --
version of Snowflake
What is the name of the SnowSQL file that can store connection information? - ANSWER -
config
SnowSQL supports multiple configuration files that allow organizations to define base values for
connection parameters, default settings, and variables while allowing individual users to
customize their personal settings in their own <HOME_DIR>/.snowsql/config files.
What happens when an external or an internal state is dropped? - ANSWER - When dropping
an external stage, the files are not removed and only the stage is dropped.
When dropping an internal stage, the files are deleted with the stage and the files are not
recoverable.
For an internal stage, all of the files in the stage are purged from Snowflake, regardless of their
load status. This prevents the files from continuing to using storage and, consequently, accruing
storage charges.
However, this also means that the staged files cannot be recovered after a stage is dropped.
For an external stage, only the stage itself is dropped; any data files in the referenced external
location (Amazon S3, Google Cloud Storage, or Microsoft Azure) are not removed.
, Which Snowflake object stores DML changes made to tables and metadata about each
change? - ANSWER - Table streams
All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed
and managed entirely on a selected cloud platform.
Snowflake is provided as Software-as-a-Service (SaaS) that runs completely on cloud
infrastructure. This means that all three layers of Snowflake's architecture (storage, compute,
and cloud services) are deployed and managed entirely on a selected cloud platform.
In addition, Snowflake's virtual warehouses and cloud services layers are similarly deployed
across three availability zones in a region.
Top of Snowflake Partner Diagram - ANSWER - Data Integration
Which programming languages are supported for Snowflake User-Defined Functions (UDFs) -
ANSWER - Python and Javascript
A task is still being executed before the next scheduled task. What is going to happen with the
new scheduled task? - ANSWER - Snowflake will skip it.
Snowflake ensures that only one instance of a task with a schedule is executed at a given time.
If a task is still running when the next scheduled execution time occurs, then that scheduled
time is skipped.
What command will use warehouse credits? - ANSWER - SELECT MAX(ID) FROM MYTABLE
GROUP BY ID
GROUP BY doesn't use metadata cache
Which file function generates a Snowflake-hosted file URL to a staged file using the stage name
and relative file path as inputs? - ANSWER - BUILD_STAGE_FILE_URL
BUILD_STAGE_FILE_URL Generates a Snowflake-hosted file URL to a staged file using the
stage name and relative file path as inputs. A file URL permits prolonged access to a specified
file. That is, the file URL does not expire.
4 Questions and Answers (Graded A)
Snowflake's approach to the management of system access combines which of the following
models? (Choose two.) - ANSWER - Role-Based Access Control (RBAC)
Discretionary Access Control (DAC)
Snowflake's approach to access control combines aspects from both of the following models:
Discretionary Access Control (DAC): Each object has an owner, who can in turn grant access to
that object.
Role-based Access Control (RBAC): Access privileges are assigned to roles, which are in turn
assigned to users.
What happens to the shared objects for users in a consumer account from a share, once a
database has been created in that account? - ANSWER - The shared objects become
accessible.
Once a database is created (in a consumer account) from a share, all the shared objects are
accessible to users in the consumer account.
Which of the following Snowflake capabilities are available in all Snowflake editions? - ANSWER
- Automatic encryption of all data
Object-level access control
Which of the following file formats is not supported by Snowflake to unload data? - ANSWER -
Arvo
A File Format object describes and stores the format information required to load data into
Snowflake tables. You can specify different parameters, such as the file's delimiter, if you want
to skip the header or not, etc.
,Streams are Snowflake objects that record data manipulation language (DML) changes made to
tables and views, including INSERTS, UPDATES, and DELETES, as well as metadata about
each change. A stream can also be referred to as a "table stream".
Which statements are true concerning Snowflake's underlying cloud infrastructure? - ANSWER -
Snowflake uses the core compute and storage services of each cloud provider for its own
compute and storage.
Snowflake data and services are deployed in at least three availability zones within a cloud
provider's region.
Which of the following SQL statements will list the version of the drivers currently being used? -
ANSWER - Execute SELECT CURREN_CLIENT(); from an application
CURRENT_CLIENT() -- name and version of connected client CURRENT_VERSION() --
version of Snowflake
What is the name of the SnowSQL file that can store connection information? - ANSWER -
config
SnowSQL supports multiple configuration files that allow organizations to define base values for
connection parameters, default settings, and variables while allowing individual users to
customize their personal settings in their own <HOME_DIR>/.snowsql/config files.
What happens when an external or an internal state is dropped? - ANSWER - When dropping
an external stage, the files are not removed and only the stage is dropped.
When dropping an internal stage, the files are deleted with the stage and the files are not
recoverable.
For an internal stage, all of the files in the stage are purged from Snowflake, regardless of their
load status. This prevents the files from continuing to using storage and, consequently, accruing
storage charges.
However, this also means that the staged files cannot be recovered after a stage is dropped.
For an external stage, only the stage itself is dropped; any data files in the referenced external
location (Amazon S3, Google Cloud Storage, or Microsoft Azure) are not removed.
, Which Snowflake object stores DML changes made to tables and metadata about each
change? - ANSWER - Table streams
All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed
and managed entirely on a selected cloud platform.
Snowflake is provided as Software-as-a-Service (SaaS) that runs completely on cloud
infrastructure. This means that all three layers of Snowflake's architecture (storage, compute,
and cloud services) are deployed and managed entirely on a selected cloud platform.
In addition, Snowflake's virtual warehouses and cloud services layers are similarly deployed
across three availability zones in a region.
Top of Snowflake Partner Diagram - ANSWER - Data Integration
Which programming languages are supported for Snowflake User-Defined Functions (UDFs) -
ANSWER - Python and Javascript
A task is still being executed before the next scheduled task. What is going to happen with the
new scheduled task? - ANSWER - Snowflake will skip it.
Snowflake ensures that only one instance of a task with a schedule is executed at a given time.
If a task is still running when the next scheduled execution time occurs, then that scheduled
time is skipped.
What command will use warehouse credits? - ANSWER - SELECT MAX(ID) FROM MYTABLE
GROUP BY ID
GROUP BY doesn't use metadata cache
Which file function generates a Snowflake-hosted file URL to a staged file using the stage name
and relative file path as inputs? - ANSWER - BUILD_STAGE_FILE_URL
BUILD_STAGE_FILE_URL Generates a Snowflake-hosted file URL to a staged file using the
stage name and relative file path as inputs. A file URL permits prolonged access to a specified
file. That is, the file URL does not expire.
