ExamGecko
Search Search Login
Home Home / Snowflake / COF-R02

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

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
Which minimum Snowflake edition allows for a dedicated metadata store?
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?
Which TABLE function helps to convert semi-structured data to a relational representation?
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
What is a responsibility of Snowflake’s virtual warehouses?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question 201

Report
Export
Collapse

Network policies can be set at which Snowflake levels? (Choose two.)

A.
Role
A.
Role
Answers
B.
Schema
B.
Schema
Answers
C.
User
C.
User
Answers
D.
Database
D.
Database
Answers
E.
Account
E.
Account
Answers
F.
Tables
F.
Tables
Answers
Suggested answer: C, E

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-networkpolicies

Question 202

Report
Export
Collapse

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

A.
Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 days.Fail Safe retention time is 1 day.
A.
Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 days.Fail Safe retention time is 1 day.
Answers
B.
Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 days.Fail Safe retention time is 7 days.
B.
Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 days.Fail Safe retention time is 7 days.
Answers
C.
Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.
C.
Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.
Answers
D.
Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.
D.
Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.
Answers
E.
Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 day.Fail Safe retention time is 90 days.
E.
Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 day.Fail Safe retention time is 90 days.
Answers
F.
Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 days.Fail Safe retention time is 356 days.
F.
Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 days.Fail Safe retention time is 356 days.
Answers
Suggested answer: D

Question 203

Report
Export
Collapse

Which of the following objects are contained within a schema? (Choose two.)

A.
Role
A.
Role
Answers
B.
Stream
B.
Stream
Answers
C.
Warehouse
C.
Warehouse
Answers
D.
External table
D.
External table
Answers
E.
User
E.
User
Answers
F.
Share
F.
Share
Answers
Suggested answer: C, D

Question 204

Report
Export
Collapse

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A.
When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
A.
When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
Answers
B.
When the data cache is full, the least-recently used data will be cleared to make room.
B.
When the data cache is full, the least-recently used data will be cleared to make room.
Answers
C.
A user can only access their own queries from the query result cache.
C.
A user can only access their own queries from the query result cache.
Answers
D.
A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
D.
A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
Answers
E.
The RESULT_SCAN table function can access and filter the contents of the query result cache.
E.
The RESULT_SCAN table function can access and filter the contents of the query result cache.
Answers
Suggested answer: B, D

Question 205

Report
Export
Collapse

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

A.
Compress the file and load the compressed file.
A.
Compress the file and load the compressed file.
Answers
B.
Split the file into multiple files in the recommended size range (100 MB - 250 MB).
B.
Split the file into multiple files in the recommended size range (100 MB - 250 MB).
Answers
C.
Use a larger-sized warehouse.
C.
Use a larger-sized warehouse.
Answers
D.
Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
D.
Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
Answers
Suggested answer: A

Question 206

Report
Export
Collapse

Which of the following describes a Snowflake stored procedure?

A.
They can be created as secure and hide the underlying metadata from the user.
A.
They can be created as secure and hide the underlying metadata from the user.
Answers
B.
They can only access tables from a single database.
B.
They can only access tables from a single database.
Answers
C.
They can contain only a single SQL statement.
C.
They can contain only a single SQL statement.
Answers
D.
They can be created to run with a caller's rights or an owner's rights.
D.
They can be created to run with a caller's rights or an owner's rights.
Answers
Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

Question 207

Report
Export
Collapse

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

A.
CONTENT
A.
CONTENT
Answers
B.
PATH
B.
PATH
Answers
C.
BYTE_SIZE
C.
BYTE_SIZE
Answers
D.
INDEX
D.
INDEX
Answers
E.
DATATYPE
E.
DATATYPE
Answers
Suggested answer: B, C

Question 208

Report
Export
Collapse

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

A.
parse_json()
A.
parse_json()
Answers
B.
json_extract_path_text()
B.
json_extract_path_text()
Answers
C.
object_construct()
C.
object_construct()
Answers
D.
flatten
D.
flatten
Answers
Suggested answer: B

Question 209

Report
Export
Collapse

How are serverless features billed?

A.
Per second multiplied by an automatic sizing for the job
A.
Per second multiplied by an automatic sizing for the job
Answers
B.
Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
B.
Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
Answers
C.
Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
C.
Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
Answers
D.
Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account
D.
Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account
Answers
Suggested answer: D

Question 210

Report
Export
Collapse

Which Snowflake architectural layer is responsible for a query execution plan?

A.
Compute
A.
Compute
Answers
B.
Data storage
B.
Data storage
Answers
C.
Cloud services
C.
Cloud services
Answers
D.
Cloud provider
D.
Cloud provider
Answers
Suggested answer: D
Total 330 questions
Go to page: of 33
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms