COF-C02 practice questions 501–510

1. Question 501 · 1323 in bank

   Select 2

   Which of the following conditions must be met in order to return results from the results cache? (Choose two.)

   • AThe user has the appropriate privileges on the objects associated with the query.
   • BMicro-partitions have been reclustered since the query was last run.
   • CThe new query is run using the same virtual warehouse as the previous query.
   • DThe query includes a User Defined Function (UDF).
   • EThe query has been run within 24 hours of the previously-run query.

   Show answer

   Answer: AE

   Explanation

   E is correct and maybe A If the same query is fired again in 24 hrs, it will not be COMPUTED, which means it will not be charged. and it is not affected by WH suspension. So as the previous question the same exact query will return the pre-computed results if the underlying data hasn't changed and the results were last accessed within previous 24-hour period

   Source: Adapted from community discussion — halol

   References

   • Snowflake documentation

   Next question

2. Question 502 · 1323 in bank

   Which statement about billing applies to Snowflake credits?

   • ACredits are billed per-minute with a 60-minute minimum.
   • BCredits are used to pay for cloud data storage usage.
   • CCredits are consumed based on the number of credits billed for each hour that a warehouse runs.
   • DCredits are consumed based on the warehouse size and the time the warehouse is running.

   Show answer

   Answer: D

   Explanation

   D is the answer. A virtual warehouse is one or more clusters of compute resources that enable executing queries, loading data, and performing other DML operations. Snowflake credits are used to pay for the processing time used by each virtual warehouse. Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size.

   Source: Adapted from community discussion — arpit_dataguy

   References

   • Snowflake documentation

   Next question

3. Question 503 · 1323 in bank

   A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

   • AGRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
   • BGRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
   • CGRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
   • DGRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

   Show answer

   Answer: A

   Explanation

   in all commands it is missing the keyword GRANT before "CREATE MATERIALIZED VIEW" The answer A is correct but the answer D is correct too because the keyword ROLE is optional: https://docs.snowflake.com/en/sql-reference/sql/grant-privilege.html TO [ ROLE ] [ WITH GRANT OPTION ] So the question must allow for multiple answers.

   Source: Adapted from community discussion — BigDataBB

   References

   • Snowflake documentation

   Next question

4. Question 504 · 1323 in bank

   What is the purpose of multi-cluster virtual warehouses?

   • ATo create separate data warehouses to increase query optimization
   • BTo allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
   • CTo eliminate or reduce queuing of concurrent queries
   • DTo allow the warehouse to resize automatically

   Show answer

   Answer: C

   Next question

5. Question 505 · 1323 in bank

   Select 3

   Select the three types of tables that exist within Snowflake. (Choose three.)

   • ATemporary
   • BTransient
   • CProvisional
   • DPermanent

   Show answer

   Answer: ABD

   Next question

6. Question 506 · 1323 in bank

   Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

   • AAn FTP server with TLS encryption
   • BAn HTTPS server with WebDAV
   • CA Google Cloud storage bucket
   • DA Windows server file share on Azure

   Show answer

   Answer: C

   Explanation

   Correct answer is C. Snowflake supports loading data from files staged in any of the following locations, regardless of the cloud platform for your Snowflake account: • Internal (i.e. Snowflake) stages • Amazon S3 • Google Cloud Storage • Microsoft Azure blob storage

   Source: Adapted from community discussion — ShagunMittal

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

7. Question 507 · 1323 in bank

   Select 2

   Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

   • AFiles
   • BExternal tables
   • CSecure User-Defined Functions (UDFs)
   • DSequences
   • EStreams

   Show answer

   Answer: BC

   Explanation

   https://docs.snowflake.com/en/user-guide/data-sharing-intro Secure Data Sharing lets you share selected objects in a database in your account with other Snowflake accounts. You can share the following Snowflake database objects: Tables External tables Secure views Secure materialized views Secure UDFs

   Source: Adapted from community discussion — okurok

   References

   • Snowflake documentation

   Next question

8. Question 508 · 1323 in bank

   Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

   • AIf an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
   • BA Data Exchange allows groups of accounts to share data privately among the accounts.
   • CA Data Exchange allows accounts to share data with third, non-Snowflake parties.
   • DData Exchange functionality is available by default in accounts using the Enterprise edition or higher.
   • EThe sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

   Show answer

   Answer: E

   References

   • Snowflake documentation

   Next question

9. Question 509 · 1323 in bank

   A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?

   • ANo virtual warehouse will be used, data will be read from the result cache.
   • BNo virtual warehouse will be used, data will be read from the local disk cache.
   • CThe default virtual warehouse will be used to read all data.
   • DThe virtual warehouse that is defined at the session level will be used to read all data.

   Show answer

   Answer: A

   Next question

10. Question 510 · 1323 in bank

    Which feature allows a user the ability to control the organization of data in a micro-partition?

    • ARange Partitioning
    • BSearch Optimization Service
    • CAutomatic Clustering
    • DHorizontal Partitioning

    Show answer

    Answer: C

    Explanation

    Automatic Clustering = Defining Clustering key "All you need to do is define a clustering key for each table" https://docs.snowflake.com/en/user-guide/tables-auto-reclustering

    Source: Adapted from community discussion — Def21

    References

    • Snowflake documentation

    Next question

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

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