SnowPro Certification – Questions With Answers
Every Week ✔️Ans - Snowflake deploy new release at what frequency?
Cluster the Transactions table on the transaction data column. The daily
report will only access one day at a time and therefore will only scan required
data ✔️Ans - You are the data modeler at a large retail organization who
store their transactional data in a Snowflake table called "Transactions". The
daily revenue reports execute using the "Transactions" table and calculates
the revenue for the current day.
The "Transactions" table had 500GB of data originally but it has now grown to
be 5TB. You have noticed that over time the performance of the daily revenue
reports have degraded.
What is most efficient & cost effective way of optimizing performance.
SnowSQL, ODBC Driver, JDBC Driver ✔️Ans - Under the Download section
in Snowflake Web UI, what are the connectors & programs that can be
downloaded? Select All that apply
Alter the existing virtual warehouse and change the size to Large.
ALTER_WAREHOUSE reporting_warehouse WAREHOUSE_SIZE=large ✔️Ans
- You have a virtual warehouse named reporting_warehouse which is sized
as Medium. You need the size of the virtual warehouse to be Large for future
queries. What is the best way to make this change.
The Query performance has slowed down over time and the size of the table is
in multi terabytes ✔️Ans - What are some general indicators that a
clustering key is required on a table? List all that apply.
Account ✔️Ans - On the WebUI which button on the top bar should you
select to get to tabs that provide information about virtual warehouse usage?
True ✔️Ans - A virtual warehouse can resized at any time whether they are
running or stopped
Introduce a dedicated virtual warehouse instance for the finance department
and size is according to their needs. Set the new virtual warehouse to auto
suspend and auto resume. ✔️Ans - You are the solution architect for a
,large retail company running a Snowflake data warehouse. Your Snowflake
implementation has just gone live with a single virtual warehouse and has
been opened up to all the users across the organization.
One of your heaviest users are the Finance department, who have a large
number of users and execute a large number of queries. The finance
department has complained that the queries take a long time to execute for
them.
What is the best immediate action should you take to improve their
experience?
Yes ✔️Ans - Snow flake uses a unique architecture in which data and
compute has been decoupled and both can be scaled independent of each
other.
copy into customer
from @my_stage
pattern='.*.csv'
file_format = (type = csv); ✔️Ans - You are loading data from an S3 stage
which has a variety of files. You are only interested in loading the files which
have an extension of .csv.
What is the correct command to execute?
Assume the target table is called customer & the name of the stage is my_stage
Memory, Temporary Storage, CPU ✔️Ans - What are the resources that a
virtual warehouse provides? Select all that apply.
True ✔️Ans - Snowflake does not start executing any queries on a new
virtual warehouse until all of the servers are provisioned.
History ✔️Ans - On the WebUI which button on the top bar should you
select to see the query history?
Snowflake Internal Stage, Database(and the tables in it) ✔️Ans - Which of
the following will contribute to your account level storage usage?
False ✔️Ans - A consumer of a shared database can add new tables or
views in the shared database?
,auto_suspend, auto_resume ✔️Ans - Which of the following are options
when creating a new virtual warehouse. Select all that apply
True ✔️Ans - A cloned object itself doesn't inherit any of the original
privileges although the child objects of the cloned object do inherit.
True ✔️Ans - When a virtual warehouse is provisioned there is no benefit
in stopping the virtual warehouse with in the first 60 seconds because that
time period has already been billed.
The consumer account with which the database and the objects are to be
shared. Privileges that grant access to a database and a schema from which
objects will be shared. Privileges that grant access to the objects i.e. tables,
secures views etc. which will be shared ✔️Ans - Each snowflake share can
consist of ...
False ✔️Ans - It is possible to share data with any other Snowflake
customer regardless of what edition of Snowflake they are running?
SHOW WAREHOUSES LIKE 'reporting%'; ✔️Ans - To see existing virtual
warehouse which names start with reporting, what is the correct command?
CREATE OR REPLACE WAREHOUSE brand_new_warehouse
WAREHOUSE_SIZE=large AUTO_RESUME=true; ✔️Ans - You are creating a
new virtual warehouse that you want to auto resume if a query is run while
the warehouse is in suspended state.
What is the correct syntax for creating such a virtual warehouse? Assume the
name of the virtual warehouse will be brand_new_warehouse.
internal named stage ✔️Ans - Which one of the following can not be
cloned?
Enterprise ✔️Ans - Internal named stages can not be cloned
True ✔️Ans - Snowflake uses a staged release process for new releases in
which different account types are upgraded gradually.
Execute ALTER statement on the table to add the clustering key
, ALTER TABLE events CLUSTERS BY (Event_date); ✔️Ans - You are the
database administrator for a large retailer running Snowflake. There is a event
table which more then 5TB of data but it doesn't have a clustering key defined.
You need to define a new cluster key on this table. What is the best method to
add the cluster key?
The structure of the table is given below and the clustering key is to be
created on event_date.
CREATE TABLE events (
Event_Date DATE,
Event_Id integer ,
Event_PayLoad string,
Event_Origin_Id integer
);
Business Critical, Enterprise, Standard, Premier ✔️Ans - Assuming you are
a Snowflake customer with Enterprise Edition license, which other editions
can you share your data with?
True ✔️Ans - The privileges provided by the SYSADMIN &
SECURITYADMIN role are automatically contained in the ACCOUNTADMIN
role since the ACCOUNTADMIN role sits on the top of the role hierarchy.
WAREHOUSE_SIZE, AUTO_RESUME, AUTO_SUSPEND ✔️Ans - Which of the
following are valid parameters when create a new virtual warehouse?
Experiment with different types of query and virtual warehouses to
determine the virtual warehouse size that best meets your requirements
✔️Ans - What are the virtual warehouse sizing approach recommended by
Snowflake?
Read-only ✔️Ans - When data is shared between Snowflake accounts, a
database is created on the consumer side for sharing purposes. The type of
this database is?
True ✔️Ans - Both time travel & failsafe require extra storage which has
cost associated with it.
Every Week ✔️Ans - Snowflake deploy new release at what frequency?
Cluster the Transactions table on the transaction data column. The daily
report will only access one day at a time and therefore will only scan required
data ✔️Ans - You are the data modeler at a large retail organization who
store their transactional data in a Snowflake table called "Transactions". The
daily revenue reports execute using the "Transactions" table and calculates
the revenue for the current day.
The "Transactions" table had 500GB of data originally but it has now grown to
be 5TB. You have noticed that over time the performance of the daily revenue
reports have degraded.
What is most efficient & cost effective way of optimizing performance.
SnowSQL, ODBC Driver, JDBC Driver ✔️Ans - Under the Download section
in Snowflake Web UI, what are the connectors & programs that can be
downloaded? Select All that apply
Alter the existing virtual warehouse and change the size to Large.
ALTER_WAREHOUSE reporting_warehouse WAREHOUSE_SIZE=large ✔️Ans
- You have a virtual warehouse named reporting_warehouse which is sized
as Medium. You need the size of the virtual warehouse to be Large for future
queries. What is the best way to make this change.
The Query performance has slowed down over time and the size of the table is
in multi terabytes ✔️Ans - What are some general indicators that a
clustering key is required on a table? List all that apply.
Account ✔️Ans - On the WebUI which button on the top bar should you
select to get to tabs that provide information about virtual warehouse usage?
True ✔️Ans - A virtual warehouse can resized at any time whether they are
running or stopped
Introduce a dedicated virtual warehouse instance for the finance department
and size is according to their needs. Set the new virtual warehouse to auto
suspend and auto resume. ✔️Ans - You are the solution architect for a
,large retail company running a Snowflake data warehouse. Your Snowflake
implementation has just gone live with a single virtual warehouse and has
been opened up to all the users across the organization.
One of your heaviest users are the Finance department, who have a large
number of users and execute a large number of queries. The finance
department has complained that the queries take a long time to execute for
them.
What is the best immediate action should you take to improve their
experience?
Yes ✔️Ans - Snow flake uses a unique architecture in which data and
compute has been decoupled and both can be scaled independent of each
other.
copy into customer
from @my_stage
pattern='.*.csv'
file_format = (type = csv); ✔️Ans - You are loading data from an S3 stage
which has a variety of files. You are only interested in loading the files which
have an extension of .csv.
What is the correct command to execute?
Assume the target table is called customer & the name of the stage is my_stage
Memory, Temporary Storage, CPU ✔️Ans - What are the resources that a
virtual warehouse provides? Select all that apply.
True ✔️Ans - Snowflake does not start executing any queries on a new
virtual warehouse until all of the servers are provisioned.
History ✔️Ans - On the WebUI which button on the top bar should you
select to see the query history?
Snowflake Internal Stage, Database(and the tables in it) ✔️Ans - Which of
the following will contribute to your account level storage usage?
False ✔️Ans - A consumer of a shared database can add new tables or
views in the shared database?
,auto_suspend, auto_resume ✔️Ans - Which of the following are options
when creating a new virtual warehouse. Select all that apply
True ✔️Ans - A cloned object itself doesn't inherit any of the original
privileges although the child objects of the cloned object do inherit.
True ✔️Ans - When a virtual warehouse is provisioned there is no benefit
in stopping the virtual warehouse with in the first 60 seconds because that
time period has already been billed.
The consumer account with which the database and the objects are to be
shared. Privileges that grant access to a database and a schema from which
objects will be shared. Privileges that grant access to the objects i.e. tables,
secures views etc. which will be shared ✔️Ans - Each snowflake share can
consist of ...
False ✔️Ans - It is possible to share data with any other Snowflake
customer regardless of what edition of Snowflake they are running?
SHOW WAREHOUSES LIKE 'reporting%'; ✔️Ans - To see existing virtual
warehouse which names start with reporting, what is the correct command?
CREATE OR REPLACE WAREHOUSE brand_new_warehouse
WAREHOUSE_SIZE=large AUTO_RESUME=true; ✔️Ans - You are creating a
new virtual warehouse that you want to auto resume if a query is run while
the warehouse is in suspended state.
What is the correct syntax for creating such a virtual warehouse? Assume the
name of the virtual warehouse will be brand_new_warehouse.
internal named stage ✔️Ans - Which one of the following can not be
cloned?
Enterprise ✔️Ans - Internal named stages can not be cloned
True ✔️Ans - Snowflake uses a staged release process for new releases in
which different account types are upgraded gradually.
Execute ALTER statement on the table to add the clustering key
, ALTER TABLE events CLUSTERS BY (Event_date); ✔️Ans - You are the
database administrator for a large retailer running Snowflake. There is a event
table which more then 5TB of data but it doesn't have a clustering key defined.
You need to define a new cluster key on this table. What is the best method to
add the cluster key?
The structure of the table is given below and the clustering key is to be
created on event_date.
CREATE TABLE events (
Event_Date DATE,
Event_Id integer ,
Event_PayLoad string,
Event_Origin_Id integer
);
Business Critical, Enterprise, Standard, Premier ✔️Ans - Assuming you are
a Snowflake customer with Enterprise Edition license, which other editions
can you share your data with?
True ✔️Ans - The privileges provided by the SYSADMIN &
SECURITYADMIN role are automatically contained in the ACCOUNTADMIN
role since the ACCOUNTADMIN role sits on the top of the role hierarchy.
WAREHOUSE_SIZE, AUTO_RESUME, AUTO_SUSPEND ✔️Ans - Which of the
following are valid parameters when create a new virtual warehouse?
Experiment with different types of query and virtual warehouses to
determine the virtual warehouse size that best meets your requirements
✔️Ans - What are the virtual warehouse sizing approach recommended by
Snowflake?
Read-only ✔️Ans - When data is shared between Snowflake accounts, a
database is created on the consumer side for sharing purposes. The type of
this database is?
True ✔️Ans - Both time travel & failsafe require extra storage which has
cost associated with it.
