Pass Guaranteed Quiz 2023 Realistic Verified Free COF-R02 Exam Dumps
Free SnowPro Core COF-R02 Ultimate Study Guide (Updated 332 Questions)
The SnowPro Core Recertification Exam is aimed at professionals who have already achieved the SnowPro Core certification and are looking to recertify. The exam is intended to test their knowledge of Snowflake’s latest features, tools, and techniques. The certification ensures that professionals retain their expertise and stay current in the rapidly evolving field of data warehousing.
The Snowflake COF-R02: SnowPro Core Recertification Exam is an online, proctored exam that can be taken from anywhere in the world. The exam consists of multiple-choice questions, and candidates have two hours to complete it. The exam is scored on a scale of 100 to 1000, and candidates must score at least 700 to pass.
NEW QUESTION # 199
What data is stored in the Snowflake storage layer? (Select TWO).
- A. Standard and secure view results
- B. Query history
- C. Snowflake parameters
- D. Micro-partitions
- E. Persisted query results
Answer: D,E
NEW QUESTION # 200
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Remove all dates and timestamps.
- B. Remove semi-structured data types
- C. Avoid using embedded characters such as commas for numeric data types
- D. Load files that are approximately 25 MB or smaller.
- E. Load files that are approximately 100-250 MB (or larger)
Answer: C,E
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
NEW QUESTION # 201
The fail-safe retention period is how many days?
- A. 45 days
- B. 7 days
- C. 1 day
- D. 90 days
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
NEW QUESTION # 202
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
- A. object_construct()
- B. json_extract_path_text()
- C. parse_json()
- D. flatten
Answer: B
NEW QUESTION # 203
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
- A. Tri-Secret Secure
- B. External stages
- C. Data encryption
- D. Fail-safe
- E. Time Travel
Answer: D,E
NEW QUESTION # 204
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
- A. Internal stage
- B. View
- C. Schema
- D. Role
- E. Table
- F. User
Answer: C,E
NEW QUESTION # 205
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SYSADMIN
- B. ACCOUNTADMIN
- C. PUBLIC
- D. SECURITYADMIN
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/security-access-control-overview.html
"Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"
NEW QUESTION # 206
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
- A. Compute resources
- B. Authentication
- C. Data storage
- D. Metadata
- E. Query execution
Answer: B,D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
* Authentication
* Infrastructure management
* Metadata management
* Query parsing and optimization
* Access control
NEW QUESTION # 207
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
- A. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
- B. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- C. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
Answer: D
NEW QUESTION # 208
What internal stages are available in Snowflake? (Choose three.)
- A. User stage
- B. Stream stage
- C. Table stage
- D. Database stage
- E. Schema stage
- F. Named stage
Answer: C,E,F
NEW QUESTION # 209
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
- A. The columns that are queried in the select clause.
- B. The columns with very high cardinality.
- C. The columns with many different values.
- D. The columns most actively used in the select filters.
Answer: D
NEW QUESTION # 210
True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html
NEW QUESTION # 211
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
- A. Percentage scanned from cache
- B. Bytes sent over network
- C. Partitions scanned
- D. Bytes spilled to local storage
- E. Partitions total
Answer: A,C
NEW QUESTION # 212
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
- A. The reader account compute will be billed to the provider account.
- B. The reader account will automatically use the Standard edition of Snowflake.
- C. The reader account can create a copy of the shared data using CREATE TABLE AS...
- D. The reader account can clone data the provider has shared, but cannot re-share it.
Answer: D
NEW QUESTION # 213
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
- A. BYTE_SIZE
- B. INDEX
- C. CONTENT
- D. PATH
- E. DATATYPE
Answer: A,D
NEW QUESTION # 214
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A. An FTP server with TLS encryption
- B. A Google Cloud storage bucket
- C. An HTTPS server with WebDAV
- D. A Windows server file share on Azure
Answer: B
NEW QUESTION # 215
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
- A. False
- B. True
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html
NEW QUESTION # 216
Which type of table corresponds to a single Snowflake session?
- A. Temporary
- B. Provisional
- C. Permanent
- D. Translent
Answer: A
Explanation:
Explanation
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creatin
NEW QUESTION # 217
True or False: During data unloading, only JSON and CSV files can be compressed.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html
NEW QUESTION # 218
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
- A. Is only available to customers with Business Critical Edition
- B. Restricts or enables access to specific IP addresses
- C. Is available to all Snowflake Editions
- D. Is activated using an "ALTER DATABASE" command
Answer: B,C
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html
NEW QUESTION # 219
Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)
- A. grant SELECT on future tables in database DB1 to role MYROLE;
- B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
- C. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
- D. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
- E. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
- F. grant SELECT on all tables in database DB1 to role MYROLE;
Answer: D,E
NEW QUESTION # 220
What privilege should a user be granted to change permissions for new objects in a managed access schema?
- A. Grant the OWNERSHIP privilege on the database.
- B. Grant the MANAGE GRANTS global privilege.
- C. Grant ALL privileges on the schema.
- D. Grant the OWNERSHIP privilege on the schema.
Answer: B
NEW QUESTION # 221
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
- A. 1 year
- B. 14 days
- C. 24 hours
- D. 30 days
- E. 60 minutes
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html
NEW QUESTION # 222
......
Get to the Top with COF-R02 Practice Exam Questions: https://www.real4prep.com/COF-R02-exam.html