Snowflake 14/02/2024

What happens when the values for both an ALLOWED_IP_LIST and a BLOCKED_IP_LIST are used in a network policy?

• Snowflake ignores the BLOCKED_IP_LIST first.

• Snowflake applies the BLOCKED_IP_LIST first.

• Snowflake applies the ALLOWED_IP_LIST first.

• Snowflake ignores the ALLOWED_IP_LIST first.

When unloading data from Snowflake, what is the default file size of each file?

• 16 MB

• 32 MB

• 64 MB

• 5 GB

What is the abbreviated form to get all the files in the stage for the current user?

• LIST @~;

• LS @~;

• LS @usr;

• SHOW @%;

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

• There are multiple SQL UDFs with the same names and the same number of arguments.

• There are multiple SQL UDFs with the same names and the same number of argument types.

• There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

• There are multiple SQL UDFs with different names but the same number of arguments or argument types.

A Snowflake user has a query that is running for a long time. When the user opens the query profiler, it indicates that a lot of data is

spilling to disk. What is causing this to happen?

• The result cache is almost full and is unable to hold the results.

• The cloud storage staging area is not sufficient to hold the data results.

• Clustering has not been applied to the table so the table is not optimized.

• The warehouse memory is not sufficient to hold the intermediate query results.

What tasks can be completed using the COPY command? (Choose two.)

• Columns can be aggregated.

• Columns can be joined with an existing table.

• Columns can be reordered.

• Columns can be omitted.

• Data can be loaded without the need to spin up a virtual warehouse.

How many days is load history for Snowpipe retained?

• 1 day

• 7 days

• 14 days

• 64 days

What actions will prevent leveraging of the ResultSet cache?

• Removing a column from the query SELECT list

• Stopping the virtual warehouse that the query is running against

• If the result has not been reused within the last 12 hours

• Executing the RESULTS_SCAN() table function

A user executes the following SQL query:

create table SALES_BKP like SALES;

What are the cost implications for processing this query?

• Processing costs will be generated based on how long the query takes.

• Storage costs will be generated based on the size of the data.

• No costs will be incurred as the query will use metadata.

• The cost for running the virtual warehouse will be charged by the second.

What is the maximum length of time travel available in the Snowflake Standard Edition?

• 1 Day

• 7 Days

• 30 Days

• 90 Days