Question 1

How can the Snowpipe REST API be used to keep a log of data load history?

Options :

A : Call insertReport every 20 minutes, fetching the last 10,000 entries.

B : Call loadHistoryScan every minute for the maximum time range.

C : Call insertReport every 8 minutes for a 10-minute time range.

D : Call loadHistoryScan every 10 minutes for a 15-minutes range.

Answer: D

Question 2

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?

Options :

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.

Answer: D

Question 3

An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy command. The loading performance is poor. What changes can be made to Improve the data loading performance?

Options :

A : Increase the size of the virtual warehouse.

B : Create a multi-cluster warehouse and merge smaller files to create bigger files.

C : Create a specific storage landing bucket to avoid file scanning.

D : Change the file format from CSV to JSON.

Answer: B

Question 4

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 5

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

Options :

A : SYSTEM$CLUSTERING_INFORMATION

B : SYSTEM$CLUSTERING_USAGE

C : SYSTEM$CLUSTERING_DEPTH

D : SYSTEM$CLUSTERING_KEYS

E : SYSTEM$CLUSTERING_PERCENT

Answer: A,C