Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

• A.Query execution
• B.Data loading
• C.Time Travel data
• D.Security
• E.Authentication and access control

Comment: *

Name: *

Email: *

Verification: *

What are ways to create and manage data shares in Snowflake? (Select TWO)

• A.Through the Snowflake web interface (Ul)
• B.Through the DATA_SHARE=TRUE parameter
• C.Through SQL commands
• D.Through the enable__share=true parameter
• E.Using the CREATE SHARE AS SELECT * TABLE command

Comment: *

Name: *

Email: *

Verification: *

What is the recommended method for loading data into Snowflake?

• A.Load data in batch
• B.Load row by row
• C.Load data via frequent, angle row DML's
• D.Load data by writing it In the Snowflake Web Interface (UI)

Comment: *

Name: *

Email: *

Verification: *

Which feature is only available in the Enterprise or higher editions of Snowflake?

• A.SOC 2 type II certification
• B.Column-level security
• C.Multi-factor Authentication (MFA)
• D.Object-level access control

Comment: *

Name: *

Email: *

Verification: *

What step can reduce data spilling in Snowflake?

• A.Using a larger virtual warehouse
• B.Increasing the virtual warehouse maximum timeout limit
• C.Increasing the amount of remote storage for the virtual warehouse
• D.Using a Common Table Expression (CTE) instead of a temporary table

Comment: *

Name: *

Email: *

Verification: *