COF-C02 practice questions 1,041–1,050

1. Question 1041 · 1323 in bank

   Select 2

   What are characteristics of directory tables when used with unstructured data? (Choose two.)

   • AOnly cloud storage stages support directory tables.
   • BEach directory table has grantable privileges of its own.
   • CDirectory tables store a catalog of staged files in cloud storage.
   • DA directory table can be added explicitly to a stage when the stage is created.
   • EA directory table is a separate database object that can be layered explicitly on a stage.

   Show answer

   Answer: CD

   Explanation

   CD is correct! Directory table: 1- its implicit not separate database object 2 - like external table stores file-level metadata about the data files in the stage 3 - has NO grantable privileges of its own https://docs.snowflake.com/en/user-guide/data-load-dirtables#what-is-a-directory-table

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

2. Question 1042 · 1323 in bank

   Snowflake best practice recommends that which role be used to enforce a network policy on a Snowflake account?

   • AACCOUNTADMIN
   • BSECURITYADMIN
   • CSYSADMIN
   • DUSERADMIN

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

3. Question 1043 · 1323 in bank

   What is the default behavior of internal stages in Snowflake?

   • ANamed internal stages are created by default.
   • BUsers must manually create their own internal stages.
   • CData files are automatically staged to a default location.
   • DEach user and table are automatically allocated an internal stage.

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

4. Question 1044 · 1323 in bank

   The MAXIMUM size for a serverless task run is equivalent to what size virtual warehouse?

   • AMedium
   • BLarge
   • C2X-Large
   • D4X-Large

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

5. Question 1045 · 1323 in bank

   What storage cost is completely eliminated when a Snowflake table is defined as transient?

   • AActive
   • BFail-safe
   • CStaged
   • DTime Travel

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

6. Question 1046 · 1323 in bank

   How can a Snowflake user traverse semi-structured data?

   • AInsert a colon (:) between the VARIANT column name and any first-level element.
   • BInsert a colon (:) between the VARIANT column name and any second-level element.
   • CInsert a double colon (::) between the VARIANT column name and any first-level element.
   • DInsert a double colon (::) between the VARIANT column name and any second-level element.

   Show answer

   Answer: A

   Next question

7. Question 1047 · 1323 in bank

   Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

   • AACCOUNTADMIN
   • BSECURITYADMIN
   • CSYSADMIN
   • DUSERADMIN

   Show answer

   Answer: C

   Explanation

   https://docs.snowflake.com/en/user-guide/security-access-control-overview#custom-roles When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN.

   Source: Adapted from community discussion — bor4un

   References

   • Snowflake documentation

   Next question

8. Question 1048 · 1323 in bank

   What happens to the privileges granted to Snowflake system-defined roles?

   • AThe privileges cannot be revoked.
   • BThe privileges can be revoked by an ACCOUNTADMIN.
   • CThe privileges can be revoked by an ORGADMIN.
   • DThe privileges can be revoked by any user-defined role with appropriate privileges.

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

9. Question 1049 · 1323 in bank

   What privileges are required to create a task?

   • AThe GLOBAL privilege CREATE TASK is required to create a new task.
   • BTasks are created at the Application level and can only be created by the Account Admin role.
   • CMany Snowflake DDLs are metadata operations only, and CREATE TASK DDL can be executed without virtual warehouse requirement or task specific grants.
   • DThe role must have access to the target schema and the CREATE TASK privilege on the schema itself.

   Show answer

   Answer: D

   Explanation

   D. The role must have access to the target schema and the CREATE TASK privilege on the schema itself: The role executing the CREATE TASK statement must have access privileges on the schema where the task will be created. This includes having the necessary privileges to create objects within the schema. Typically, the role needs the CREATE TASK privilege granted on the specific schema.

   Source: Adapted from community discussion — shubtred

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

10. Question 1050 · 1323 in bank

    By default, which role allows a user to manage a Snowflake Data Exchange share?

    • AACCOUNTADMIN
    • BSECURITYADMIN
    • CSYSADMIN
    • DUSERADMIN

    Show answer

    Answer: A

    References

    • Snowflake documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

COF-C02 practice, question 1041. 1323 questions available.