COF-C02 practice questions 1,231–1,240

1. Question 1231 · 1323 in bank

   How many shares can be consumed by a single Data Consumer?

   • A1
   • B10
   • C100, but can be increased by contacting support
   • DUnlimited

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

2. Question 1232 · 1323 in bank

   Which Snowflake feature supports continuous, serverless data loading into tables as soon as new data arrives?

   • ASnowpark
   • BSnowSQL
   • CSnowCD
   • DSnowpipe

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

3. Question 1233 · 1323 in bank

   A Snowflake user runs a query for 36 seconds on a size 2XL virtual warehouse. What would be the credit consumption?

   • ASnowflake will charge for 36 seconds at the rate of 32 credits per hour.
   • BSnowflake will charge for 36 seconds at the rate of 64 credits per hour.
   • CSnowflake will charge for 60 seconds at the rate of 32 credits per hour.
   • DSnowflake will charge for 60 seconds at the rate of 64 credits per hour.

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

4. Question 1234 · 1323 in bank

   What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?

   • AIO
   • BNetwork
   • CPruning
   • DSpilling

   Show answer

   Answer: D

   Next question

5. Question 1235 · 1323 in bank

   What is an advantage of using a multi-cluster virtual warehouse as compared to a single-cluster virtual warehouse in Snowflake?

   • AA user can auto-suspend a running warehouse due to inactivity.
   • BA user can specify a warehouse size while configuring it for use.
   • CA user can resize a warehouse at any time whether running or not.
   • DA user can specify the maximum and minimum number of cluster(s).

   Show answer

   Answer: D

   Next question

6. Question 1236 · 1323 in bank

   Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

   • AThe column name and element names are both case-sensitive.
   • BThe column name and element names are both case-insensitive.
   • CThe column name is case-sensitive but element names are case-insensitive.
   • DThe column name is case-insensitive but element names are case-sensitive.

   Show answer

   Answer: D

   Explanation

   Regardless of which notation you use, the column name is case-insensitive but element names are case-sensitive. For example, (src is a column name) in the following list, the first two paths are equivalent, but the third is not: src:salesperson.name SRC:salesperson.name SRC:Salesperson.Name

   Source: Adapted from community discussion — nexerSnow

   References

   • Snowflake documentation

   Next question

7. Question 1237 · 1323 in bank

   Which Snowflake data type is used to store JSON key value pairs?

   • ATEXT
   • BBINARY
   • CSTRING
   • DVARIANT

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

8. Question 1238 · 1323 in bank

   How are network policies defined in Snowflake?

   • AThey are a set of rules that define the network routes within Snowflake.
   • BThey are a set of rules that dictate how Snowflake accounts can be used between multiple users.
   • CThey are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.
   • DThey are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect to Snowflake.

   Show answer

   Answer: D

   Explanation

   Snowflake recommends using network rules in conjunction with network policies rather using this parameter. Use the BLOCKED_NETWORK_RULE_LIST parameter to specify network rules that contain IPv4 addresses. Specifies a list of IPv4 addresses that are denied access to your Snowflake account. This is referred to as the blocked list. Set this parameter only when you are allowing access to a range of IP addresses (specified in ALLOWED_IP_LIST), but want to deny access to one or more IP addresses within the range.

   Source: Adapted from community discussion — nexerSnow

   Next question

9. Question 1239 · 1323 in bank

   What is the only supported character set for loading and unloading data from all supported file formats?

   • AUTF-8
   • BUTF-16
   • CISO-8859-1
   • DWINDOWS-1253

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

10. Question 1240 · 1323 in bank

    Which function is used to convert rows in a relational table to a single VARIANT column?

    • AARRAY_AGG
    • BOBJECT_AGG
    • CARRAY_CONSTRUCT
    • DOBJECT_CONSTRUCT

    Show answer

    Answer: D

    References

    • Snowflake documentation

    Next question

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

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