COF-C02 practice questions 221–230

1. Question 221 · 1323 in bank

   What is the default authenticator while using the JDBC driver connection in Snowflake?

   • Aexternalbrowser
   • Bsnowlake
   • Cusername_password_mfa
   • Dsnowflake_jwt

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

2. Question 222 · 1323 in bank

   True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

   • ATrue
   • BFalse

   Show answer

   Answer: A

   Explanation

   What is restricted/allowed in a reader account? A reader account is intended primarily for querying data shared by the provider of the account. You can work with data, for example, by creating materialized views. You cannot perform the following tasks in a reader account: - Uploading new data. - Modifying existing data. - Unloading data using a storage integration. However, you can use the COPY INTO command with your connection credentials to unload data into a cloud storage location. So the answer is A, you can export data into a cloud storage location. Link: https://docs.snowflake.com/en/user-guide/data-sharing-reader-create

   Source: Adapted from community discussion — lol632

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 223 · 1323 in bank

   When will Snowflake charge credits for the use of the Cloud Services layer?

   • ACredits will be charged whenever the Cloud Services layer is used.
   • BCredits will be charged only when running a Snowflake-provisioned compute warehouse COMPUTE_WH.
   • CCredits will be charged when the daily consumption of cloud services resources exceeds 10% of the daily warehouse usage.
   • DCredits will be charged only when a virtual warehouse consumes serverless compute services.

   Show answer

   Answer: C

   Explanation

   In the courses it is not specified if it is about "daily", but for sure A is not correct, because the 10% have to be exceeded. Hence, it remains to be C.

   Source: Adapted from community discussion — 37ceea2

   Next question

4. Question 224 · 1323 in bank

   How can the performance of queries run on external tables be optimized?

   • ACluster the tables
   • BCreate materialized views on the tables
   • CUse the metadata cache
   • DEnable the search optimization service

   Show answer

   Answer: B

   Explanation

   To improve query performance, you can use a materialized view based on an external table. This sentence is from https://docs.snowflake.com/en/user-guide/tables-external-intro. Hence, the reply is B.

   Source: Adapted from community discussion — 37ceea2

   References

   • Snowflake documentation

   Next question

5. Question 225 · 1323 in bank

   Select 2

   What are the recommended alternative data types in Snowflake for unsupported large object data types such as BLOB and CLOB? (Choose two.)

   • AVARIANT
   • BARRAY
   • CBINARY
   • DOBJECT
   • EVARCHAR

   Show answer

   Answer: CE

   References

   • Snowflake documentation

   Next question

6. Question 226 · 1323 in bank

   Select 2

   A table named car_sales contains a single VARIANT column named src. Below is the output of the query SELECT * FROM car_sales;

   

   Which queries will return the element "phone number" from the data? (Choose two.)

   • ASELECT src:customer.’phone number’ FROM car_sales;
   • BSELECT SRC:customer."phone number" FROM car_sales;
   • CSELECT src:customer."phone number" FROM car_sales;
   • DSELECT SRC:customer.phone number FROM car_sales;
   • ESELECT SRC:CUSTOMER."phone number" FROM car_sales;

   Show answer

   Answer: BC

   Next question

7. Question 227 · 1323 in bank

   Select 2

   Which strings will be converted to TRUE using the TO_BOOLEAN() or CAST() functions when unloading data? (Choose two.)

   • A0
   • Bn
   • Cno
   • Don
   • Eyes

   Show answer

   Answer: DE

   References

   • Snowflake documentation

   Next question

8. Question 228 · 1323 in bank

   True or False: You can define multiple columns within a clustering key on a table.

   • ATrue
   • BFalse

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

9. Question 229 · 1323 in bank

   Which authentication method requires access to a secure file that is only stored on the user's local device?

   • APassword authentication
   • BKey-pair authentication
   • CMulti-Factor Authentication (MFA)
   • DFederated authentication

   Show answer

   Answer: B

   Next question

10. Question 230 · 1323 in bank

    If a source table is updated while cloning is in progress, what data will be included in the cloned table?

    • AAll data from the timestamp when the user runs the query.
    • BAll data from the timestamp when the user session was created.
    • CAll data from the timestamp when the clone statement was initiated.
    • DAll data from the timestamp when the clone statement was completed.

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