Udemy Snowpro Core Certification - Practice Questions
Test 1 with Detailed Solutions
When defining a clustering key for a large table, consider using columns frequently used in
WHERE clauses. Correct Ans-True
Which query profile results indicate that a large table may not be well clustered? Correct
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) Correct Ans-Partition Pruning
A stored procedure can return which type of results? Correct Ans-- Single Value
- Tabular Data
, Udemy Snowpro Core Certification - Practice Questions
Test 1 with Detailed Solutions
What type of virtual warehouse automatically lets you add or remove additional clusters as
concurrency and demand change? Correct Ans-Multi-cluster virtual warehouse
Files already loaded from a stage to a table can be loaded again into a cloned table.
Correct Ans-True
Which of the following operations can be performed on a cloned table? Correct 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? Correct Ans-SCIM
- SCIM is an open standard that provides automatic user provisioning and role synchronization
based on identity provider information
, Udemy Snowpro Core Certification - Practice Questions
Test 1 with Detailed Solutions
Which of the following could be used as a remote service for an external function? Correct
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. Correct Ans-True
True or False: When unloading data, each exported file is 16MB, and this configuration cannot
be changed. Correct 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 Correct Ans-- The query profile indicates that results
produced by a previous query were reused
Test 1 with Detailed Solutions
When defining a clustering key for a large table, consider using columns frequently used in
WHERE clauses. Correct Ans-True
Which query profile results indicate that a large table may not be well clustered? Correct
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) Correct Ans-Partition Pruning
A stored procedure can return which type of results? Correct Ans-- Single Value
- Tabular Data
, Udemy Snowpro Core Certification - Practice Questions
Test 1 with Detailed Solutions
What type of virtual warehouse automatically lets you add or remove additional clusters as
concurrency and demand change? Correct Ans-Multi-cluster virtual warehouse
Files already loaded from a stage to a table can be loaded again into a cloned table.
Correct Ans-True
Which of the following operations can be performed on a cloned table? Correct 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? Correct Ans-SCIM
- SCIM is an open standard that provides automatic user provisioning and role synchronization
based on identity provider information
, Udemy Snowpro Core Certification - Practice Questions
Test 1 with Detailed Solutions
Which of the following could be used as a remote service for an external function? Correct
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. Correct Ans-True
True or False: When unloading data, each exported file is 16MB, and this configuration cannot
be changed. Correct 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 Correct Ans-- The query profile indicates that results
produced by a previous query were reused
