COF-C02 practice questions 541–550

1. Question 541 · 1323 in bank

   When loading data into Snowflake, the COPY command supports which of the following?

   • AJoins
   • BFilters
   • CColumn reordering
   • DAggregates

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

2. Question 542 · 1323 in bank

   What is cached during a query on a virtual warehouse?

   • AAll columns in a micro-partition
   • BAny columns accessed during the query
   • CThe columns in the result set of the query
   • DAll rows accessed during the query

   Show answer

   Answer: B

   Explanation

   B is correct. Each warehouse, when running, maintains a cache of table data accessed as queries are processed by the warehouse. https://docs.snowflake.com/en/user-guide/warehouses-considerations

   Source: Adapted from community discussion — OTE

   References

   • Snowflake documentation

   Next question

3. Question 543 · 1323 in bank

   What is the default character set used when loading CSV files into Snowflake?

   • AUTF-8
   • BUTF-16
   • CISO 8859-1
   • DANSI_X3.4

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

4. Question 544 · 1323 in bank

   Which of the following describes external functions in Snowflake?

   • AThey are a type of User-defined Function (UDF).
   • BThey contain their own SQL code.
   • CThey call code that is stored inside of Snowflake.
   • DThey can return multiple rows for each row received.

   Show answer

   Answer: A

   Explanation

   A correct An external function is a type of UDF. Unlike other UDFs, an external function does not contain its own code; instead, the external function calls code that is stored and executed outside Snowflake

   Source: Adapted from community discussion — halol

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 545 · 1323 in bank

   Select 3

   Which of the following are valid methods for authenticating users for access into Snowflake? (Choose three.)

   • ASCIM
   • BFederated authentication
   • CTLS 1.2
   • DKey-pair authentication
   • EOAuth
   • FOCSP authentication

   Show answer

   Answer: BDE

   References

   • Snowflake documentation

   Next question

6. Question 546 · 1323 in bank

   A user has a standard multi-cluster warehouse auto-scaling policy in place. Which condition will trigger a cluster to shut-down?

   • AWhen after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
   • BWhen after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
   • CWhen after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
   • DWhen after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

   Show answer

   Answer: D

   Explanation

   After 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up the cluster again. https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation

   Next question

7. Question 547 · 1323 in bank

   What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

   • AStandard
   • BEnterprise
   • CBusiness Critical
   • DVirtual Private Snowflake

   Show answer

   Answer: C

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 548 · 1323 in bank

   How would a user execute a series of SQL statements using a task?

   • AInclude the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
   • BA stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
   • CUse a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
   • DCreate a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

   Show answer

   Answer: C

   Next question

9. Question 549 · 1323 in bank

   True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Next question

10. Question 550 · 1323 in bank

    How many resource monitors can be assigned at the account level?

    • A1
    • B2
    • C3
    • D4

    Show answer

    Answer: A

    Explanation

    A single monitor can be set at the account level to control credit usage for all warehouses in your account. https://docs.snowflake.com/en/user-guide/resource-monitors.html#monitor-level

    Source: Adapted from community discussion — SV1122

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