ExamGecko
Home / Snowflake / COF-R02 / List of questions
Ask Question

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

Question list
Search

Question 151

Report
Export
Collapse

What can be used to view warehouse usage over time? (Select Two).

The load HISTORY view
The load HISTORY view
The Query history view
The Query history view
The show warehouses command
The show warehouses command
The WAREHOUSE_METERING__HISTORY View
The WAREHOUSE_METERING__HISTORY View
The billing and usage tab in the Snowflake web Ul
The billing and usage tab in the Snowflake web Ul
Suggested answer: D, E
asked 23/09/2024
Claudious Utete
40 questions

Question 152

Report
Export
Collapse

Which Snowflake feature is used for both querying and restoring data?

Cluster keys
Cluster keys
Time Travel
Time Travel
Fail-safe
Fail-safe
Cloning
Cloning
Suggested answer: B

Explanation:

https://docs.snowflake.com/en/user-guide/dataavailability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.

asked 23/09/2024
cristian vargas
42 questions

Question 153

Report
Export
Collapse

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Okta Verify
Okta Verify
Duo Mobile
Duo Mobile
Microsoft Authenticator
Microsoft Authenticator
Google Authenticator
Google Authenticator
Suggested answer: B

Explanation:

https://docs.snowflake.com/en/user-guide/security-mfa.html

asked 23/09/2024
Padmavathi Jawaharlal
35 questions

Question 154

Report
Export
Collapse

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Pipes
Pipes
Streams
Streams
Tasks
Tasks
Procedures
Procedures
Suggested answer: B

Explanation:

https://dataterrain.com/how-to-change-tracking-using-table-streams-insnowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20change.

asked 23/09/2024
Peter Chong
37 questions

Question 155

Report
Export
Collapse

What tasks can be completed using the copy command? (Select TWO)

Columns can be aggregated
Columns can be aggregated
Columns can be joined with an existing table
Columns can be joined with an existing table
Columns can be reordered
Columns can be reordered
Columns can be omitted
Columns can be omitted
Data can be loaded without the need to spin up a virtual warehouse
Data can be loaded without the need to spin up a virtual warehouse
Suggested answer: C, D
asked 23/09/2024
Dirk Lamberts
40 questions

Question 156

Report
Export
Collapse

What feature can be used to reorganize a very large table on one or more columns?

Micro-partitions
Micro-partitions
Clustering keys
Clustering keys
Key partitions
Key partitions
Clustered partitions
Clustered partitions
Suggested answer: B

Explanation:

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

asked 23/09/2024
Swapnil Salunke
39 questions

Question 157

Report
Export
Collapse

What SQL command would be used to view all roles that were granted to user.1?

show grants to user USER1;
show grants to user USER1;
show grants of user USER1;
show grants of user USER1;
describe user USER1;
describe user USER1;
show grants on user USER1;
show grants on user USER1;
Suggested answer: A
asked 23/09/2024
rudzani nndwammbi
30 questions

Question 158

Report
Export
Collapse

Which of the following can be executed/called with Snowpipe?

A User Defined Function (UDF)
A User Defined Function (UDF)
A stored procedure
A stored procedure
A single copy_into statement
A single copy_into statement
A single insert__into statement
A single insert__into statement
Suggested answer: C
asked 23/09/2024
Nikolaos Alexiou
32 questions

Question 159

Report
Export
Collapse

What Snowflake role must be granted for a user to create and manage accounts?

ACCOUNTADMIN
ACCOUNTADMIN
ORGADMIN
ORGADMIN
SECURITYADMIN
SECURITYADMIN
SYSADMIN
SYSADMIN
Suggested answer: A

Explanation:

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

asked 23/09/2024
Felix Morales
34 questions

Question 160

Report
Export
Collapse

When unloading to a stage, which of the following is a recommended practice or approach?

Set SINGLE: = true for larger files
Set SINGLE: = true for larger files
Use OBJECT_CONSTRUCT ( * ) when using Parquet
Use OBJECT_CONSTRUCT ( * ) when using Parquet
Avoid the use of the CAST function
Avoid the use of the CAST function
Define an individual file format
Define an individual file format
Suggested answer: C
asked 23/09/2024
Adrien BARDE
31 questions
Total 330 questions
Go to page: of 33