Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

• A.Use the DROP < file > command after the load completes.
• B.Specify the TEMPORARY option when creating the file format.
• C.Specify the PURGE copy option in the COPY INTO < table > command.
• D.Use the REMOVE command after the load completes.
• E.Use the DELETE LOAD HISTORY command after the load completes.

Comment: *

Name: *

Email: *

Verification: *

Which operator is used to evaluate query pruning efficiency by comparing partitions scanned to partitions total?

• A.Filter
• B.TableScan
• C.ExternalScan
• D.IndexScan

Comment: *

Name: *

Email: *

Verification: *

How can a Snowflake user validate data that is unloaded using the COPY INTO < location > command?

• A.Load the data into a CSV file.
• B.Load the data into a relational table.
• C.Use the VALlDATlON_MODE - SQL statement.
• D.Use the validation mode = return rows statement.

Comment: *

Name: *

Email: *

Verification: *

What will be the retention period for an object if the parameter
MIN_DATA_RETENTION_TIME_IN_DAYS is set at the account level and the
DATA_RETENTION_TIME_IN_DAYS is set at the object level?

• A.The retention period will be equal to the lesser of the two values of parameters DATA_RETENTION_TIME_IN_DAYS set at the object level and MIN_DATA_RETENTION_TIME_IN_DAYS set at the account level.
• B.The retention period will be equal to the value of the parameter
  DATA_RETENTION_TIME_IN_DAYS set at the object level.
• C.The retention period will be equal to the value of the parameter
  MIN_DATA_RETENTION_TIME_IN_DAYS set at the account level.
• D.The retention period will be equal to the greatest of the two values of parameters DATA_RETENTION_TIME_IN_DAYS set at the object level, and MIN_DATA_RETENTION_TIME_IN_DAYS set at the account level.

Comment: *

Name: *

Email: *

Verification: *

When an ACCOUNTADMIN gives a user a custom role, what privilege or privileges is the user granted by default?

• A.All privileges on objects allowed by the custom role
• B.Access to all the objects owned by the USERADMIN role
• C.Access to the PUBLIC role
• D.All privileges that have been granted to the ACCOUNTADMIN

Comment: *

Name: *

Email: *

Verification: *