COF-C02 practice questions 1,151–1,160

1. Question 1151 · 1323 in bank

   Why would a Snowflake user choose to use a transient table?

   • ATo store data for long-term analysis
   • BTo store large data files that are used frequently
   • CTo create a permanent table for ongoing use in ELT
   • DTo store transitory data that needs to be maintained beyond the session

   Show answer

   Answer: D

   Explanation

   D is the correct answer. transient tables are specifically designed for transitory data that needs to be maintained beyond each session https://docs.snowflake.com/en/user-guide/tables-temp-transient#transient-tables

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

2. Question 1152 · 1323 in bank

   What does a masking policy consist of in Snowflake?

   • AA single data type, with one or more conditions, and one or more masking functions
   • BA single data type, with only one condition, and only one masking function
   • CMultiple data types, with only one condition, and one or more masking functions
   • DMultiple data types, with one or more conditions, and one or more masking functions

   Show answer

   Answer: A

   Explanation

   A "A masking policy consists of a single data type, one or more conditions, and one or more masking functions." https://docs.snowflake.com/en/user-guide/security-column-intro

   Source: Adapted from community discussion — ASK_123

   References

   • Snowflake documentation

   Next question

3. Question 1153 · 1323 in bank

   Select 2

   Secured Data Sharing is allowed for which Snowflake database objects? (Choose two.)

   • ATables
   • BUser-Defined Table Functions (UDTFs)
   • CSecure views
   • DStored procedures
   • EWorksheets

   Show answer

   Answer: AC

   Next question

4. Question 1154 · 1323 in bank

   Select 2

   What actions can be performed by a consumer account on a shared database? (Choose two.)

   • ACloning a shared table
   • BModifying the data in a shared table
   • CUsing Time Travel on a shared table
   • DExecuting the SELECT statement on a shared table
   • EJoining the data from a shared table with another table

   Show answer

   Answer: DE

   Next question

5. Question 1155 · 1323 in bank

   Select 2

   What optional properties can a Snowflake user set when creating a virtual warehouse? (Choose two.)

   • AAuto-suspend
   • BCache size
   • CDefault role
   • DResource monitor
   • EStorage size

   Show answer

   Answer: AD

   Next question

6. Question 1156 · 1323 in bank

   What data type is used to ingest semi-structured data into a Snowflake table?

   • ABOOLEAN
   • BNUMBER
   • CVARBINARY
   • DVARIANT

   Show answer

   Answer: D

   Next question

7. Question 1157 · 1323 in bank

   True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Explanation

   n addition, if you have an on-premises environment (e.g. a non-hosted data center), you can choose to use AWS Direct Connect, in conjunction with AWS PrivateLink, to connect all your virtual and physical environments in a single, private network. therefore AWS private link alone wont work. Answer:False

   Source: Adapted from community discussion — pappuji

   References

   • Snowflake documentation

   Next question

8. Question 1158 · 1323 in bank

   Which security feature is used to connect or log in to a Snowflake account?

   • ANetwork policy
   • BSCIM
   • CRole-Based Access Control (RBAC)
   • DKey pair authentication

   Show answer

   Answer: D

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 1159 · 1323 in bank

   Select 2

   How can the ACCESS_HISTORY view in the ACCOUNT_USAGE schema be used to review the data governance settings for an account? (Choose two.)

   • AIdentify queries run by a particular user.
   • BIdentify access to the roles given to a user.
   • CIdentify SQL statements that failed to run.
   • DIdentify objects that were modified by a query.
   • EIdentify object dependencies.

   Show answer

   Answer: AD

   Next question

10. Question 1160 · 1323 in bank

    Select 2

    Given the statement template below, which database objects can be added to a share? (Choose two.) GRANT [privilege] ON [object] [object_name] TO SHARE [share_name];

    • ASecure functions
    • BStored procedures
    • CStreams
    • DTables
    • ETasks

    Show answer

    Answer: AD

    Explanation

    Secure Data Sharing lets you share selected objects in a database in your account with other Snowflake accounts. You can share the following Snowflake objects: Databases Tables Dynamic tables External tables Iceberg tables Secure views Secure materialized views Secure user-defined functions (UDFs)

    Source: Adapted from community discussion — induna

    References

    • Snowflake documentation

    Next question

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

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