ExamGecko
Home Home / Snowflake / COF-R02

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

Question list
Search
Search

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

A.
SHOW GRANTS OF ROLE MY_ROLE
A.
SHOW GRANTS OF ROLE MY_ROLE
Answers
B.
SHOW GRANTS TO ROLE MY_ROLE
B.
SHOW GRANTS TO ROLE MY_ROLE
Answers
C.
SHOW GRANTS FOR ROLE MY_ROLE
C.
SHOW GRANTS FOR ROLE MY_ROLE
Answers
D.
SHOW GRANTS ON ROLE MY_ROLE
D.
SHOW GRANTS ON ROLE MY_ROLE
Answers
Suggested answer: B

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

A.
Business Critical Edition
A.
Business Critical Edition
Answers
B.
Standard Edition
B.
Standard Edition
Answers
C.
Virtual Private Snowflake (VPS)
C.
Virtual Private Snowflake (VPS)
Answers
D.
Enterprise Edition
D.
Enterprise Edition
Answers
Suggested answer: D

A user created a transient table and made several changes to it over the course of several days.

Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

A.
Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
A.
Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
Answers
B.
The transient table version cannot be retrieved after 24 hours.
B.
The transient table version cannot be retrieved after 24 hours.
Answers
C.
Contact Snowflake Support to have the data retrieved from Fail-safe storage.
C.
Contact Snowflake Support to have the data retrieved from Fail-safe storage.
Answers
D.
Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
D.
Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
Answers
Suggested answer: B

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A.
Tri-Secret Secure
A.
Tri-Secret Secure
Answers
B.
Time Travel
B.
Time Travel
Answers
C.
Fail-safe
C.
Fail-safe
Answers
D.
Data encryption
D.
Data encryption
Answers
E.
External stages
E.
External stages
Answers
Suggested answer: B, C

Where can a user find and review the failed logins of a specific user for the past 30 days?

A.
The USERS view in ACCOUNT_USAGE
A.
The USERS view in ACCOUNT_USAGE
Answers
B.
The LOGIN_HISTORY view in ACCOUNT_USAGE
B.
The LOGIN_HISTORY view in ACCOUNT_USAGE
Answers
C.
The ACCESS_HISTORY view in ACCOUNT_USAGE
C.
The ACCESS_HISTORY view in ACCOUNT_USAGE
Answers
D.
The SESSIONS view in ACCOUNT_USAGE
D.
The SESSIONS view in ACCOUNT_USAGE
Answers
Suggested answer: B

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A.
Snowflake leverages a Role-Based Access Control (RBAC) model.
A.
Snowflake leverages a Role-Based Access Control (RBAC) model.
Answers
B.
Snowflake requires a user to configure an IAM user to connect to the database.
B.
Snowflake requires a user to configure an IAM user to connect to the database.
Answers
C.
All data in Snowflake is encrypted.
C.
All data in Snowflake is encrypted.
Answers
D.
Snowflake can run within a user's own Virtual Private Cloud (VPC).
D.
Snowflake can run within a user's own Virtual Private Cloud (VPC).
Answers
E.
All data in Snowflake is compressed.
E.
All data in Snowflake is compressed.
Answers
Suggested answer: A, D

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

A.
Runs a query that takes 3 minutes to complete
A.
Runs a query that takes 3 minutes to complete
Answers
B.
Leaves for 15 minutes
B.
Leaves for 15 minutes
Answers
C.
Returns and runs a query that takes 10 seconds to complete
C.
Returns and runs a query that takes 10 seconds to complete
Answers
D.
Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?
D.
Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?
Answers
E.
4 minutes
E.
4 minutes
Answers
F.
10 minutes
F.
10 minutes
Answers
G.
14 minutes
G.
14 minutes
Answers
H.
24 minutes
H.
24 minutes
Answers
Suggested answer: C

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A.
Removing a column from the query SELECT list
A.
Removing a column from the query SELECT list
Answers
B.
Stopping the virtual warehouse that the query is running against
B.
Stopping the virtual warehouse that the query is running against
Answers
C.
Clustering of the data used by the query
C.
Clustering of the data used by the query
Answers
D.
Executing the RESULTS_SCAN() table function
D.
Executing the RESULTS_SCAN() table function
Answers
E.
Changing a column that is not in the cached query
E.
Changing a column that is not in the cached query
Answers
Suggested answer: A, D

Which statement is true about running tasks in Snowflake?

A.
A task can be called using a CALL statement to run a set of predefined SQL commands.
A.
A task can be called using a CALL statement to run a set of predefined SQL commands.
Answers
B.
A task allows a user to execute a single SQL statement/command using a predefined schedule.
B.
A task allows a user to execute a single SQL statement/command using a predefined schedule.
Answers
C.
A task allows a user to execute a set of SQL commands on a predefined schedule.
C.
A task allows a user to execute a set of SQL commands on a predefined schedule.
Answers
D.
A task can be executed using a SELECT statement to run a predefined SQL command.
D.
A task can be executed using a SELECT statement to run a predefined SQL command.
Answers
Suggested answer: C

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

A.
When the system has enough load for 2 minutes
A.
When the system has enough load for 2 minutes
Answers
B.
When the system has enough load for 6 minutes
B.
When the system has enough load for 6 minutes
Answers
C.
When the system has enough load for 8 minutes
C.
When the system has enough load for 8 minutes
Answers
D.
When the system has enough load for 10 minutes
D.
When the system has enough load for 10 minutes
Answers
Suggested answer: D
Total 330 questions
Go to page: of 33