COF-R02 Exam Training Practice Tests (Snowflake SnowPro Core Recertification)]

Question 1

Which TABLE function helps to convert semi-structured data to a relational representation?

A. FLATTEN B. CHECK_JSON C. PARSE_JSON D. TO_JSON

Correct Answer: C

Question 2

Which Snowflake architectural layer is responsible for a query execution plan?

A. Cloud provider B. Compute C. Cloud services D. Data storage

Correct Answer: A

Question 3

Which of the following objects can be shared through secure data sharing?

A. External table B. Stored procedure C. Task D. Masking policy

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A. Power Bl B. Adobe C. Data Robot D. Informatica

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

Which of the following are characteristics of security in Snowflake?

A. Account and user authentication is only available with the Snowflake Business Critical edition. B. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher C. Support for HIPAA and GDPR compliance is available for UI Snowflake editions. D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Correct Answer: B

Question 6

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

A. Roles B. Secure User-Defined Functions (UDFs) C. Stored Procedures D. Secure Views E. Tables F. Schemas

Correct Answer: A,B,F

Question 7

Which of the following are benefits of micro-partitioning? (Select TWO)

A. Micro-partitions cannot overlap in their range of values B. Micro-partitions can be defined on a schema-by-schema basis C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses D. Micro-partitions are immutable objects that support the use of Time Travel. E. Rows are automatically stored in sorted order within micro-partitions

Correct Answer: A,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 8

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

A. True B. False

Correct Answer: B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 9

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

A. SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY; B. SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user()) C. SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY; D. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;

Correct Answer: A

Question 10

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;

Correct Answer: D,E

Question 11

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A. The RESULT_SCAN table function can access and filter the contents of the query result cache. B. A user can only access their own queries from the query result cache. C. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer. D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries. E. When the data cache is full, the least-recently used data will be cleared to make room.

Correct Answer: D,E

Question 12

Which of the following objects are contained within a schema? (Choose two.)

A. Role B. User C. External table D. Warehouse E. Stream F. Share

Correct Answer: C,D

Question 13

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

A. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns B. It removes the last element of the outer array. C. It removes the outer array structure and loads the records into separate table rows, D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 14

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A. Custom B. Economy C. Optimized D. Standard

Correct Answer: B,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 15

Which statement describes how Snowflake supports reader accounts?

A. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks. B. A reader account can consume data from the provider account that created it and combine it with its own data. C. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account. D. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

Correct Answer: A

Snowflake SnowPro Core Recertification - COF-R02 Exam Practice Test