SnowPro Core Exam Practice Questions Part 3 –
Questions & Answers
What is a SF virtual warehouse? ✔️Ans - Virtual warehouse is the name
given to the compute clusters used by SF for query processing.
Which options can be used to bring semi structured data into SF? ✔️Ans -
Load semi structured data into a VARIANT column; Transform the data while
using the COPY command
T/F - A Small virtual warehouse (2 servers) executing for 2 hours will
consume the same number of credits as a Medium virtual warehouse (4
servers) executing for 1 hour ✔️Ans - True - with a larger size the credit
consumption is more
In the SF staged release process for new releases, which account types are
applied updates ahead of everyone else? ✔️Ans - Designated accounts opting
for early access
The reader account belongs to: ✔️Ans - The producer - created by, owned by,
uses the compute resources of the producer
T/F - In a VARIANT column, the NULL values are stored as a literal string
"null" ✔️Ans - True
Under the Download section in Snowflake Web UI, what are the connectors &
programs that can be downloaded? ✔️Ans - Spark Connector, Python
Components, Node.js driver; not Redshift connector or Unload connector
Y/N - SF stores data for each table in a proprietary columnar format ✔️Ans -
Yes
On the WebUI, which button on the top bar should you select to run queries?
✔️Ans - Worksheets
To see existing virtual warehouses, what is the correct command? ✔️Ans -
SHOW WAREHOUSES;
, You are creating a new virtual warehouse that you want to auto suspend if no
query has been run in last 10 minutes. What is the correct syntax for creating
such a virtual warehouse? ✔️Ans - CREATE OR REPLACE WAREHOUSE
brand_new_warehouse WAREHOUSE_SIZE=large AUTO_SUSPEND=600;
A share has been granted to a consumer. If a new object is added to the share
it will: ✔️Ans - Become accessible to the consumer immediately
T/F - SF maintains the partitions using the order of the data in which it is
inserted ✔️Ans - True - and this may require reclustering of very large tables
in which data has been inserted over time
T/F - By 'warehouse size' SF means the number of servers in each cluster
✔️Ans - True
T/F - Micro partitioning can be disabled for tables if needed ✔️Ans - False -
it's automatically managed by SF; you can only control the clustering key
which changes the micro partitioning approach but does not disable it
What is the correct command to see all pipes defined under a database called
my_database? ✔️Ans - USE my_database; SHOW PIPES;
Which types of query results may be produced without requiring a running
virtual warehouse? ✔️Ans - Query results that can be fulfilled from cache do
not require a virtual warehouse. The cache could be the result cache or
metadata cache
The maximum possible period for which a query result cache may be retained
is ✔️Ans - 31 days - the query result cache is purged after 24 hours unless
another query is run which makes use of the cache. the query result is
retained for a maximum of 31 days after being generated as long as the cache
is getting reused during that period before the 24 hour period expires
A cloned object doesn't contribute to overall storage unless: ✔️Ans - New
populated tables are created in one of the cloned schemas; operations that
modify data are performed on the cloned table (update, insert, delete); there
is no CREATE_COPY statement and you can only clone an object you have
privileges to
Questions & Answers
What is a SF virtual warehouse? ✔️Ans - Virtual warehouse is the name
given to the compute clusters used by SF for query processing.
Which options can be used to bring semi structured data into SF? ✔️Ans -
Load semi structured data into a VARIANT column; Transform the data while
using the COPY command
T/F - A Small virtual warehouse (2 servers) executing for 2 hours will
consume the same number of credits as a Medium virtual warehouse (4
servers) executing for 1 hour ✔️Ans - True - with a larger size the credit
consumption is more
In the SF staged release process for new releases, which account types are
applied updates ahead of everyone else? ✔️Ans - Designated accounts opting
for early access
The reader account belongs to: ✔️Ans - The producer - created by, owned by,
uses the compute resources of the producer
T/F - In a VARIANT column, the NULL values are stored as a literal string
"null" ✔️Ans - True
Under the Download section in Snowflake Web UI, what are the connectors &
programs that can be downloaded? ✔️Ans - Spark Connector, Python
Components, Node.js driver; not Redshift connector or Unload connector
Y/N - SF stores data for each table in a proprietary columnar format ✔️Ans -
Yes
On the WebUI, which button on the top bar should you select to run queries?
✔️Ans - Worksheets
To see existing virtual warehouses, what is the correct command? ✔️Ans -
SHOW WAREHOUSES;
, You are creating a new virtual warehouse that you want to auto suspend if no
query has been run in last 10 minutes. What is the correct syntax for creating
such a virtual warehouse? ✔️Ans - CREATE OR REPLACE WAREHOUSE
brand_new_warehouse WAREHOUSE_SIZE=large AUTO_SUSPEND=600;
A share has been granted to a consumer. If a new object is added to the share
it will: ✔️Ans - Become accessible to the consumer immediately
T/F - SF maintains the partitions using the order of the data in which it is
inserted ✔️Ans - True - and this may require reclustering of very large tables
in which data has been inserted over time
T/F - By 'warehouse size' SF means the number of servers in each cluster
✔️Ans - True
T/F - Micro partitioning can be disabled for tables if needed ✔️Ans - False -
it's automatically managed by SF; you can only control the clustering key
which changes the micro partitioning approach but does not disable it
What is the correct command to see all pipes defined under a database called
my_database? ✔️Ans - USE my_database; SHOW PIPES;
Which types of query results may be produced without requiring a running
virtual warehouse? ✔️Ans - Query results that can be fulfilled from cache do
not require a virtual warehouse. The cache could be the result cache or
metadata cache
The maximum possible period for which a query result cache may be retained
is ✔️Ans - 31 days - the query result cache is purged after 24 hours unless
another query is run which makes use of the cache. the query result is
retained for a maximum of 31 days after being generated as long as the cache
is getting reused during that period before the 24 hour period expires
A cloned object doesn't contribute to overall storage unless: ✔️Ans - New
populated tables are created in one of the cloned schemas; operations that
modify data are performed on the cloned table (update, insert, delete); there
is no CREATE_COPY statement and you can only clone an object you have
privileges to
