Which file format will keep floating-point numbers from being truncated when data is unloaded?
Correct Answer: D
Question 632
A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access. Which file function should be used?
Correct Answer: C
The GET_PRESIGNED_URL function in Snowflake generates a presigned URL for a file stored in an internal stage, allowing direct access to the file without requiring Snowflake access. This feature is particularly useful for sharing unstructured data with external applications or tools that do not have direct access to Snowflake. The presigned URL provides temporary access to the file, making it an ideal solution for securely sharing unstructured data from an internal stage with a reporting tool or any other external application. References: * Snowflake Documentation: Generating Presigned URLs
Question 633
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Correct Answer: A,E
Question 634
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Correct Answer: C,D
The credit consumption for maintaining a materialized view is impacted by how often the base table changes and whether the materialized view has a cluster key defined (D). Changes to the base table can trigger a refresh of the materialized view, consuming credits. Additionally, having a cluster key defined can optimize the performance and credit usage during the materialized view's maintenance. References: SnowPro Core Certification materialized view credit consumption
Question 635
How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
Correct Answer: D
To monitor updates, such as SCIM API requests sent to Snowflake by the identity provider, an administrator can use the REST EVENT HISTORY feature. This feature allows administrators to query historical data about REST API calls made to Snowflake, including those related to user and role management through SCIM (System for Cross-domain Identity Management). The REST EVENT HISTORY table function returns information about REST API calls made over a specified period. It is particularly useful for auditing and monitoring purposes, especially when integrating Snowflake with third-party identity providers that use SCIM for automated user provisioning and deprovisioning. An example query to check for SCIM API requests might look like this: SELECT * FROM TABLE(information_schema.rest_event_history(date_range_start=>dateadd('hours',-1,current_timestamp()))) WHERE request_type = 'SCIM'; This query returns details on SCIM API requests made in the last hour, including the request type, the identity provider's details, and the outcome of each request. Reference: Snowflake Documentation on REST EVENT HISTORY (https://docs.snowflake.com/en/sql-reference/functions/rest_event_history.html)
