Question 1

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

Options :

A : Create a zero-copy clone of the worksheet and grant permissions to teammates

B : Create a private Data Exchange so that any teammate can use the worksheet

C : Share the worksheet with teammates within Snowsight

D : Create a database and grant all permissions to teammates

Answer: C

Question 2

What features does Snowflake Time Travel enable?

Options :

A : Querying data-related objects that were created within the past 365 days

B : Restoring data-related objects that have been deleted within the past 90 days

C : Conducting point-in-time analysis for Bl reporting

D : Analyzing data usage/manipulation over all periods of time

Answer: B

Question 3

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Options :

A : Informatica

B : Power Bl

C : Adobe

D : Data Robot

Answer: D

Question 4

What happens to historical data when the retention period for an object ends?

Options :

A : The data is cloned into a historical object.

B : The data moves to Fail-safe

C : Time Travel on the historical data is dropped.

D : The object containing the historical data is dropped.

Answer: D

Question 5

Which TABLE function helps to convert semi-structured data to a relational representation?

Options :

A : CHECK_JSON

B : TO_JSON

C : FLATTEN

D : PARSE_JSON

Answer: D

Higher Test Marks with Free Online COF-R02 Exam Practice