COF-C02 practice questions 681–690

1. Question 681 · 1323 in bank

   Select 2

   A Snowflake user has been granted the CREATE DATA EXCHANGE LISTING privilege with their role. Which tasks can this user now perform on the Data Exchange? (Choose two.)

   • ARename listings
   • BDelete provider profiles
   • CModify listings properties
   • DModify incoming listing access requests
   • ESubmit listings for approval/publishing

   Show answer

   Answer: CE

   Explanation

   If the global CREATE DATA EXCHANGE LISTING privilege is granted to a role, any user with the role can create a listing or provider profile. As the creator and therefore owner of the listing, the role can be used to perform all tasks on the listing, including: Create listings. Modify listings properties. View listings. View incoming listing requests. Reject listing requests. Submit listings for approval. Publish a listings. Create and view provider profiles. https://docs.snowflake.com/en/user-guide/data-exchange-marketplace-privileges#global-create-data-exchange-listing-privilege note: Only account administrators (users with the ACCOUNTADMIN role) can grant the global CREATE DATA EXCHANGE LISTING privilege to a role.

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 682 · 1323 in bank

   Which parameter prevents streams on tables from becoming stale?

   • AMAX_DATA_EXTENSION_TIME_IN_DAYS
   • BMIN_DATA_RETENSION_TIME_IN_DAYS
   • CLOCK_TIMEOUT
   • DSTALE_AFTER

   Show answer

   Answer: A

   Explanation

   D. STALE_AFTER is a parameter for streams in Snowflake that determines when a stream is considered stale and should be refreshed. It specifies the number of seconds before a stream becomes stale, and can be set to any value between 60 seconds and 14,400 seconds (4 hours). When a stream becomes stale, it is no longer guaranteed to contain a complete record of changes to the underlying table, and should be refreshed to ensure consistency.

   Source: Adapted from community discussion — isolated_sniper

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 683 · 1323 in bank

   If a virtual warehouse runs for 30 seconds after it is provisioned, how many seconds will the customer be billed for?

   • A30 seconds
   • B60 seconds
   • C121 seconds
   • D1 hour

   Show answer

   Answer: B

   Next question

4. Question 684 · 1323 in bank

   When should a stored procedure be created with caller's rights?

   • AWhen the caller needs to be prevented from viewing the source code of the stored procedure
   • BWhen the caller needs to run a statement that could not execute outside of the stored procedure
   • CWhen the stored procedure needs to run with the privileges of the role that called the stored procedure
   • DWhen the stored procedure needs to operate on objects that the caller does not have privileges on

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

5. Question 685 · 1323 in bank

   Select 2

   What JavaScript delimiters are available in Snowflake stored procedures? (Choose two.)

   • ADouble quotes (“)
   • BSingle quote (’)
   • CDouble forward slash (//)
   • DDouble backslash (\\)
   • EDouble dollar sign ($$)

   Show answer

   Answer: BE

   Explanation

   The JavaScript portion of the stored procedure code must be enclosed within either single quotes ' or double dollar signs $$. https://docs.snowflake.com/en/sql-reference/stored-procedures-javascript

   Source: Adapted from community discussion — fahfouhi94

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

6. Question 686 · 1323 in bank

   What type of function can be used to estimate the approximate number of distinct values from a table that has trillions of rows?

   • AMD5
   • BWindow
   • CExternal
   • DHyperLogLog (HLL)

   Show answer

   Answer: D

   Explanation

   Snowflake uses HyperLogLog to estimate the approximate number of distinct values in a data set. HyperLogLog is a state-of-the-art cardinality estimation algorithm, capable of estimating distinct cardinalities of trillions of rows with an average relative error of a few percent. HyperLogLog can be used in place of COUNT(DISTINCT …) in situations where estimating cardinality is acceptable.

   Source: Adapted from community discussion — fahfouhi94

   References

   • Snowflake documentation

   Next question

7. Question 687 · 1323 in bank

   Select 2

   Which Data Definition Language (DDL) commands are supported by Snowflake to manage tags? (Choose two.)

   • AALTER TAG
   • BDESCRIBE TAG
   • CDROP TAG
   • DGRANT [privilege] ... TO TAG
   • EGRANT TAG

   Show answer

   Answer: AC

   Explanation

   Tag DDL Reference Snowflake supports the following DDL to create and manage tags: CREATE TAG ALTER TAG ALTER (to set a tag on a Snowflake object) SHOW TAGS DROP TAG UNDROP TAG

   Source: Adapted from community discussion — sjndds

   References

   • Snowflake documentation

   Next question

8. Question 688 · 1323 in bank

   Select 2

   What Snowflake objects can be added to a share? (Choose two.)

   • AViews
   • BTables
   • CStored procedures
   • DStreams
   • ESecure views

   Show answer

   Answer: BE

   Explanation

   Before creating a share, Snowflake recommends identifying the Snowflake objects you plan to share: Database Tables External tables Secure views Secure materialized views Secure UDFs

   Source: Adapted from community discussion — bibisa

   Next question

9. Question 689 · 1323 in bank

   A Query Profile shows a UnionAll operator with an extra Aggregate operator on top. What does this signify?

   • AExploding joins
   • BInefficient pruning
   • CUNION without ALL
   • DQueries that are too large to fit in memory

   Show answer

   Answer: C

   Explanation

   UNION Without ALL In SQL, it is possible to combine two sets of data with either UNION or UNION ALL constructs. The difference between them is that UNION ALL simply concatenates inputs, while UNION does the same, but also performs duplicate elimination. A common mistake is to use UNION when the UNION ALL semantics are sufficient. These queries show in Query Profile as a UnionAll operator with an extra Aggregate operator on top (which performs duplicate elimination).

   Source: Adapted from community discussion — sjndds

   References

   • Snowflake documentation

   Next question

10. Question 690 · 1323 in bank

    Which data governance control has Snowflake embedded in the application?

    • ANetwork policies
    • BCredit computation
    • CData storage
    • DAttribute-based access control

    Show answer

    Answer: D

    Explanation

    A OAuth - a standard protocol that allows supported clients authorized access to Snowflake without sharing or storing user login credentials. Network policies - for limiting/controlling site access by user IP address. Admins can create IP allow and IP block lists. Object-level access control - granular control over access to objects — who can access what objects, the operations that are allowed on those objects, and the roles that can create or alter access control policies. Row Access Policies - to enforce access policies that determine which rows are visible in a query result. Object Tagging - to apply tags to Snowflake objects. This tagging helps track sensitive data and resource usage.

    Source: Adapted from community discussion — mingzeng0226

    Next question

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

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