The PUT command: (Choose two.)

• A.Automatically compresses files using Gzip
• B.Automatically uses the last Stage created
• C.Automatically creates a File Format object
• D.Automatically encrypts files

Comment: *

Name: *

Email: *

Verification: *

What is a key feature of Snowflake architecture?

• A.Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
• B.Snowflake eliminates resource contention with its virtual warehouse implementation
• C.Zero-copy cloning creates a mirror copy of a database that updates with the original
• D.Software updates are automatically applied on a quarterly basis
• E.Multi-cluster warehouses allow users to run a query that spans across multiple clusters

Comment: *

Name: *

Email: *

Verification: *

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)

B)

C)

D)

• A.Option C
• B.Option B
• C.Option D
• D.Option A

Comment: *

Name: *

Email: *

Verification: *

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

• A.Snowpipe
• B.AUTOMATIC__CLUSTERING
• C.Execute a COPY command
• D.Updating data
• E.Scaling up a warehouse

Comment: *

Name: *

Email: *

Verification: *

A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?

• A.When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
• B.When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
• C.When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
• D.When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Comment: *

Name: *

Email: *

Verification: *