When cloning a database, what is cloned with the database? (Choose two.)

• A.Privileges on the database
• B.Existing child objects within the database
• C.Future child objects within the database
• D.Privileges on the schemas within the database
• E.Only schemas and tables within the database

Comment: *

Name: *

Email: *

Verification: *

The following settings are configured:

For how many days will the data be retained at the object level?

• A.5
• B.7
• C.2
• D.3

Comment: *

Name: *

Email: *

Verification: *

What is a best practice after creating a custom role?

• A.Assign the custom role to the PUBLIC role
• B.Assign the custom role to the SYSADMIN role
• C.Add_CUSTOM to all custom role names
• D.Create the custom role using the SYSADMIN role.

Comment: *

Name: *

Email: *

Verification: *

Which statement best describes '' clustering''?

• A.The clustering key must be included on the COPV command when loading data into Snowflake.
• B.Clustering can be disabled within a Snowflake account.
• C.Clustering represents the way data is grouped together and stored within snowflake's micro-partitions
• D.The database administrator must define the clustering methodology for each Snowflake table.

Comment: *

Name: *

Email: *

Verification: *

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

• A.The table contains a column that has very low cardinality
• B.DML statements that are being issued against the table are blocked
• C.The table has a small number of micro-partitions
• D.Queries on the table are running slower than expected
• E.The clustering depth for the table is large

Comment: *

Name: *

Email: *

Verification: *