Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 191:

  Which Snowflake partner specializes in data catalog solutions?

  A. Alation

  B. DataRobot

  C. dbt

  D. Tableau

  Correct Answer: A

  Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, and Govern Data Across an Enterprise. https://docs.snowflake.com/en/user-guide/ecosystem-all.html

• Question 192:

  Which of the following describes how clustering keys work in Snowflake?

  A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

  B. Clustering keys sort the designated columns over time, without blocking DML operations

  C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

  D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

  Correct Answer: B

• Question 193:

  True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

  A. True

  B. False

  Correct Answer: A

  You can experiment the same with snowflake UI.

• Question 194:

  In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

  A. Compute Credits = 50 Credits Cloud Services = 10

  B. Compute Credits = 80 Credits Cloud Services = 5

  C. Compute Credits = 10 Credits Cloud Services = 9

  D. Compute Credits = 120 Credits Cloud Services = 10

  E. Compute Credits = 200 Credits Cloud Services = 26

  Correct Answer: BD

• Question 195:

  How often are encryption keys automatically rotated by Snowflake?

  A. 30 Days

  B. 60 Days

  C. 90 Days

  D. 365 Days

  Correct Answer: A

  All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.

  https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is%20automatically%20destroyed.

• Question 196:

  User-level network policies can be created by which of the following roles? (Select TWO).

  A. ROLEADMIN

  B. ACCOUNTADMIN

  C. SYSADMIN

  D. SECURITYADMIN

  E. USERADMIN

  Correct Answer: DE

  By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e. IPv4) addresses. An administrator with sufficient permissions can create any number of network policies.

  https://docs.snowflake.com/en/user-guide/network-policies.html#:~:text=A%20security%20administrator%20(or%20higher,any%20number%20of%20network%20policies.

• Question 197:

  A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

  COPY INTO my__table FROM @my__stage;

  The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

  If the user runs the same copy into command what will happen?

  A. All data from all of the files on the stage will be appended to the table

  B. Only data about new customers from the new files will be appended to the table

  C. The operation will fail with the error uncertain files in stage.

  D. All data from only the newly-added files will be appended to the table.

  Correct Answer: A

• Question 198:

  Where would a Snowflake user find information about query activity from 90 days ago?

  A. account__usage . query history view

  B. account__usage.query__history__archive View

  C. information__schema . cruery_history view

  D. information__schema-query history_by_ses s i on view

  Correct Answer: A

• Question 199:

  A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

  Which statements will provide this access?

  A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

  B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

  C. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

  D. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

  Correct Answer: B

• Question 200:

  Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

  A. Standard

  B. Premium

  C. Enterprise

  D. Business Critical

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/privatelink-azure.html