ExamGecko
Home / Snowflake / COF-R02
Ask Question

Snowflake COF-R02 Practice Test - Questions Answers, Page 25

Question list
Search

Question 241

Report
Export
Collapse

Which of the following accurately describes shares?

Tables, secure views, and secure UDFs can be shared
Tables, secure views, and secure UDFs can be shared
Shares can be shared
Shares can be shared
Data consumers can clone a new table from a share
Data consumers can clone a new table from a share
Access to a share cannot be revoked once granted
Access to a share cannot be revoked once granted
Suggested answer: A
asked 23/09/2024
Perry Schoenmaker
37 questions

Question 242

Report
Export
Collapse

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
The ACCOUNTADMIN role must be granted to only one user.
The ACCOUNTADMIN role must be granted to only one user.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
Suggested answer: A, D
asked 23/09/2024
Mathieu Alingum Nubee
39 questions

Question 243

Report
Export
Collapse

What is the minimum Snowflake edition required for row level security?

Standard
Standard
Enterprise
Enterprise
Business Critical
Business Critical
Virtual Private Snowflake
Virtual Private Snowflake
Suggested answer: B
asked 23/09/2024
sergio sombrero
34 questions

Question 244

Report
Export
Collapse

The is the minimum Fail-safe retention time period for transient tables?

1 day
1 day
7 days
7 days
12 hours
12 hours
0 days
0 days
Suggested answer: D
asked 23/09/2024
Jessy Kevin NGANE OBAME
32 questions

Question 245

Report
Export
Collapse

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Data is live, ready-to-query, and can be personalized.
Data is live, ready-to-query, and can be personalized.
Data needs to be loaded into a cloud provider as a consumer account.
Data needs to be loaded into a cloud provider as a consumer account.
Data is not available for copying or moving to an individual Snowflake account.
Data is not available for copying or moving to an individual Snowflake account.
Data is available without copying or moving.
Data is available without copying or moving.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Suggested answer: A, D
asked 23/09/2024
Jose M Rivera Vega
34 questions

Question 246

Report
Export
Collapse

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

Whether or not it is also a secure view
Whether or not it is also a secure view
How often the underlying base table is queried
How often the underlying base table is queried
How often the base table changes
How often the base table changes
Whether the materialized view has a cluster key defined
Whether the materialized view has a cluster key defined
How often the materialized view is queried
How often the materialized view is queried
Suggested answer: D, E
asked 23/09/2024
C/1094 WOLOGUEDE COTONOU – BENIN NDENDE
36 questions

Question 247

Report
Export
Collapse

What COPY INTO SQL command should be used to unload data into multiple files?

Become a Premium Member for full access
  Unlock Premium Member

Question 248

Report
Export
Collapse

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Become a Premium Member for full access
  Unlock Premium Member

Question 249

Report
Export
Collapse

When loading data into Snowflake, how should the data be organized?

Become a Premium Member for full access
  Unlock Premium Member

Question 250

Report
Export
Collapse

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member
Total 330 questions
Go to page: of 33