ExamGecko
Home Home / Snowflake / COF-R02

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

Question list
Search
Search

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

A.
CSV (Unzipped)
A.
CSV (Unzipped)
Answers
B.
Parquet
B.
Parquet
Answers
C.
CSV (Gzipped)
C.
CSV (Gzipped)
Answers
D.
ORC
D.
ORC
Answers
Suggested answer: A

Which copy INTO command outputs the data into one file?

A.
SINGLE=TRUE
A.
SINGLE=TRUE
Answers
B.
MAX_FILE_NUMBER=1
B.
MAX_FILE_NUMBER=1
Answers
C.
FILE_NUMBER=1
C.
FILE_NUMBER=1
Answers
D.
MULTIPLE=FAISE
D.
MULTIPLE=FAISE
Answers
Suggested answer: A

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

A.
account__usage . query history view
A.
account__usage . query history view
Answers
B.
account__usage.query__history__archive View
B.
account__usage.query__history__archive View
Answers
C.
information__schema . cruery_history view
C.
information__schema . cruery_history view
Answers
D.
information__schema - query history_by_ses s i on view
D.
information__schema - query history_by_ses s i on view
Answers
Suggested answer: A

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

A.
Clustering
A.
Clustering
Answers
B.
Indexing
B.
Indexing
Answers
C.
Fragmenting
C.
Fragmenting
Answers
D.
Using INDEX__HINTS
D.
Using INDEX__HINTS
Answers
Suggested answer: A

Explanation:

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

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

A.
ROLEADMIN
A.
ROLEADMIN
Answers
B.
ACCOUNTADMIN
B.
ACCOUNTADMIN
Answers
C.
SYSADMIN
C.
SYSADMIN
Answers
D.
SECURITYADMIN
D.
SECURITYADMIN
Answers
E.
USERADMIN
E.
USERADMIN
Answers
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.

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

A.
LOAD
A.
LOAD
Answers
B.
copy
B.
copy
Answers
C.
GET
C.
GET
Answers
D.
PUT
D.
PUT
Answers
Suggested answer: D

Explanation:

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

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

A.
When dropping an external stage, the files are not removed and only the stage is dropped
A.
When dropping an external stage, the files are not removed and only the stage is dropped
Answers
B.
When dropping an external stage, both the stage and the files within the stage are removed
B.
When dropping an external stage, both the stage and the files within the stage are removed
Answers
C.
When dropping an internal stage, the files are deleted with the stage and the files are recoverable
C.
When dropping an internal stage, the files are deleted with the stage and the files are recoverable
Answers
D.
When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
D.
When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
Answers
E.
When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
E.
When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
Answers
Suggested answer: A, C

How long is Snowpipe data load history retained?

A.
As configured in the create pipe settings
A.
As configured in the create pipe settings
Answers
B.
Until the pipe is dropped
B.
Until the pipe is dropped
Answers
C.
64 days
C.
64 days
Answers
D.
14 days
D.
14 days
Answers
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.

In which use cases does Snowflake apply egress charges?

A.
Data sharing within a specific region
A.
Data sharing within a specific region
Answers
B.
Query result retrieval
B.
Query result retrieval
Answers
C.
Database replication
C.
Database replication
Answers
D.
Loading data into Snowflake
D.
Loading data into Snowflake
Answers
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.

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

A.
ROLES
A.
ROLES
Answers
B.
POLICY_REFERENCES
B.
POLICY_REFERENCES
Answers
C.
QUERY_HISTORY
C.
QUERY_HISTORY
Answers
D.
RESOURCE_MONIT ORS
D.
RESOURCE_MONIT ORS
Answers
E.
ACCESS_HISTORY
E.
ACCESS_HISTORY
Answers
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.

Total 330 questions
Go to page: of 33