Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 21:

  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
  D. Business Critical

  ---

  Explanation/Reference:

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

• Question 22:

  What privileges are required to create a task?

  A. The global privilege create task is required to create a new task.
  B. Tasks are created at the Application level and can only be created by the Account Admin role.
  C. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
  D. The role must have access to the target schema and the create task privilege on the schema itself.
  D. The role must have access to the target schema and the create task privilege on the schema itself.

  ---

  Explanation/Reference:

  All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema. https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

• Question 23:

  User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

  Which command will show all privileges granted to that schema?

  A. SHOW GRANTS ON ROLE DATA_SCIENCE
  B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
  C. SHOW GRANTS TO USER INQUISITIVE_PERSON
  D. SHOW GRANTS OF ROLE DATA_SCIENCE
  B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

• Question 24:

  True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.

• Question 25:

  What is the recommended compressed file size range for continuous data loads using Snowpipe?

  A. 8-16 MB
  B. 16-24 MB
  C. 10-99 MB
  D. 100-250 MB
  B. 16-24 MB

• Question 26:

  How often are the Account and Table master keys automatically rotated by Snowflake?

  A. 30 Days
  B. 60 Days
  C. 90 Days
  D. 365 Days.
  D. 365 Days.

• Question 27:

  Which Snowflake partner specializes in data catalog solutions?

  A. Alation
  B. DataRobot
  C. dbt
  D. Tableau
  A. Alation

  ---

  Explanation/Reference:

  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 28:

  True or False: You can query the files in an External Stage directly without having to load the data into a table.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html

  External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

• Question 29:

  What are the three layers that make up Snowflake's architecture? Choose 3 answer

  A. Compute
  B. Tri-Secret Secure
  C. Storage
  D. Cloud Services
  A. Compute
  C. Storage
  D. Cloud Services

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

• Question 30:

  Which command can be used to load data files into a Snowflake stage?

  A. JOIN
  B. COPY INTO
  C. PUT
  D. GET
  C. PUT