COF-C02 practice questions 1,011–1,020

1. Question 1011 · 1323 in bank

   What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology that is not listed in Snowflake’s partner ecosystem?

   • AUse Snowflake’s native API.
   • BUse a custom-built connector.
   • CContact Snowflake Support for a new driver.
   • DConnect through Snowflake’s JDBC or ODBC drivers.

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

2. Question 1012 · 1323 in bank

   What is the expiration period for a file URL used to access unstructured data in cloud storage?

   • AThe remainder of the session
   • BAn unlimited amount of time
   • CThe length of time specified in the expiration_time argument
   • DThe same length of time as the expiration period for the query results cache

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

3. Question 1013 · 1323 in bank

   Select 2

   Which applications can use key pair authentication? (Choose two).

   • ASnowflake Marketplace
   • BSnowCD
   • CSnowsight
   • DSnowSQL
   • ESnowflake connector for Python

   Show answer

   Answer: DE

   Explanation

   support. A missing checkmark indicates key pair authentication is not supported. Client Key Pair Authentication Key Pair Rotation Unencrypted Private Keys SnowSQL (CLI Client) ✔ ✔ ✔ Snowflake Connector for Python ✔ ✔ ✔ Snowflake Connector for Spark ✔ ✔ ✔ Snowflake Connector for Kafka ✔ ✔ ✔ Go driver ✔ ✔ JDBC Driver ✔ ✔ ✔ ODBC Driver ✔ ✔ ✔ Node.js Driver ✔ ✔ ✔ .NET Driver ✔ ✔ ✔ PHP PDO Driver for Snowflake ✔ ✔ ✔

   Source: Adapted from community discussion — [Removed]

   References

   • Snowflake documentation

   Next question

4. Question 1014 · 1323 in bank

   Select 2

   Which commands can only be executed using SnowSQL? (Choose two.)

   • ACOPY INTO
   • BGET
   • CLIST
   • DPUT
   • EREMOVE

   Show answer

   Answer: BD

   Next question

5. Question 1015 · 1323 in bank

   True or False: Multi-Factor Authentication (MFA) in Snowflake is only supported in conjunction with Single Sign-On (SSO).

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Explanation

   MFA token caching can be combined with connection caching in federated single sign-on. To combine these two features, ensure that the ALLOW_ID_TOKEN parameter is set to true in tandem with the ALLOW_CLIENT_MFA_CACHING parameter

   Source: Adapted from community discussion — SushY18

   Next question

6. Question 1016 · 1323 in bank

   A user has enabled the STRIP_OUTER_ARRAY file format option for the COPY INTO {table} command to remove the outer array structure. What else will this format option and command do?

   • ALoad the records into separate table rows.
   • BUnload the records from separate table rows.
   • CExport data files in smaller chunks.
   • DEnsure each unique element stores values of a single native data type.

   Show answer

   Answer: A

   Next question

7. Question 1017 · 1323 in bank

   Which objects will incur storage costs associated with Fail-safe?

   • AExternal tables
   • BPermanent tables
   • CData files available in internal stages
   • DData files available in external stages

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

8. Question 1018 · 1323 in bank

   What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

   • AB-tree
   • BIndexing
   • CMap reduce
   • DPruning

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

9. Question 1019 · 1323 in bank

   Select 2

   What activities can a user with the ORGADMIN role perform? (Choose two.)

   • ACreate INFORMATION_SCHEMA in a database.
   • BView usage information for all accounts in the organization.
   • CEnable database cloning for an account in the organization.
   • DEnable database replication for an account in the organization.
   • EView micro-partition information for all accounts in the organization.

   Show answer

   Answer: BD

   References

   • Snowflake documentation

   Next question

10. Question 1020 · 1323 in bank

    Select 2

    In a managed access schema, who can grant privileges on objects in the schema to other roles? (Choose two.)

    • AThe schema owner role
    • BThe ORGADMIN system role
    • CThe USERADMIN system role
    • DThe role with the MANAGE GRANTS privilege
    • EThe role that owns the object in the schema

    Show answer

    Answer: AD

    References

    • Snowflake documentation

    Next question

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

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