Which of the below commands will use warehouse credits?

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

Comment: *

Name: *

Email: *

Verification: *

A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual warehouses?

• A.Setting a '0' or NULL value means the warehouses will never suspend.
• B.Setting a '0' or NULL value means the warehouses will suspend immediately.
• C.Setting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.
• D.Setting a '0' value means the warehouses will suspend immediately, and NULL means the warehouses will never suspend.

Comment: *

Name: *

Email: *

Verification: *

A company has a table with that has corrupted data, named Dat
a. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel.
What command will accomplish this?

• A.CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
• B.CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
• C.CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
• D.CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

Comment: *

Name: *

Email: *

Verification: *

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect's highest priority is to configure the connector to stream data in the MOST cost-effective manner.
Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

• A.Utilize a lower Buffer.size.bytes in the connector configuration.
• B.Utilize a higher Buffer.size.bytes in the connector configuration.
• C.Utilize a higher Buffer.flush.time in the connector configuration.
• D.Utilize a lower Buffer.count.records in the connector configuration.

Comment: *

Name: *

Email: *

Verification: *

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP () what will occur?

• A.All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
• B.Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
• C.Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
• D.All rows loaded using a specific COPY statement will have the same timestamp value.

Comment: *

Name: *

Email: *

Verification: *