COF-R02 Actual Questions - Instant Download Tests Free Updated Today!
Get instant access of 100% real Snowflake COF-R02 exam questions with verified answers
The Snowflake COF-R02 exam covers a wide range of topics, including Snowflake architecture, data loading and unloading, data modeling, SQL queries, security, and performance optimization. This exam can be taken online, and candidates have 90 minutes to complete 60 multiple-choice questions. A passing score of 80% is required to obtain the certification. The certification is valid for two years, after which the candidate will need to recertify to maintain their SnowPro Core certification status.
NEW QUESTION # 126
How would a user execute a series of SQL statements using a task?
- A. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
- B. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
- C. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
- D. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
Answer: C
NEW QUESTION # 127
What are supported file formats for unloading data from Snowflake? (Choose three.)
- A. AVRO
- B. JSON
- C. Parquet
- D. ORC
- E. XML
- F. CSV
Answer: B,C,F
NEW QUESTION # 128
True or False: A single database can exist in more than one Snowflake account.
- A. False
- B. True
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html
NEW QUESTION # 129
True or False: An active warehouse is required to run a COPY INTO statement.
- A. False
- B. True
Answer: B
NEW QUESTION # 130
Which of the following statements is true of Snowflake?
- A. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
- B. It's based on an Oracle Architecture
- C. It was built specifically for the cloud
- D. It was built for Hadoop architecture
- E. It was built as an on-premises solution and then ported to the cloud
Answer: C
Explanation:
Reference: https://www.stitchdata.com/resources/snowflake/
NEW QUESTION # 131
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
- A. Time Travel
- B. Internal stages
- C. Incremental backups
- D. Zero-copy clones
- E. Fail-safe
Answer: A,E
Explanation:
Explanation
Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.
Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):
* Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.
* Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.
https://docs.snowflake.com/en/user-guide/data-availability.html
NEW QUESTION # 132
Which data type can store more than one type of data structure?
- A. JSON
- B. VARIANT
- C. VARCHAR
- D. BINARY
Answer: B
NEW QUESTION # 133
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
- A. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
- B. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
- C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
- D. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
- E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
- F. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
Answer: B,D,E
NEW QUESTION # 134
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
- A. When the system has enough load for 8 minutes
- B. When the system has enough load for 10 minutes
- C. When the system has enough load for 2 minutes
- D. When the system has enough load for 6 minutes
Answer: B
NEW QUESTION # 135
True or False: Data Providers can share data with only the Data Consumer.
- A. False
- B. True
Answer: A
NEW QUESTION # 136
What is the maximum Time Travel retention period for a temporary Snowflake table?
- A. 90 days
- B. 1 day
- C. 45 days
- D. 7 days
Answer: B
NEW QUESTION # 137
Which of the following are options when creating a Virtual Warehouse?
- A. Auto-suspend
- B. User count
- C. Local SSD size
- D. Auto-resume
Answer: A,D
NEW QUESTION # 138
Which of the following objects can be shared through secure data sharing?
- A. External table
- B. Masking policy
- C. Stored procedure
- D. Task
Answer: A
Explanation:
Explanation
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
* Tables
* External tables
* Secure views
* Secure materialized views
* Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and
"imported" by data consumers.
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enabl
NEW QUESTION # 139
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A. Time Travel - 0 days. Fail-safe - 1 day
- B. Transient tables are retained in neither Fail-safe nor Time Travel
- C. Time Travel - 1 day. Fail-safe - 0 days
- D. Time Travel - 1 day. Fail-safe - 1 day
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient
NEW QUESTION # 140
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
- A. False
- B. True
Answer: B
NEW QUESTION # 141
Users are responsible for data storage costs until what occurs?
- A. Data is deleted from a table
- B. Data expires from Time Travel
- C. Data is truncated from a table
- D. Data expires from Fail-safe
Answer: D
NEW QUESTION # 142
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
- A. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
- B. A multi-cluster Warehouse can add clusters automatically based on query activity
- C. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
- D. A multi-cluster Warehouse can scale down when query activity slows
Answer: A,B,C,D
NEW QUESTION # 143
Which of the following objects are contained within a schema? (Choose two.)
- A. External table
- B. Share
- C. Stream
- D. User
- E. Role
- F. Warehouse
Answer: A,F
NEW QUESTION # 144
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
- A. To validate a file for errors before it gets executed using a COPY command
- B. To validate external table files in table t1 across all sessions
- C. To validate task SQL statements against table t1 in the last 14 days
- D. To return errors from the last executed COPY command into table t1 in the current session
Answer: D
NEW QUESTION # 145
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
- A. 24 hours
- B. 48 hours
- C. 30 days
- D. 7 days
Answer: A
NEW QUESTION # 146
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
- A. Table
- B. Internal stage
- C. View
- D. User
- E. Schema
- F. Role
Answer: A,E
NEW QUESTION # 147
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
- A. Streams
- B. Procedures
- C. Tasks
- D. Pipes
Answer: A
Explanation:
Explanation
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%
NEW QUESTION # 148
True or False: Snowflake charges a premium for storing semi-structured data.
- A. False
- B. True
Answer: A
Explanation:
Reference:
https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges- premium-for-storing-semi-structured-data
NEW QUESTION # 149
......
Download Latest & Valid Questions For Snowflake COF-R02 exam: https://exampasspdf.testkingit.com/Snowflake/latest-COF-R02-exam-dumps.html