COF-C02 practice questions 1,261–1,270

1. Question 1261 · 1323 in bank

   Select 2

   Who can activate a network policy for users in a Snowflake account? (Choose two.)

   • AACCOUNTADMIN
   • BUSERADMIN
   • CPUBLIC
   • DSYSADMIN
   • EAny role that has the global ATTACH POLICY privilege

   Show answer

   Answer: AE

   Explanation

   AE Only security administrators (i.e. users with the SECURITYADMIN role) or higher or a role with the global ATTACH POLICY privilege can activate a network policy for an account. Once the policy is associated with your account, Snowflake restricts access to your account based on the allowed list and blocked list.

   Source: Adapted from community discussion — Alex_Ovidiu

   Next question

2. Question 1262 · 1323 in bank

   Select 2

   For which use cases is running a virtual warehouse required? (Choose two.)

   • AWhen creating a table
   • BWhen loading data into a table
   • CWhen unloading data from a table
   • DWhen executing a SHOW command
   • EWhen executing a LIST command

   Show answer

   Answer: BC

   Explanation

   Executing SQL SELECT statements that require compute resources (e.g. retrieving rows from tables and views). Performing DML operations, such as: Updating rows in tables (DELETE , INSERT , UPDATE). Loading data into tables (COPY INTO ). Unloading data from tables (COPY INTO ).

   Source: Adapted from community discussion — Jordi204

   References

   • Snowflake documentation

   Next question

3. Question 1263 · 1323 in bank

   What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

   • AUse the automatic sharing feature for seamless access.
   • BDrop the object and then re-add it to the database to trigger sharing.
   • CRecreate the object with a different name in the database before sharing.
   • DUse the GRANT privilege ... TO SHARE command to grant the necessary privileges.

   Show answer

   Answer: D

   Explanation

   To make a new object available to consumers, you must use the GRANT … TO SHARE command to explicitly add the object to the share.

   Source: Adapted from community discussion — Anblicks

   References

   • Snowflake documentation

   Next question

4. Question 1264 · 1323 in bank

   Select 2

   Which drivers or connectors are supported by Snowflake? (Choose two.)

   • APerl Connector
   • BMongoDB Rust Driver
   • CGo Snowflake Driver
   • DCobol Driver
   • ESnowflake Connector for Python

   Show answer

   Answer: CE

   Next question

5. Question 1265 · 1323 in bank

   Which Snowflake privilege is required on a pipe object to pause or resume pipes?

   • AOPERATE
   • BREAD
   • CSELECT
   • DUSAGE

   Show answer

   Answer: A

   Explanation

   A non-owner role with the OPERATE privilege on the pipe can pause or resume a pipe (using ALTER PIPE … SET PIPE_EXECUTION_PAUSED = TRUE | FALSE). SQL operations on schema objects also require the USAGE privilege on the database and schema that contain the object.

   Source: Adapted from community discussion — nsojunior

   Next question

6. Question 1266 · 1323 in bank

   Select 2

   Which commands can a Snowflake user execute to specify a cluster key for a table? (Choose two.)

   • ACREATE
   • BUPDATE
   • CALTER
   • DSET
   • ESHOW

   Show answer

   Answer: AC

   Explanation

   A clustering key can be defined at table creation (using the CREATE TABLE command) or afterward (using the ALTER TABLE command).

   Source: Adapted from community discussion — Jordi204

   References

   • Snowflake documentation

   Next question

7. Question 1267 · 1323 in bank

   Authorization to execute CREATE [object] statements comes only from which role?

   • APrimary role
   • BSecondary role
   • CApplication role
   • DDatabase role

   Show answer

   Answer: A

   Explanation

   A. Primary role Note that authorization to execute CREATE statements to create objects is provided by the primary role. https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles

   Source: Adapted from community discussion — 0e504b5

   References

   • Snowflake documentation

   Next question

8. Question 1268 · 1323 in bank

   Which ACCOUNT_USAGE view can be used to identify the masking policy assigned to an object?

   • AACCESS_HISTORY
   • BOBJECT_DEPENDENCIES
   • CPOLICY_REFERENCES
   • DTAG_REFERENCES

   Show answer

   Answer: C

   Next question

9. Question 1269 · 1323 in bank

   Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

   • ARETURN_-1_ROWS
   • BRETURN_n_ROWS
   • CRETURN_ERRORS
   • DRETURN_ALL_ERRORS

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

10. Question 1270 · 1323 in bank

    Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

    • AGET
    • BPUT
    • CCREATE STREAM
    • DCOPY INTO [location]

    Show answer

    Answer: B

    References

    • Snowflake documentation

    Next question

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

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