What transformations are supported when loading data into a table using the COPY INTO
command? (Select TWO).
Options:
A.
Column reordering
B.
Column omission
C.
JOIN function
D.
FLATTEN function
E.
GROUP BY function
Answer:
A, B
Explanation:
Explanation:
The COPY INTO <table> command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.
Question 93
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Options:
A.
The database owner
B.
The object owner
C.
The schema owner
D.
The Snowflake user's role
Answer:
C
Explanation:
Explanation:
In a managed access schema, the schema owner retains the OWNERSHIP privilege of any tables added to the schema. This means that while object owners have certain privileges over the objects they create, only the schema owner can manage privilege grants on these objects1.
Question 94
Which Snowflake layer is associated with virtual warehouses?
Options:
A.
Cloud services
B.
Query processing
C.
Elastic memory
D.
Database storage
Answer:
B
Explanation:
Explanation:
The layer of Snowflake's architecture associated with virtual warehouses is the Query Processing layer. Virtual warehouses in Snowflake are dedicated compute clusters that execute SQL queries against the stored data. This layer is responsible for the entire query execution process, including parsing, optimization, and the actual computation. It operates independently of the storage layer, enabling Snowflake to scale compute and storage resources separately for efficiency and cost-effectiveness.
References:
Snowflake Documentation: Snowflake Architecture
Question 95
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
Options:
A.
Standard
B.
Enterprise
C.
Business Critical
D.
Virtual Private Snowflake (VPS)
Answer:
D
Explanation:
Explanation:
The Virtual Private Snowflake (VPS) edition offers the highest level of security for organizations with the strictest security requirements. This edition provides a dedicated and isolated instance of Snowflake, including enhanced security features and compliance certifications to meet the needs of highly regulated industries or any organization requiring the utmost in data protection and privacy.