Question 1

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?

Options :

A : Utilize a higher Buffer.flush.time in the connector configuration.

B : Utilize a higher Buffer.size.bytes in the connector configuration.

C : Utilize a lower Buffer.size.bytes in the connector configuration.

D : Utilize a lower Buffer.count.records in the connector configuration.

Answer: A

Question 2

Which SQL alter command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

Options :

A :

B :

C :

D :

Answer: A

Question 3

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it

was 5 minutes ago using cloning and Time Travel.

What command will accomplish this?

Options :

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);

Answer: C

Question 4

A company has built a data pipeline using Snowpipe to ingest files from an Amazon S3 bucket. Snowpipe is configured to load data into staging database tables. Then a task runs to load the data from the staging database tables into the reporting database tables. The company is satisfied with the availability of the data in the reporting database tables, but the reporting tables are not pruning effectively. Currently, a size 4X-Large virtual warehouse is being used to query all of the tables in the reporting database. What step can be taken to improve the pruning of the reporting tables?

Options :

A : Eliminate the use of Snowpipe and load the files into internal stages using PUT commands.

B : Increase the size of the virtual warehouse to a size 5X-Large.

C : Use an ORDER BY command to load the reporting tables.

D : Create larger files for Snowpipe to ingest and ensure the staging frequency does not exceed 1 minute.

Answer: C

Question 5

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

Options :

A : The MERGE command

B : The UPSERT command

C : The CHANGES clause

D : A STREAM object

E : The CHANGE_DATA_CAPTURE command

Answer: C,D