SnowPro Core Certification practice questions

1. Question 1 of 25

   True or False: The COPY command must specify a File Format in order to execute.

   • ATrue
   • BFalse

   Show answer

   Correct answer: B

   How others answered

   • B90%

   Explanation

   The correct answer is FALSE. The file format can be defined at the stage, table, or copy into command. Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.html Copy Into: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

   Adapted from community discussion by jjordan · 2021-12-31 · 18 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 1 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. J

      jjordan

      2021-12-31

      18 upvotes

      The correct answer is FALSE. The file format can be defined at the stage, table, or copy into command. Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.html Copy Into: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

   2. T

      tbridges

      2023-05-24

      8 upvotes

      False. In Snowflake, the COPY command does not necessarily require specifying a File Format in order to execute. The COPY command can be used to load data into a table from various file formats such as CSV, JSON, Avro, Parquet, etc. When a file format is not explicitly specified in the COPY command, Snowflake attempts to automatically infer the file format based on the file's extension or internal file structure. This automatic file format inference feature is known as "automatic file format detection." However, if the file format cannot be determined automatically or if you want to override the automatic detection, you can explicitly specify a File Format in the COPY command using the FILE_FORMAT parameter. So, while specifying a File Format can provide more control and customization over the data loading process, it is not mandatory for the COPY command to execute successfully.

   3. I

      instride

      2023-06-05

      Selected B4 upvotes

      The answer is FALSE. According to snowflake documentation, FILE FORMAT is an optional parameter. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#required-parameters

   4. G

      greenlever

      2022-10-26

      Selected B4 upvotes

      Answer is False. If file format is not mentioned then file will be compressed as gz with default type csv.

2. Question 2 of 25

   True or False: During data unloading, only JSON and CSV files can be compressed.

   • ATrue
   • BFalse

   Show answer

   Correct answer: B

   How others answered

   • B82%
   • A18%

   Explanation

   B "By default, all unloaded data files are compressed using gzip, unless compression is explicitly disabled or one of the other supported compression methods is explicitly specified." https://docs.snowflake.com/en/user-guide/intro-summary-unloading

   Adapted from community discussion by Aaron_w_mendelson · 2023-10-30 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 2 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. L

      lakediver

      2024-04-11

      6 upvotes

      Along with JSON and CSV - Parquet files are also compressed while unloading https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

   2. I

      isolated_sniper

      2023-04-28

      5 upvotes

      During data loading, compression can be enabled for CSV, JSON PARQUET, AVRO, XML type files. ref: https://docs.snowflake.com/en/sql-reference/sql/create-file-format

   3. A

      Aaron_w_mendelson

      2023-10-30

      3 upvotes

      B "By default, all unloaded data files are compressed using gzip, unless compression is explicitly disabled or one of the other supported compression methods is explicitly specified." https://docs.snowflake.com/en/user-guide/intro-summary-unloading

   4. S

      Sk1020

      2022-10-31

      Selected B2 upvotes

      Unloading supports structured formatting CSV format and unstructured JSON and Parquet formats only. Hence FALSE is correct answer.

3. Question 3 of 25

   True or False: Data Providers can share data with only the Data Consumer.

   • ATrue
   • BFalse

   Show answer

   Correct answer: B

   How others answered

   • B81%
   • A19%

   Explanation

   Question itself is tricky. Usually Data providers provides the data to data Consumers. But a provider can also become a consumer. So can anyone please comment what should be the right answer . I think it should be False, as Data providers can share data with consumer and other providers as well

   Adapted from community discussion by Sid460545 · 2022-01-31 · 10 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 3 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. G

      greenlever

      2022-10-29

      Selected B13 upvotes

      Data Providers can share data with reader also. So it is False(B)

   2. S

      Sid460545

      2022-01-31

      10 upvotes

      Question itself is tricky. Usually Data providers provides the data to data Consumers. But a provider can also become a consumer. So can anyone please comment what should be the right answer . I think it should be False, as Data providers can share data with consumer and other providers as well

   3. M

      matias_salina

      2023-09-27

      3 upvotes

      "When sharing in Snowflake, the account that shares data is called a provider, and the account that is a recipient of the data is called a consumer." "A data consumer is any account that chooses to create a database from a share made available by a data provider." "To facilitate sharing data with these consumers, you can create reader accounts. Reader accounts (formerly known as “read-only accounts”) provide a quick, easy, and cost-effective way to share data without requiring the consumer to become a Snowflake customer. Each reader account belongs to the provider account that created it" https://docs.snowflake.com/en/user-guide/data-sharing-intro

   4. O

      omiiUST

      2024-08-01

      Selected B2 upvotes

      False. In Snowflake, data providers can share data not only with individual data consumers but also with multiple data consumers through various means such as: Direct Sharing: Sharing data with specific Snowflake accounts. Reader Accounts: Sharing data with organizations that do not have their own Snowflake accounts by creating and managing Reader Accounts. Snowflake Marketplace: Sharing data publicly with multiple consumers who subscribe to the data offering on the Snowflake Marketplace. Thus, data sharing in Snowflake is flexible and allows for sharing with multiple consumers in different ways.

