Where is metadata management handled in Snowflake?

• A.Query Processing
• B.Database Storage
• C.Cloud Services
• D.Compute

Comment: *

Name: *

Email: *

Verification: *

Which function, when combined with an INSERT statement, will insert semi-structured data into a VARIANT column?

• A.TO_JSON
• B.TO_VARCHAR
• C.PARSE_JSON
• D.OBJECT_INSERT

Comment: *

Name: *

Email: *

Verification: *

A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

• A.Query against the result set cache
• B.Query against a virtual warehouse cache
• C.Query against the most-recently created micro-partition
• D.Query against the metadata excite

Comment: *

Name: *

Email: *

Verification: *

Which role has the ability to create and manage users and roles?

• A.ORGADMIN
• B.USERADMIN
• C.SYSADMIN
• D.SECURITYADMIN

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: *