While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).

• A.BINARY
• B.GEOGRAPHY
• C.GEOMETRY
• D.OBJECT
• E.VARIANT

Comment: *

Name: *

Email: *

Verification: *

When is a DataFrame processed in Snowpark?

• A.When the DataFrame is created
• B.When a collect() action is triggered
• C.When there is sufficient memory available in the virtual warehouse
• D.When a new transformation is applied on the DataFrame

Comment: *

Name: *

Email: *

Verification: *

A Snowflake Practitioner manages a database called SALES_DB. This database has a PUBLIC schema and an ORDERS table that is updated frequently. The database has a data retention period of 7 days. On November 16, 2025, at 3:00 PM, the Practitioner accidentally ran a DELETE command that removed all records from the ORDERS table. Which statement will recover all deleted records?

• A.CREATE TABLE orders_restored CLONE orders AT (TIMESTAMP = > ' 2025-11-16 10:00:00 ' ::TIMESTAMP);
• B.CREATE TABLE orders_restored CLONE orders BEFORE (TIMESTAMP = > ' 2025-11-16 15:00:00' ::TIMESTAMP);
• C.CREATE TABLE orders_restored CLONE orders BEFORE (OFFSET = > -60*5);
• D.CREATE TABLE orders_restored CLONE orders AT (TIMESTAMP = > ' 2025-11-16 15:00:00 ' ::TIMESTAMP);

Comment: *

Name: *

Email: *

Verification: *

Which command will consume credits from a virtual warehouse?

• A.SELECT MAX(UUID) FROM SNOWFLAKE;
• B.SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY UUID;
• C.SHOW TABLES LIKE ' SNOWFL% ' IN SCHEMA( ' PUBLIC ' );
• D.SELECT COUNT(*) FROM SNOWFLAKE;

Comment: *

Name: *

Email: *

Verification: *

A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?

• A.Organize files into logical paths
• B.Store the files on the external stage to ensure caching is maintained
• C.Use pattern matching for regular expression execution
• D.Load the data in one large file

Comment: *

Name: *

Email: *

Verification: *