How does Snowflake support the use of structured and semi-structured data? (Select TWO)

• A.Structured data is supported through the use of traditional relational database tables, organized into rows and columns.
• B.Structured and semi-structured data are stored in separate physical storage locations; users must choose which type of data to use when creating a table.
• C.Semi-structured data is supported through the use of automatically indexed database tables.
• D.All semi-structured data is automatically converted into structured data when it is loaded into Snowflake.
• E.Users can load and query semi-structured data using SQL using the SQL semi-structured data handling functions.

Comment: *

Name: *

Email: *

Verification: *

When using the COPY INTO < location > command, which parameter is used to unload table rows into separate files?

• A.DETAILED_OUTPUT
• B.PARTITION BY
• C.FILE_FORMAT
• D.HEADER

Comment: *

Name: *

Email: *

Verification: *

Which command line parameter value can be pre-specified as an environment variable in SnowSQL?

• A.MFA-PASSCODE
• B.OPTION
• C.VARIABLE
• D.HOST

Comment: *

Name: *

Email: *

Verification: *

How does Snowflake utilize clustering information to improve query performance?

• A.It prunes unnecessary micro-partitions based on clustering metadata.
• B.It compresses the data within micro-partitions for faster querying.
• C.It automatically allocates additional resources to improve query execution.
• D.It organizes clustering information to speed-up data retrieval from storage

Comment: *

Name: *

Email: *

Verification: *

Snowflake's access control framework combines which models for securing data? (Select TWO).

• A.Attribute-based Access Control (ABAC 1
• B.Discretionary Access Control (DAC)
• C.Access Control List (ACL)
• D.Role-based Access Control (RBAC)
• E.Rule-based Access Control (RuBAC)

Comment: *

Name: *

Email: *

Verification: *