COF-C02 practice questions 851–860

1. Question 851 · 1323 in bank

   Select 2

   How can a Snowflake user optimize query performance in Snowflake? (Choose two.)

   • ACreate a view.
   • BCluster a table.
   • CEnable the search optimization service.
   • DEnable Time Travel.
   • EIndex a table.

   Show answer

   Answer: BC

   Explanation

   The correct answers are B and C. Clustering a table physically reorders the rows in a table to improve the performance of queries that filter on specific columns. The search optimization service creates a search index for a table, which can be used to improve the performance of queries that filter on specific columns. Creating a view does not improve query performance. Enabling Time Travel allows you to query data from a specific point in time, but it does not improve query performance. Indexing a table creates an index that can be used to improve the performance of queries, but it is not as effective as clustering or the search optimization service.

   Source: Adapted from community discussion — bee5k

   Next question

2. Question 852 · 1323 in bank

   What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

   • AACCOUNTADMIN
   • BSECURITYADMIN
   • CSYSADMIN
   • DORGADMIN

   Show answer

   Answer: D

   Explanation

   D https://docs.snowflake.com/en/user-guide/account-replication-config Enable Replication for Accounts in the Organization The organization administrator (ORGADMIN role) must enable replication for the source and target accounts. To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account. Log into an ORGADMIN account to enable replication for each source and target account in your organization. USE ROLE ORGADMIN; -- View the list of the accounts in your organization -- Note the organization name and account name for each account for which you are enabling replication SHOW ORGANIZATION ACCOUNTS; -- Enable replication by executing this statement for each source and target account in your organization SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(' . ', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true

   Source: Adapted from community discussion — singhks

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 853 · 1323 in bank

   Which file format will keep floating-point numbers from being truncated when data is unloaded?

   • ACSV
   • BJSON
   • CORC
   • DParquet

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

4. Question 854 · 1323 in bank

   A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

   • AThe primary cluster in the Virtual Warehouse
   • BThe entire Virtual Warehouse
   • CThe database the Virtual Warehouse resides in
   • DThe queries currently being run by the Virtual Warehouse

   Show answer

   Answer: B

   Next question

5. Question 855 · 1323 in bank

   A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

   • AARRAY
   • BOBJECT
   • CTEXT
   • DVARIANT

   Show answer

   Answer: D

   Next question

6. Question 856 · 1323 in bank

   Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

   • AResource monitor
   • BAccount_usage.query_history
   • CInformation_schema.warehouse_load_history
   • DInformation_schema.warehouse_metering_history

   Show answer

   Answer: C

   Explanation

   The user is referring to this in particular: Query History: It keeps a record of all queries executed in your Snowflake account. This allows you to analyze the performance of individual queries, including their execution time, number of rows processed, etc. However, it does not provide specific information on the impact of query queuing on virtual warehouse performance. WAREHOUSE_LOAD_HISTORY: This system view provides specific information on the usage of the virtual warehouse, including the wait times of queries in the queue. This allows you to evaluate the impact of query queuing on virtual warehouse performance by providing data on warehouse load and usage. So, if you want to assess the impact of query queuing on virtual warehouse performance, the WAREHOUSE_LOAD_HISTORY view would be more appropriate. If you want to examine the performance of individual queries as a whole, then Query History would be more relevant

   Source: Adapted from community discussion — Lematthew31

   References

   • Snowflake documentation

   Next question

7. Question 857 · 1323 in bank

   Which Snowflake object can be created to be temporary?

   • ARole
   • BStage
   • CUser
   • DStorage integration

   Show answer

   Answer: B

   Next question

8. Question 858 · 1323 in bank

   Which stream type can be used for tracking the records in external tables?

   • AAppend-only
   • BExternal
   • CInsert-only
   • DStandard

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

9. Question 859 · 1323 in bank

   What is the recommended approach for unloading data to a cloud storage location from Snowflake?

   • AUse a third-party tool to unload the data to cloud storage.
   • BUnload the data directly to the cloud storage location.
   • CUnload the data to a local file system, then upload it to cloud storage.
   • DUnload the data to a user stage, then upload the data to cloud storage

   Show answer

   Answer: B

   Next question

10. Question 860 · 1323 in bank

    Which command is used to unload files from an internal or external stage to a local file system?

    • ACOPY INTO
    • BGET
    • CPUT
    • DTRANSFER

    Show answer

    Answer: B

    Explanation

    If I had to choose, I would choose B. COPY INTO - is used to unload data into either internal or external stage, then we use GET to download files from INTERNAL stage into local system, or we use tools provided by external provider to download files. "Bulk unloading process The process for unloading data into files is the same as the loading process, except in reverse: Step 1 Use the COPY INTO command to copy the data from the Snowflake database table into one or more files in a Snowflake or external stage. Step 2 Download the file from the stage: From a Snowflake stage, use the GET command to download the data file(s). From S3, use the interfaces/tools provided by Amazon S3 to get the data file(s). From Azure, use the interfaces/tools provided by Microsoft Azure to get the data file(s)." https://docs.snowflake.com/en/user-guide/data-unload-overview ChatGPT says you can download files from external stage through SnowSQL by using GET command.

    Source: Adapted from community discussion — yaho5

    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 851. 1323 questions available.