Snowflake SnowPro Core Practice Test - Questions Answers, Page 40
List of questions
Related questions
Question 391

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
Explanation:
Tags in Snowflake allow users to track sensitive data for compliance, discovery, protection, and resource usage.They enable the categorization and tracking of data, supporting compliance with privacy regulations678.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 392

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
Explanation:
Virtual warehouses in Snowflake can be started and stopped at any time, providing flexibility in managing compute resources.They can also be resized at any time, even while running, to accommodate varying workloads910.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 393

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
Explanation:
The parameterDATA_RETENTION_TIME_IN_DAYScan be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.
Question 394

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
Explanation:
When a tag object is assigned to a table, using the statementCREATE TABLE <table_name> AS SELECT * FROM TABLE_Awill automatically assign the TABLE_A tag to the newly created table2.
Question 395

What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Explanation:
Dynamic Data Masking in Snowflake supportstables and views.These objects can have masking policies applied to their columns to dynamically mask data at query time3.
Question 396

What happens when a Snowflake user changes the data retention period at the schema level?
Explanation:
When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.
Question 397

Which Snowflake function will parse a JSON-null into a SQL-null?
Explanation:
TheSTRIP_NULL_VALUEfunction in Snowflake is used to convert a JSON null value into a SQL NULL value1.
Question 398

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
Explanation:
TheBUILD_STAGE_FILE_URLfunction generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.
Question 399

Which Snowflake database object can be used to track data changes made to table data?
Explanation:
AStreamobject in Snowflake is used for change data capture (CDC), which records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes3.
Question 400

What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).
Explanation:
TheCOPY INTO <table>command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.
Question