- (Topic 1)
What are the default Time Travel and Fail-safe retention periods for transient tables?
Correct Answer:C
Transient tables in Snowflake have a default Time Travel retention period of 1 day, which allows users to access historical data within the last 24 hours. However, transient tables do not have a Fail-safe period. Fail-safe is an additional layer of data protection that retains data beyond the Time Travel period for recovery purposes in case of extreme data loss. Since transient tables are designed for temporary or intermediate workloads with no requirement for long-term durability, they do not include a Fail-safe period by default1.
References:
✑ Snowflake Documentation on Storage Costs for Time Travel and Fail-safe
- (Topic 6)
What Snowflake recommendation is designed to ensure that staged data is only loaded once"?
Correct Answer:C
Snowflake recommends removing data files from the staging area after they have been loaded into the target table. This practice ensures that the data is only loaded once and prevents accidental reloading of the same data. By removing the files, you eliminate the risk of duplicate data loads.
✑ Stage the Data:Upload the data files to a Snowflake stage (internal or external).
✑ Load the Data:Use theCOPY INTOcommand to load the data from the stage into the Snowflake table.
✑ Remove the Data Files:After successfully loading the data, remove the data files from the stage using theREMOVEcommand.
References:
✑ Snowflake Documentation: Loading Data into Snowflake
✑ Snowflake Documentation: Staging Data Files
✑ Snowflake Documentation: COPY INTO Command
- (Topic 6)
When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? {Select TWO).
Correct Answer:CD
When unloading data from SnowSQL (Snowflake's command-line client), to a file on a local machine, you need to specify certain configuration options to determine how and where the data should be outputted. The correct configuration options required are:
✑ C. output_file: This configuration option specifies the file path where the output from the query should be stored. It is essential for directing the results of your SQL query into a local file, rather than just displaying it on the screen.
✑ D. output_format: This option determines the format of the output file (e.g., CSV, JSON, etc.). It is crucial for ensuring that the data is unloaded in a structured format that meets the requirements of downstream processes or systems.
These options are specified in the SnowSQL configuration file or directly in the SnowSQL command line. The configuration file allows users to set defaults and customize their usage of SnowSQL, including output preferences for unloading data.
References:
✑ Snowflake Documentation: SnowSQL (CLI Client) at Snowflake Documentation
✑ Snowflake Documentation: Configuring SnowSQL at Snowflake Documentation
- (Topic 5)
A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?
Correct Answer:C
To temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY, the USERADMIN role should be used. This role has the necessary privileges to modify user properties, including setting a temporary bypass for network policies, which can be crucial for enabling access under specific circumstances without permanently altering the network security configuration. References:
✑ Snowflake Documentation: User Management
- (Topic 6)
When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).
Correct Answer:AD
When sharing data in Snowflake, the provider needs to grant the following privileges along with a share:
✑ A. USAGE on the specific tables in the database:This privilege allows the
consumers of the share to access the specific tables included in the share.
✑ D. USAGE on the database and the schema containing the tables to share:This privilege is necessary for the consumers to access the database and schema levels, enabling them to access the tables within those schemas.
These privileges are crucial for setting up secure and controlled access to the shared data, ensuring that only authorized users can access the specified resources.
Reference to Snowflake documentation on sharing data and managing access:
✑ Data Sharing Overview
✑ Privileges Required for Sharing Data