Udemy Snowpro Core Certification - Practice
Questions Test 1 – Qs & As
When defining a clustering key for a large table, consider using columns
frequently used in WHERE clauses. ✔️Ans - True
Which query profile results indicate that a large table may not be well
clustered? ✔️Ans - - The value in the 'Partitions Total' qual 'Partitions
Scanned'
- A significant value for 'Partitions Scanned'
Snowflake can eliminate unneeded partitions while executing a query. What is
the name given to this optimization technique?
Retrieve needed data only (RNDO)
Predicate optimization
WHERE clause optimization
Partition pruning
(Correct) ✔️Ans - Partition Pruning
A stored procedure can return which type of results? ✔️Ans - - Single
Value
- Tabular Data
What type of virtual warehouse automatically lets you add or remove
additional clusters as concurrency and demand change? ✔️Ans - Multi-
cluster virtual warehouse
Files already loaded from a stage to a table can be loaded again into a cloned
table. ✔️Ans - True
Which of the following operations can be performed on a cloned table?
✔️Ans - DROP, SELECT, DELETE, CLONE
A cloned table is just like any other table
Which one of the following is supported by Snowflake for the purpose of auto-
provisioning users and group membership? ✔️Ans - SCIM
- SCIM is an open standard that provides automatic user provisioning and role
synchronization based on identity provider information
, Which of the following could be used as a remote service for an external
function? ✔️Ans - - AWS Lambda Function
- Node.js running on an EC2 instance
- Microsoft Azure Function
True or False. To create Snowflake instances in different regions, you must
maintain a separate Snowflake account for each region. ✔️Ans - True
True or False: When unloading data, each exported file is 16MB, and this
configuration cannot be changed. ✔️Ans - False
- Default size of each output file is 16 MB but can be changed using the
MAX_FILE_SIZE parameter
Which of the following correctly describes the query profile shown?
QUERY RESULT REUSE[0] 1005 ✔️Ans - - The query profile indicates that
results produced by a previous query were reused
- The query profile indicates that an active virtual warehouse was NOT
required for this query
Which of the following can create a new resource monitor? ✔️Ans - An
account administrator (i.e.,m a person with the ACCOUNTADMIN role)
What is a snowflake resource monitor? ✔️Ans - A resource monitor can be
used to monitor credit usage by virtual warehouses and the cloud services
needed to support those warehouses. If desired, the warehouse can be
suspended when it reaches a credit limit.
The number of credits consumed depends on the size of the warehouse and
how long it runs.
You are the data modeler at a large retail organization that stores
transactional data in a Snowflake table called "Transactions." The daily
revenue reports are generated using the "Transactions" table, which
calculates the revenue for the current day.
The "Transactions" table originally had 500GB of data but has now grown to
5TB. You have noticed that over time the performance of the daily revenue
reports has degraded.
Questions Test 1 – Qs & As
When defining a clustering key for a large table, consider using columns
frequently used in WHERE clauses. ✔️Ans - True
Which query profile results indicate that a large table may not be well
clustered? ✔️Ans - - The value in the 'Partitions Total' qual 'Partitions
Scanned'
- A significant value for 'Partitions Scanned'
Snowflake can eliminate unneeded partitions while executing a query. What is
the name given to this optimization technique?
Retrieve needed data only (RNDO)
Predicate optimization
WHERE clause optimization
Partition pruning
(Correct) ✔️Ans - Partition Pruning
A stored procedure can return which type of results? ✔️Ans - - Single
Value
- Tabular Data
What type of virtual warehouse automatically lets you add or remove
additional clusters as concurrency and demand change? ✔️Ans - Multi-
cluster virtual warehouse
Files already loaded from a stage to a table can be loaded again into a cloned
table. ✔️Ans - True
Which of the following operations can be performed on a cloned table?
✔️Ans - DROP, SELECT, DELETE, CLONE
A cloned table is just like any other table
Which one of the following is supported by Snowflake for the purpose of auto-
provisioning users and group membership? ✔️Ans - SCIM
- SCIM is an open standard that provides automatic user provisioning and role
synchronization based on identity provider information
, Which of the following could be used as a remote service for an external
function? ✔️Ans - - AWS Lambda Function
- Node.js running on an EC2 instance
- Microsoft Azure Function
True or False. To create Snowflake instances in different regions, you must
maintain a separate Snowflake account for each region. ✔️Ans - True
True or False: When unloading data, each exported file is 16MB, and this
configuration cannot be changed. ✔️Ans - False
- Default size of each output file is 16 MB but can be changed using the
MAX_FILE_SIZE parameter
Which of the following correctly describes the query profile shown?
QUERY RESULT REUSE[0] 1005 ✔️Ans - - The query profile indicates that
results produced by a previous query were reused
- The query profile indicates that an active virtual warehouse was NOT
required for this query
Which of the following can create a new resource monitor? ✔️Ans - An
account administrator (i.e.,m a person with the ACCOUNTADMIN role)
What is a snowflake resource monitor? ✔️Ans - A resource monitor can be
used to monitor credit usage by virtual warehouses and the cloud services
needed to support those warehouses. If desired, the warehouse can be
suspended when it reaches a credit limit.
The number of credits consumed depends on the size of the warehouse and
how long it runs.
You are the data modeler at a large retail organization that stores
transactional data in a Snowflake table called "Transactions." The daily
revenue reports are generated using the "Transactions" table, which
calculates the revenue for the current day.
The "Transactions" table originally had 500GB of data but has now grown to
5TB. You have noticed that over time the performance of the daily revenue
reports has degraded.
