Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake " >
Correct Answer: B
TheGET_PRESIGNED_URLfunction in Snowflake generates a pre-signed URL for a file in an internal stage. This URL can be shared with external tools or users who do not have direct access to Snowflake, allowing them to download the file. Generate Pre-Signed URL: SELECT GET_PRESIGNED_URL(@my_stage/file.txt); Share the URL:The generated URL can be shared with external users or applications, enabling them to access the file directly. References: Snowflake Documentation: GET_PRESIGNED_URL Snowflake Documentation: Working with Stages
Question 342
What is a benefit of using system tags?
Correct Answer: B
System tags help enable data classification for governance, privacy, and compliance. For example, Snowflake uses system-defined tags like SNOWFLAKE.CORE.DATA_CLASSIFICATION to detect and label sensitive data (e.g., PII, financial info). Reference: Snowflake Docs: System Tags
Question 343
Revoking which privilege will prevent one role from giving privileges to other roles?
Correct Answer: D
The correct answer is D. MANAGE GRANTS . The MANAGE GRANTS privilege allows a role to grant and revoke privileges on objects. If this privilege is revoked, the role loses the broad ability to manage privileges for other roles. Why D is correct: MANAGE GRANTS is a powerful global privilege. It allows a role to grant and revoke privileges, even on objects the role does not own, depending on Snowflake's access control rules. Why the other options are incorrect: A). USAGE allows access to an object or namespace, such as a database, schema, warehouse, or integration. It does not allow broad grant management. B). MODIFY allows changes to certain object properties or data, depending on the object type, but it does not broadly allow granting privileges to roles. C). REFERENCES is related to referencing objects, such as in constraints or policies. It does not control grant administration. Official Snowflake documentation reference: Snowflake documentation describes MANAGE GRANTS as the global privilege that enables granting and revoking privileges on objects. Reference: Snowflake Documentation - Access control privileges; Snowflake Documentation - MANAGE GRANTS; SnowPro Core Study Guide - Security and Access Control.
Question 344
A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as " Notify & Suspend Immediately " . What is the MAXIMUM limit of credits that Warehouse 2 can consume?
Correct Answer: B
In the provided exhibit, Warehouse 2 is under Resource Monitor 2, which has a credit quota of 1000 credits. However, it ' s important to note that warehouses can also draw from the account-level resource monitor if they consume their dedicated monitor ' s quota. In this exhibit, Resource Monitor 1 is set for the account with a credit quota of 500 credits. The exhibit does not clearly show whether Warehouse 2 is also subject to the account-level Resource Monitor 1, but if we assume the typical case where all warehouses can draw from the account-level monitor, the maximum limit of credits Warehouse 2 can consume would be the sum of its dedicated resource monitor (Resource Monitor 2) and the account-level resource monitor (Resource Monitor 1). Thus, Warehouse 2 can consume: 1000 credits from Resource Monitor 2 500 credits from Resource Monitor 1 (if applicable) This gives a total of 1500 credits. Therefore, the maximum credit limit that Warehouse 2 can consume, taking into account the possibility of the account-level monitor ' s contribution, would be 1500 credits. However, without explicit confirmation that Warehouse 2 can use credits from Resource Monitor 1, one would default to the specific resource monitor assigned to the warehouse, which is 1000 credits. Given the available options, the closest and most accurate answer is B. 1500, as it represents the sum of credits from both monitors that potentially apply to Warehouse 2. References: Snowflake Documentation on Resource Monitors: Managing Resource Monitors
Question 345
Which of the following are characteristics of security in Snowflake?
Correct Answer: C
One of the security features of Snowflake includes the periodic rekeying of encrypted data, which is available with the Snowflake Enterprise edition and higher2. This ensures that the encryption keys are rotated regularly to maintain a high level of security. References: [COF-C02] SnowPro Core Certification Exam Study Guide
