Question 1

What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).

Options :

A : SYSTEMSCLUSTERING

B : SYSTEMSTABLE_CLUSTERING

C : SYSTEMSCLUSTERING_DEPTH

D : SYSTEMSCLUSTERING_RATIO

E : SYSTEMSCLUSTERING_INFORMATION

Answer: C,E

Question 2

When using the copy into < table > command with the CSV file format, how does the match_by_column_name parameter behave?

Options :

A :

It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.

B : The parameter will be ignored.

C : The command will return an error.

D : The command will return a warning stating that the file has unmatched columns.

Answer: B

Question 3

An Architect runs the following SQL query:

How can this query be interpreted?

Options :

A : FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.

B : FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.

C : FILEROWS is a file. FILE_ROW_NUMBER is the file format location.

D : FILERONS is the file format location. FILE_ROW_NUMBER is a stage.

Answer: A

Question 4

An Architect is troubleshooting a query with poor performance using the QUERY function. The Architect observes that the COMPILATION_TIME Is greater than the EXECUTION_TIME. What is the reason for this?

Options :

A : The query is processing a very large dataset.

B : The query has overly complex logic.

C : The query Is queued for execution.

D : The query Is reading from remote storage

Answer: B

Question 5

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)

Options :

A : Clone a table from a share.

B : Grant modify permissions on the share.

C : Create a table from the shared database.

D : Create additional views inside the shared database.

E : Create a table stream on the shared table.

Answer: A,D