Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1141:

  What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement? Select one.

  A. INITTIALLY_SUSPENDED = TRUE/FALSE

  B. START_AFTCR_CREATE = TRUE/FALSE

  C. START_TTIME = 60 // (seconds from now)

  D. START.TIME = CURRENT.DATE()

  Correct Answer: A

• Question 1142:

  Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.

  A. More micro-partitions

  B. Better query scheduling

  C. Double the numbers of servers In the compute duster

  D. Higher storage costs

  Correct Answer: C

• Question 1143:

  True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/credits.html

• Question 1144:

  Which of the following commands are not blocking operations? Choose 2 answers

  A. UPDATE

  B. INSERT

  C. MERGE

  D. COPY

  Correct Answer: BD

• Question 1145:

  Which item in the Data Warehouse migration process does not apply in Snowflake? (Select two)

  A. Migrate Users

  B. Migrate Schemas

  C. Migrate Indexes

  D. Build the Data pipeline

  Correct Answer: CD

• Question 1146:

  Which are true of Snowflake roles?

  A. All grants to objects are given to roles, and never to users

  B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation

  C. The public role controls at other roles

  D. Roles are a subset of users and users own objects In Snowflake

  Correct Answer: AB

• Question 1147:

  Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

  A. Their default role should be set to SYSTEMADMIN (the lower of the two)

  B. They should not set up multi_Factor Authentication (MFA)--as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

  C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

  D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

  E. They should use the SYSADMIN role to perform administrative work on database objects

  Correct Answer: ACE

• Question 1148:

  The FLATEEN function is used to query which type of data in Snowflake?

  A. Structured data

  B. Semi-structured data

  C. Both of the above

  D. None of the above

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html

  FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.

• Question 1149:

  True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

• Question 1150:

  What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

  A. On-premise availability

  B. Simplicity

  C. Open source based

  D. Concurrency

  E. Performance

  Correct Answer: BDE