What is the primary purpose of a directory table in Snowflake?

• A.To store actual data from external stages
• B.To automatically expire file URLs for security
• C.To manage user privileges and access control
• D.To store file-level metadata about data files in a stage

Comment: *

Name: *

Email: *

Verification: *

What tasks can be completed using the copy command? (Select TWO)

• A.Columns can be aggregated
• B.Columns can be joined with an existing table
• C.Columns can be reordered
• D.Columns can be omitted
• E.Data can be loaded without the need to spin up a virtual warehouse

Comment: *

Name: *

Email: *

Verification: *

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of a Query Profile?

• A.To profile how many times a particular query was executed and analyze its u^age statistics over time.
• B.To profile a particular query to understand the mechanics of the query, its behavior, and performance.
• C.To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
• D.To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Comment: *

Name: *

Email: *

Verification: *

True or false: it is best practice to define a clustering key on every table.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *