Latest Snowflake COF-R02 Practice Test Questions, SnowPro Core Recertification Exam Exam Dumps
Aug-2023 Pass Snowflake COF-R02 Exam in First Attempt Easily
NEW QUESTION # 168
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
- A. Procedures
- B. Streams
- C. Tasks
- D. Pipes
Answer: B
Explanation:
Explanation
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%
NEW QUESTION # 169
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
- A. Duo Mobile
- B. Microsoft Authenticator
- C. Google Authenticator
- D. Okta Verify
Answer: A
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/security-mfa.html
NEW QUESTION # 170
Which Snowflake architectural layer is responsible for a query execution plan?
- A. Cloud provider
- B. Cloud services
- C. Data storage
- D. Compute
Answer: A
NEW QUESTION # 171
How can a row access policy be applied to a table or a view? (Choose two.)
- A. By future APPLY for all objects in a schema
- B. Within the create table or create view DDL
- C. Within a control table
- D. Using the command ALTER <object> ADD ROW ACCESS POLICY <policy>;
- E. Within the policy DDL
Answer: B,C
NEW QUESTION # 172
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
- A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
- B. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
- C. The transient table version cannot be retrieved after 24 hours.
- D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
Answer: C
NEW QUESTION # 173
What is the minimum Snowflake edition required to use Dynamic Data Masking?
- A. Standard
- B. Business Critical
- C. Virtual Private Snowflake (VPC)
- D. Enterprise
Answer: C
NEW QUESTION # 174
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
- A. Data is not available for copying or moving to an individual Snowflake account.
- B. Data is live, ready-to-query, and can be personalized.
- C. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
- D. Data needs to be loaded into a cloud provider as a consumer account.
- E. Data is available without copying or moving.
Answer: B,E
NEW QUESTION # 175
The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers
- A. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- B. The tool that s executing the query
- C. The complexity of each query
- D. The size of the data required for each query
Answer: C,D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 176
Which Snowflake layer is always leveraged when accessing a query from the result cache?
- A. Metadata
- B. Data Storage
- C. Cloud Services
- D. Compute
Answer: C
NEW QUESTION # 177
When can a Virtual Warehouse start running queries?
- A. After replication
- B. Only during administrator defined time slots
- C. When its provisioning is complete
- D. 12am-5am
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 178
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
- A. SELECT ORDER_AMT * ORDER_QTY FROM SALES;
- B. SELECT AVG(ORDER_QTY) FROM SALES;
- C. SELECT SUM (ORDER_AMT) FROM SALES;
- D. SELECT MIN(ORDER_AMT) FROM SALES;
Answer: B
NEW QUESTION # 179
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
- A. Time Travel data
- B. Security
- C. Authentication and access control
- D. Query execution
- E. Data loading
Answer: B,E
NEW QUESTION # 180
The fail-safe retention period is how many days?
- A. 7 days
- B. 90 days
- C. 45 days
- D. 1 day
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
NEW QUESTION # 181
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
NEW QUESTION # 182
Which of the following describes how clustering keys work in Snowflake?
- A. Clustering keys sort the designated columns over time, without blocking DML operations
- B. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
- C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
- D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
Answer: A
NEW QUESTION # 183
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
- A. In the metadata of the target table for 14 days
- B. In the metadata of the target table for 64 days
- C. In the metadata of the pipe for 64 days
- D. In the metadata of the pipe for 14 days
Answer: A
NEW QUESTION # 184
Which data type can store more than one type of data structure?
- A. BINARY
- B. VARCHAR
- C. JSON
- D. VARIANT
Answer: D
NEW QUESTION # 185
Select the different types of Internal Stages: (Choose three.)
- A. Schema Stage
- B. User Stage
- C. Table Stage
- D. Named Stage
Answer: B,C,D
Explanation:
Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal- Named-Stage
NEW QUESTION # 186
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A. Stream
- B. Pipe
- C. Task
- D. External stage
Answer: B
Explanation:
Explanation
Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 187
Which data type can be used to store geospatial data in Snowflake?
- A. Object
- B. Geometry
- C. Geography
- D. Variant
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geos
NEW QUESTION # 188
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.
- A. Double the numbers of servers In the compute duster
- B. More micro-partitions
- C. Higher storage costs
- D. Better query scheduling
Answer: A
NEW QUESTION # 189
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
- A. Microsoft Azure Cloud
- B. Google Cloud Platform
- C. Amazon Web Services
- D. Oracle Cloud
- E. Docker
- F. IBM Cloud
Answer: A,B,E
NEW QUESTION # 190
......
Free COF-R02 Exam Files Downloaded Instantly 100% Dumps & Practice Exam: https://testking.exams-boost.com/COF-R02-valid-materials.html