ExamGecko
Home Home / Snowflake / COF-R02

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

Question list
Search
Search

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A.
Roles
A.
Roles
Answers
B.
Databases
B.
Databases
Answers
C.
Warehouses
C.
Warehouses
Answers
D.
Users
D.
Users
Answers
E.
Accounts
E.
Accounts
Answers
Suggested answer: A, D

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

A.
Configure the user to be initially disabled.
A.
Configure the user to be initially disabled.
Answers
B.
Force an immediate password change.
B.
Force an immediate password change.
Answers
C.
Set a default role for the user.
C.
Set a default role for the user.
Answers
D.
Set the number of minutes to unlock to 15 minutes.
D.
Set the number of minutes to unlock to 15 minutes.
Answers
E.
Set the user's access to expire within a specified timeframe.
E.
Set the user's access to expire within a specified timeframe.
Answers
Suggested answer: A, E

Which statement MOST accurately describes clustering in Snowflake?

A.
The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
A.
The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
Answers
B.
Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
B.
Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
Answers
C.
The clustering key must be included in the COPY command when loading data into Snowflake.
C.
The clustering key must be included in the COPY command when loading data into Snowflake.
Answers
D.
Clustering can be disabled within a Snowflake account.
D.
Clustering can be disabled within a Snowflake account.
Answers
Suggested answer: B

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

A.
USAGE
A.
USAGE
Answers
B.
OPERATE
B.
OPERATE
Answers
C.
MONITOR
C.
MONITOR
Answers
D.
MODIFY
D.
MODIFY
Answers
Suggested answer: B

Explanation:

Reference: https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resumeoperate-warehouse-privilege

How often are the Account and Table master keys automatically rotated by Snowflake?

A.
30 Days
A.
30 Days
Answers
B.
60 Days
B.
60 Days
Answers
C.
90 Days
C.
90 Days
Answers
D.
365 Days.
D.
365 Days.
Answers
Suggested answer: D

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement?

(Choose two.)

A.
The clone always stays in sync with the original table.
A.
The clone always stays in sync with the original table.
Answers
B.
The clone has better query performance.
B.
The clone has better query performance.
Answers
C.
The clone is created almost instantly.
C.
The clone is created almost instantly.
Answers
D.
The clone will have time travel history from the original table.
D.
The clone will have time travel history from the original table.
Answers
E.
The clone saves space by not duplicating storage.
E.
The clone saves space by not duplicating storage.
Answers
Suggested answer: C, E

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A.
Bytes sent over network
A.
Bytes sent over network
Answers
B.
Percentage scanned from cache
B.
Percentage scanned from cache
Answers
C.
Partitions total
C.
Partitions total
Answers
D.
Bytes spilled to local storage
D.
Bytes spilled to local storage
Answers
E.
Partitions scanned
E.
Partitions scanned
Answers
Suggested answer: B, E

Which TABLE function helps to convert semi-structured data to a relational representation?

A.
CHECK_JSON
A.
CHECK_JSON
Answers
B.
TO_JSON
B.
TO_JSON
Answers
C.
FLATTEN
C.
FLATTEN
Answers
D.
PARSE_JSON
D.
PARSE_JSON
Answers
Suggested answer: D

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

A.
Pre-signed URL
A.
Pre-signed URL
Answers
B.
Scoped URL
B.
Scoped URL
Answers
C.
Signed URL
C.
Signed URL
Answers
D.
File URL
D.
File URL
Answers
Suggested answer: C

What is the recommended compressed file size range for continuous data loads using Snowpipe?

A.
8-16 MB
A.
8-16 MB
Answers
B.
16-24 MB
B.
16-24 MB
Answers
C.
10-99 MB
C.
10-99 MB
Answers
D.
100-250 MB
D.
100-250 MB
Answers
Suggested answer: B
Total 330 questions
Go to page: of 33