A table gets updated throughout the day. A user wants to automate the process of table changes by capturing only the changed rows every 20 minutes and applying transformations without manual intervention. How can this be accomplished?
Correct Answer: C
The correct answer is C. Create a stream and schedule a task every 20 minutes. A stream is used to capture change data capture, or CDC, information for a table. It records inserts, updates, and deletes made to the source table. A task is used to automate SQL execution on a schedule. Together, streams and tasks are commonly used to automate incremental data processing in Snowflake. Why C is correct: The requirement has two parts: Capture only changed rows. Run the transformation automatically every 20 minutes. A stream satisfies the first requirement because it tracks changed rows. A scheduled task satisfies the second requirement because it can run SQL logic at a defined interval, such as every 20 minutes. Example concept: CREATE STREAM my_stream ON TABLE source_table; CREATE TASK my_task WAREHOUSE = my_warehouse SCHEDULE = ' 20 MINUTE ' AS INSERT INTO target_table SELECT ... FROM my_stream; Why the other options are incorrect: A). This is partially correct, but it does not clearly satisfy the requirement to run every 20 minutes. A task can include a WHEN SYSTEM$STREAM_HAS_DATA(...) condition, but the question specifically asks for processing every 20 minutes. B). A task alone can run every 20 minutes, but it does not capture only changed rows. D). Dynamic tables are used for declarative automated data transformation, but the question specifically asks to capture only changed rows from a frequently updated table, which is the purpose of a stream. Official Snowflake documentation reference: Snowflake documentation describes streams as objects that record data manipulation language, or DML, changes made to tables. Snowflake tasks execute SQL statements on a schedule or as part of a task graph. Reference: Snowflake Documentation - Streams; Snowflake Documentation - Introduction to tasks; SnowPro Core Study Guide - SQL and Snowflake Objects.
Question 267
Which function returns the URL of a stage using the stage name as the input?
Correct Answer: C
The function in Snowflake that returns the URL of a stage using the stage name as the input is C. GET_PRESIGNED_URL. This function generates a pre-signed URL for a specific file in a stage, enabling secure, temporary access to that file without requiring Snowflake credentials. While the function is primarily used for accessing files in external stages, such as Amazon S3 buckets, it is instrumental in scenarios requiring direct, secure file access for a limited time. It's important to note that as of my last update, Snowflake's documentation does not specifically list a function named GET_PRESIGNED_URL for directly obtaining a stage's URL by its name. The description aligns closely with functionality available in cloud storage services (e.g., AWS S3's presigned URLs) which can be used in conjunction with Snowflake stages for secure, temporary access to files. For direct interaction with stages and their files, Snowflake offers various functions and commands, but the exact match for generating a presigned URL through a simple function call may vary or require leveraging external cloud services APIs in addition to Snowflake's capabilities. References: Snowflake Documentation and cloud services (AWS, Azure, GCP) documentation on presigned URLs and stage interactions.
Question 268
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Correct Answer: A
The FLATTEN function can be used with the recursive argument to return a list of distinct key names in all nested elements within an object.This function is particularly useful for working with semi-structured data in Snowflake
Question 269
Which Snowflake technique can be used to improve the performance of a query?
Correct Answer: A
Clustering is a technique used in Snowflake to improve the performance of queries. It involves organizing the data in a table into micro-partitions based on the values of one or more columns. This organization allows Snowflake to efficiently prune non-relevant micro-partitions during a query, which reduces the amount of data scanned and improves query performance. References: [COF-C02] SnowPro Core Certification Exam Study Guide Snowflake Documentation on Clustering
Question 270
What feature specifies which roles are allowed to see a particular record in a table?
Correct Answer: C
The correct answer is C. Row access policy . A row access policy is used to implement row-level security in Snowflake. It controls whether a row is visible in query results based on conditions such as the current role, current user, or values in a mapping table. Why C is correct: The question asks which feature controls visibility of particular records, meaning rows. Row access policies are designed exactly for that purpose. Example concept: CREATE ROW ACCESS POLICY region_policy AS (region STRING) RETURNS BOOLEAN - > region IN ( SELECT allowed_region FROM role_region_mapping WHERE role_name = CURRENT_ROLE() ); This policy can allow users with different roles to see only the rows assigned to their region. Why the other options are incorrect: A). Dynamic Data Masking controls how column values are displayed. It masks data in columns but does not filter entire rows. B). Secure Data Sharing allows data to be shared between accounts, but it is not the row-level filtering feature itself. D). Object tagging classifies or labels objects for governance, but it does not directly control row visibility. Official Snowflake documentation reference: Snowflake documentation describes row access policies as schema-level objects that determine whether a row is visible in query results. Reference: Snowflake Documentation - Row access policies; Snowflake Documentation - Row-level security; SnowPro Core Study Guide - Data Protection and Governance. ==
