What is the MINIMUM permission needed to access a file URL from an external stage?
Correct Answer: D
To access a file URL from an external stage in Snowflake, the minimum permission required is USAGE on the stage object. USAGE permission allows a user to reference the stage in SQL commands, necessary for actions like listing files or loading data from the stage, but does not permit the user to alter or drop the stage. Reference: Snowflake Documentation: Access Control
Question 362
Which security models are used in Snowflake to manage access control? (Select TWO).
Correct Answer: A,D
Snowflake uses both Discretionary Access Control (DAC) and Role-Based Access Control (RBAC) to manage access control. DAC allows object owners to grant access privileges to other users. RBAC assigns permissions to roles, and roles are then granted to users, making it easier to manage permissions based on user roles within the organization. Reference: Snowflake Documentation: Access Control in Snowflake
Question 363
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
Correct Answer: A,E
The Snowflake Cloud Services layer performs a variety of tasks, including the management of metadata and the parsing and optimization of queries. This layer is responsible for coordinating activities across Snowflake, including user session management, security, and query compilation3.
Question 364
What will happen when the data retention period for an object is set to 0 days?
Correct Answer: B
Comprehensive and Detailed Explanation From Exact Extract: * Why B (Time Travel will be deactivated for the object) is correct:In Snowflake, the data retention period determines how long historical data (including deleted or modified data) is retained for Time Travel. When this period is set to 0 days, Time Travel is effectively disabled for that object (such as a table, schema, or database). From the official Snowflake documentation: "The DATA_RETENTION_TIME_IN_DAYS parameter specifies the number of days for which historical data is retained for Time Travel. A value of 0 disables Time Travel for the object." This means: * When DATA_RETENTION_TIME_IN_DAYS = 0, no historical versions of the object's data are retained. * As a result, Time Travel queries (using AT or BEFORE clauses) and undrop/recovery operations are not available for that object. * Why A (Streams containing the object will become stale) is incorrect:Streams become stale when the data change tracking window exceeds the retention period of the source table's Time Travel, but only if the retention period expires after some time. Setting retention to 0 disables Time Travel immediately, but doesn't by itself make existing streams "stale." Instead, new streams cannot be used effectively because there is no historical data to track. * Why C (Data replication will be disabled) is incorrect:Data replication is independent of the Time Travel retention period. A retention period of 0 does not affect replication; it only impacts the Time Travel feature. * Why D (Data sharing will be disabled) is incorrect:Data sharing is a separate Snowflake feature (using Secure Data Sharing). It is not impacted by Time Travel retention settings. Shared data can still be accessible regardless of the retention period. References (Snowflake SnowPro Core / Study Guide / Official Documentation): * Snowflake Documentation - Time Travel: "Setting DATA_RETENTION_TIME_IN_DAYS = 0 disables Time Travel for the object." * Snowflake Documentation - Object Parameters:Describes DATA_RETENTION_TIME_IN_DAYS behavior at the database, schema, and table levels. * Snowflake Study Guide - Data Protection and Governance:Clarifies that setting retention to zero disables historical data storage and deactivates Time Travel functionality.
Question 365
What is a best practice after creating a custom role?
Correct Answer: B
Assigning the custom role to the SYSADMIN role is considered a best practice because it allows the SYSADMIN role to manage objects created by the custom role. This is important for maintaining proper access control and ensuring that the SYSADMIN can perform necessary administrative tasks on objects created by users with the custom role. References: * [COF-C02] SnowPro Core Certification Exam Study Guide * Section 1.3 - SnowPro Core Certification Study Guide1
