Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

• A.Security
• B.Data storage
• C.Data visualization
• D.Query computation
• E.Metadata management

Comment: *

Name: *

Email: *

Verification: *

Which statement MOST accurately describes clustering in Snowflake?

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

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 Tables
• B.Materialized Views
• C.External Tokenization
• D.User-Defined Table Functions (UDTF)

Comment: *

Name: *

Email: *

Verification: *

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

• A.Cloud services layer
• B.Compute layer
• C.Storage layer
• D.Cloud agnostic layer

Comment: *

Name: *

Email: *

Verification: *

What privilege should a user be granted to change permissions for new objects in a managed access schema?

• A.Grant ALL privileges on the schema.
• B.Grant the MANAGE GRANTS global privilege.
• C.Grant the OWNERSHIP privilege on the database.
• D.Grant the OWNERSHIP privilege on the schema.

Comment: *

Name: *

Email: *

Verification: *