What is the purpose of the Snowflake SPLIT TO_TABLE function?

• A.To count the number of characters in a string
• B.To split a string into an array of sub-strings
• C.To split a string and flatten the results into rows
• D.To split a string and flatten the results into columns

Comment: *

Name: *

Email: *

Verification: *

What statement describes Snowflake data architecture?

• A.NoSQL warehouse as a service
• B.Single-node, isolated data
• C.Multi-cluster, shared data
• D.Centralized data storage and processing

Comment: *

Name: *

Email: *

Verification: *

A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

• A.Query against the result set cache
• B.Query against a virtual warehouse cache
• C.Query against the most-recently created micro-partition
• D.Query against the metadata excite

Comment: *

Name: *

Email: *

Verification: *

What is a characteristic of a tag associated with a masking policy?

• A.A tag can be dropped after a masking policy is assigned
• B.A tag can have only one masking policy for each data type.
• C.A tag can have multiple masking policies for each data type.
• D.A tag can have multiple masking policies with varying data types

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake objects consume storage? (Select TWO)

• A.Views
• B.Temporary schemas
• C.External tables
• D.Permanent tables
• E.Materialized views

Comment: *

Name: *

Email: *

Verification: *