- (Topic 3)
Which TABLE function helps to convert semi-structured data to a relational representation?
Correct Answer:C
The FLATTEN table function in Snowflake is used to convert semi- structured data, such as JSON or XML, into a relational format. It expands nested arrays or objects into multiple rows, making the data suitable for relational querying3.
- (Topic 1)
How long is Snowpipe data load history retained?
Correct Answer:C
Snowpipe data load history is retained for 64 days. This retention period allows users to review and audit the data load operations performed by Snowpipe over a significant period of time, which can be crucial for troubleshooting and ensuring data integrity.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Snowpipe1
- (Topic 6)
What can the Snowflake SCIM API be used to manage? (Select TWO).
Correct Answer:DE
The Snowflake SCIM (System for Cross-domain Identity Management) API is used for automated user and role management. It enables integration with identity providers (IdPs) for the provisioning and deprovisioning of user accounts and roles in Snowflake. This helps in managing access control and permissions systematically and aligns with identity governance practices.
References:
✑ Snowflake Documentation: Managing Users and Roles with SCIM API
- (Topic 3)
Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
Correct Answer:A
In Snowflake, a User-Defined Table Function (UDTF) can be accessed in the FROM clause of a query. UDTFs return a set of rows with one or more columns, which can be queried like a regular table
- (Topic 6)
Which task is supported by the use of Access History in Snowflake?
Correct Answer:C
Access History in Snowflake is primarily utilized for compliance auditing. The Access History feature provides detailed logs that track data access and modifications, including queries that read from or write to database objects. This information is crucial for organizations to meet regulatory requirements and to perform audits related to data access and usage.
✑ Role of Access History:Access History logs are designed to help organizations understand who accessed what data and when. This is particularly important for compliance with various regulations that require detailed auditing capabilities.
✑ How Access History Supports Compliance Auditing:
Reference:For more information on how Access History supports compliance auditing, refer to the Snowflake documentation on Access History: https://docs.snowflake.com/en/sql-reference/account-usage/access_history.html