Snowflake SnowPro Advanced Data Engineer Exam Practice Questions (P. 3)

GPT-4o - Answer

In a Snowflake environment where a schema has MANAGED ACCESS enabled, only specific roles can grant access to the tables within that schema. The role owning the schema definitely has this ability because they directly control all underlying objects by virtue of ownership. Similarly, the database owner oversees everything at the database level, including all schemas and therefore can also manage access. The direct owner of the table, i.e., the role that created or has been assigned ownership of the CUSTOMER table, naturally retains permission to manage its access. Other roles like SYSADMIN, SECURITYADMIN, or USERADMIN do not inherently possess the ability to manage access solely based on their title unless explicitly granted relevant privileges. Remember that each role must be explicitly equipped with the necessary privileges specific to the access control requirements of a MANAGED ACCESS schema.

GPT-4o - Answer

The BUILD_STAGE_FILE_URL function in Snowflake creates a permanent URL which enables enduring access to files stored in a specified stage. This is particularly useful as it allows users and systems to repeatedly access the same file without needing to regenerate access URLs, thereby simplifying integration and access workflows in long-term data handling scenarios.

GPT-4o - Answer

When transitioning Scala scripts to Snowpark for data transformations, it's crucial to recognize that Snowpark operations are lazily executed; operations are compiled into plans on the server but don't run until an action is called. This allows efficient query optimization. Also, Snowpark fully supports manipulating multiple DataFrames, making tasks like joining tables seamless and practical inside the Snowflake environment itself. This integrates well with the existing Snowflake capabilities, ensuring that no additional computation clusters are required outside of Snowflake.