COF-C02 practice questions 821–830

1. Question 821 · 1323 in bank

   How does a Snowflake user enable Multi-Factor Authentication (MFA)?

   • AThe user must enroll themselves through the web interface.
   • BThe user must submit their encrypted private key to Snowflake.
   • CThe user must sign up with Duo Mobile for approval to use the service.
   • DThe user must configure Snowflake to use Single Sign-On (SSO).

   Show answer

   Answer: A

   Explanation

   By default, MFA is not enabled for individual Snowflake users. If you wish to use MFA for more secure login, you must enroll using the Snowflake web interface.

   Source: Adapted from community discussion — bibisa

   References

   • Snowflake documentation

   Next question

2. Question 822 · 1323 in bank

   What allows a user to limit the number of credits consumed within a Snowflake account?

   • ATracking account usage
   • BCreating resource monitors
   • CAutomatic virtual warehouse scaling
   • DAutomatic clustering

   Show answer

   Answer: B

   Next question

3. Question 823 · 1323 in bank

   Which statement accurately describes Snowflake's architecture?

   • AIt uses a local data repository for all compute nodes in the platform.
   • BIt is a blend of shared-disk and shared-everything database architectures.
   • CIt is a hybrid of traditional shared-disk and shared-nothing database architectures.
   • DIt reorganizes loaded data into internal optimized, compressed, and row-based format.

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

4. Question 824 · 1323 in bank

   To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

   • AConfigure the Maximum Clusters setting to ג€Auto-Scaleג€
   • BSet the Warehouse type to ג€Autoג€
   • CSet the Minimum Clusters and Maximum Clusters settings to the same value
   • DSet the Minimum Clusters and Maximum Clusters settings to the different values

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

5. Question 825 · 1323 in bank

   Which Snowflake SQL command is used to get a subset of rows randomly from a table?

   • AGENERATOR
   • BLATERAL
   • CPIVOT
   • DSAMPLE

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

6. Question 826 · 1323 in bank

   Which statement accurately describes how a virtual warehouse functions?

   • AIncreasing the size of a virtual warehouse will always improve data loading performance.
   • BEach virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
   • CEach virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
   • DAll virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.

   Show answer

   Answer: C

   Explanation

   https://docs.snowflake.com/en/user-guide/intro-key-concepts Query Processing Query execution is performed in the processing layer. Snowflake processes queries using “virtual warehouses”. Each virtual warehouse is an MPP compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.

   Source: Adapted from community discussion — chuks_charley

   References

   • Snowflake documentation

   Next question

7. Question 827 · 1323 in bank

   Which Snowflake object can be used to record DML changes made to a table?

   • ASnowpipe
   • BStage
   • CStream
   • DTask

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

8. Question 828 · 1323 in bank

   Which statistic displayed in a Query Profile is specific to external functions?

   • ABytes written
   • BTotal invocations
   • CPartitions scanned
   • DBytes sent over the network

   Show answer

   Answer: B

   Explanation

   External Functions — information about calls to external functions: The following statistics are shown for each external function called by the SQL statement. If the same function was called more than once from the same SQL statement, then the statistics are aggregated. Total invocations — number of times that an external function was called. (This can be different from the number of external function calls in the text of the SQL statement due to the number of batches that rows are divided into, the number of retries (if there are transient network problems), etc.)

   Source: Adapted from community discussion — chuks_charley

   References

   • Snowflake documentation

   Next question

9. Question 829 · 1323 in bank

   If there is queueing in the virtual warehouse load monitoring chart, what should a Snowflake user do?

   • ADecrease the warehouse size.
   • BDecrease the MIN_CLUSTER_COUNT parameter.
   • CChange the multi-cluster settings to add additional clusters.
   • DStart a separate warehouse and move queued queries there.

   Show answer

   Answer: C

   Explanation

   Both C & D are correct. C: If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. D: Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward.

   Source: Adapted from community discussion — Kelvin_Yu

   Next question

10. Question 830 · 1323 in bank

    How long is the load history stored in the metadata of the pipe in Snowpipe?

    • A2 days
    • B7 days
    • C14 days
    • D64 days

    Show answer

    Answer: C

    Next question

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

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