Snowflake COF-R02 Practice Test - Questions Answers, Page 13
List of questions
Related questions
Question 121

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

Which copy INTO command outputs the data into one file?
Question 123

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

Which Snowflake technique can be used to improve the performance of a query?
Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
Question 125

User-level network policies can be created by which of the following roles? (Select TWO).
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.
Question 126

Which command can be used to load data into an internal stage?
Explanation:
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internalstages-7121cc3cc9
Question 127

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

How long is Snowpipe data load history retained?
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.
Question 129

In which use cases does Snowflake apply egress charges?
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.
Question 130

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
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.
Question