COF-C02 practice questions 191–200

1. Question 191 · 1323 in bank

   When sharing data among multiple Snowflake accounts, what charges are incurred by a data consumer when viewing shared data using their own account?

   • ACloud services charges
   • BCompute charges
   • CData storage charges
   • DData egress charges

   Show answer

   Answer: B

   Next question

2. Question 192 · 1323 in bank

   Select 2

   Which objects can be cloned in Snowflake? (Choose two.)

   • AVirtual warehouses
   • BInternal named stages
   • CExternal named stages
   • DDynamic tables
   • EExternal tables

   Show answer

   Answer: CD

   Next question

3. Question 193 · 1323 in bank

   What happens to foreign key constraints when a table is cloned to another database?

   • AAll referenced tables will be cloned.
   • BThe cloned table will reference the primary key in the source table.
   • CThe cloned table will lose all references to the primary key.
   • DThe cloned table will lose all references to the foreign and primary keys

   Show answer

   Answer: B

   Explanation

   I changed my mind: https://docs.snowflake.com/en/user-guide/object-clone Cloning and foreign key constraints A table can have a foreign key constraint that references a table that includes the primary key. When a table with a foreign key constraint is cloned, the cloned table references the source or cloned table that includes the primary key: If the database or schema containing both tables is cloned, the cloned table with the foreign key references the primary key in the other cloned table. If the tables are in separate databases or schemas, the cloned table references the primary key in the source table. Hence, the answer is B, since the question does not mention that the both tables are cloned, within the same cloned database.

   Source: Adapted from community discussion — 37ceea2

   References

   • Snowflake documentation

   Next question

4. Question 194 · 1323 in bank

   What step must be taken to ensure that a user can only access Snowsight from a specific location, or when working from home?

   • AUse a company Virtual Private Network (VPN) connection.
   • BUse Multi-Factor Authentication (MFA).
   • CUse Single Sign-On (SSO).
   • DAdd the user's IP address to the network policy allowed list.

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

5. Question 195 · 1323 in bank

   What does a Query Profile metric that shows excessive spillage indicate?

   • APoor query optimization
   • BExpired temporary tables
   • CImproper virtual warehouse sizing
   • DImproper Common Table Expressions (CTEs)

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

6. Question 196 · 1323 in bank

   In a SPLIT_PART function, what will the returned value be if the partNumber is out of range?

   • A−1
   • BAn empty string
   • CThe full string
   • DAn error

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

7. Question 197 · 1323 in bank

   Select 2

   From which locations can data files be downloaded using the GET command? (Choose two.)

   • AExternal stage
   • BTable stage
   • CUser stage
   • DDirectory table
   • EPermanent table

   Show answer

   Answer: BC

   Next question

8. Question 198 · 1323 in bank

   Which of the following commands sets the Virtual Warehouse for a session?

   • ACOPY WAREHOUSE FROM <<config file>>;
   • BSET WAREHOUSE = <<warehouse name>>;
   • CUSE WAREHOUSE <<warehouse name>>;
   • DUSE VIRTUAL_WAREHOUSE <<warehouse name>>;

   Show answer

   Answer: C

   Explanation

   The correct answer is C. According to snowflake docs, "A Snowflake session can only have one current warehouse at a time. The current warehouse for a session can be specified or changed at any time through the USE WAREHOUSE command."

   Source: Adapted from community discussion — instride

   Next question

9. Question 199 · 1323 in bank

   How would you determine the size of the virtual warehouse used for a task?

   • ARoot task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
   • BQuerying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
   • CIf using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
   • DSince task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

   Show answer

   Answer: C

   Explanation

   "Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries. They are not as beneficial for improving the performance of slow-running queries or data loading. For these types of operations, resizing the warehouse provides more benefits." Snowflake representative explained this here https://community.snowflake.com/s/question/0D50Z00009F8nPTSAZ/how-to-choose-the-right-virtual-warehouse-size-in-snowflake-for-your-workload

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation

   Next question

10. Question 200 · 1323 in bank

    Select 2

    What Snowflake features are recommended to restrict unauthorized users from accessing Personal Identifiable Information (PI)? (Choose two.)

    • ADynamic Data Masking
    • BTransient tables
    • CSecure views
    • DMulti-Factor Authentication (MFA)
    • EData encryption

    Show answer

    Answer: AC

    Next question

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

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