Pass SnowPro Core COF-C02 exam [Apr 27, 2023] Updated 265 Questions [Q98-Q121]

NO.98 A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

NO.99 Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

编号 100 True or False the longer the data retention period, the higher the resulting storage costs.

NO.101 Which of the following are common use cases for zero-copy cloning? Choose 3 answers

编号：102 Which of the following describes a Snowflake stored procedure?

第 103 号 The FLATEEN function is used to query which type of data in Snowflake?

第 104 号 If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

第 105 号 A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)

B)

C)

D)

NO.106 Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

第 107 号 Select the different types of Internal Stages: (Choose three.)

第 108 号 What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

第 109 号 Which SQL command can be used to see the CREATE definition of a masking policy?

编号 110 Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

第 111 号 Which services does the Snowflake Cloud Services layer manage? (Select TWO).

编号 112 The Snowflake Search Optimization Services supports improved performance of which kind of query?

第 113 号 User-level network policies can be created by which of the following roles? (Select TWO).

第 114 号 Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

NO.115 True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

第 116 号 Which copy INTO command outputs the data into one file?

第 117 号 Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

第 118 号 Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

NO.119 Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

NO.120 True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

NO.121 True or False: Pipes can be suspended and resumed.