COF-C02 Exam Dumps, COF-C02 Practice Test Questions [Q269-Q286]

Q269. What is the MINIMUM role required to set the value for the parameter
ENABLE_ACCOUNT_DATABASE_REPLICATION?

Q270. The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.
How can this be accomplished?

Q271. Which of the following statements is true of Snowflake micro-partitioning?

Q272. A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

Q273. A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

Q274. What is a limitation of a Materialized View?

Q275. What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

Q276. How can a Snowflake user traverse semi-structured data?

Q277. A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

Q278. What is a best practice after creating a custom role?

Q279. For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Q280. Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

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

Q282. Which function should be used to insert JSON format string data inot a VARIANT field?

Q283. What is used to diagnose and troubleshoot network connections to Snowflake?

Q284. Which function will provide the proxy information needed to protect Snowsight?

Q285. What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

Q286. Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).