When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

• A.When the compute must be available with no delay or lag time
• B.When users will be using compute at different times throughout a 24/7 period
• C.When managing a steady workload
• D.When you don't want to have to manually turn on the Warehouse each time a user needs it

Comment: *

Name: *

Email: *

Verification: *

When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

• A.Performance
• B.Concurrency

Comment: *

Name: *

Email: *

Verification: *

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

• A.ORC
• B.XML
• C.Avro
• D.Parquet
• E.JSON

Comment: *

Name: *

Email: *

Verification: *

Which cache type is used to cache data output from SQL queries?

• A.Result cache
• B.Metadata cache
• C.Local file cache
• D.Remote cache

Comment: *

Name: *

Email: *

Verification: *

Which use case does the search optimization service support?

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

Comment: *

Name: *

Email: *

Verification: *