COF-C02 practice questions 121–130

1. Question 121 · 1323 in bank

   Which Snowflake object is supported by both database replication and replication groups?

   • APipes
   • BUsers
   • CStages
   • DMaterialized views

   Show answer

   Answer: D

   Explanation

   Correct Answer: A. Pipes In Snowflake, pipes are supported by both database replication and replication groups. Pipes are used in the context of Snowpipe, which allows for continuous data ingestion into Snowflake. When you set up database replication or replication groups, pipes can be included in the replication process to ensure that the continuous data loading configurations are replicated along with the data.

   Source: Adapted from community discussion — cybe001

   References

   • Snowflake documentation

   Next question

2. Question 122 · 1323 in bank

   Select 2

   When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Choose two.)

   • AESCAPE_UNENCLOSED_FIELD
   • BREPLACE_INVALID_CHARACTERS
   • CFIELD_OPTIONALLY_ENCLOSED_BY
   • DEMPTY_FIELD_AS_NULL
   • ESKIP_BLANK_LINES

   Show answer

   Answer: CD

   Explanation

   Correct Answers: C. FIELD_OPTIONALLY_ENCLOSED_BY and D. EMPTY_FIELD_AS_NULL FIELD_OPTIONALLY_ENCLOSED_BY: This parameter specifies a character that encloses the field. By using this parameter, you can ensure that empty strings are enclosed within the specified character (e.g., double quotes), allowing them to be differentiated from NULL values. EMPTY_FIELD_AS_NULL: This parameter determines how to handle empty fields during the unload operation. When set to TRUE, empty fields are treated as NULL values. This helps in distinguishing between actual empty strings and NULLs in the unloaded data.

   Source: Adapted from community discussion — cybe001

   References

   • Snowflake documentation

   Next question

3. Question 123 · 1323 in bank

   Which role must be used to create resource monitors?

   • ASECURITYADMIN
   • BACCOUNTADMIN
   • CSYSADMIN
   • DORGADMIN

   Show answer

   Answer: B

   Next question

4. Question 124 · 1323 in bank

   What step does Snowflake recommend when loading data from a stage?

   • AUse PURGE when using the COPY INTO [table] command.
   • BUse REMOVE when using the COPY INTO [table] command.
   • CUse the LOAD HISTORY function to view the status of loaded files.
   • DUse the COPY HISTORY function to update the status of loaded files.

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

5. Question 125 · 1323 in bank

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

   • ATrue
   • BFalse

   Show answer

   Answer: B

   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

   Source: Adapted from community discussion — Aaron_w_mendelson

   References

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

   Next question

6. Question 126 · 1323 in bank

   How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?

   • ACreate transient tables and periodically copy them to permanent tables.
   • BCreate temporary tables and periodically copy them to permanent tables.
   • CCreate regular tables with extended Time Travel and Fail-safe settings.
   • DCreate regular tables with default Time Travel and Fail-safe settings.

   Show answer

   Answer: A

   Explanation

   For large, high-churn dimension tables that incur overly-excessive CDP costs, the solution is to create these tables as transient with zero Time Travel retention (i.e. DATA_RETENTION_TIME_IN_DAYS=0) and then copy these tables on a periodic basis into a permanent table.

   Source: Adapted from community discussion — Anblicks

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

7. Question 127 · 1323 in bank

   Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?

   • ASnowSQL
   • BDashboards
   • CPython worksheets
   • DProvider Studio

   Show answer

   Answer: C

   Next question

8. Question 128 · 1323 in bank

   Select 2

   In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Choose two.)

   • AImplementation of column-level security will optimize query performance.
   • BColumn-level security supports encryption of the entire database.
   • CColumn-level security ensures that only the table owner can access the data.
   • DColumn-level security limits access to specific columns within a table based on user privileges.
   • EColumn-level security allows the application of a masking policy to a column within a table or view.

   Show answer

   Answer: DE

   Next question

9. Question 129 · 1323 in bank

   How does Snowflake utilize clustering information to improve query performance?

   • AIt prunes unnecessary micro-partitions based on clustering metadata.
   • BIt compresses the data within micro-partitions for faster querying.
   • CIt automatically allocates additional resources to improve query execution.
   • DIt organizes clustering information to speed-up data retrieval from storage.

   Show answer

   Answer: A

   Next question

10. Question 130 · 1323 in bank

    How can staged files be removed during data loading once the files have loaded successfully?

    • AUse the DROP command.
    • BUse the PURGE copy option.
    • CUse the FORCE = TRUE parameter.
    • DUse the LOAD_UNCERTAIN_FILES copy option.

    Show answer

    Answer: B

    Next question

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

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