What happens when a suspended virtual warehouse is resized in Snowflake?

• A.It will return an error.
• B.It will return a warning.
• C.The suspended warehouse is resumed and new compute resources are provisioned immediately.
• D.The additional compute resources are provisioned when the warehouse is resumed.

Comment: *

Name: *

Email: *

Verification: *

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory?
(Select TWO).

• A.Bytes scanned
• B.Partitions scanned
• C.Bytes spilled to local storage
• D.Bytes spilled to remote storage
• E.Percentage scanned from cache

Comment: *

Name: *

Email: *

Verification: *

Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?

• A.Free listing
• B.Paid listing
• C.Direct share
• D.Data Exchange

Comment: *

Name: *

Email: *

Verification: *

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

• A.Table definition
• B.Stage definition
• C.Session level
• D.COPY INTO TABLE statement

Comment: *

Name: *

Email: *

Verification: *

What are characteristics of reader accounts in Snowflake? (Select TWO).

• A.Reader account users cannot add new data to the account.
• B.Reader account users can share data to other reader accounts.
• C.A single reader account can consume data from multiple provider accounts.
• D.Data consumers are responsible for reader account setup and data usage costs.
• E.Reader accounts enable data consumers to access and query data shared by the provider.

Comment: *

Name: *

Email: *

Verification: *