Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

What happens to the privileges granted to Snowflake system-defined roles?

• A.The privileges cannot be revoked.
• B.The privileges can be revoked by an ACCOUNTADMIN.
• C.The privileges can be revoked by an orgadmin.
• D.The privileges can be revoked by any user-defined role with appropriate privileges.

Comment: *

Name: *

Email: *

Verification: *

What is the recommended way to change the existing file format type in my format from CSV to JSON?

• A.ALTER FILE FORMAT my_format SET TYPE=JSON;
• B.ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
• C.CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
• D.REPLACE FILE FORMAT my format TYPE-JSON;

Comment: *

Name: *

Email: *

Verification: *

Which privilege is required to use the search optimization service in Snowflake?

• A.GRANT SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
• B.GRANT SEARCH OPTIMIZATION ON DATABASE <database_name> TO ROLE <role>
• C.GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
• D.GRANT ADD SEARCH OPTIMIZATION ON DATABASE <database name> TO ROLE <role>

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

• A.External Tokenization
• B.Materialized Views
• C.User-Defined Table Functions (UDTF)
• D.External Tables

Comment: *

Name: *

Email: *

Verification: *