Snow

What does Snowflake recommend regarding database object ownership? (Choose two.)

• Create objects with ACCOUNTADMIN and do not reassign ownership.

• Create objects with SYSADMIN.

• Create objects with SECURITYADMIN to ease granting of privileges later.

• Create objects with a custom role and grant this role to SYSADMIN.

• Use only managed access schemas for objects owned by ACCOUNTADMIN.

Which Snowflake table supports unstructured data?

• Directory

• Transient

• Temporary

• Permanent

What happens when a database is cloned?

• It does not retain any privileges granted on the source object.

• It replicates all granted privileges on the corresponding source objects.

• It replicates all granted privileges on the corresponding child objects.

• It replicates all granted privileges on the corresponding child schema objects.

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

• The data from the permanent table.

• The data from the temporary table.

• An error stating that the view could not be compiled.

• An error stating that the referenced object could not be uniquely identified.

Which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

• BUILD_STAGE_FILE_URL

• GET_ABSOLUTE_PATH

• GET_RELATIVE_PATH

• GET_STAGE_LOCATION

How many network policies can be assigned to an account or specific user at a time?

• One

• Two

• Three

• Unlimited

What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?

• 1-16 MB

• 16-128 MB

• 100-250 MB

• 256-512 MB

Which constraint is enforced in Snowflake?

• FOREIGN KEY

• NOT NULL

• PRIMARY KEY

• UNIQUE KEY

How does Snowflake reorganize data when it is loaded? (Choose two.)

• Binary format

• Columnar format

• Compressed format

• Raw format

• Zipped format

What type of columns does Snowflake recommend to be used as clustering keys? (Choose two.)

• A VARIANT column

• A column with very low cardinality

• A column with very high cardinality

• A column that is most actively used in selective filters

• A column that is most actively used in join predicates