SnowPro Core Exam Practice Questions Part 2 –
Questions With Solutions
Which of the following actions cannot be performed by the consumer of a
shared database? ✔️Ans - Create a new table in a shared database, insert
data in a shared table
Which function is used to find the query id of the last executed query?
✔️Ans - SELECT last_query_id()
Which of the following is true regarding how SF stores its data?
1. SF stores table data as simple comma separated files in cloud based storage
2. SF uses its own proprietary columnar format to store table data
3. SF uses parquet file format to store the table data ✔️Ans - SF uses its
own proprietary columnar format to store table data
SF patch releases are applied to all accounts at the same time ✔️Ans - True
- patch releases are applied to all accounts at the same time; the staged
released process is only used for new software releases
You increased the size of a virtual warehouse to improve performance of a
query. What is this an example of? ✔️Ans - Scale Up - Increasing the size of
a virtual warehouse will enable faster processing for queries but will not
necessarily accommodate more queries and more users
What is the SF recommended approach to identifying the minimum and
maximum values for a multi cluster virtual warehouse? ✔️Ans - 1. Track
the virtual warehouse usage over time and adjust the minimum and maximum
values that provide the best configuration for your workload
2. Start with a minimum of 1 & a maximum cluster value of 2 or 3
3. Start with the multi cluster virtual warehouse in auto scale mode
T/F - There is a cost associated with maintaining the partitions associated
with the clustering keys ✔️Ans - True - SF credits are used to organize the
data into correct partitions as it is added to the table
, What is the correct command to see all pipes which have the text TXN in their
name? ✔️Ans - SHOW PIPES LIKE '%TXN%';
In the SF staged release process for new releases, which account types are
applied updates the last? ✔️Ans - Enterprise & higher accounts
In a multi cluster virtual warehouse, if you set different values for minimum
cluster count and maximum cluster count: ✔️Ans - SF starts minimum
required clusters in the multi cluster virtual warehouse; the most is called
auto scale
What is one of the ways to improve performance in SF? ✔️Ans - Clustering
keys
Using the COPY command you can load data from which of the following
sources? ✔️Ans - Google Cloud Storage, Internal Stages, Azure Blob Storage,
AWS S3 - not IBM Cloud or Oracle Cloud
When a virtual warehouse is resized to a smaller size, the required servers are
only removed when? ✔️Ans - There are no SQL statements running on the
servers
Cloning a database will clone: ✔️Ans - All tables within every schema in
that database, all schemas in the database, the database itself
How are the columns stored in a SF micro partition (also referred to as
Columnar storage) ✔️Ans - Independently - each column is stored on its
own so they can be scanned more efficiently
Which of the following properties can be set for a multi cluster virtual
warehouse? ✔️Ans - MAX_CLUSTER_COUNT, AUTO_SUSPEND,
MIN_CLUSTER_COUNT, AUTO_RESUME
When a database or schema is cloned: ✔️Ans - External named stages are
cloned, named internal stages are NOT cloned, table internal stages are cloned
You are designing a SF based solution for a large retail chain. What should you
consider for ensuring performance once the SF based data warehouse goes
Questions With Solutions
Which of the following actions cannot be performed by the consumer of a
shared database? ✔️Ans - Create a new table in a shared database, insert
data in a shared table
Which function is used to find the query id of the last executed query?
✔️Ans - SELECT last_query_id()
Which of the following is true regarding how SF stores its data?
1. SF stores table data as simple comma separated files in cloud based storage
2. SF uses its own proprietary columnar format to store table data
3. SF uses parquet file format to store the table data ✔️Ans - SF uses its
own proprietary columnar format to store table data
SF patch releases are applied to all accounts at the same time ✔️Ans - True
- patch releases are applied to all accounts at the same time; the staged
released process is only used for new software releases
You increased the size of a virtual warehouse to improve performance of a
query. What is this an example of? ✔️Ans - Scale Up - Increasing the size of
a virtual warehouse will enable faster processing for queries but will not
necessarily accommodate more queries and more users
What is the SF recommended approach to identifying the minimum and
maximum values for a multi cluster virtual warehouse? ✔️Ans - 1. Track
the virtual warehouse usage over time and adjust the minimum and maximum
values that provide the best configuration for your workload
2. Start with a minimum of 1 & a maximum cluster value of 2 or 3
3. Start with the multi cluster virtual warehouse in auto scale mode
T/F - There is a cost associated with maintaining the partitions associated
with the clustering keys ✔️Ans - True - SF credits are used to organize the
data into correct partitions as it is added to the table
, What is the correct command to see all pipes which have the text TXN in their
name? ✔️Ans - SHOW PIPES LIKE '%TXN%';
In the SF staged release process for new releases, which account types are
applied updates the last? ✔️Ans - Enterprise & higher accounts
In a multi cluster virtual warehouse, if you set different values for minimum
cluster count and maximum cluster count: ✔️Ans - SF starts minimum
required clusters in the multi cluster virtual warehouse; the most is called
auto scale
What is one of the ways to improve performance in SF? ✔️Ans - Clustering
keys
Using the COPY command you can load data from which of the following
sources? ✔️Ans - Google Cloud Storage, Internal Stages, Azure Blob Storage,
AWS S3 - not IBM Cloud or Oracle Cloud
When a virtual warehouse is resized to a smaller size, the required servers are
only removed when? ✔️Ans - There are no SQL statements running on the
servers
Cloning a database will clone: ✔️Ans - All tables within every schema in
that database, all schemas in the database, the database itself
How are the columns stored in a SF micro partition (also referred to as
Columnar storage) ✔️Ans - Independently - each column is stored on its
own so they can be scanned more efficiently
Which of the following properties can be set for a multi cluster virtual
warehouse? ✔️Ans - MAX_CLUSTER_COUNT, AUTO_SUSPEND,
MIN_CLUSTER_COUNT, AUTO_RESUME
When a database or schema is cloned: ✔️Ans - External named stages are
cloned, named internal stages are NOT cloned, table internal stages are cloned
You are designing a SF based solution for a large retail chain. What should you
consider for ensuring performance once the SF based data warehouse goes
