COF-C02 practice questions 711–720

1. Question 711 · 1323 in bank

   What happens when a database is cloned?

   • AIt does not retain any privileges granted on the source object.
   • BIt replicates all granted privileges on the corresponding source objects.
   • CIt replicates all granted privileges on the corresponding child objects.
   • DIt replicates all granted privileges on the corresponding child schema objects.

   Show answer

   Answer: C

   Explanation

   If the source object is a database or schema, the clone inherits all granted privileges on the clones of all child objects contained in the source object: For databases, contained objects include schemas, tables, views, etc. For schemas, contained objects include tables, views, etc. Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container.

   Source: Adapted from community discussion — EmiB

   References

   • Snowflake documentation

   Next question

2. Question 712 · 1323 in bank

   What does a Query Profile provide in Snowflake?

   • AA multi-step query that displays each processing step in the same panel.
   • BA pre-computed data set derived from a query specification and stored for later use.
   • CA graphical representation of the main components of the processing plan for a query.
   • DA collapsible panel in the operator tree pane that lists nodes by execution time in descending order for a query.

   Show answer

   Answer: C

   Explanation

   Query Profile, available through the classic web interface, provides execution details for a query. For the selected query, it provides a graphical representation of the main components of the processing plan for the query, with statistics for each component, along with details and statistics for the overall query.

   Source: Adapted from community discussion — EmiB

   References

   • Snowflake documentation

   Next question

3. Question 713 · 1323 in bank

   True or False: When a data share is established between a Data Provider and a Data Consumer, the Data Consumer can extend that data share to other Data Consumers.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Explanation

   FALSE General Limitations for Shared Databases¶ Shared databases have the following limitations for consumers: Shared databases are read-only. Users in a consumer account can view/query data, but cannot insert or update data, or create any objects in the database. The following actions are not supported: Creating a clone of a shared database or any schemas/tables in the database. Time Travel for a shared database or any schemas/tables in the database. Editing the comments for a shared database. Shared databases and all the objects in the database cannot be re-shared with other accounts. Shared databases cannot be replicated.

   Source: Adapted from community discussion — Marge23

   References

   • Snowflake documentation

   Next question

4. Question 714 · 1323 in bank

   When executing a COPY INTO command, performance can be negatively affected by using which optional parameter on a large number of files?

   • AFILE_FORMAT
   • BPATTERN
   • CVALIDATION_MODE
   • DFILES

   Show answer

   Answer: B

   Explanation

   The correct answer is B. Pattern For the best performance, try to avoid applying patterns that filter on a large number of files. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#:~:text=paths%20to%20match.-,Tip,-For%20the%20best

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

5. Question 715 · 1323 in bank

   Which URL type should be used to get a permanent URL to a file in a stage?

   • AFile URL
   • BPre-signed URL
   • CSaved URL
   • DScoped URL

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

6. Question 716 · 1323 in bank

   Which operation will produce an error in Snowflake?

   • AInserting duplicate values into a PRIMARY KEY column
   • BInserting a NULL into a column with a NOT NULL constraint
   • CInserting duplicate values into a column with a UNIQUE constraint
   • DInserting a value to FOREIGN KEY column that does not match a value in the column referenced

   Show answer

   Answer: B

   Explanation

   B - Snowflake supports defining and maintaining constraints, but does not enforce them, except for NOT NULL constraints, which are always enforced.

   Source: Adapted from community discussion — EmiB

   Next question

7. Question 717 · 1323 in bank

   How are URLs that access unstructured data in external stages retrieved?

   • AFrom the Snowsight navigation menu
   • BBy querying a directory table
   • CBy creating an external function
   • DBy using the INFORMATION_USAGE schema

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

8. Question 718 · 1323 in bank

   What is the Snowflake multi-clustering feature for virtual warehouses used for?

   • ATo improve the data unloading process to the cloud
   • BTo improve data loading from very large data sets
   • CTo improve concurrency for users and queries
   • DTo speed up slow or stalled queries

   Show answer

   Answer: C

   Next question

9. Question 719 · 1323 in bank

   Select 2

   Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Choose two.)

   • ASearch optimization service
   • BAutomatic clustering
   • CRow access policies
   • DMulti-cluster virtual warehouses
   • ESecure views

   Show answer

   Answer: AB

   Next question

10. Question 720 · 1323 in bank

    Which command would return an empty sample?

    • Aselect * from testtable sample ();
    • Bselect * from testtable sample (0);
    • Cselect * from testtable sample (null);
    • Dselect * from testtable sample (none);

    Show answer

    Answer: B

    Explanation

    num specifies the number of rows (up to 1,000,000) to sample from the table. Can be any integer between 0 (no rows selected) and 1000000 inclusive. https://docs.snowflake.com/en/sql-reference/constructs/sample

    Source: Adapted from community discussion — aemilka

    References

    • Snowflake documentation

    Next question

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

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