Snowflake SnowPro Core Practice Test - Questions Answers, Page 31
Related questions
Question 301

What role is required to use Partner Connect?
Explanation:
To use Partner Connect, the ACCOUNTADMIN role is required.Partner Connect allows account administrators to easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake
Question 302

How does a scoped URL expire?
Explanation:
A scoped URL expires when the persisted query result period ends, which is typically after the results cache expires.This is currently set to 24 hours
Question 303

Which features make up Snowflake's column level security? (Select TWO).
Explanation:
Snowflake's column level security features include Dynamic Data Masking and External Tokenization.Dynamic Data Masking uses masking policies to selectively mask data at query time, while External Tokenization allows for the tokenization of data before loading it into Snowflake and detokenizing it at query runtime5.
Question 304

What is the difference between a stored procedure and a User-Defined Function (UDF)?
Explanation:
Stored procedures in Snowflake can perform a variety of database operations, including DDL and DML, whereas UDFs are designed to return values and cannot execute database operations1.
Question 305

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
Explanation:
Disabling auto-suspend for a virtual warehouse is recommended when there is a steady workload, which ensures that compute resources are always available.Additionally, it is advisable to disable auto-suspend when immediate availability of compute resources is critical, eliminating any startup delay
Question 306

How does Snowflake handle the bulk unloading of data into single or multiple files?
Explanation:
When unloading data, Snowflake assigns each file a unique name to ensure there is no overlap or confusion between files.This is part of the bulk unloading process where data is exported from Snowflake tables into flat files3.
Question 307

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
Explanation:
When file format options are specified in multiple locations, the load operation applies the options in the following order of precedence: first, the COPY INTO TABLE statement; second, the stage definition; and third, the table definition1
Question 308

Which statement accurately describes a characteristic of a materialized view?
Explanation:
A characteristic of a materialized view is that the data accessed through it can be stale.This is because the data in a materialized view may not reflect the latest changes in the base tables until the view is refreshed
Question 309

Which stream type can be used for tracking the records in external tables?
Explanation:
The stream type that can be used for tracking the records in external tables is 'External'.This type of stream is specifically designed to track changes in external tables
Question 310

What can a Snowflake user do in the Activity section in Snowsight?
Explanation:
In the Activity section in Snowsight, Snowflake users can explore the performance of executed queries.This includes monitoring queries, viewing details about queries, including performance data, and exploring each step of an executed query in the query profile1.
Question