COF-C02 practice questions 1,311–1,320

1. Question 1311 · 1323 in bank

   How does the authorization associated with a pre-signed URL work for an unstructured file?

   • AAnyone who has the URL can access the referenced file for the life of the token.
   • BOnly the user who generates the URL can use the URL to access the referenced file.
   • COnly the users who have roles with sufficient privileges on the URL can access the referenced file.
   • DThe role specified in the GET REST API call must have sufficient privileges on the stage to access the referenced file using the URL.

   Show answer

   Answer: A

   Next question

2. Question 1312 · 1323 in bank

   Select 2

   What can a reader account user do when accessing shared data? (Choose two.)

   • AInsert new data using the COPY INTO [location] command.
   • BExecute secure User-Defined Functions (UDFs).
   • CRemove records using the DELETE command.
   • DSelect data from secure views.
   • EModify records using the UPDATE and MERGE commands.

   Show answer

   Answer: BD

   Next question

3. Question 1313 · 1323 in bank

   What is a fundamental characteristic of Snowflake micro-partitions?

   • AThey can be read directly as files.
   • BThey serve as an index for Snowflake tables.
   • CThey are sized based on Time Travel requirements.
   • DOnce established, they cannot be changed.

   Show answer

   Answer: D

   Next question

4. Question 1314 · 1323 in bank

   What happens when a multi-cluster virtual warehouse is resized?

   • AThe auto-suspend feature is automatically enabled for inactive clusters.
   • BThe scaling policy of the warehouse is updated.
   • CThe new size applies to all clusters within that warehouse configuration.
   • DThe minimum and maximum number of clusters is automatically adjusted.

   Show answer

   Answer: C

   Next question

5. Question 1315 · 1323 in bank

   Using which copy option when unloading data allows users to include a Universally Unique Identifier (UUID) in the names of unloaded files?

   • AVALIDATION_MODE
   • BSINGLE
   • CHEADER
   • DINCLUDE_QUERY_ID

   Show answer

   Answer: D

   Next question

6. Question 1316 · 1323 in bank

   What type of policy states that each object within Snowflake has a unique owner who can grant access to that object?

   • ARole-Based Access Control (RBAC)
   • BDiscretionary Access Control (DAC)
   • CMandatory Access Control (MAC)
   • DRule-Based Access Control (RuBAC)

   Show answer

   Answer: B

   Next question

7. Question 1317 · 1323 in bank

   What type of authentication is recommended when creating a Snowflake service account that will connect to a third-party application?

   • AUsername and password
   • BKey-pair authentication
   • CMulti-Factor Authentication (MFA)
   • DSingle Sign-on (SSO)

   Show answer

   Answer: B

   Next question

8. Question 1318 · 1323 in bank

   When do Snowflake object owners lose their ability to make grant decisions?

   • AWhen the object owner has been granted a database role
   • BWhen the object owner has been granted an account role
   • CWhen the object is part of a managed access schema
   • DWhen the object is part of a regular schema

   Show answer

   Answer: C

   Next question

9. Question 1319 · 1323 in bank

   Which command allows a user to unload data from a Snowflake database table into one or more files in a Snowflake or external stage?

   • AGET
   • BLIST
   • CPUT
   • DCOPY INTO [location]

   Show answer

   Answer: D

   Next question

10. Question 1320 · 1323 in bank

    Which Snowflake feature enables loading data from cloud storage as soon as files are available in a stage?

    • ACOPY_INTO [location] command
    • BData replication
    • CSnowpipe
    • DDirect share

    Show answer

    Answer: C

    Next question

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

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