- (Topic 3)
What role is required to use Partner Connect?
Correct Answer:A
To use Partner Connect, the ACCOUNTADMIN role is required. Partner Connect allows account administrators to easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake
- (Topic 6)
Which key access control concept does Snowflake descibe as a defined level of access to an object?
Correct Answer:B
In Snowflake, the term "privilege" refers to a defined level of access to an object. Privileges are specific actions that roles can perform on securable objects in Snowflake, such as tables, views, warehouses, databases, and schemas. These privileges are granted to roles and can be further granted to users through their roles, forming the basis of Snowflake??s access control framework.References:Snowflake Documentation on Access Control Privileges
- (Topic 6)
Given the statement template below, which database objects can be added to a share?(Select TWO).
GRANT
Correct Answer:CD
In Snowflake, shares are used to share data across different Snowflake accounts securely. When you create a share, you can include various database objects that you want to share with consumers. According to Snowflake's documentation, the types of objects that can be shared include tables, secure views, secure materialized views, and streams. Secure functions and stored procedures are not shareable objects. Tasks also cannot be shared directly. Therefore, the correct answers are streams (C) and tables (D).
To share a stream or a table, you use theGRANTstatement to grant privileges on these objects to a share. The syntax for sharing a table or stream involves specifying the type of object, the object name, and the share to which you are granting access. For example:
GRANTSELECTONTABLEmy_tableTOSHARE my_share;GRANTSELECTONSTREAM
my_streamTOSHARE my_share;
These commands grant the SELECT privilege on a table namedmy_tableand a stream
namedmy_streamto a share namedmy_share. This enables the consumer of the share to access these objects according to the granted privileges.
Reference: Snowflake Documentation on Shares and Database Objects
(https://docs.snowflake.com)
- (Topic 3)
Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).
Correct Answer:BE
User-Defined Function (UDF) handlers must be written inline for Javascript and SQL. These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF2.
- (Topic 6)
A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?
Correct Answer:B
For minimizing the cost of large tables that are used to store transitory data, which does not need to be protected against failures because it can be reconstructed outside of Snowflake, the best table type to use isTransient. Transient tables in Snowflake are designed for temporary or transitory data storage and offer reduced storage costs compared to permanent tables. However, unlike temporary tables, they persist across sessions until explicitly dropped.
✑ Why Transient Tables:Transient tables provide a cost-effective solution for storing data that is temporary but needs to be available longer than a single session. They have lower data storage costs because Snowflake does not maintain historical data (Time Travel) for as long as it does for permanent tables.
✑ Creating a Transient Table:
CREATETRANSIENTTABLEmy_transient_table (...);
✑ Use Case Considerations:Transient tables are ideal for scenarios where the data is not critical, can be easily recreated, and where cost optimization is a priority. They are suitable for development, testing, or staging environments where data longevity is not a concern.
Reference:For more details on transient tables and their usage scenarios, refer to the Snowflake documentation on table types: https://docs.snowflake.com/en/sql- reference/sql/create-table.html#table-types
- (Topic 6)
Who can create and manage reader accounts? (Select TWO).
Correct Answer:AD
In Snowflake, reader accounts are special types of accounts that allow data sharing with external consumers without them having their own Snowflake account. The creation and management of reader accounts can be performed by users with the ACCOUNTADMIN role or the ORGADMIN role. The ACCOUNTADMIN role has comprehensive administrative privileges within a Snowflake account, including managing other accounts and roles. The ORGADMIN role, which is higher in hierarchy, oversees multiple accounts within an organization and can manage reader accounts across those accounts.
References:
✑ Snowflake Documentation: Creating and Managing Reader Accounts