What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

• A.GROUP BY
• B.LIMIT
• C.ORDER BY
• D.PARTITION BY
• E.UNION ALL

Comment: *

Name: *

Email: *

Verification: *

How do secure views compare to non-secure views in Snowflake?

• A.Secure views execute slowly compared to non-secure views.
• B.Non-secure views are preferred over secure views when sharing data.
• C.Secure views are similar to materialized views in that they are the most performant.
• D.There are no performance differences between secure and non-secure views.

Comment: *

Name: *

Email: *

Verification: *

Which statement describes how Snowflake supports reader accounts?

• A.A reader account can consume data from the provider account that created it and combine it with its own data.
• B.The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
• C.A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
• D.The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

Comment: *

Name: *

Email: *

Verification: *

What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

• A.5
• B.10
• C.1
• D.100

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

• A.Each Snowflake account can be hosted in a different cloud vendor and region.
• B.Each Snowflake account must be hosted in a different cloud vendor and region
• C.All Snowflake accounts must be hosted in the same cloud vendor and region
• D.Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Comment: *

Name: *

Email: *

Verification: *