Snowflake DEA-C01 Practice Test - Questions Answers, Page 5

The smaller the average depth, the better clustered the table is with regards to the specified column?

Data Engineer, ran the below clustering depth analysis function:

select system$clustering_depth('TPCH_CUSTOMERS', '(C1, C6)', 'C9 = 30'); on TPCH_CUSTOMERS table, will return which of the following?

Mark the Correct Statements:

Statement 1. Snowflake's zero-copy cloning feature provides a convenient way to quickly take a "snapshot" of any table, schema, or database.

Statement 2. Data Engineer can use zero-copy cloning feature for creating instant backups that do not incur any additional costs (until changes are made to the cloned object).

Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?

Mark the Correct Statements:

Statement 1. Enable failover for a primary database to one or more accounts in your organization using an ALTER DATABASE … ENABLE FAILOVER TO ACCOUNTS statement.

Statement 2. Enabling failover for a primary database can be done by Data Engineer either before or after a replica of the primary database has been created in a specified account.

Which Role inherits the privileges of the USERADMIN role via the system role hierarchy?

Which privilege are required on an object (i.e. user or role) with USERADMIN Role can modify the object properties?

Does sensitive data in Snowflake is modified in an existing table while applying Masking policies?

Can Masking policies be applied to virtual columns?