Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 271:

  Which function is used to convert rows in a relational table to a single VARIANT column?

  A. ARRAY_AGG

  B. OBJECT_AGG

  C. ARRAY_CONSTRUCT

  D. OBJECT_CONSTRUCT

  Correct Answer: D

• Question 272:

  The following settings are configured:

  

  For how many days will the data be retained at the object level?

  A. 2

  B. 3

  C. 5

  D. 7

  Correct Answer: A

• Question 273:

  What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

  A. The ACCCUKTMKIN role should be set as tie user's default role.

  B. The user should use federated authentication instead of a password

  C. The user should be required to use Multi-Factor Authentication (MFA).

  D. There should be just one user with the ACCOUNTADMIN role in each Snowflake account.

  Correct Answer: C

• Question 274:

  When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileged to the stage or to issue access token?

  A. File URL

  B. Scope URL

  C. Relative URL

  D. Pre-Signed URL

  Correct Answer: D

• Question 275:

  A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

  Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

  A. CREATE TABLE LIKE TABLE_A;

  B. CREATE VIEW Mview_name> as SELECT * FROM TABLE_A;

  C. CREATE TABLE < table name> AS SELECT * FROM TABLE A;

  D. CREATE MTERIALIED VIEW As SELECT * FROM TABLE_A;

  Correct Answer: A

• Question 276:

  A stream can be created on which Snowflake objects to record data manipulation language(DML) changes? (Select TWO).

  A. Database

  B. Standard tables

  C. External tables

  D. Standard views

  E. Schemas

  F. Pipes

  Correct Answer: BC

• Question 277:

  What type of account can be used to share data with a consumer who does have a Snowflake account?

  A. Data provider

  B. Data consumer

  C. Reader

  D. Organization

  Correct Answer: A

• Question 278:

  A user wants to access stored in a stage without authenticating into Snowflake.

  Which type of URL should be used?

  A. File URL

  B. Staged URL

  C. Scoped URL

  D. Pre-signed URL

  Correct Answer: D

• Question 279:

  Which key access control concept does Snowflake descibe as a defined level of access to an object?

  A. Grant

  B. Privilege

  C. Role

  D. Session

  Correct Answer: B

• Question 280:

  Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

  A. GET_STATE_LOCATION

  B. GET_PRESENT_URL

  C. BUILD_SCOPED_FILE_URL

  D. BUILD_STAGE_FILE_URL

  Correct Answer: D