COF-C02 Snowflake Exam Questions and Free Practice Test

Question 139

- (Topic 3)
What are benefits of using Snowpark with Snowflake? (Select TWO).

A. Snowpark uses a Spark engine to generate optimized SQL query plans.

B. Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C. Snowpark does not require that a separate cluster be running outside of Snowflake.

D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Correct Answer:CD
Snowpark is designed to bring the data programmability to Snowflake, enabling developers to write code in familiar languages like Scala, Java, and Python. It allows for the execution of these codes directly within Snowflake??s virtual warehouses, eliminating the need for a separate cluster. Additionally, Snowpark??s compatibility with Spark allows users to leverage their existing Spark code with minimal changes1.

Question 140

- (Topic 1)
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 LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;

B. SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())

C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Correct Answer:D
To generate a report listing all Snowflake logins within the last 90 days, the ACCOUNT_USAGE.LOGIN_HISTORY view should be used. This view provides information about login attempts, including successful and unsuccessful logins, and is suitable for security audits4.

Question 141

- (Topic 2)
Which of the following accurately describes shares?

A. Tables, secure views, and secure UDFs can be shared

B. Shares can be shared

C. Data consumers can clone a new table from a share

D. Access to a share cannot be revoked once granted

Correct Answer:A
Shares in Snowflake are named objects that encapsulate all the information required to share databases, schemas, tables, secure views, and secure UDFs. These objects can be added to a share by granting privileges on them to the share via a database role

Question 142

- (Topic 5)
What type of function returns one value for each Invocation?

A. Aggregate

B. Scalar

C. Table

D. Window

Correct Answer:B
Scalar functions in Snowflake (and SQL in general) are designed to return a single value for each invocation. They operate on a single value and return a single result, making them suitable for a wide range of data transformations and calculations within queries.
References:
✑ Snowflake Documentation: Functions

Question 143

- (Topic 6)
What causes objects in a data share to become unavailable to a consumer account?

A. The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

B. The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.

C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

D. The consumer account acquires the data share through a private data exchange.

Correct Answer:C
Objects in a data share become unavailable to a consumer account if the objects in the data share are deleted or if the permissions on these objects are altered without re- applying the grant permissions systematically. This is because the sharing mechanism in Snowflake relies on explicit grants of permissions on specific objects (like tables, views, or secure views) to the share. If these objects are deleted or if their permissions change without updating the share accordingly, consumers can lose access. TheDATA_RETENTION_TIME_IN_DAYSparameter does not directly affect the availability of shared objects, as it controls how long Snowflake retains historical data for time travel and does not impact data sharing permissions.
Running theGRANT IMPORTED PRIVILEGEScommand in the consumer account is not related to the availability of shared objects; this command is used to grant privileges on imported objects within the consumer's account and is not a routine maintenance command that would need to be run regularly.
Acquiring a data share through a private data exchange does not inherently make objects unavailable; issues would only arise if there were problems with the share configuration or if the shared objects were deleted or had their permissions altered without re-granting access to the share.
Reference: Snowflake Documentation on Managing Access to Shared Data
(https://docs.snowflake.com/en/user-guide/data-sharing-consuming.html#managing-access-to-shared-data)

Question 144

- (Topic 1)
What is the default File Format used in the COPY command if one is not specified?

A. CSV

B. JSON

C. Parquet

D. XML

Correct Answer:A
The default file format for the COPY command in Snowflake, when not specified, is CSV (Comma-Separated Values). This format is widely used for data exchange because it is simple, easy to read, and supported by many data analysis tools.

START COF-C02 EXAM