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

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

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.)
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?
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 minimum Snowflake edition allows for a dedicated metadata store?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
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?
Which TABLE function helps to convert semi-structured data to a relational representation?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question 261

Report
Export
Collapse

What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

A.
To validate external table files in table t1 across all sessions
A.
To validate external table files in table t1 across all sessions
Answers
B.
To validate task SQL statements against table t1 in the last 14 days
B.
To validate task SQL statements against table t1 in the last 14 days
Answers
C.
To validate a file for errors before it gets executed using a COPY command
C.
To validate a file for errors before it gets executed using a COPY command
Answers
D.
To return errors from the last executed COPY command into table t1 in the current session
D.
To return errors from the last executed COPY command into table t1 in the current session
Answers
Suggested answer: D

Question 262

Report
Export
Collapse

Which file formats are supported for unloading data from Snowflake? (Choose two.)

A.
Avro
A.
Avro
Answers
B.
JSON
B.
JSON
Answers
C.
ORC
C.
ORC
Answers
D.
XML
D.
XML
Answers
E.
Delimited (CSV, TSV, etc.)
E.
Delimited (CSV, TSV, etc.)
Answers
Suggested answer: C, E

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-unloadprepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc,is%20comma%20(i.e.%20CSV).&text=File%20format%20options%20specify%20the,the%20format%20of%20the%20data

Question 263

Report
Export
Collapse

The Snowflake Search Optimization Services supports improved performance of which kind of query?

A.
Queries against large tables where frequent DML occurs
A.
Queries against large tables where frequent DML occurs
Answers
B.
Queries against tables larger than 1 TB
B.
Queries against tables larger than 1 TB
Answers
C.
Selective point lookup queries
C.
Selective point lookup queries
Answers
D.
Queries against a subset of columns in a table
D.
Queries against a subset of columns in a table
Answers
Suggested answer: C

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/search-optimizationservice.html#:~:text=The%20search%20optimization%20service%20can%20improve%20the%20performance%20of%20point,OBJECT%2C%20and%20ARRAY%20columns)

Question 264

Report
Export
Collapse

What are common issues found by using the Query Profile? (Choose two.)

A.
Identifying queries that will likely run very slowly before executing them
A.
Identifying queries that will likely run very slowly before executing them
Answers
B.
Locating queries that consume a high amount of credits
B.
Locating queries that consume a high amount of credits
Answers
C.
Identifying logical issues with the queries
C.
Identifying logical issues with the queries
Answers
D.
Identifying inefficient micro-partition pruning
D.
Identifying inefficient micro-partition pruning
Answers
E.
Data spilling to a local or remote disk
E.
Data spilling to a local or remote disk
Answers
Suggested answer: A, D

Question 265

Report
Export
Collapse

What happens to historical data when the retention period for an object ends?

A.
The data is cloned into a historical object.
A.
The data is cloned into a historical object.
Answers
B.
The data moves to Fail-safe
B.
The data moves to Fail-safe
Answers
C.
Time Travel on the historical data is dropped.
C.
Time Travel on the historical data is dropped.
Answers
D.
The object containing the historical data is dropped.
D.
The object containing the historical data is dropped.
Answers
Suggested answer: D

Question 266

Report
Export
Collapse

By default, which Snowflake role is required to create a share?

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

Question 267

Report
Export
Collapse

In a Snowflake role hierarchy, what is the top-level role?

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

Question 268

Report
Export
Collapse

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

A.
PURGE
A.
PURGE
Answers
B.
MODIFY
B.
MODIFY
Answers
C.
REMOVE
C.
REMOVE
Answers
D.
DELETE
D.
DELETE
Answers
Suggested answer: D

Explanation:

Reference: https://www.simplilearn.com/tutorials/sql-tutorial/delete-insql#:~:text=The%20Delete%20command%20in%20SQL,the%20records%20from%20a%20table

Question 269

Report
Export
Collapse

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

A.
Configure the warehouse to a size larger than generally required
A.
Configure the warehouse to a size larger than generally required
Answers
B.
Set the minimum and maximum clusters to autoscale
B.
Set the minimum and maximum clusters to autoscale
Answers
C.
Use the standard warehouse scaling policy
C.
Use the standard warehouse scaling policy
Answers
D.
Use the economy warehouse scaling policy
D.
Use the economy warehouse scaling policy
Answers
Suggested answer: B

Question 270

Report
Export
Collapse

Where is Snowflake metadata stored?

A.
Within the data files
A.
Within the data files
Answers
B.
In the virtual warehouse layer
B.
In the virtual warehouse layer
Answers
C.
In the cloud services layer
C.
In the cloud services layer
Answers
D.
In the remote storage layer
D.
In the remote storage layer
Answers
Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/queryingmetadata.html#:~:text=Snowflake%20automatically%20generates%20metadata%20for,using%20a%20standard%20SELECT%20statement

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