- (Topic 3)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

Correct Answer:A
Snowsight automatically detects if a target account is in a different region and enables cross-cloud auto-fulfillment when using a paid listing on the Snowflake Marketplace. This feature allows Snowflake to manage the replication of data products to consumer regions as needed, without manual intervention1.

- (Topic 6)
How can a 5 GB table be downloaded into a single file MOST efficiently?

Correct Answer:C
To download a 5 GB table into a single file most efficiently in Snowflake, you should set the SINGLE parameter to TRUE. This parameter ensures that the COPY INTO command outputs the result into a single file, regardless of the file size. This approach is more efficient than relying on the default MAX_FILE_SIZE setting, which would split the output into multiple files.
References:
✑ Snowflake Documentation: COPY INTO

- (Topic 6)
Which file function gives a user or application access to download unstructured data from a Snowflake stage?

Correct Answer:C
The function that provides access to download unstructured data from a Snowflake stage is:
✑ C. GET_PRESIGNED_URL: This function generates a presigned URL for a single file within a stage. The generated URL can be used to directly access or download the file without needing to go through Snowflake. This is particularly useful for unstructured data such as images, videos, or large text files, where direct access via a URL is needed outside of the Snowflake environment.
Example usage: SELECTGET_PRESIGNED_URL('stage_name','file_path');
This function simplifies the process of securely sharing or accessing files stored in Snowflake stages with external systems or users.
References:
✑ Snowflake Documentation: GET_PRESIGNED_URL Function at Snowflake Documentation

- (Topic 5)
What information does the Query Profile provide?

Correct Answer:B
The Query Profile in Snowflake provides a graphical representation and statistics for each component of the query's execution plan. This includes details such as the execution time, the number of rows processed, and the amount of data scanned for each operation within the query. The Query Profile is a crucial tool for understanding and optimizing the performance of queries, as it helps identify potential bottlenecks and inefficiencies.
References:
✑ Snowflake Documentation: Understanding the Query Profile

- (Topic 6)
The following settings are configured:
For how many days will the data be retained at the object level?

Correct Answer:A
The settings shown in the image indicate that the data retention time in days is configured at two different levels: the account level and the object level. At the account level, theMIN_DATA_RETENTION_TIME_IN_DAYSis set to 5 days, and at the object level, theDATA_RETENTION_TIME_IN_DAYSis set to 2 days. Since the object level setting has a lower value, it takes precedence over the account level setting for the specific object. Therefore, the data will be retained for 2 days at the object level.References:Snowflake Documentation on Data Retention Policies

- (Topic 2)
Users are responsible for data storage costs until what occurs?

Correct Answer:B
Users are responsible for data storage costs in Snowflake until the data expires from the Fail-safe period. Fail-safe is the final stage in the data lifecycle, following Time Travel, and provides additional protection against accidental data loss. Once data exits the Fail-safe state, users are no longer billed for its storage