Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

• A.A Google Cloud storage bucket
• B.A Windows server file share on Azure
• C.An HTTPS server with WebDAV
• D.An FTP server with TLS encryption

Comment: *

Name: *

Email: *

Verification: *

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

• A.4
• B.8
• C.16
• D.32

Correct Answer: B

Explanation
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Comment: *

Name: *

Email: *

Verification: *

Which parameter prevents streams on tables from becoming stale?

• A.STALE_AFTER
• B.LOCK_TIMEOUT
• C.MAXDATAEXTENSIONTIMEINDAYS
• D.MTN_DATA_RETENTION_TTME_TN_DAYS

Comment: *

Name: *

Email: *

Verification: *

Which features make up Snowflake's column level security? (Select TWO).

• A.Key pair authentication
• B.External Tokenization
• C.Row access policies
• D.Dynamic Data Masking
• E.Continuous Data Protection (CDP)

Comment: *

Name: *

Email: *

Verification: *

Which command is used to unload data from a Snowflake table into a file in a stage?

• A.GET
• B.EXTRACT INTO
• C.WRITE
• D.COPY INTO

Comment: *

Name: *

Email: *

Verification: *