Which stream type can be used for tracking the records in external tables?

• A.External
• B.Insert-only
• C.Append-only
• D.Standard

Comment: *

Name: *

Email: *

Verification: *

Which statements describe benefits of Snowflake's separation of compute and storage?(Select TWO).

• A.Compote can be scaled up or down without the requirement to add more storage.
• B.The separation ensures consistent data encryption across all virtual data warehouses.
• C.Storage volume growth and compute usage growth can be tightly coupled.
• D.The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
• E.The separation allows independent scaling of computing resources.

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of multi-cluster virtual warehouses?

• A.To create separate data warehouses to increase query optimization
• B.To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
• C.To eliminate or reduce Queuing of concurrent queries
• D.To allow the warehouse to resize automatically

Comment: *

Name: *

Email: *

Verification: *

What features does Snowflake Time Travel enable?

• A.Querying data-related objects that were created within the past 365 days
• B.Restoring data-related objects that have been deleted within the past 90 days
• C.Conducting point-in-time analysis for Bl reporting
• D.Analyzing data usage/manipulation over all periods of time

Comment: *

Name: *

Email: *

Verification: *

When creating a user it is advisable sable to: Choose 2 answers

• A.Set the number of minutes to unlock to 15 minutes
• B.Set a default role for the user
• C.Force an immediate password change
• D.Set the users access to expire within a specified timeframe
• E.Set the user to be initially disabled

Comment: *

Name: *

Email: *

Verification: *