A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

• A.10 minutes
• B.14 minutes
• C.4 minutes
• D.24 minutes

Comment: *

Name: *

Email: *

Verification: *

What is one of the characteristics of data shares?

• A.Data shares support full DML operations.
• B.Data shares utilize secure views for sharing view objects.
• C.Data shares are cloud agnostic and can cross regions by default.
• D.Data shares work by copying data to consumer accounts.

Comment: *

Name: *

Email: *

Verification: *

Which use case does the search optimization service support?

• A.Disjuncts (OR) in join predicates
• B.Conjunctions (AND) of multiple equality predicates
• C.UKE/ILIKE/RLIKE join predicates
• D.Join predicates on VARIANT columns

Comment: *

Name: *

Email: *

Verification: *

The following settings are configured:
For how many days will the data be retained at the object level?

• A.2
• B.3
• C.5
• D.7

Comment: *

Name: *

Email: *

Verification: *

Why would a Snowflake user decide to use a materialized view instead of a regular view?

• A.The base tables do not change frequently.
• B.The results of the view change often.
• C.The query is not resource intensive.
• D.The query results are not used frequently.

Comment: *

Name: *

Email: *

Verification: *