ExamGecko
Home / Snowflake / COF-R02 / List of questions
Ask Question

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

Question list
Search

Question 121

Report
Export
Collapse

What is the MOST performant file format for loading data in Snowflake?

CSV (Unzipped)
CSV (Unzipped)
Parquet
Parquet
CSV (Gzipped)
CSV (Gzipped)
ORC
ORC
Suggested answer: A
asked 23/09/2024
Rannie Dayapan
42 questions

Question 122

Report
Export
Collapse

Which copy INTO command outputs the data into one file?

SINGLE=TRUE
SINGLE=TRUE
MAX_FILE_NUMBER=1
MAX_FILE_NUMBER=1
FILE_NUMBER=1
FILE_NUMBER=1
MULTIPLE=FAISE
MULTIPLE=FAISE
Suggested answer: A
asked 23/09/2024
MIGUEL GAITERO GIL
40 questions

Question 123

Report
Export
Collapse

Where would a Snowflake user find information about query activity from 90 days ago?

account__usage . query history view
account__usage . query history view
account__usage.query__history__archive View
account__usage.query__history__archive View
information__schema . cruery_history view
information__schema . cruery_history view
information__schema - query history_by_ses s i on view
information__schema - query history_by_ses s i on view
Suggested answer: A
asked 23/09/2024
Kameron Katoku
47 questions

Question 124

Report
Export
Collapse

Which Snowflake technique can be used to improve the performance of a query?

Clustering
Clustering
Indexing
Indexing
Fragmenting
Fragmenting
Using INDEX__HINTS
Using INDEX__HINTS
Suggested answer: A

Explanation:

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

asked 23/09/2024
Andrew Carver
38 questions

Question 125

Report
Export
Collapse

User-level network policies can be created by which of the following roles? (Select TWO).

ROLEADMIN
ROLEADMIN
ACCOUNTADMIN
ACCOUNTADMIN
SYSADMIN
SYSADMIN
SECURITYADMIN
SECURITYADMIN
USERADMIN
USERADMIN
Suggested answer: D, E

Explanation:

By default, Snowflake allows users to connect to the service from any computer or device IP address.

A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e.

IPv4) addresses.

An administrator with sufficient permissions can create any number of network policies.

https://docs.snowflake.com/en/user-guide/networkpolicies.html#:~:text=A%20security%20administrator%20(or%20higher,any%20number%20of%20network%20policies.

asked 23/09/2024
Antonio Pombo
36 questions

Question 126

Report
Export
Collapse

Which command can be used to load data into an internal stage?

LOAD
LOAD
copy
copy
GET
GET
PUT
PUT
Suggested answer: D

Explanation:

https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internalstages-7121cc3cc9

asked 23/09/2024
Karoy Bandi
33 questions

Question 127

Report
Export
Collapse

What happens when an external or an internal stage is dropped? (Select TWO).

When dropping an external stage, the files are not removed and only the stage is dropped
When dropping an external stage, the files are not removed and only the stage is dropped
When dropping an external stage, both the stage and the files within the stage are removed
When dropping an external stage, both the stage and the files within the stage are removed
When dropping an internal stage, the files are deleted with the stage and the files are recoverable
When dropping an internal stage, the files are deleted with the stage and the files are recoverable
When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
Suggested answer: A, C
asked 23/09/2024
Mourad Tannous
24 questions

Question 128

Report
Export
Collapse

How long is Snowpipe data load history retained?

As configured in the create pipe settings
As configured in the create pipe settings
Until the pipe is dropped
Until the pipe is dropped
64 days
64 days
14 days
14 days
Suggested answer: C

Explanation:

Bulk data load

Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output.

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%20data%20load&text=Stored%20in%20the%20metadata%20of,statement%20as%20the%20statement%20output.&text=Stored%20in%20the%20metadata%20of%20the%20pipe%20for%2014%20days.

asked 23/09/2024
jonathan siu
41 questions

Question 129

Report
Export
Collapse

In which use cases does Snowflake apply egress charges?

Data sharing within a specific region
Data sharing within a specific region
Query result retrieval
Query result retrieval
Database replication
Database replication
Loading data into Snowflake
Loading data into Snowflake
Suggested answer: A

Explanation:

Cloud providers apply data egress charges in either of the following use cases:

Data is transferred from one region to another within the same cloud platform.

Data is transferred out of the cloud platform.

https://docs.snowflake.com/en/user-guide/billing-datatransfer.html#:~:text=Cloud%20providers%20apply%20data%20egress,out%20of%20the%20cloud%20platform.

asked 23/09/2024
Rafal Piasecki
40 questions

Question 130

Report
Export
Collapse

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

ROLES
ROLES
POLICY_REFERENCES
POLICY_REFERENCES
QUERY_HISTORY
QUERY_HISTORY
RESOURCE_MONIT ORS
RESOURCE_MONIT ORS
ACCESS_HISTORY
ACCESS_HISTORY
Suggested answer: B, C

Explanation:

https://docs.snowflake.com/en/user-guide/security-column-ddmintro.html#:~:text=DESCRIBE%20MASKING%20POLICY-,Auditing%20Dynamic%20Data%20Masking,a%20masking%20policy%20is%20set.

asked 23/09/2024
Rama Krishna
38 questions
Total 330 questions
Go to page: of 33