4. Question 4 of 25

   Select 2

   What transformations are supported in a CREATE PIPE ... AS COPY `¦ FROM (`¦) statement? (Choose two.)

   • AData can be filtered by an optional WHERE clause.
   • BIncoming data can be joined with other tables.
   • CColumns can be reordered.
   • DColumns can be omitted.
   • ERow level access can be defined.

   Show answer

   Correct answer: C, D

   How others answered

   • CD100%

   Explanation

   Using a query as the source for the COPY statement for column reordering [C], column omission [D], and casts (i.e. transforming data during a load) is supported. For usage examples, see Transforming Data During a Load. Note that only simple SELECT statements are supported. Filtering using a WHERE clause is not supported [E].

   Adapted from community discussion by EmiB · 2023-03-06 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 4 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. E

      EmiB

      2023-03-06

      Selected C, D2 upvotes

      Using a query as the source for the COPY statement for column reordering [C], column omission [D], and casts (i.e. transforming data during a load) is supported. For usage examples, see Transforming Data During a Load. Note that only simple SELECT statements are supported. Filtering using a WHERE clause is not supported [E].

   2. S

      SV1122

      2022-12-26

      2 upvotes

      CD is correct https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html

   3. [

      [Removed]

      2023-10-30

      Selected C, D1 upvote

      https://docs.snowflake.com/en/user-guide/data-load-transform

   4. B

      BigDataBB

      2023-01-05

      1 upvote

      https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes

5. Question 5 of 25

   Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

   • AAuto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
   • BThe ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
   • CSnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
   • DA user cannot specify a default warehouse when using the ODBC driver.
   • EThe default virtual warehouse size can be changed at any time.

   Show answer

   Correct answer: C

   How others answered

   • C54%
   • E46%

   Only 54% agreed on this answer — treat it as contested rather than settled.

   Explanation

   CE are correct. I cant believe exam topics wants to charge for this test. We cant even vote for the correct answer in this case. What a joke.

   Adapted from community discussion by nintendogamer64 · 2022-12-30 · 30 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 5 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. N

      nintendogamer64

      2022-12-30

      30 upvotes

      CE are correct. I cant believe exam topics wants to charge for this test. We cant even vote for the correct answer in this case. What a joke.

   2. G

      gstv_g

      2023-10-28

      4 upvotes

      C and E. Rule out A: Multi-cluster warehouses support all the same properties and actions as single-cluster warehouses, including auto-resuming a suspended warehouse when new queries are submitted. (https://docs.snowflake.com/en/user-guide/warehouses-multicluster) Rule out B: Warehouses can be suspended in non-Enterprise versions of Snowflake, but auto-suspending multi-cluster warehouses is only available in Enterprise. (https://docs.snowflake.com/en/user-guide/warehouses-considerations) Rule out D: Default warehouse size is set in the connection parameters of ODBC connections (https://docs.snowflake.com/en/developer-guide/odbc/odbc-parameters)

   3. J

      jveag

      2022-09-11

      Selected C2 upvotes

      I think the same way.C y E. This test is very confusing to me

   4. W

      William_20

      2022-08-30

      Selected C1 upvote

      C and E. Can only pick one answer here though question assumes 2. E for sure, C because of deduction (remaining options are not true)

6. Question 6 of 25

   Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

   • ATo accommodate more queries
   • BTo accommodate more users
   • CTo accommodate fluctuations in workload
   • DTo accommodate a more complex workload

   Show answer

   Correct answer: D

   How others answered

   • D96%

   Explanation

   A is the correct answer. Ref: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html Resizing a warehouse generally improves query performance, particularly for larger, more complex queries. It can also help reduce the queuing that occurs if a warehouse does not have enough compute resources to process all the queries that are submitted concurrently. Note that warehouse resizing is not intended for handling concurrency issues; instead, use additional warehouses to handle the workload or use a multi-cluster warehouse (if this feature is available for your account).

   Adapted from community discussion by SteveKarr · 2022-02-28 · 15 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 6 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. S

      SteveKarr

      2022-02-28

      15 upvotes

      A is the correct answer. Ref: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html Resizing a warehouse generally improves query performance, particularly for larger, more complex queries. It can also help reduce the queuing that occurs if a warehouse does not have enough compute resources to process all the queries that are submitted concurrently. Note that warehouse resizing is not intended for handling concurrency issues; instead, use additional warehouses to handle the workload or use a multi-cluster warehouse (if this feature is available for your account).

   2. A

      asorock

      2023-07-11

      8 upvotes

      You answer option contradicts you post. What you posted mentioned that "...particularly for larger, more complex queries.". So correct answer is D

   3. A

      AdolinKholin

      2023-06-12

      5 upvotes

      Answer is D. As you mention warehouse resizing is not intended for handling concurrency issues(i.e handling more queries). The solution for A would be multi-clustering.

   4. P

      pistachio99

      2023-10-06

      Selected D2 upvotes

      Should be D. If a query is too complex Snowflake would simply not be able to finished the query in XS warehouse. You have to increase to the warehouse size to medium to make it work.

7. Question 7 of 25

   What is a feature of a stored procedure in Snowflake?

   • AThey can be created as secure and hide the underlying metadata from all users.
   • BThey can access tables from a single database.
   • CThey can only contain a single SQL statement.
   • DThey can be created to run with a caller's rights or an owner's rights.

   Show answer

   Correct answer: D

   How others answered

   • D77%
   • A23%

   Explanation

   but can't hide the underlying metadata from all users. Here "all" users is the catch. The role that created can view the definition of stored proc

   Adapted from community discussion by SV1122 · 2023-06-29 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 7 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. B

      BobFar

      2024-04-13

      1 upvote

      Answer is D , I am not sure about A. For example, for a secure function or procedure, information omitted for unauthorized users includes its: Body (the handler code that comprises its logic) List of imports Handler name Packages list Unauthorized users will still be able to see information that includes its: Parameter types Return type Handler language Null handling Volatility https://docs.snowflake.com/en/developer-guide/secure-udf-procedure#label-secure-limiting-visibility-definition But D is definitely true A stored procedure runs with either the caller’s rights or the owner’s rights. It cannot run with both at the same time. This topic describes the differences between a caller’s rights stored procedure and an owner’s rights stored procedure. https://docs.snowflake.com/en/developer-guide/stored-procedure/stored-procedures-rights

   2. W

      William_20

      2023-02-28

      Selected D3 upvotes

      https://docs.snowflake.com/en/sql-reference/stored-procedures-rights.html

   3. S

      SV1122

      2023-06-29

      2 upvotes

      but can't hide the underlying metadata from all users. Here "all" users is the catch. The role that created can view the definition of stored proc

   4. E

      EmiB

      2023-09-06

      Selected D1 upvote

      A - False - When you specify that the UDF or procedure is secure, these details are visible only to authorized users – in other words, to users who are granted a role that owns the function.

8. Question 8 of 25

   Which Snowflake architectural layer is responsible for a query execution plan?

   • ACompute
   • BData storage
   • CCloud services
   • DCloud provider

   Show answer

   Correct answer: C

   How others answered

   • C67%
   • A33%

   Only 67% agreed on this answer — treat it as contested rather than settled.

   Explanation

   Cloud Services The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control

   Adapted from community discussion by Naah · 2022-12-27 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 8 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. S

      sakis213

      2023-01-07

      7 upvotes

      Correct but the question is about Explain/Query execution plan not Query execution. Perhaps C.

   2. N

      Naah

      2022-12-27

      4 upvotes

      Cloud Services The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control

   3. R

      rogerek077

      2024-03-29

      4 upvotes

      At least the discussion section under each question looks very valuable from learning perspective. You have a chance to see other opinions, sometimes different than yours which urges you to your own deeper research and better understanding.

   4. 4

      4db5e62

      2024-01-24

      4 upvotes

      Made a mistake buying this set, all answers are wrong. Will never ever recommend this to anyone. Refrain from using this.

9. Question 9 of 25

   Select 2

   Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

   • ADatabase replication and failover
   • BAutomated index management
   • CCustomer managed keys (Tri-secret secure)
   • DExtended time travel
   • ENative support for geospatial data

   Show answer

   Correct answer: D, E

   How others answered

   • DE93%

   Explanation

   A. Database replication and fail over and C. Customer managed keys (Tri-secret secure) are supported Business Critical and above only. https://docs.snowflake.com/en/user-guide/intro-editions.html

   Adapted from community discussion by tejarun · 2022-11-25 · 13 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   View community discussion4

   Candidate context

   Question 9 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

   1. R

      Raju039

      2023-03-16

      Selected D, E13 upvotes

      A. Database replication and failover - Business B. Automated index management - No index in Snowflake C. Customer managed keys (Tri-secret secure) - Business D. Extended time travel - Enterprise E. Native support for geospatial data - Standard

   2. T

      tejarun

      2022-11-25

      Selected D, E13 upvotes

      A. Database replication and fail over and C. Customer managed keys (Tri-secret secure) are supported Business Critical and above only. https://docs.snowflake.com/en/user-guide/intro-editions.html

   3. H

      halol

      2022-12-07

      Selected D, E4 upvotes

      https://docs.snowflake.com/en/user-guide/intro-editions.html

   4. C

      Corinaa

      2023-05-07

      Selected D, E2 upvotes

      Database and share replication IS for all editions, BUT Failover is only for Business Critical and VPS => A is wrong DE is correct.

10. Question 10 of 25

    Users are responsible for data storage costs until what occurs?

    • AData expires from Time Travel
    • BData expires from Fail-safe
    • CData is deleted from a table
    • DData is truncated from a table

    Show answer

    Correct answer: B

    How others answered

    • B67%
    • D19%

    Only 67% agreed on this answer — treat it as contested rather than settled.

    Explanation

    Storage is calculated and charged for data regardless of whether it is in the Active, Time Travel, or Fail-safe state. Because these life-cycle states are sequential, updated/deleted data protected by CDP will continue to incur storage costs until the data leaves the Fail-safe state. https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

    Adapted from community discussion by halol · 2022-12-07 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 10 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. S

       SV1122

       2022-12-26

       Selected B7 upvotes

       Storage fees are incurred for maintaining historical data during both the Time Travel and Fail-safe periods. https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html

    2. H

       halol

       2022-12-07

       Selected B3 upvotes

       Storage is calculated and charged for data regardless of whether it is in the Active, Time Travel, or Fail-safe state. Because these life-cycle states are sequential, updated/deleted data protected by CDP will continue to incur storage costs until the data leaves the Fail-safe state. https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

    3. C

       Colourseun

       2023-11-14

       4 upvotes

       The answer is D. Data is truncated from a table. Once data is truncated from a table, it is permanently deleted and cannot be recovered. Snowflake charges for data storage until the data is truncated.

    4. M

       Mike722

       2024-02-14

       Selected B2 upvotes

       B: https://docs.snowflake.com/en/user-guide/tables-storage-considerations Storage is calculated and charged for data regardless of whether it is in the Active, Time Travel, or Fail-safe state. Because these life-cycle states are sequential, updated/deleted data protected by CDP will continue to incur storage costs until the data leaves the Fail-safe state.

11. Question 11 of 25

    How many days is load history for Snowpipe retained?

    • A1 day
    • B7 days
    • C14 days
    • D64 days

    Show answer

    Correct answer: C

    How others answered

    • C100%

    Explanation

    Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output. Snowpipe Stored in the metadata of the pipe for 14 days. Must be requested from Snowflake via a REST endpoint, SQL table function, or ACCOUNT_USAGE view. source : https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro

    Adapted from community discussion by shyemko · 2023-03-29 · 7 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 11 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. S

       shyemko

       2023-03-29

       Selected C7 upvotes

       Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output. Snowpipe Stored in the metadata of the pipe for 14 days. Must be requested from Snowflake via a REST endpoint, SQL table function, or ACCOUNT_USAGE view. source : https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro

    2. E

       EmiB

       2023-03-06

       Selected C4 upvotes

       COPY INTO - Stored in the metadata of the target table for 64 days SNOWPIPE - Stored in the metadata of the pipe for 14 days

    3. C

       Colourseun

       2023-11-14

       1 upvote

       Load history for Snowpipe is retained for 14 days:C Snowflake stores load history for Snowpipe in the metadata of the pipe object. This history includes information such as the date and time of the load, the number of files loaded, and the size of the data loaded. SELECT * FROM INFORMATION_SCHEMA.PIPE_LOAD_HISTORY WHERE PIPE_NAME = ' ' ORDER BY START_TIME DESC;

    4. N

       Naah

       2022-12-27

       2 upvotes

       C https://docs.snowflake.com/en/sql-reference/functions/copy_history.html

12. Question 12 of 25

    Select 2

    What happens when a cloned table is replicated to a secondary database? (Choose two.)

    • AA read-only copy of the cloned tables is stored.
    • BThe replication will not be successful.
    • CThe physical data is replicated.
    • DAdditional costs for storage are charged to a secondary account.
    • EMetadata pointers to cloned tables are replicated.

    Show answer

    Correct answer: C, D

    How others answered

    • CD88%

    Explanation

    Answers C&D are correct. For C read this: Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloni For D , read this : Charges based on replication are divided into two categories: data transfer and compute resources. Both categories are billed on the target account (i.e. the account that stores the secondary database or secondary replication/failover group that is refreshed). https://docs.snowflake.com/en/user-guide/account-replication-cost

    Adapted from community discussion by Vinit_Agarwal · 2023-06-14 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 12 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. S

       SV1122

       2022-12-29

       Selected C, D8 upvotes

       When a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.

    2. V

       Vinit_Agarwal

       2023-06-14

       Selected C, D3 upvotes

       Answers C&D are correct. For C read this: Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloni For D , read this : Charges based on replication are divided into two categories: data transfer and compute resources. Both categories are billed on the target account (i.e. the account that stores the secondary database or secondary replication/failover group that is refreshed). https://docs.snowflake.com/en/user-guide/account-replication-cost

    3. C

       c0d3g

       2023-05-14

       Selected C, D1 upvote

       Replication and Cloning Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloni

    4. P

       PrasantSadangi

       2025-03-28

       Selected C, D1 upvote

       Historically Cloned objects were replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database don’t contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.

13. Question 13 of 25

    Which statement is true about running tasks in Snowflake?

    • AA task can be called using a CALL statement to run a set of predefined SQL commands.
    • BA task allows a user to execute a single SQL statement/command using a predefined schedule.
    • CA task allows a user to execute a set of SQL commands on a predefined schedule.
    • DA task can be executed using a SELECT statement to run a predefined SQL command.

    Show answer

    Correct answer: B

    How others answered

    • B94%

    Explanation

    A task can execute any one of the following types of SQL code: Single SQL statement Call to a stored procedure Procedural logic using Snowflake Scripting Developer Guide https://docs.snowflake.com/en/user-guide/tasks-intro.html

    Adapted from community discussion by SV1122 · 2022-12-27 · 9 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 13 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. S

       SV1122

       2022-12-27

       Selected B9 upvotes

       A task can execute any one of the following types of SQL code: Single SQL statement Call to a stored procedure Procedural logic using Snowflake Scripting Developer Guide https://docs.snowflake.com/en/user-guide/tasks-intro.html

    2. P

       Prajdeo

       2023-03-05

       Selected B3 upvotes

       A task can execute any one of the following types of SQL code: Single SQL statement Call to a stored procedure Procedural logic using Snowflake Scripting Developer Guide https://docs.snowflake.com/en/user-guide/tasks-intro

    3. D

       deeshubh

       2024-05-03

       1 upvote

       Multiple SQL statements using SnowSQL Create task executes multiple SQL statements. Example, task modifies the TIMESTAMP_OUTPUT_FORMAT for the session and then queries the CURRENT_TIMESTAMP function. The SQL code in the task definition includes multiple statements. To execute the CREATE TASK statement, you must temporarily set a character other than a semicolon as the delimiter for SQL statements; otherwise, the CREATE TASK statement would return a user error. The command to change the SQL delimiter in SnowSQL is !set sql_delimiter = . https://docs.snowflake.com/en/sql-reference/sql/create-task Now Decide B or C, As per my understanding, may be now they have add this feature, so as per old snowflake its B but for now its C

    4. S

       SnowProCertDec22

       2022-12-14

       2 upvotes

       A task can execute any one of the following types of SQL code: Single SQL statement

14. Question 14 of 25

    Select 2

    Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

    • ACustomers can change the size of the Warehouse after creation
    • BA Warehouse can be resized while running
    • CA Warehouse can be configured to suspend after a period of inactivity
    • DA Warehouse can be configured to auto-resume when new queries are submitted

    Show answer

    Correct answer: A, B

    How others answered

    • AB67%
    • CD18%

    Only 67% agreed on this answer — treat it as contested rather than settled.

    Explanation

    Correct, you can configure auto suspend and auto resume: https://docs.snowflake.com/en/user-guide/warehouses-considerations#automating-warehouse-suspension AND you can resize a wh even when it is running: https://docs.snowflake.com/en/user-guide/warehouses-overview

    Adapted from community discussion by 56d43d6 · 2024-12-28 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 14 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. A

       aba2s

       2024-10-30

       2 upvotes

       ALL ANSWERS ARE TRUE When discussing Virtual Warehouses, there are several characteristics that we can identify as true: Customers can change the size of the Warehouse after creation: After a virtual warehouse has been created, customers are able to modify its size to scale compute resources up or down based on their current needs. A Warehouse can be resized while running: It is possible to adjust the size of a virtual warehouse while it is running to accommodate changing workloads without needing to stop and restart the warehouse. A Warehouse can be configured to suspend after a period of inactivity: To manage costs and resources efficiently, a virtual warehouse can be set up to automatically suspend after it has been inactive for a predefined period. A Warehouse can be configured to auto-resume when new queries are submitted: This feature ensures that when new queries require processing, the warehouse can automatically resume operation without manual intervention.

    2. M

       Marge23

       2023-09-16

       4 upvotes

       Additionally, multi-cluster warehouses support all the same properties and actions as single-cluster warehouses, including: Specifying a warehouse size. Resizing a warehouse at any time. Auto-suspending a running warehouse due to inactivity; note that this does not apply to individual clusters, but rather the entire multi-cluster warehouse. Auto-resuming a suspended warehouse when new queries are submitted.

    3. S

       SuryaG2490

       2025-02-27

       Selected A, B1 upvote

       All of the following statements are true of Virtual Warehouses in Snowflake: A. Customers can change the size of the Warehouse after creation: You can resize a warehouse at any time to adjust the compute resources. B. A Warehouse can be resized while running: Warehouses can be resized even while they are running to accommodate changing workloads. C. A Warehouse can be configured to suspend after a period of inactivity: You can set a warehouse to automatically suspend after a specified period of inactivity to save costs. D. A Warehouse can be configured to auto-resume when new queries are submitted: Warehouses can be configured to automatically resume when new queries are submitted, ensuring that compute resources are available when needed.

    4. G

       grantz

       2024-03-15

       Selected A, B2 upvotes

       Additionally, multi-cluster warehouses support all the same properties and actions as single-cluster warehouses, including: Specifying a warehouse size. Resizing a warehouse at any time. Auto-suspending a running warehouse due to inactivity; note that this does not apply to individual clusters, but rather the entire multi-cluster warehouse. Auto-resuming a suspended warehouse when new queries are submitted. https://docs.snowflake.com/en/user-guide/warehouses-multicluster

15. Question 15 of 25

    When unloading data to an external stage, which compression format can be used for Parquet files with the COPY INTO command?

    • ABROTLI
    • BGZIP
    • CLZO
    • DZSTD

    Show answer

    Correct answer: C

    How others answered

    • C100%

    Explanation

    None if the above. by default it should be Snappy. "When unloading data, files are compressed using the Snappy algorithm by default. You can optionally specify this value." https://docs.snowflake.com/en/sql-reference/sql/create-file-format#type-parquet:~:text=When%20unloading%20data%2C%20files%20are%20compressed%20using%20the%20Snappy%20algorithm%20by%20default.%20You%20can%20optionally%20specify%20this%20value.

    Adapted from community discussion by SexyPotato · 2023-03-04 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 15 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. B

       BigDataBB

       2023-01-20

       Selected C2 upvotes

       if You try You will disvover that "By default, all unloaded data files are compressed using gzip" is false for parquet file type COPY INTO @SG_PROVA FROM GAME_LOGS FILE_FORMAT = ( TYPE = PARQUET); -- sg_prova/data_0_0_0.snappy.parquet COPY INTO @SG_PROVA/data2 FROM GAME_LOGS FILE_FORMAT = ( TYPE = PARQUET COMPRESSION = LZO); -- sg_prova/data2_0_0_0.lzo.parquet COPY INTO @SG_PROVA/data3 FROM GAME_LOGS FILE_FORMAT = ( TYPE = PARQUET COMPRESSION = GZIP); -- Invalid compression format GZIP

    2. S

       SexyPotato

       2023-03-04

       3 upvotes

       None if the above. by default it should be Snappy. "When unloading data, files are compressed using the Snappy algorithm by default. You can optionally specify this value." https://docs.snowflake.com/en/sql-reference/sql/create-file-format#type-parquet:~:text=When%20unloading%20data%2C%20files%20are%20compressed%20using%20the%20Snappy%20algorithm%20by%20default.%20You%20can%20optionally%20specify%20this%20value.

    3. A

       aroma

       2023-04-13

       4 upvotes

       TYPE = PARQUET COMPRESSION = AUTO | LZO | SNAPPY | NONE SNAPPY Files are compressed using the Snappy algorithm by default. You can optionally specify this value.

    4. H

       halol

       2022-12-08

       Selected C2 upvotes

       When unloading data, files are compressed using the Snappy algorithm by default. If unloading data to LZO-compressed files, specify this value. https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html#type-parquet

16. Question 16 of 25

    Which interfaces can be used to create and/or manage Virtual Warehouses?

    • AThe Snowflake Web Interface (UI)
    • BSQL commands
    • CData integration tools
    • DAll of the above

    Show answer

    Correct answer: D

    How others answered

    • D82%

    Explanation

    https://docs.snowflake.com/en/user-guide/intro-key-concepts.html A warehouse can be created through the web interface or using SQL: Classic Web Interface Click on Warehouses Warehouses tab » Create SQL Execute a CREATE WAREHOUSE command.

    Adapted from community discussion by Graghu · 2022-05-09 · 13 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 16 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. G

       Graghu

       2022-05-09

       13 upvotes

       https://docs.snowflake.com/en/user-guide/intro-key-concepts.html A warehouse can be created through the web interface or using SQL: Classic Web Interface Click on Warehouses Warehouses tab » Create SQL Execute a CREATE WAREHOUSE command.

    2. B

       bee5k

       2023-05-15

       Selected D4 upvotes

       The correct answer is D. All of the above. Virtual Warehouses can be created and/or managed using the Snowflake Web Interface (UI), SQL commands, or data integration tools. The Snowflake Web Interface (UI) is a graphical user interface that allows users to create and manage Virtual Warehouses. The Snowflake Web Interface (UI) is available in both a web browser and a mobile app. SQL commands can be used to create and manage Virtual Warehouses. SQL commands can be executed using the Snowflake Web Interface (UI), the Snowflake Command Line Interface (CLI), or a data integration tool. Data integration tools can be used to create and manage Virtual Warehouses. Data integration tools are software applications that allow users to extract, transform, and load data from a variety of sources into Snowflake.

    3. A

       Alex_Ovidiu

       2024-04-04

       3 upvotes

       D. All of the above A. The Snowflake Web Interface (UI): The Snowflake web interface provides a user-friendly graphical interface for managing Snowflake objects, including creating, starting, stopping, suspending, and resizing virtual warehouses. B. SQL commands: Snowflake allows using SQL commands to perform various administrative tasks, including creating, managing, and monitoring virtual warehouses. You can use the SQL interface within the web UI or a separate SQL client tool. C. Data integration tools: Various data integration tools can interact with Snowflake and automate tasks related to virtual warehouses. These tools might provide functionalities to create, start, stop, or suspend warehouses as part of data processing workflows.

    4. K

       krishna3195

       2024-10-14

       3 upvotes

       A. The Snowflake Web Interface (UI): True. Snowflake provides a user-friendly web interface (UI) where users can create, resize, suspend, resume, and manage virtual warehouses. B. SQL commands: True. Virtual warehouses can be created and managed using SQL commands like CREATE WAREHOUSE, ALTER WAREHOUSE, DROP WAREHOUSE, etc. C. Data integration tools: True. Many data integration tools that connect to Snowflake (such as ETL tools like Talend, Matillion, or Fivetran) can also manage virtual warehouses, either through direct integration or by executing SQL commands under the hood. Since virtual warehouses can be managed via all of the listed interfaces, the correct answer is D. All of the above.

17. Question 17 of 25

    When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

    • AThe Pipe load history is reset to empty
    • BThe REFRESH parameter is set to TRUE
    • CPreviously loaded files will be ignored
    • DAll of the above

    Show answer

    Correct answer: A

    How others answered

    • A70%

    Only 70% agreed on this answer — treat it as contested rather than settled.

    Explanation

    I believe the correct answer is A. REFRESH is a parameter for ALTER PIPE https://docs.snowflake.com/en/sql-reference/sql/alter-pipe.html It is NOT a parameter for CREATE [OR REPLACE] Pipe. https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html Further recreating a pipe resets history: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#label-snowpipe-management-recreate-pipes "Load History The load history for Snowpipe operations is stored in the metadata of the pipe object. When a pipe is recreated, the load history is dropped. In general, this condition only affects users if they subsequently execute an ALTER PIPE … REFRESH statement on the pipe. Doing so could load duplicate data from staged files in the storage location for the pipe if the data was already loaded successfully and the files were not deleted subsequently."

    Adapted from community discussion by jjordan · 2021-12-31 · 27 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 17 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. J

       jjordan

       2021-12-31

       27 upvotes

       I believe the correct answer is A. REFRESH is a parameter for ALTER PIPE https://docs.snowflake.com/en/sql-reference/sql/alter-pipe.html It is NOT a parameter for CREATE [OR REPLACE] Pipe. https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html Further recreating a pipe resets history: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#label-snowpipe-management-recreate-pipes "Load History The load history for Snowpipe operations is stored in the metadata of the pipe object. When a pipe is recreated, the load history is dropped. In general, this condition only affects users if they subsequently execute an ALTER PIPE … REFRESH statement on the pipe. Doing so could load duplicate data from staged files in the storage location for the pipe if the data was already loaded successfully and the files were not deleted subsequently."

    2. H

       Hello1991

       2022-01-13

       3 upvotes

       "Load History The load history for Snowpipe operations is stored in the metadata of the pipe object. When a pipe is recreated, the load history is dropped. In general, this condition only affects users if they subsequently execute an ALTER PIPE … REFRESH statement on the pipe. Doing so could load duplicate data from staged files in the storage location for the pipe if the data was already loaded successfully and the files were not deleted subsequently." correct answer is A.

    3. A

       aqmdla2002

       2022-03-20

       Selected A3 upvotes

       https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

    4. K

       kentucky13caa

       2024-11-15

       2 upvotes

       The correct answer is D. All of the above. When a Pipe is recreated using the CREATE OR REPLACE PIPE command: The Pipe load history is reset to empty (A is true) The REFRESH parameter is automatically set to TRUE (B is true) Previously loaded files will be ignored (C is true) Therefore, since all three statements (A, B, and C) are true, D "All of the above" is the correct answer. This is important to understand because recreating a pipe effectively gives you a fresh start - clearing history, refreshing the pipe, and ignoring previously processed files.

18. Question 18 of 25

    Which SQL command can be used to see the CREATE definition of a masking policy?

    • ASHOW MASKING POLICIES
    • BDESCRIBE MASKING POLICY
    • CGET_DDL
    • DLIST MASKING POLICIES

    Show answer

    Correct answer: C

    How others answered

    • C100%

    Explanation

    This is the result of B https://docs.snowflake.com/en/sql-reference/sql/desc-masking-policy.html#example So B can't be the answer And this is the result of C https://docs.snowflake.com/en/sql-reference/functions/get_ddl.html#examples So C is the answer

    Adapted from community discussion by AS314 · 2023-07-18 · 10 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 18 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. A

       AS314

       2023-07-18

       10 upvotes

       This is the result of B https://docs.snowflake.com/en/sql-reference/sql/desc-masking-policy.html#example So B can't be the answer And this is the result of C https://docs.snowflake.com/en/sql-reference/functions/get_ddl.html#examples So C is the answer

    2. S

       sakis213

       2023-06-30

       Selected C4 upvotes

       should be GET_DDL, describe returns only the body, not the whole create statement definition , for example input & return column data types values will be missing

    3. S

       scoob

       2023-06-19

       4 upvotes

       C - GET_DDL returns the create statement to recreate the object. DESCRIBE will show the sql behind the policy but not in the form of a create statement.

    4. H

       harshagc180

       2023-06-08

       4 upvotes

       Correct answer DESCRIBE MASKING POLICY since the question is about command. If asked about the function then GET_DDL

19. Question 19 of 25

    Which command can be used to load data into an internal stage?

    • ALOAD
    • BCOPY
    • CGET
    • DPUT

    Show answer

    Correct answer: D

    How others answered

    • D62%
    • B38%

    Only 62% agreed on this answer — treat it as contested rather than settled.

    Explanation

    I think it's ambiguous question B or D It depends on the data source COPY unloads the data from table into stage PUT uploads a file from local file system into a stage https://docs.snowflake.com/en/user-guide/data-unload-overview https://docs.snowflake.com/en/sql-reference/sql/put

    Adapted from community discussion by 0e504b5 · 2024-08-02 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 19 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. 0

       0e504b5

       2024-08-02

       Selected D3 upvotes

       I think it's ambiguous question B or D It depends on the data source COPY unloads the data from table into stage PUT uploads a file from local file system into a stage https://docs.snowflake.com/en/user-guide/data-unload-overview https://docs.snowflake.com/en/sql-reference/sql/put

    2. E

       EmiB

       2023-09-12

       Selected D3 upvotes

       D - PUT (load data into a stage (from local)) B - COPY (unload data into a stage (from snowflake))

    3. N

       Naveen90

       2023-06-28

       3 upvotes

       The Answer is B. Get and Put are used to unload to local disk and load into Snowflake respectively. https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#unloading-into-a-snowflake-stage

    4. B

       BigDataBB

       2023-07-10

       Selected D2 upvotes

       If the question was "Which command can be used to UNLOAD ..." then is correct copy, but loading on stage means that You are loading external data, so is correct D

20. Question 20 of 25

    The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

    • AIn the metadata of the target table for 14 days
    • BIn the metadata of the pipe for 14 days
    • CIn the metadata of the target table for 64 days
    • DIn the metadata of the pipe for 64 days

    Show answer

    Correct answer: C

    How others answered

    • C71%
    • A19%

    Only 71% agreed on this answer — treat it as contested rather than settled.

    Explanation

    data bulk load history ===> in the metadata of the target table for 64 days snowpipe ====> in the metadata of the pipe for 14 days

    Adapted from community discussion by fahfouhi94 · 2024-02-06 · 10 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 20 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. H

       harshagc180

       2023-12-09

       22 upvotes

       Correct Answer : C https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#load-history

    2. F

       fahfouhi94

       2024-02-06

       Selected C10 upvotes

       data bulk load history ===> in the metadata of the target table for 64 days snowpipe ====> in the metadata of the pipe for 14 days

    3. S

       SA_206

       2024-02-12

       4 upvotes

       For Snowpipe use copy_history. and for table LOAD_History, both have 14day hisotry https://docs.snowflake.com/en/sql-reference/functions/copy_history.html https://docs.snowflake.com/en/sql-reference/info-schema/load_history.html

    4. B

       BigDataBB

       2024-01-18

       Selected C1 upvote

       https://docs.snowflake.com/en/user-guide/data-load-considerations-load.html#load-metadata Snowflake maintains detailed metadata for each table into which data is loaded .... This load metadata expires after 64 days. If the LAST_MODIFIED date for a staged data file is less than or equal to 64 days, the COPY command can determine its load status for a given table and prevent reloading (and data duplication).

21. Question 21 of 25

    Which of the following roles is recommended to be used to create and manage users and roles?

    • ASYSADMIN
    • BSECURITYADMIN
    • CPUBLIC
    • DACCOUNTADMIN

    Show answer

    Correct answer: B

    How others answered

    • B94%

    Explanation

    I think the answer to this should be USERADMIN which is not in the options. So the next best answer will be SECURITYADMIN

    Adapted from community discussion by blazingliverbird · 2022-01-12 · 22 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 21 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. B

       blazingliverbird

       2022-01-12

       22 upvotes

       I think the answer to this should be USERADMIN which is not in the options. So the next best answer will be SECURITYADMIN

    2. C

       c0d3g

       2023-02-28

       Selected B9 upvotes

       Here the answer should be SECURITYADMIN as it is parent of USERADMIN (which is the correct answer) More details: https://docs.snowflake.com/en/user-guide/security-access-control-considerations Attention By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user should then create one or more additional users who are assigned the USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN role or another role that is granted the global CREATE USER privilege.

    3. H

       hotflake

       2024-08-05

       2 upvotes

       TYPES OF ROLES: SYSTEM ROLES: ● ORGADMIN manages operations at the organizational level ● ACCOUNTADMIN performs administrative functions ● SECURITYADMIN creates and manages users and roles, and manages grants ● USERADMIN creates users and roles ● SYSADMIN creates and manages databases, schemas, and warehouses ● PUBLIC is available to all users, but (by default) cannot do anything but log in CUSTOM ROLES: ● Created by the SECURITYADMIN or USERADMIN based on a company's desired hierarchy ● Custom roles generally "roll up" to the SYSADMIN role

    4. P

       palmer24

       2023-06-26

       2 upvotes

       In Snowflake, the recommended role to create and manage users and roles is the ACCOUNTADMIN role. The ACCOUNTADMIN role is a built-in, superuser role that has full administrative privileges and can perform all administrative tasks within a Snowflake account. Users assigned the ACCOUNTADMIN role have the ability to create, modify, and delete users and roles. They can also grant and revoke privileges, create and manage warehouses, databases, and schemas, and perform other administrative functions within the account.

22. Question 22 of 25

    Select 2

    What are benefits of using the ACCESS_HISTORY view in the SNOWFLAKE database?

    • AIdentification of unused data
    • BIdentification of which roles have been used
    • CTracking of network policy usage
    • DHighlighting of row access policy usage
    • EIdentification of who has read data

    Show answer

    Correct answer: A, E

    How others answered

    • AE35%
    • A23%
    • DE23%

    Only 35% agreed on this answer — treat it as contested rather than settled.

    Explanation

    A E C - no, use this instead: https://docs.snowflake.com/en/sql-reference/account-usage/network_policies B - I would probably use QUERY_HISTORY for that instead https://docs.snowflake.com/en/sql-reference/account-usage/query_history D - I would use this instead: ROW_ACCESS_POLICIES https://docs.snowflake.com/en/sql-reference/account-usage/row_access_policies

    Adapted from community discussion by 0e504b5 · 2024-08-04 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 22 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. M

       markpumc

       2023-08-09

       3 upvotes

       The benefits of using the ACCESS_HISTORY view in the Snowflake database include: Identification of who has read data Tracking of which roles have been used Highlighting of row access policy usage By using the ACCESS_HISTORY view, organizations can get a better understanding of who has access to what data within their Snowflake environment, and ensure that data is being accessed and used in an appropriate manner.

    2. S

       shankarj68

       2024-01-22

       4 upvotes

       A is the right answer. Check the benefit section: https://docs.snowflake.com/en/user-guide/access-history#benefits

    3. 0

       0e504b5

       2024-08-04

       Selected A, E2 upvotes

       A E C - no, use this instead: https://docs.snowflake.com/en/sql-reference/account-usage/network_policies B - I would probably use QUERY_HISTORY for that instead https://docs.snowflake.com/en/sql-reference/account-usage/query_history D - I would use this instead: ROW_ACCESS_POLICIES https://docs.snowflake.com/en/sql-reference/account-usage/row_access_policies

    4. S

       SV1122

       2023-06-29

       Selected A, E1 upvote

       E is an obvious advantage of the Access History view. A is a derivation from this view https://docs.snowflake.com/en/user-guide/access-history.html#:~:text=Benefits,-Access%20history%20in&text=Discover%20unused%20data%20to%20determine%20whether%20to%20archive%20or%20delete%20the%20data.&text=Track%20data%20movement%20from%20an,to%20a%20different%20Snowflake%20table.

23. Question 23 of 25

    What privilege does a user need in order to receive or request data from the Snowflake Marketplace?

    • ACREATE DATA EXCHANGE LISTING
    • BCREATE SHARE
    • CIMPORT SHARE
    • DIMPORTED PRIVILEGES

    Show answer

    Correct answer: C

    How others answered

    • C70%
    • D30%

    Only 70% agreed on this answer — treat it as contested rather than settled.

    Explanation

    C There are several ways of sharing data on Snowflake, such as: - Direct share - Listings (Snowflake Marketplace) - Data exchange The question is asking about Snowflake Marketplace, where you can have listings The question is NOT asking about data shares or data exchanges. https://other-docs.snowflake.com/en/collaboration/consumer-becoming#set-up-required-privileges Get a listing for your account, then grant the IMPORTED PRIVILEGES privilege on the database created from the listing to a role on your account. This lets you access the data in the listing without having access to get any listing on the Snowflake Marketplace or privately. The answer should be C. IMPORT SHARE privileges to a role on your account allows you get access to listings and therefore, receive and request data from Snowflake Marketplace. Once you do get listing for your account, then you would need IMPORTED PRIVILEGES to access it.

    Adapted from community discussion by 0e504b5 · 2024-08-08 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 23 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. R

       Renvis

       2023-08-14

       13 upvotes

       IMPORTED PRIVILEGES is the right answer. https://docs.snowflake.com/en/user-guide/security-access-control-privileges#:~:text=Usage-,IMPORTED%20PRIVILEGES,-Enables%20roles%20other

    2. 0

       0e504b5

       2024-08-08

       Selected C3 upvotes

       C There are several ways of sharing data on Snowflake, such as: - Direct share - Listings (Snowflake Marketplace) - Data exchange The question is asking about Snowflake Marketplace, where you can have listings The question is NOT asking about data shares or data exchanges. https://other-docs.snowflake.com/en/collaboration/consumer-becoming#set-up-required-privileges Get a listing for your account, then grant the IMPORTED PRIVILEGES privilege on the database created from the listing to a role on your account. This lets you access the data in the listing without having access to get any listing on the Snowflake Marketplace or privately. The answer should be C. IMPORT SHARE privileges to a role on your account allows you get access to listings and therefore, receive and request data from Snowflake Marketplace. Once you do get listing for your account, then you would need IMPORTED PRIVILEGES to access it.

    3. E

       EmiB

       2023-09-10

       Selected C3 upvotes

       IMPORT SHARE - Applies to data consumers. Grants the ability to view shares shared with your account. Also grants the ability to create databases from the shares. IMPORTED PRIVILEGES - manage a Snowflake Marketplace or Data Exchange

    4. G

       Gulpa

       2024-01-09

       Selected C2 upvotes

       Answer C as per this documentation https://other-docs.snowflake.com/en/collaboration/consumer-becoming#:~:text=To%20access%20a%20listing%2C%20you%20must%20use%20the%20ACCOUNTADMIN%20role%20or%20another%20role%20with%20the%20CREATE%20DATABASE%20and%20IMPORT%20SHARE%20privileges

24. Question 24 of 25

    The Query History in the Snowflake Web Interface (UI) is kept for approximately:

    • A60 minutes
    • B24 hours
    • C14 days
    • D30 days
    • E1 year

    Show answer

    Correct answer: C

    How others answered

    • C91%

    Explanation

    Answer should be C (14 days) As per docs - Query History page available under Activity Menu on Web UI, holds query data for 14 days. And you can Query_history view available in Account_Usage schema holds query data for 365 days https://docs.snowflake.com/en/user-guide/ui-snowsight-activity#query-history https://docs.snowflake.com/en/sql-reference/account-usage/query_history

    Adapted from community discussion by Prajdeo · 2023-03-04 · 9 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 24 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. L

       LuciBhish

       2022-03-02

       Selected C13 upvotes

       Answer C History page holds 14days data account usage->Access_history holds 1year data

    2. P

       Prajdeo

       2023-03-04

       Selected C9 upvotes

       Answer should be C (14 days) As per docs - Query History page available under Activity Menu on Web UI, holds query data for 14 days. And you can Query_history view available in Account_Usage schema holds query data for 365 days https://docs.snowflake.com/en/user-guide/ui-snowsight-activity#query-history https://docs.snowflake.com/en/sql-reference/account-usage/query_history

    3. S

       Sk1020

       2022-11-01

       Selected C5 upvotes

       Query history data in UI is available for 14 days history data only. If querying from Query_History view, the data is available for 365 days ie 1Yr. Here the question was tricky... they asked for history data availability thru Web UI , hence answer is 14 days.

    4. U

       uncle_benz

       2022-11-08

       Selected C4 upvotes

       The Query History page lets you view and drill into the details of queries executed in your Snowflake account in the last 14 days. https://docs.snowflake.com/en/user-guide/ui-snowsight-activity.html#query-history

25. Question 25 of 25

    Select 2

    Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

    • ANumber of users
    • BWarehouse size
    • CAmount of data processed
    • D# of clusters for the Warehouse

    Show answer

    Correct answer: B, D

    How others answered

    • BD82%
    • BC18%

    Explanation

    The answer to this is wrong. Consumption is based on the Size of the Warehouse, Number of Clusters and the amount of time the warehouse is running. The correct answer is therefore B&D

    Adapted from community discussion by jjordan · 2021-12-31 · 26 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation
    • Snowflake documentation

    View community discussion4

    Candidate context

    Question 25 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by COF-C02 or CertExamHQ.

    1. J

       jjordan

       2021-12-31

       26 upvotes

       The answer to this is wrong. Consumption is based on the Size of the Warehouse, Number of Clusters and the amount of time the warehouse is running. The correct answer is therefore B&D

    2. B

       blazingliverbird

       2022-01-12

       7 upvotes

       I tend to disagree. Option D doesn't say active clusters and if the clusters are inactive they don't contribute to the consumption.

    3. J

       junpal

       2023-04-02

       2 upvotes

       B. Warehouse size: The size of the virtual warehouse is one of the primary factors that determine the credit consumption. Larger warehouses have more compute resources available, which allows them to process data faster and more efficiently, but also results in higher credit consumption. C. Amount of data processed: The amount of data processed by the virtual warehouse is another key factor that determines credit consumption. Snowflake charges credits based on the amount of data processed, regardless of the number of users or the number of clusters used by the virtual warehouse. A. Number of users and D. # of clusters for the warehouse are not direct factors in credit consumption by the compute layer. However, the number of users and the number of clusters used can indirectly affect credit consumption by impacting the amount of data processed and the warehouse size required to process that data efficiently. Therefore, the credit consumption by the compute layer in Snowflake is primarily based on warehouse size and the amount of data processed.

    4. R

       Rad1941

       2023-08-25

       2 upvotes

       Correct answer is B & D. Analysis [A. number of users] and [C. amount of data processed] are non- factors / have absolutely nothing to do with the calcualtion of credit consumption. Which leaves B and D. Credit consumption is based upon [B. warehouse size] and [D.# clusters for the warehouse]. B and D are not the same thing. VW properties: size = XS S M L XL 2XL 3XL 4XL 5XL 6XL clusters= single or multi-cluster say scale UP now say scale OUT. original post OP: re: _________________________________________________________________________________________ Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.) A. Number of users B. Warehouse size Most Voted C. Amount of data processed D. # of clusters for the Warehouse Most Voted Correct Answer: BC 🗳️ _________________________________________________________________________________________ Disagree! correct answer is BD

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

COF-C02 practice, question 1 of 25