COF-C02 practice questions 261–270

1. Question 261 · 1323 in bank

   How should a data provider securely share Snowflake objects with a data consumer who does not have a Snowflake account?

   • AGive the consumer owner's rights on the provider's Snowflake account.
   • BUnload the data into the consumer's cloud storage.
   • CCreate a reader account for the consumer.
   • DCreate and replicate a share, then give the consumer access to the replication.

   Show answer

   Answer: C

   Next question

2. Question 262 · 1323 in bank

   When unloading Snowflake relational data to a Parquet file format, why should the PARTITION BY clause be used?

   • AIt will provide a mechanism to encrypt each micro-partition with a unique key.
   • BIt will guarantee data integrity by splitting the data into smaller, manageable chunks.
   • CIt will increase storage efficiency by automatically compressing data based on access patterns.
   • DIt will optimize query performance by filtering relevant partitions without scanning the entire dataset.

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

3. Question 263 · 1323 in bank

   How can a user access information about a query execution plan without consuming virtual warehouse compute resources?

   • AUse the EXPLAIN function.
   • BReview the Query Profile metrics.
   • CReview the data in the Account_Usage view.
   • DUse the Snowsight dashboard.

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

4. Question 264 · 1323 in bank

   If a query is being used to unload a 1 TB table into a stage, which DML operator will be shown in the Query Profile?

   • AINSERT
   • BUNLOAD
   • CCOPY
   • DUPDATE

   Show answer

   Answer: D

   Next question

5. Question 265 · 1323 in bank

   Select 2

   At what levels can network policies be defined in Snowflake? (Choose two.)

   • AUser
   • BAccount
   • CTable
   • DSchema
   • EDatabase

   Show answer

   Answer: AB

   Next question

6. Question 266 · 1323 in bank

   Select 2

   A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two VARIANT columns? (Choose two.)

   • ARECORD_TIMESTAMP
   • BRECORD_CONTENT
   • CRECORD_KEY
   • DRECORD_SESSION
   • ERECORD_METADATA

   Show answer

   Answer: BE

   Explanation

   https://docs.snowflake.com/en/user-guide/kafka-connector-overview "RECORD_CONTENT. This contains the Kafka message. RECORD_METADATA. This contains metadata about the message, for example, the topic from which the message was read." No RECORD_KEY mentioned. Answer is B and E.

   Source: Adapted from community discussion — 37ceea2

   References

   • Snowflake documentation

   Next question

7. Question 267 · 1323 in bank

   Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?

   • AAccount -> Schema -> Database -> Table
   • BAccount -> Database -> Schema -> Table
   • CDatabase -> Schema -> Table -> Account
   • DDatabase -> Table -> Schema -> Account

   Show answer

   Answer: B

   Next question

8. Question 268 · 1323 in bank

   How should a Snowflake user access a third-party SaaS service to process unstructured data?

   • AUse internal functions.
   • BUse external functions.
   • CUse process functions.
   • DUse an API gateway.

   Show answer

   Answer: D

   Next question

9. Question 269 · 1323 in bank

   Which command will list all of the dropped accounts in an organization that have not been deleted?

   • ASHOW MANAGED ACCOUNTS;
   • BSHOW ORGANIZATION ACCOUNTS;
   • CSHOW ORGANIZATION ACCOUNTS HISTORY;
   • DSHOW ORGANIZATION ACCOUNTS LIKE 'myaccounts%';

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

10. Question 270 · 1323 in bank

    Select 4

    Which of the following objects can be cloned? (Choose four.)

    • ATables
    • BNamed File Formats
    • CSchemas
    • DShares
    • EDatabases
    • FUsers

    Show answer

    Answer: ABCE

    Explanation

    ABCE : Shares and Users cannot be cloned in Snowflake because they represent different types of objects and have different purposes. Shares represent shared access to data within Snowflake, and they cannot be cloned because access to data is controlled through the sharing mechanism, not through copying the share itself. Users represent individual accounts within Snowflake, and they cannot be cloned because each user account must have a unique name and must be associated with a unique set of permissions. Cloning a user would result in two users with the same name, which is not allowed in Snowflake. Instead of cloning Shares or Users, you can use the Snowflake GRANT command to manage access to data and permissions in Snowflake. The GRANT command allows you to control access to data by granting specific privileges to users, roles, or groups.

    Source: Adapted from community discussion — AI_323

    References

    • Snowflake documentation
    • Snowflake documentation

    Next question

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

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