How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

• A.A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
• B.A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.
• C.Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
• D.A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

Comment: *

Name: *

Email: *

Verification: *

Which ACCOUNT_USAGE view can be used to identify the masking policy assigned to an object?

• A.TAG_REFERENCES
• B.ACCESS_HISTORY
• C.OBJECT_DEPENDENCIES
• D.POLICY_REFERENCES

Comment: *

Name: *

Email: *

Verification: *

Which statement best describes Snowflake tables?

• A.Snowflake tables require that clustering keys be defined to perform optimally
• B.Snowflake tables are logical representations of underlying physical data
• C.Snowflake tables are owned by a user
• D.Snowflake tables ate the physical instantiation of data loaded Into Snowflake

Comment: *

Name: *

Email: *

Verification: *

A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

• A.Increase the warehouse size from Medium to 2XL.
• B.Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
• C.Configure the warehouse to a multi-cluster warehouse.
• D.Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user wants to design a series of transformations that need to be executed in a specific order on a given schedule.
Which of the snowflake objects should be used?

• A.Streams
• B.Tasks
• C.Pipes
• D.Sequences

Comment: *

Name: *

Email: *

Verification: *