ExamGecko
Home Home / Snowflake / COF-R02

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

Question list
Search
Search

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

A.
The load HISTORY view
A.
The load HISTORY view
Answers
B.
The Query history view
B.
The Query history view
Answers
C.
The show warehouses command
C.
The show warehouses command
Answers
D.
The WAREHOUSE_METERING__HISTORY View
D.
The WAREHOUSE_METERING__HISTORY View
Answers
E.
The billing and usage tab in the Snowflake web Ul
E.
The billing and usage tab in the Snowflake web Ul
Answers
Suggested answer: D, E

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

A.
Cluster keys
A.
Cluster keys
Answers
B.
Time Travel
B.
Time Travel
Answers
C.
Fail-safe
C.
Fail-safe
Answers
D.
Cloning
D.
Cloning
Answers
Suggested answer: B

Explanation:

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

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?

A.
Okta Verify
A.
Okta Verify
Answers
B.
Duo Mobile
B.
Duo Mobile
Answers
C.
Microsoft Authenticator
C.
Microsoft Authenticator
Answers
D.
Google Authenticator
D.
Google Authenticator
Answers
Suggested answer: B

Explanation:

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

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

A.
Pipes
A.
Pipes
Answers
B.
Streams
B.
Streams
Answers
C.
Tasks
C.
Tasks
Answers
D.
Procedures
D.
Procedures
Answers
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.

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

A.
Columns can be aggregated
A.
Columns can be aggregated
Answers
B.
Columns can be joined with an existing table
B.
Columns can be joined with an existing table
Answers
C.
Columns can be reordered
C.
Columns can be reordered
Answers
D.
Columns can be omitted
D.
Columns can be omitted
Answers
E.
Data can be loaded without the need to spin up a virtual warehouse
E.
Data can be loaded without the need to spin up a virtual warehouse
Answers
Suggested answer: C, D

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

A.
Micro-partitions
A.
Micro-partitions
Answers
B.
Clustering keys
B.
Clustering keys
Answers
C.
Key partitions
C.
Key partitions
Answers
D.
Clustered partitions
D.
Clustered partitions
Answers
Suggested answer: B

Explanation:

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

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

A.
show grants to user USER1;
A.
show grants to user USER1;
Answers
B.
show grants of user USER1;
B.
show grants of user USER1;
Answers
C.
describe user USER1;
C.
describe user USER1;
Answers
D.
show grants on user USER1;
D.
show grants on user USER1;
Answers
Suggested answer: A

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

A.
A User Defined Function (UDF)
A.
A User Defined Function (UDF)
Answers
B.
A stored procedure
B.
A stored procedure
Answers
C.
A single copy_into statement
C.
A single copy_into statement
Answers
D.
A single insert__into statement
D.
A single insert__into statement
Answers
Suggested answer: C

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

A.
ACCOUNTADMIN
A.
ACCOUNTADMIN
Answers
B.
ORGADMIN
B.
ORGADMIN
Answers
C.
SECURITYADMIN
C.
SECURITYADMIN
Answers
D.
SYSADMIN
D.
SYSADMIN
Answers
Suggested answer: A

Explanation:

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

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

A.
Set SINGLE: = true for larger files
A.
Set SINGLE: = true for larger files
Answers
B.
Use OBJECT_CONSTRUCT ( * ) when using Parquet
B.
Use OBJECT_CONSTRUCT ( * ) when using Parquet
Answers
C.
Avoid the use of the CAST function
C.
Avoid the use of the CAST function
Answers
D.
Define an individual file format
D.
Define an individual file format
Answers
Suggested answer: C
Total 330 questions
Go to page: of 33