Free SnowPro Core Recertification Exam COF-R02 Exam Practice Test

- (Exam Topic 3) When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

• There is no need to have a Snowflake account in the target region, a share will be created for each user.
• The listing is replicated into all selected regions automatically, the data is not.
• The user must have the ORGADMIN role available in at least one account to link accounts for replication.
• Shares attached to listings in remote regions can be viewed from any account in an organization.
• For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

- (Exam Topic 3) Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

• parse_json()
• json_extract_path_text()
• object_construct()
• flatten

- (Exam Topic 3) What is a responsibility of Snowflake’s virtual warehouses?

• Infrastructure management
• Metadata management
• Query execution
• Query parsing and optimization
• Permanent storage of micro-partitions

- (Exam Topic 3) What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

• Standard
• Enterprise
• Business Critical
• Virtual Private Snowflake

- (Exam Topic 1) What privileges are required to create a task?

• The global privilege create task is required to create a new task.
• Tasks are created at the Application level and can only be created by the Account Admin role.
• Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
• The role must have access to the target schema and the create task privilege on the schema itself.

- (Exam Topic 2) What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

• Via the Snowflake Web Interface (Ul)
• Via the data_share=true parameter
• Via SQL commands
• Via Virtual Warehouses

- (Exam Topic 1) True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

• True
• False

- (Exam Topic 2) The fail-safe retention period is how many days?

• 1 day
• 7 days
• 45 days
• 90 days

- (Exam Topic 2) What happens when an external or an internal stage is dropped? (Select TWO).

• When dropping an external stage, the files are not removed and only the stage is dropped
• When dropping an external stage, both the stage and the files within the stage are removed
• When dropping an internal stage, the files are deleted with the stage and the files are recoverable
• When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
• When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

- (Exam Topic 1) True or False: The COPY command must specify a File Format in order to execute.

• True
• False