Snowflake COF-R02 Test Engine Practice Test Questions, Exam Dumps
100% Free COF-R02 Daily Practice Exam With 332 Questions
NEW QUESTION 95
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
- A. Consumer
- B. Vendor
- C. Personalized
- D. Reader
- E. Standard
Answer: C,E
NEW QUESTION 96
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
- A. Python
D18912E1457D5D1DDCBD40AB3BF70D5D - B. JDBC
- C. ODBC
- D. Snowflake Web Interface (UI)
- E. SnowSQL
Answer: A,B,C,D,E
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
NEW QUESTION 97
What internal stages are available in Snowflake? (Choose three.)
- A. User stage
- B. Database stage
- C. Stream stage
- D. Named stage
- E. Schema stage
- F. Table stage
Answer: D,E,F
NEW QUESTION 98
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
- A. Stopping the virtual warehouse that the query is running against
- B. Clustering of the data used by the query
- C. Removing a column from the query SELECT list
- D. Executing the RESULTS_SCAN() table function
- E. Changing a column that is not in the cached query
Answer: C,D
NEW QUESTION 99
Which data type can store more than one type of data structure?
- A. VARIANT
- B. JSON
- C. VARCHAR
- D. BINARY
Answer: A
NEW QUESTION 100
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Explanation
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION 101
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
- A. Create a zero-copy clone of the worksheet and grant permissions to teammates
- B. Share the worksheet with teammates within Snowsight
- C. Create a database and grant all permissions to teammates
- D. Create a private Data Exchange so that any teammate can use the worksheet
Answer: B
NEW QUESTION 102
What Snowflake role must be granted for a user to create and manage accounts?
- A. SYSADMIN
- B. ORGADMIN
- C. ACCOUNTADMIN
- D. SECURITYADMIN
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
NEW QUESTION 103
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
- A. The virtual warehouse that is defined at the session level will be used to read all data.
- B. The default virtual warehouse will be used to read all data.
- C. No virtual warehouse will be used, data will be read from the local disk cache.
- D. No virtual warehouse will be used, data will be read from the result cache.
Answer: D
NEW QUESTION 104
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
- A. PUT
- B. GET
- C. SELECT
- D. COPY
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html
NEW QUESTION 105
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
- A. Infrastructure security
- B. Management of metadata
- C. Computing the data
- D. Parsing and optimizing queries
- E. Maintaining Availability Zones
Answer: B,D
NEW QUESTION 106
By default, which Snowflake role is required to create a share?
- A. ORGADMIN
- B. ACCOUNTADMIN
- C. SECURITYADMIN
- D. SHAREADMIN
Answer: D
NEW QUESTION 107
What is the purpose of an External Function?
- A. To ingest data from on-premises data sources
- B. To run a function in another Snowflake database
- C. To call code that executes outside of Snowflake
- D. To share data in Snowflake with external parties
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/external-functions.html
NEW QUESTION 108
Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)
- A. A directory table is a separate database object.
- B. A directory table will be automatically added to a stage.
- C. Directory table data can not be refreshed manually.
- D. Directory tables do not have their own grantable privileges.
- E. Directory tables store data file metadata.
Answer: D,E
NEW QUESTION 109
What happens to historical data when the retention period for an object ends?
- A. The data is cloned into a historical object.
- B. The object containing the historical data is dropped.
- C. Time Travel on the historical data is dropped.
- D. The data moves to Fail-safe
Answer: B
NEW QUESTION 110
User-level network policies can be created by which of the following roles? (Select TWO).
- A. ROLEADMIN
- B. USERADMIN
- C. SYSADMIN
- D. ACCOUNTADMIN
- E. SECURITYADMIN
Answer: B,E
Explanation:
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/network-policies.html#:~:text=A%20security%20administrator%20(or
NEW QUESTION 111
How many resource monitors can be assigned at the account level?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 112
......
Use Valid New COF-R02 Test Notes & COF-R02 Valid Exam Guide: https://www.surepassexams.com/COF-R02-exam-bootcamp.html