Snowflake Day2_3 Practice Quiz

Which table property allows efficient partition pruning in Snowflake?

• Cluster Keys

• Primary Keys

• Foreign Keys

• Indexes

In Snowflake, how can you unload data in Parquet format?

• UNLOAD INTO

• EXPORT DATA

• COPY INTO

• EXTRACT INTO

Which of these optimizations improves query pruning?

• Using clustered tables

• Increasing warehouse size

• Disabling result caching

• Running queries in multiple tabs

What issues can be identified and troubleshooted using the Query Profile? (Choose two.)

• Full Scan of the Indexes

• Exploding Joins

• Spilling

• Insufficient Privileges

What is the difference between Validate Table function and Validation_Mode?

• Validate - used to check errors before running copy command

  Validation_Mode - used to check errors after running copy command

• Validate - used to check errors after running copy command

  Validation_Mode - used to check errors before running copy command

• Validate - used to check previous loads using copy command

  Validation_Mode - used to check errors before running copy command

• Validate - used to check errors after running copy command

  Validation_Mode - used to check previous loads using copy command

Which of the following is used to determine the cost of using a virtual warehouse in Snowflake?

• The type of SQL statements executed

• Total number of tables queried

• Amount of data stored in the warehouse

• The duration of time the compute resources in each cluster run

Which objects are allowed for Secure Data Sharing in Snowflake?

• Tables

• Stages

• Standard Views

• Secure UDFs

Which system function is used to check whether the clustering is efficient in table?

• Clustering_IN_Table

• Clustering_Depth

• AUTOCLUSTER

• CLUSTERING_DETAILS

What is the use of OBJECT_CONSTRUCT function?

• To convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file

• To Construct an array

• To remove NULL values from OBJECT data type

• To construct Table object in Snowflake database

Directory Tables have grantable privileges of it's own.

• TRUE

• False