Question 1

What kind of information can be found in Query History in Snowsight? (Select THREE)

Options :

A : Virtual Warehouse size used

B : Credit consumption

C : Execution Status (e.g. Succeeded, Failed)

D : Duration of the query

E : Query ID

Answer: C,D,E

Question 2

What are the benefits of using the Snowsight data loading interface? (Select TWO).

Options :

A : It creates permanent file formats that can be used to load data in the future.

B : It allows a user to insert the records of a supported file into a table.

C : It will try to detect data types.

D : It allows a user to optimize data loading into a table.

E : It lets a user merge file rows into the table records.

Answer: B,C

Question 3

What filter can be used when searching for data products on the Snowflake Marketplace?

Options :

A : Size

B : Compatibility

C : Price

D : Performance

Answer: C

Question 4

What types of privileges can be granted to a role in Snowflake?

Options :

A : INSERT

B : SELECT

C : MONITOR

D : All of them

Answer: D

Question 5

What Snowflake parameter is configured in the Query Processing layer?

Options :

A : The minimum and maximum serverless compute limits

B : The types of tables available in an account

C : The sizing of virtual warehouses

D : The minimum and maximum micro-partition limits

Answer: C

Higher Test Marks with Free Online SOL-C01 Exam Practice